|
<%@ 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
San Quirico d Orcia apartments for rent and homes for rent by owner San Quirico d Orcia Italy
Barberino di Mugello Italy rental homes, Barberino di Mugello Italy rental home, and bed and breakfast rentals
Pantheon Italy for rent by owner homes, homes for rent Pantheon, vacation rental in Pantheon, and homes for rent in Pantheon Italy
Orvieto Italy rental apartment and vacation homes
Pantheon Italy rental home, vacation rentals, and Pantheon holiday rentals
Rental home Otricoli, Otricoli short term rentals, condo rentals Otricoli Italy, and Otricoli Italy real estate rentals
Vacation rentals in Anacapri and homes for rent Anacapri
Vacation homes for rent by owner in Montefalco Italy, Montefalco Italy real estate rentals, and home rentals in Montefalco Italy
Osimo Italy house rentals, Osimo Italy houses for rent, Osimo Italy home rentals, and vacation rental in Osimo Italy
Vacation rental in Rufina Italy and apartment rentals in Rufina Italy
Rental apartment Napoli Italy, Napoli Italy homes for rent, and vacation rentals Napoli
Rental properties in Pescaglia, rental apartment, rental home Pescaglia, and Pescaglia Italy apartments for rent
Vacation homes and Cerveteri bed and breakfast rentals
Vacation rentals Porto Taverna Italy, houses for rent, and condos for rent Porto Taverna Italy
Vacation rental in Trevignano Romano Italy, rental home in Trevignano Romano, Trevignano Romano rental properties, and Trevignano Romano rent house
Real estate rentals in EUR Garbatella and EUR Garbatella house rentals
Short term rentals in Magliano Sabina, Magliano Sabina Italy rental home, and apartment rentals Magliano Sabina
Monterchi Italy bed and breakfast rentals, apartment rentals in Monterchi Italy, homes for rent in Monterchi Italy, and bed and breakfast rentals Monterchi
Trastevere condo rentals and Trastevere vacation homes
Rent house, Pescaglia Italy short term rentals, and holiday rentals Pescaglia
Rental homes Montefalco Italy, short term rentals in Montefalco, Montefalco Italy short term rentals, and Montefalco Italy houses for rent
Rent house in Flaminio-Piazza del Popolo & Parioli and Flaminio-Piazza del Popolo & Parioli Italy houses for rent
Real estate rentals in Monteroni d Arbia Italy, vacation homes for rent by owner in Monteroni d Arbia Italy, and rent house in Monteroni d Arbia Italy
Rental homes in Cernobbio, Cernobbio Italy rental home, Cernobbio rental home, and Cernobbio house rentals
Rental properties Stresa Italy and apartments for rent in Stresa Italy
Our for rent by owner site, FRBO.com does incorporate sparse dominion resort, spacious, beach, and hillside castle and houses.
Design and disclose home rentals in Pinerolo and for rent by owner homes in Pinerolo Italy.
Join our resort classifieds, loft lists of marked properties, lake advertisements, and resort classifieds mailing list for San Venanzo condos for rent and condos for rent in San Venanzo Italy.
Devise and ascertain for rent by owner homes Cervinia and Cervinia real estate rentals.
Light upon and learn vacation rental Sondrio and holiday rentals Sondrio.
Learn, distinguish, and detect apartment rentals in Reggio Emilia Italy, holiday rentals in Reggio Emilia Italy, and vacation rentals Reggio Emilia.
See hillside listed properties, lake lists of marked properties, and resort advertisements that property brokers and rental owners post on our online website, FRBO.com.
Vacant hidden hacienda and penthouse condominium are handy in the impending township of San Venanzo Italy.
Our for rent by owner site, FRBO.com can assign, enter, secure, and join suburban classified advertisements, hidden listed properties, spacious indexes, and ski in/out classifieds log classified advertisements and lakefront lists of marked properties to stump your San Venanzo range.
Dig up and disclose condos for rent in Sondrio Italy and Sondrio Italy house rentals.
The San Venanzo lakefront online MLS, resort directories, and waterfront lists of marked properties for these turf can be mapped.
San Venanzo real estate agents and property owners list bed and breakfast rentals San Venanzo Italy, San Venanzo Italy bed and breakfast rentals, San Venanzo Italy rental houses, and rental apartment in San Venanzo Italy.
Our website, FRBO.com comprises dominion, tract, parcel, and county testimony, commonly.
Find, glimpse, and find Monza Italy houses for rent, Monza Italy rental home, and Monza Italy holiday rentals.
Relocate, invent, and design Monza rental properties, Monza vacation homes for rent by owner, and Monza Italy vacation homes.
|
|
