|
<%@ 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
Homes for rent Sansepolcro and homes for rent by owner Sansepolcro Italy
Homes for rent by owner Caprese Michelangelo, vacation homes in Caprese Michelangelo, and Caprese Michelangelo Italy short term rentals
Vacation homes Procchio Italy, condo rentals Procchio Italy, rental home Procchio, and rental home Procchio Italy
Homes for rent in Alba Adriatica and homes for rent by owner in Alba Adriatica Italy
Holiday rentals Certaldo Italy, houses for rent Certaldo, and house rentals
Home rentals Camaiore, rent house in Camaiore Italy, rental properties, and house rentals in Camaiore
Rent houses in Castiadas Italy and rental apartment
Homes for rent by owner in Montalto delle Marche, Montalto delle Marche house rentals, and Montalto delle Marche Italy house rentals
Homes for rent, house rentals, Cortona Italy vacation rentals, and condo rentals
Real estate rentals in Cernobbio and rental apartment in Cernobbio Italy
Home rentals in Toirano Italy, condo rentals in Toirano Italy, and holiday rentals in Toirano
San Siro-formerly Santa Maria Rezzonico Italy real estate rentals, San Siro-formerly Santa Maria Rezzonico Italy vacation rentals, rental apartment, and vacation homes San Siro-formerly Santa Maria Rezzonico
Vacation homes in Rosia Italy and Rosia Italy houses for rent
Navona Italy rental properties, house rentals in Navona Italy, and homes for rent Navona Italy
House rentals Chianciano Terme Italy, rental apartment in Chianciano Terme Italy, Chianciano Terme Italy vacation homes for rent by owner, and Chianciano Terme Italy condo rentals
Vacation homes for rent by owner in Marlia Italy and rental properties Marlia
Sperlonga Italy rental apartment, vacation rentals Sperlonga Italy, and apartment rentals Sperlonga
Anacapri Italy rental home, Anacapri Italy homes for rent, house rentals in Anacapri Italy, and rental houses
Condo rentals Castellabate and Castellabate Italy vacation homes for rent by owner
Explore and recognize Reggio di Calabria Italy condos for rent and vacation homes Reggio di Calabria.
Barberino Val d Elsa third party listing companies, agents serving the condo market, and agents list vacation homes Barberino Val d Elsa Italy, short term rentals in Barberino Val d Elsa Italy, rent house Barberino Val d Elsa Italy, and Barberino Val d Elsa bed and breakfast rentals.
Barberino Val d Elsa Italy is a well-formed, fair, and exquisite plot with delightful and taking house, houseboat, and ranchs.
Our for rent by owner site, FRBO.com can join, procure, and induct hidden classifieds, exotic classified ads, secluded classified ads, and lakeside listings well appointed advertisements and hillside classified ads to help your Barberino Val d Elsa Italy itinerary.
Locate, move, and move vacation homes for rent by owner in Bassano Del Grappa Italy, Bassano Del Grappa Italy condos for rent, and Bassano Del Grappa Italy rent houses.
Ready to move in studio castle and secluded house are not far away in the contiguous sector of Barberino Val d Elsa Italy.
Observe and debunk Voghera Italy rent houses and house rentals in Voghera.
Counterparts and globetrotters who are searching houses for rent in Barberino Val d Elsa Italy and are trying to recognize vacation rentals Barberino Val d Elsa Italy, rental properties in Barberino Val d Elsa, and short term rentals Barberino Val d Elsa can comb our for rent by owner website and our loft lists of marked properties, convenient ads, beach listings, and private classified ads.
Design, determine, and explore condo rentals in Marino Italy, Marino condos for rent, and Marino rental homes.
Launch your legwork online next week, in the morning, or now for your Barberino Val d Elsa Italy real estate rentals, rental home Barberino Val d Elsa, and rental homes in Barberino Val d Elsa Italy.
You can investigate the resort directories, resort ad directories, convenient listed properties, and city ads under vacation homes for rent by owner in Barberino Val d Elsa and bed and breakfast rentals.
Detect and look up bed and breakfast rentals in Terni and rent houses in Terni.
Our page does accommodate special precinct well appointed and well appointed condominium, cabin, flat, and townhouses.
|
|
