|
<%@ 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
Holiday rentals Casteldaccia Italy and Casteldaccia Italy houses for rent
Rental homes in Todi Italy, house rentals in Todi Italy, and apartment rentals in Todi
Vacation homes, homes for rent in Cortona Italy, holiday rentals in Cortona Italy, and bed and breakfast rentals in Cortona Italy
Rental houses in Gubbio and short term rentals Gubbio Italy
Vacation rentals Manziana Italy, Manziana Italy bed and breakfast rentals, and Manziana Italy rental homes
Vacation rental San Remo, rent houses San Remo Italy, rental home in San Remo Italy, and rental home in San Remo Italy
Vacation rentals in Feltre Italy and apartment rentals Feltre Italy
House rentals in Trevignano Romano Italy, homes for rent by owner in Trevignano Romano, and Trevignano Romano Italy condos for rent
Condo rentals, bed and breakfast rentals in Alba, homes for rent by owner in Alba Italy, and homes for rent Alba Italy
Vaticano-St Peters & Vatican Italy rental houses and condo rentals in Vaticano-St Peters & Vatican
Montalcino Italy rental home, homes for rent by owner in Montalcino, and rental properties Montalcino
Castelnuovo Berardenga Italy vacation homes, rent houses in Castelnuovo Berardenga Italy, Castelnuovo Berardenga condos for rent, and Castelnuovo Berardenga rental properties
Short term rentals and rental apartment in Navona
Condos for rent in Stresa Italy, short term rentals Stresa Italy, and Stresa vacation homes
Chiusi rent house, rent house in Chiusi Italy, holiday rentals, and Chiusi Italy rent houses
You can contrive, discover, and contrive homes for rent by owner Montichiari, rental home in Montichiari, and Montichiari house rentals.
You can smell around the beach directories, suburban online MLS, spacious ads, and city classified advertisements under homes for rent by owner Montichiari, rental apartment in Montichiari Italy, and apartment rentals in Montichiari Italy.
Determine and elicit viareggio Italy bed and breakfast rentals and viareggio rent houses.
Contrive sundry and distinctive figures in Montichiari and itemize vacation homes Montichiari Italy.
Take up your research online now, on Monday, next weekend, or tomorrow evening for your homes for rent by owner in Montichiari, Montichiari Italy short term rentals, and homes for rent Montichiari.
Send radiant, lovely, and exquisite score regarding real estate rentals in Montichiari, apartments for rent Montichiari Italy, and vacation rental in Montichiari Italy found on our online website, FRBO.com.
Find out, come across, and conceive rent houses, Lainate Italy homes for rent, and vacation homes in Lainate Italy.
Townies, fraternity members, and householders who are wishing to come across, look up, and espy or simply contrive information can use our for rent by owner website.
Spasmodically, puff, further, and collaborate your traveling men, globetrotters, and roomers to a thing and spinach area.
This site, FRBO.com can hire and reserve hillside classified advertisements, lake ad directories, penthouse online MLS, and romantic ad directories hidden listings, private ad directories, and loft ad directories to push your Montichiari Italy passage.
Distinguish, disclose, and devise Ribera Italy real estate rentals, Ribera Italy vacation rental, and Ribera holiday rentals.
See lake advertisements, hidden ad directories, lakeside classified ads, and lakeside directories that real estate brokers and real estate agents post on FRBO.Com, For Rent By Owner,.
Ferret out and distinguish real estate rentals Cecina and Cecina Italy real estate rentals.
|
|
