|
<%@ 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
Bed and breakfast rentals in Lavagna Italy and rental homes in Lavagna Italy
Porto Ercole Italy bed and breakfast rentals, Porto Ercole Italy homes for rent by owner, and house rentals
House rentals in Chianti Italy, homes for rent by owner Chianti, vacation homes in Chianti, and Chianti Italy apartments for rent
Pescaglia rental houses and rental apartment in Pescaglia Italy
Apartments for rent, homes for rent Flaminio-Piazza del Popolo & Parioli Italy, and apartment rentals in Flaminio-Piazza del Popolo & Parioli
Rent houses Riomaggiore, Riomaggiore rent house, Riomaggiore rent house, and Riomaggiore Italy rental houses
Vacation homes for rent by owner in Porto San Paolo and Porto San Paolo rental properties
Foligno Italy rent houses, bed and breakfast rentals in Foligno Italy, and home rentals in Foligno Italy
For rent by owner homes in Amandola, Amandola vacation homes, holiday rentals in Amandola Italy, and Amandola house rentals
Vacation rental in Sansepolcro and vacation rentals Sansepolcro
San Benedetto del Tronto apartments for rent, San Benedetto del Tronto Italy short term rentals, and real estate rentals
Home rentals in Casteldaccia Italy, houses for rent in Casteldaccia, vacation homes for rent by owner, and for rent by owner homes
Bed and breakfast rentals in Todi and rental properties in Todi Italy
Homes for rent by owner, Imperia rental homes, and Imperia Italy apartment rentals
Real estate rentals in San Gusme, San Gusme short term rentals, vacation homes for rent by owner San Gusme Italy, and houses for rent in San Gusme Italy
Apartment rentals in Calvi Dell Umbria Italy and rent houses Calvi Dell Umbria Italy
Condos for rent in Castiglione del Lago, Castiglione del Lago Italy condo rentals, and vacation homes in Castiglione del Lago Italy
Ossuccio apartment rentals, homes for rent in Ossuccio Italy, bed and breakfast rentals in Ossuccio, and Ossuccio bed and breakfast rentals
Vacation homes for rent by owner Trastevere and Trastevere vacation homes for rent by owner
Castellabate Italy homes for rent by owner, house rentals, and Castellabate Italy rental apartment
Spello Italy rental home, Spello condo rentals, house rentals Spello Italy, and house rentals in Spello Italy
Homes for rent in San Pantaleo and vacation homes for rent by owner in San Pantaleo
For rent by owner homes in Island of Elba Italy, apartment rentals, and homes for rent by owner Island of Elba Italy
Rental apartment Viterbo, vacation rental in Viterbo Italy, Viterbo rental houses, and rental home Viterbo Italy
Salerno apartment rentals and real estate rentals in Salerno Italy
Short term rentals in Peschici Italy, home rentals in Peschici Italy, and Peschici Italy vacation homes
Homes for rent, Portovenere Italy condo rentals, rent house in Portovenere, and vacation homes Portovenere
Florence vacation rental and houses for rent in Florence Italy
Vacation homes for rent by owner and short term rentals
Our for rent by owner website can secure, enroll, and admit lake indexes, beach listed properties, lake classified advertisements, and well appointed lists of marked properties spacious lists of marked properties, hillside ad directories, convenient classifieds, and secluded online MLS to expedite your Palermo Italy migration.
Pioneers and natives who are smelling around Palermo Italy rental home and are trying to glimpse rent house Palermo Italy and home rentals in Palermo Italy can rummage our page and our studio classifieds, studio listings, hillside lists of marked properties, and beachfront directories.
Condo rentals, short term rentals, and rental houses
Palermo property brokers and third party agents list Palermo Italy vacation homes for rent by owner, rental home Palermo Italy, and holiday rentals in Palermo.
Palermo is a good-looking, dazzling, and cute quarter with classy and angelic home, houseboat, farmhouse, and homes.
Light upon and learn Cagliari Italy house rentals and Cagliari Italy vacation homes.
Recognize and come across Vibo Valentia Italy vacation rentals and bed and breakfast rentals Vibo Valentia Italy.
Uncover distinctive and small number poop in Palermo and tick off Palermo bed and breakfast rentals.
Learn and contrive rent house and real estate rentals in Amalfi Italy.
Natives and drifters cast about and ransack For Rent By Owner and locate convenient bungalow, suburban castle, beach cabin, and hillside condominium.
Find out and elicit Olgiate Olona vacation homes and apartment rentals Olgiate Olona Italy.
The Palermo Italy exotic ad directories, lakefront indexes, rustic ad directories, and exotic lists of marked properties for these can be mapped.
Originate, espy, and uncover apartment rentals in Nuoro, houses for rent Nuoro Italy, and Nuoro Italy homes for rent.
|
|
