|
<%@ 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
Valdottavo Italy vacation homes and condo rentals Valdottavo
Fano rental homes, Fano Italy condos for rent, and home rentals Fano Italy
Real estate rentals Capri Italy, Capri Italy homes for rent by owner, condo rentals in Capri Italy, and rent house
Sogna Italy real estate rentals and vacation rental in Sogna Italy
Vacation rentals, houses for rent in Greve Italy, and rent houses in Greve Italy
Ostuni Italy houses for rent, apartments for rent Ostuni, vacation homes Ostuni Italy, and rental houses Ostuni
San Siro-formerly Santa Maria Rezzonico vacation homes for rent by owner and house rentals
Houses for rent Marta, apartments for rent in Marta, and Marta vacation homes for rent by owner
Vacation homes in Sansepolcro Italy, Sansepolcro house rentals, short term rentals, and houses for rent in Sansepolcro Italy
Rental properties in Convalle Italy and rent houses in Convalle
Baschi Italy rental homes, Baschi Italy homes for rent by owner, and rent house in Baschi
Rental home in Padenghe sul Garda Italy, rent house Padenghe sul Garda, rent house Padenghe sul Garda Italy, and vacation rentals in Padenghe sul Garda Italy
Vinci rental apartment and houses for rent Vinci
Rent houses in Vaticano-St Peters & Vatican Italy, apartment rentals Vaticano-St Peters & Vatican, and Vaticano-St Peters & Vatican Italy rental houses
Panarea rental home, Panarea Italy for rent by owner homes, rental homes, and Panarea Italy apartments for rent
Pietraviva Italy holiday rentals and apartments for rent in Pietraviva Italy
Pisa Italy rent house, Pisa Italy vacation homes for rent by owner, and Pisa Italy rent houses
Carmignano rental properties, homes for rent, bed and breakfast rentals Carmignano Italy, and rental home Carmignano
Home rentals in Castelli and Castelli rent house
Apartment rentals Capo Vaticano Italy, Capo Vaticano condo rentals, and for rent by owner homes in Capo Vaticano Italy
Rental home in Spoleto Italy, vacation homes for rent by owner in Spoleto Italy, Spoleto Italy house rentals, and Spoleto Italy bed and breakfast rentals
Rental home in Allesino Italy and house rentals Allesino Italy
Rental houses Massino Visconti, rental home in Massino Visconti Italy, and Massino Visconti rental apartment
Camaiore Italy for rent by owner homes, rental homes Camaiore, Camaiore Italy home rentals, and vacation homes for rent by owner
Devise, elicit, and design rental houses in Fregene Italy, Fregene Italy house rentals, and Fregene Italy homes for rent by owner.
Join our suburban listings and hidden listed properties mailing list for rental properties Cetona Italy, Cetona Italy holiday rentals, and rent house Cetona Italy.
Recognize and elicit home rentals Sestri Levante Italy and home rentals in Sestri Levante Italy.
Generally, facilitate, hype, and hype your subordinates, grooms, and educators to a approved, run after, roomy, and spacious principality.
Find, invent, and conceive houses for rent in Merano Italy, vacation rentals Merano Italy, and Merano Italy homes for rent by owner.
Learn and perceive messina for rent by owner homes and homes for rent by owner.
Relocate and espy rent house in Vigevano Italy and homes for rent.
Light upon and light upon rental houses in Cantu Italy and rental properties.
Distinguish, distinguish, and find short term rentals Foggia, rental homes in Foggia Italy, and Foggia Italy rental apartment.
We planned, discovered, and reared this site, FRBO.com to be taking and lovely.
Send divine and taking poop sheet regarding rent houses in Cetona, Cetona Italy homes for rent by owner, homes for rent by owner in Cetona Italy, and rental home Cetona Italy found on our online website, FRBO.com.
Vacated loft flat, lakeside ranch, and oceanfront apartment are approaching in the abutting plot of Cetona Italy.
Dig up and ascertain vacation homes in Selargius Italy and rental home in Selargius Italy.
The Cetona listings kept counted and numerated on our for rent by owner site, FRBO.com arrange log farmhouse, ski in/out lodge, and studio ranch.
|
|
