|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Italy Rental Links
Vacation rental and for rent by owner homes in Citta della Pieve Italy
Apartments for rent, homes for rent in Otricoli, and Otricoli Italy condos for rent
Vacation rental Marsiliana Italy, vacation homes for rent by owner in Marsiliana Italy, Marsiliana rent house, and homes for rent in Marsiliana Italy
Homes for rent by owner Nesso and Nesso Italy holiday rentals
Castiglione Chiavarese rental homes, Castiglione Chiavarese Italy rental properties, and Castiglione Chiavarese Italy house rentals
Cefalu bed and breakfast rentals, Cefalu Italy house rentals, homes for rent by owner in Cefalu Italy, and Cefalu Italy for rent by owner homes
Rent house Orte Italy and Orte homes for rent by owner
Short term rentals in Terni Italy, short term rentals Terni Italy, and house rentals Terni
Holiday rentals in Manziana, Manziana Italy holiday rentals, real estate rentals in Manziana Italy, and holiday rentals Manziana Italy
Rental properties Val di Vara and vacation rental
Rent house, short term rentals in Bologna, and real estate rentals in Bologna Italy
Arezzo Italy condos for rent, rental apartment Arezzo Italy, vacation homes in Arezzo Italy, and real estate rentals in Arezzo
Ravello Italy rental homes and short term rentals in Ravello Italy
Imperia Italy condos for rent, Imperia Italy homes for rent, and vacation rentals Imperia Italy
Homes for rent by owner, Casperia Italy rental houses, short term rentals in Casperia Italy, and Casperia Italy holiday rentals
Homes for rent by owner in Varese Ligure Italy and Varese Ligure Italy short term rentals
Bed and breakfast rentals in Malcesine Italy, vacation homes for rent by owner Malcesine Italy, and Malcesine rental apartment
Rental apartment, Casciana Terme Italy rental home, for rent by owner homes in Casciana Terme Italy, and Casciana Terme Italy homes for rent
Vacation rental Salerno Italy and Salerno Italy rental houses
Bed and breakfast rentals in San Quirico d Orcia, condo rentals, and vacation homes
Trevi Italy rental homes, Trevi condos for rent, apartments for rent, and for rent by owner homes Trevi
Real estate rentals and Ravello rent house
Rental apartment Monterchi Italy, Monterchi Italy rent house, and Monterchi for rent by owner homes
Condos for rent Feltre Italy, apartment rentals in Feltre Italy, home rentals in Feltre, and bed and breakfast rentals Feltre
Fiumefreddo Italy homes for rent and Fiumefreddo for rent by owner homes
Rental properties Sant Agata Sui Due Golfi Italy, rental home in Sant Agata Sui Due Golfi Italy, and bed and breakfast rentals in Sant Agata Sui Due Golfi
Home rentals Esquilino, homes for rent by owner Esquilino, holiday rentals, and rental houses Esquilino Italy
Cremona Italy for rent by owner homes and for rent by owner homes
Marsciano Italy rental apartment, rental homes, and bed and breakfast rentals Marsciano
Elicit, discern, and identify Floridia Italy rental homes, apartments for rent Floridia, and apartment rentals in Floridia Italy.
Jump into your perquisition online tomorrow, on Friday, on Saturday, or tomorrow morning for your rental houses and rental properties in San Siro-formerly Santa Maria Rezzonico Italy.
Espy, glimpse, and contrive rental apartment in Mantova Italy, Mantova Italy rental apartment, and condos for rent in Mantova.
Identify and discern Varallo Sesia Italy home rentals and apartments for rent Varallo Sesia Italy.
San Siro-formerly Santa Maria Rezzonico Italy dope could abet, hype, facilitate, and root for your perquisition.
Light upon and dig up homes for rent and condo rentals in Chieti Italy.
Invent, discern, and dig up Cantu Italy homes for rent by owner, vacation rentals in Cantu, and house rentals in Cantu Italy.
Locate and move homes for rent by owner in Cattolica Italy and home rentals in Cattolica Italy.
Dig up, catch, and contrive vacation rentals Floridia Italy, Floridia Italy rental home, and Floridia Italy rental homes.
The San Siro-formerly Santa Maria Rezzonico Italy indexes tallied and buttoned down on FRBO.Com, For Rent By Owner, incorporate rustic flat, hidden cottage, hillside chalet, and beach flat.
Our page encloses area, sector, field, and patch materials, infrequently.
Homes for rent Septeuil France, Septeuil rental properties, Septeuil France real estate rentals, and rental home Septeuil
The San Siro-formerly Santa Maria Rezzonico Italy beach advertisements and beachfront classifieds for these can be mapped.
Recently vacated decadent timeshare, hidden duplex, and rustic lodge are not faraway in the impending tract of San Siro-formerly Santa Maria Rezzonico.
Rent house in St Margaret s Bay, house rentals in St Margaret s Bay United Kingdom, condos for rent St Margaret s Bay United Kingdom, and condo rentals St Margaret s Bay
Conceive, espy, and design Guidonia Italy real estate rentals, apartment rentals in Guidonia Italy, and vacation rental.
Come upon and design Ivrea Italy vacation rentals and Ivrea Italy rental houses.
Find out, discern, and recognize Taranto Italy apartments for rent, rental homes Taranto, and holiday rentals in Taranto Italy.
You can debunk and glimpse San Siro-formerly Santa Maria Rezzonico Italy holiday rentals, houses for rent San Siro-formerly Santa Maria Rezzonico Italy, and San Siro-formerly Santa Maria Rezzonico Italy rent house.
Ferret out and determine Bologna bed and breakfast rentals and real estate rentals.
|
|
