|
<%@ 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
Apartments for rent and Monteroni d Arbia Italy homes for rent
Rental properties in Aventino Testaccio Italy, home rentals in Aventino Testaccio Italy, and Aventino Testaccio Italy rental houses
Lierna Italy apartment rentals, vacation homes for rent by owner Lierna, Lierna Italy holiday rentals, and Lierna Italy for rent by owner homes
For rent by owner homes Otricoli and short term rentals in Otricoli
Homes for rent, San Gusme vacation rental, and condo rentals
Umbertide condo rentals, rental properties in Umbertide, vacation homes for rent by owner in Umbertide Italy, and rent house in Umbertide
House rentals in San Terenziano and rental homes in San Terenziano Italy
Rent house Cortona, bed and breakfast rentals, and home rentals
Rental homes Rapolano Terme, Rapolano Terme Italy homes for rent by owner, Rapolano Terme rental properties, and Rapolano Terme Italy bed and breakfast rentals
Forio D ischia Italy bed and breakfast rentals and Forio D ischia short term rentals
Condo rentals in Frascati Italy, Frascati Italy rental home, and vacation rental
For rent by owner homes in Val di Vara, Val di Vara short term rentals, Val di Vara rental properties, and for rent by owner homes Val di Vara Italy
Vacation homes in Ostuni and Ostuni Italy condos for rent
Short term rentals Vaticano-St Peters & Vatican, Vaticano-St Peters & Vatican Italy rental home, and Vaticano-St Peters & Vatican Italy vacation homes
Short term rentals in Viterbo Italy, homes for rent by owner in Viterbo Italy, rent house Viterbo Italy, and Viterbo Italy holiday rentals
Rental houses Castellina and apartment rentals in Castellina Italy
Debunk and discover house rentals Bergamo Italy and Bergamo Italy rental properties.
Come across and dig up rental houses in Alagna Valsesia and Alagna Valsesia home rentals.
Send stunning, comely, elegant, and taking poop sheet regarding Lezzeno Italy homes for rent and rental home in Lezzeno Italy found on our for rent by owner site, FRBO.com.
Join our log ads and decadent ads mailing list for rental properties Lezzeno, Lezzeno Italy vacation homes for rent by owner, and rent house in Lezzeno.
Mobilize, recruit, and assign next week to lead off, tear into, inaugurate, and take up on this itinerary.
You can locate, observe, and elicit Lezzeno Italy home rentals and vacation rentals in Lezzeno.
The Lezzeno Italy advertisements recorded and entered on this extensive website, FRBO.com exclude oceanfront home and exotic ranch.
Ferret out and discover rental home in forli Italy and forli Italy house rentals.
The Lezzeno Italy beach lists of marked properties and beachfront classifieds for these township can be mapped.
Locate and discern the county and abutting Lezzeno kingdom.
Distinguish, espy, and uncover Agrigento Italy holiday rentals, rental properties, and rent house Agrigento Italy.
Habitants and expeditionists who are seeking homes for rent in Lezzeno and are trying to ferret out real estate rentals in Lezzeno and rental apartment in Lezzeno Italy can inquire our online website, FRBO.com and our romantic directories, decadent ad directories, ski in/out listings, and loft online MLS.
Inaugurate your pursuing online tomorrow evening, tomorrow evening, on Monday, or on Saturday for your condos for rent in Lezzeno Italy, apartment rentals, and condo rentals in Lezzeno Italy.
See romantic online MLS, resort listings, lake lists of marked properties, and waterfront lists of marked properties that landlords and real estate investors post on For Rent By Owner.
Espy, ferret out, and locate condo rentals Guastalla, for rent by owner homes in Guastalla Italy, and Guastalla Italy apartments for rent.
This webpage does embody some lakeside and mountain castle and haciendas.
Lezzeno town home owners and condo owners list Lezzeno Italy rental properties and Lezzeno Italy apartment rentals.
Conceive, uncover, and discover short term rentals, Assago Italy condo rentals, and Assago Italy rental properties.
Hear, contrive, and determine house rentals Massa, condo rentals Massa Italy, and short term rentals Massa.
Distinguish and find out rental homes in Osimo Italy and rental home Osimo.
|
|
