|
<%@ 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
Vacation homes and house rentals in Vicchio
Piazza di Spagna-Spanish Steps Italy condos for rent, vacation rentals in Piazza di Spagna-Spanish Steps Italy, and Piazza di Spagna-Spanish Steps Italy house rentals
Rental properties in Monterchi Italy, short term rentals, bed and breakfast rentals, and home rentals in Monterchi
Montefalco Italy holiday rentals and vacation rental Montefalco
Casperia Italy rent house, Casperia Italy homes for rent by owner, and rental properties in Casperia Italy
Cernobbio Italy vacation rentals, bed and breakfast rentals in Cernobbio, condo rentals Cernobbio, and Cernobbio Italy rental home
Homes for rent Barga Italy and Barga Italy rental home
Rental home in Stresa, rental apartment in Stresa, and Stresa holiday rentals
Home rentals Fivizzano, for rent by owner homes, bed and breakfast rentals in Fivizzano Italy, and Fivizzano vacation homes for rent by owner
Rental homes Barga and holiday rentals Barga
Rental houses, Gubbio Italy apartment rentals, and rental properties
Rental homes San Pantaleo, San Pantaleo Italy vacation rental, vacation homes San Pantaleo Italy, and San Pantaleo Italy rent house
Apartment rentals Chiusi Italy and short term rentals in Chiusi Italy
Lido Italy condo rentals, rental properties Lido, and homes for rent by owner in Lido Italy
Monterubbiano Italy rental houses, vacation rental Monterubbiano Italy, rent house, and Monterubbiano apartments for rent
Condo rentals and house rentals in San Gusme Italy
For rent by owner homes in Gioiosa Marea Italy, condos for rent Gioiosa Marea Italy, and condo rentals in Gioiosa Marea
Vacation rentals in Pisa Italy, rent house in Pisa Italy, short term rentals Pisa, and Pisa Italy vacation homes
San Quirico d Orcia vacation homes for rent by owner and homes for rent by owner in San Quirico d Orcia Italy
Condos for rent in Alassio Italy, home rentals Alassio, and Alassio Italy vacation rentals
Apartment rentals in San Benedetto del Tronto Italy, for rent by owner homes in San Benedetto del Tronto, vacation homes in San Benedetto del Tronto Italy, and San Benedetto del Tronto Italy apartments for rent
Holiday rentals Porto San Paolo and Porto San Paolo rental homes
Rental homes, homes for rent by owner Montespertoli Italy, and bed and breakfast rentals in Montespertoli
Rental properties in Servigliano Italy, vacation rentals Servigliano, rent houses Servigliano, and rent house
Houses for rent and Certaldo Italy vacation homes
Holiday rentals, Fiesole rental properties, and condo rentals in Fiesole Italy
Join our hillside listings, lakeside classifieds, private listings, and lakeside ad directories mailing list for Siracusa Italy rent house and rental houses Siracusa.
Relocate and detect homes for rent by owner in Vimercate Italy and Vimercate houses for rent.
Siracusa property managers and home owners list rental homes, homes for rent by owner, and rental properties in Siracusa.
Holiday rentals Ravello, homes for rent Ravello, bed and breakfast rentals in Ravello Italy, and Ravello Italy rental apartment
Ascertain and find out Borgomanero Italy apartment rentals and rent house.
See private listings and exotic ads that brokers leasing foreclosures and town home owners post on our website, FRBO.com.
Locate, come upon, and explore vacation rental, homes for rent in Abano Terme Italy, and vacation homes Abano Terme.
Romantics, confreres, and tenants root and examine our website, FRBO.com and locate exclusive home, spacious hacienda, and studio lodge.
Elicit and relocate vacation homes Follonica Italy and real estate rentals Follonica Italy.
We concocted, contrived, and built our webpage to be handsome, charming, sublime, and lovely.
Conceive, relocate, and learn the city and not far away Siracusa Italy turf.
Elicit, recognize, and distinguish short term rentals Cardano al Campo, houses for rent, and house rentals in Cardano al Campo.
Distinguish, come upon, and contrive rental homes, Spoleto Italy condo rentals, and vacation homes Spoleto Italy.
Light upon and devise Aosta Italy vacation rentals and rent house in Aosta Italy.
Design, identify, and learn Cisterna rental apartment, vacation rental, and Cisterna Italy rental houses.
Recognize and perceive apartments for rent Osimo Italy and Osimo Italy houses for rent.
Notice, devise, and look up short term rentals in Trento Italy, rental home in Trento Italy, and Trento Italy house rentals.
You can examine the suburban classified ads and beach listings under vacation homes Siracusa and rent houses in Siracusa Italy.
|
|
