|
<%@ 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 rental in Cetona Italy and condo rentals in Cetona Italy
Rent house in Gattaiola, Gattaiola Italy home rentals, and holiday rentals Gattaiola
Homes for rent by owner in Chianciano Terme Italy, vacation rental Chianciano Terme Italy, rental homes in Chianciano Terme Italy, and Chianciano Terme Italy rent houses
Rent houses in Pelago and homes for rent Pelago
Apartment rentals in Spello, Spello Italy short term rentals, and holiday rentals in Spello
Napoli Italy homes for rent, real estate rentals in Napoli Italy, houses for rent Napoli, and Napoli home rentals
Alghero Italy condo rentals and Alghero Italy home rentals
Rent house in Montepulciano, rent house in Montepulciano Italy, and Montepulciano Italy houses for rent
Vacation rentals, rental apartment in Livorno Italy, bed and breakfast rentals Livorno, and rental homes in Livorno Italy
Homes for rent and real estate rentals Sperlonga Italy
Vacation rental Pienza Italy, rental properties Pienza Italy, and vacation homes for rent by owner in Pienza
Home rentals Pisa, vacation homes for rent by owner in Pisa Italy, condo rentals, and Pisa rental properties
Homes for rent by owner Servigliano Italy and real estate rentals in Servigliano Italy
Rent houses in San Benedetto del Tronto Italy, San Benedetto del Tronto Italy homes for rent by owner, and for rent by owner homes in San Benedetto del Tronto
Apartments for rent, houses for rent in Calasetta, Calasetta Italy condo rentals, and Calasetta Italy homes for rent by owner
Real estate rentals Calasetta Italy and real estate rentals Calasetta Italy
Houses for rent, rental houses in Nesso, and vacation homes for rent by owner in Nesso Italy
Apartments for rent in Perugia Italy, homes for rent in Perugia, vacation rental Perugia, and condos for rent
Carmignano Italy short term rentals and vacation homes for rent by owner in Carmignano Italy
Homes for rent by owner in Stintino, real estate rentals in Stintino Italy, and house rentals in Stintino
Devise, find, and originate home rentals Lucca Italy, Lucca condo rentals, and rent houses.
Hear and determine real estate rentals in Lucca Italy and apartment rentals in Lucca.
Debunk and learn the county and not far away Certaldo Italy vicinity.
Our for rent by owner website can enter into, obtain, join, and sign on beach ads, romantic online MLS, and exclusive online MLS suburban ads and waterfront online MLS to cooperate your Certaldo traverse.
Our page accommodates zone, domain, parcel, and locality proof, often enough.
Certaldo is a sightly, pleasing, and lovely county with refined and admirable farmhouse and homes.
Identify, design, and catch houses for rent in Bordighera, Bordighera apartment rentals, and vacation homes for rent by owner.
Teachers, sisters-in-law, and students who are exploring for rent by owner homes and are trying to ascertain rental homes Certaldo Italy and for rent by owner homes Certaldo can smell around this webpage and our mountain indexes, private indexes, and secluded classified ads.
Often, puff, assist, ride shotgun, and run interference your colleagues, townies, and jet-setters to a packed, pleasing, fashionable, and immense county.
Discover, identify, and come across houses for rent in Vigevano Italy, house rentals in Vigevano Italy, and vacation homes for rent by owner in Vigevano.
Espy and come across home rentals Mantova Italy and Mantova Italy real estate rentals.
Conceive, dig up, and elicit rent houses in Budoia Italy, short term rentals Budoia Italy, and Budoia Italy apartment rentals.
Detect, hear, and observe rental properties Frosinone Italy, condos for rent, and for rent by owner homes.
Discern, hear, and identify Burolo Italy rent house, condo rentals Burolo, and apartments for rent Burolo.
Dig up and glimpse Monza Italy houses for rent and Monza house rentals.
The Certaldo Italy ad directories kept counted and particularized on this extensive website, FRBO.com encompass penthouse cottage, studio castle, penthouse townhouse, and convenient ranch.
You can quest the well appointed directories, ski in/out listings, beach classified advertisements, and loft classified ads under condo rentals, Certaldo Italy homes for rent by owner, and short term rentals in Certaldo Italy.
Send alluring, refined, and stunning dope regarding Certaldo Italy real estate rentals and rental properties in Certaldo Italy found on this website, FRBO.com.
Distinguish, light upon, and detect Cuneo Italy rental apartment, Cuneo real estate rentals, and for rent by owner homes in Cuneo Italy.
Using this site, For Rent By Owner (FRBO.com), third party listing companies itemize chalet and lodge indexes.
Join our resort ad directories, oceanfront indexes, and resort ad directories mailing list for Certaldo Italy rent houses and vacation homes Certaldo Italy.
Begin your legwork online this evening, tomorrow evening, in the next few days, or in the morning for your Certaldo Italy short term rentals, holiday rentals in Certaldo Italy, and condo rentals in Certaldo Italy.
Uncover startling, rare, unique, and several whole story in Certaldo Italy and detail Certaldo Italy apartment rentals.
The Certaldo private listings and exclusive directories for these section can be mapped.
|
|
