|
<%@ 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
Rental houses in Levanto and bed and breakfast rentals
Home rentals in San Casciano in Val di Pesa, vacation rentals, and San Casciano in Val di Pesa Italy apartments for rent
Forte dei Marmi rental apartment, rental home, Forte dei Marmi Italy home rentals, and rental homes in Forte dei Marmi
Homes for rent by owner Castagnola and vacation rentals Castagnola
Bed and breakfast rentals in Fivizzano Italy, Fivizzano Italy rental homes, and Fivizzano Italy rental houses
Holiday rentals, Marsiliana Italy condos for rent, home rentals Marsiliana Italy, and vacation rental in Marsiliana Italy
Forte dei Marmi Italy rental houses and vacation homes in Forte dei Marmi Italy
Marsiliana Italy condos for rent, houses for rent, and Marsiliana Italy rental home
Rental home Tremezzo Italy, homes for rent Tremezzo Italy, holiday rentals in Tremezzo Italy, and vacation rental
Vacation rentals in Marlia and Marlia real estate rentals
Procchio apartments for rent, Procchio Italy real estate rentals, and Procchio Italy holiday rentals
Rental properties in Frascati Italy, rental apartment, rent house in Frascati Italy, and Frascati Italy homes for rent
Pariana rental home and rental houses in Pariana
Vacation homes for rent by owner in Gattaiola, vacation homes for rent by owner in Gattaiola Italy, and houses for rent Gattaiola
Rental homes in Bologna Italy, Bologna Italy vacation homes for rent by owner, house rentals in Bologna Italy, and condo rentals Bologna Italy
Porto San Paolo Italy holiday rentals and Porto San Paolo apartment rentals
Home rentals in San Gusme Italy, rent houses, and apartments for rent in San Gusme Italy
Apartments for rent Monterubbiano, Monterubbiano Italy rent house, Monterubbiano holiday rentals, and Monterubbiano rental homes
Rent house in Amelia Italy and bed and breakfast rentals Amelia Italy
Chianciano Terme rent houses, Chianciano Terme Italy rental homes, and Chianciano Terme vacation rentals
Vacation rentals, rental homes in Ravello Italy, Ravello Italy rental home, and house rentals Ravello Italy
Vacation rentals Castelli and rental apartment
Gypsies and occupants cast about, look, and forage this webpage and recognize ski in/out farmhouse, beach bungalow, hidden castle, and loft chalet.
Contrive, dig up, and catch vacation rental Avellino Italy, holiday rentals, and apartments for rent in Avellino.
Design and distinguish Alghero rental apartment and holiday rentals Alghero.
You can discern, discover, and contrive Praiano Italy for rent by owner homes and vacation homes in Praiano.
See secluded directories and beachfront listed properties that third party agents and third party listing companies post on this extensive website, FRBO.com.
Locate, recognize, and debunk apartment rentals in Viterbo Italy, Viterbo Italy condo rentals, and vacation rentals Viterbo Italy.
Ferret out, discover, and ferret out rent houses in Vibo Valentia Italy, Vibo Valentia Italy bed and breakfast rentals, and homes for rent by owner in Vibo Valentia.
Detect and invent Omegna Italy rental properties and Omegna Italy short term rentals.
Praiano real estate investors and real estate brokers list vacation rentals Praiano, Praiano Italy vacation rental, house rentals Praiano, and short term rentals in Praiano Italy.
Discover and identify rental homes in Pisa Italy and house rentals in Pisa.
Recognize and notice home rentals in Varese and apartment rentals in Varese Italy.
Praiano Italy details could puff and thump your inspection.
Distinguish, conceive, and look up homes for rent by owner in Treviglio Italy, real estate rentals in Treviglio, and bed and breakfast rentals Treviglio.
Travelers, occupiers, and dwellers who are grubbing for rent by owner homes in Praiano Italy and are trying to observe Praiano vacation rental and rental properties Praiano Italy can search for our site, FRBO.com and our spacious advertisements, lakefront classifieds, rustic directories, and hidden classifieds.
Glimpse, disclose, and debunk rental houses, rental apartment Pavia Italy, and Pavia Italy rental home.
Our for rent by owner website does encompass small number plot lakefront, waterfront, resort, and exotic villa and haciendas.
|
|
