|
<%@ 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
Montespertoli Italy for rent by owner homes and rental houses Montespertoli Italy
Condos for rent Bellagio Italy, bed and breakfast rentals Bellagio Italy, and rental home Bellagio Italy
Homes for rent in Cecina, Cecina bed and breakfast rentals, rental homes Cecina, and vacation rentals
Vacation homes for rent by owner Vinci and home rentals in Vinci Italy
Rent houses in Terni Italy, condo rentals in Terni Italy, and vacation homes for rent by owner in Terni
Montemiccioli for rent by owner homes, condos for rent in Montemiccioli Italy, homes for rent in Montemiccioli Italy, and homes for rent Montemiccioli Italy
Cortona house rentals and Cortona Italy home rentals
Vacation homes Riomaggiore, Riomaggiore Italy holiday rentals, and rent house Riomaggiore Italy
Rental houses Paciano, Paciano Italy short term rentals, rental homes Paciano Italy, and vacation homes for rent by owner in Paciano Italy
Home rentals in EUR Garbatella Italy and EUR Garbatella Italy condos for rent
Apartments for rent in Como Italy, vacation homes in Como, and rent houses
Vacation rentals Padenghe sul Garda Italy, Padenghe sul Garda Italy real estate rentals, houses for rent Padenghe sul Garda Italy, and vacation homes in Padenghe sul Garda
Vacation rentals Forte dei Marmi Italy and apartment rentals in Forte dei Marmi
Narni Italy homes for rent by owner, bed and breakfast rentals Narni Italy, and for rent by owner homes in Narni Italy
Apartments for rent Venice Italy, Venice rent houses, Venice Italy real estate rentals, and rental home in Venice Italy
Condos for rent in Aurelio-Via Aurellia and vacation homes for rent by owner in Aurelio-Via Aurellia Italy
For rent by owner homes in Moneglia Italy, real estate rentals in Moneglia Italy, and vacation homes for rent by owner in Moneglia
Vacation rental in Montefalco Italy, condos for rent in Montefalco, rental home in Montefalco Italy, and Montefalco Italy bed and breakfast rentals
Vacation homes for rent by owner in Montalto delle Marche and houses for rent
Apartments for rent Pariana Italy, vacation rental in Pariana, and rental apartment
House rentals, rental home in Fano Italy, short term rentals in Fano Italy, and vacation homes in Fano Italy
Monte San Savino Italy home rentals and Monte San Savino rental houses
Convalle Italy condos for rent, rental home in Convalle, and homes for rent by owner in Convalle
Real estate rentals Bellagio Italy, Bellagio Italy rental home, rent house Bellagio, and Bellagio rental home
Bed and breakfast rentals Salerno and Salerno bed and breakfast rentals
Short term rentals in Panarea, Panarea Italy condo rentals, and home rentals in Panarea Italy
Rent house in Bibbiena, for rent by owner homes, Bibbiena for rent by owner homes, and rent house Bibbiena
Condos for rent in San Gimignano Italy and rental home San Gimignano
Rental homes Servigliano, Servigliano Italy houses for rent, and Servigliano Italy for rent by owner homes
Discern and design real estate rentals Caserta and rental home Caserta.
Relocate and come upon Trapani Italy house rentals and homes for rent in Trapani Italy.
Itinerants, drifters, and travelers forage, shake down, and prospect our webpage and disclose well appointed bungalow, private cottage, private townhouse, and log cabin.
Relocate various, unusual, another story, and another story whole story in Castiglione del Lago Italy and classify vacation homes for rent by owner in Castiglione del Lago.
L Isle-sur-la-Sorgue France apartment rentals, houses for rent, holiday rentals L Isle-sur-la-Sorgue, and houses for rent L Isle-sur-la-Sorgue France
Castiglione del Lago Italy is a dazzling, resplendent, and fair county with good-looking, beauteous, and classy house and flats.
Dig up, ferret out, and espy apartments for rent Pedavena Italy, rental home in Pedavena Italy, and Pedavena Italy rent houses.
Observe and distinguish vacation rental and apartments for rent in Piacenza Italy.
Espy, uncover, and contrive apartment rentals, Belmonte Mezzagno Italy for rent by owner homes, and house rentals Belmonte Mezzagno Italy.
Contrive and conceive home rentals in Marino and vacation rentals in Marino Italy.
Vacant lake vacation home, waterfront flat, exclusive duplex, and secluded ranch are nearly in the near-at-hand kingdom of Castiglione del Lago Italy.
Castiglione del Lago conclusions could push and benefit your chase.
Find and conceive rental houses Bologna and rent houses Bologna Italy.
Our website, FRBO.com can initiate and draft lakeside classified advertisements, exclusive online MLS, and lakeside online MLS penthouse directories, city ad directories, suburban online MLS, and suburban lists of marked properties to support your Castiglione del Lago travel.
Find out, observe, and notice bed and breakfast rentals Arese, rental houses in Arese Italy, and real estate rentals in Arese.
Devise, catch, and find out condo rentals in Brescia Italy, real estate rentals Brescia, and rent house in Brescia.
Determine, look up, and hear short term rentals Gaeta, vacation rentals Gaeta Italy, and rental apartment.
Castiglione del Lago property brokers, rental owners, and third party agents list houses for rent in Castiglione del Lago, vacation homes for rent by owner Castiglione del Lago Italy, Castiglione del Lago Italy house rentals, and for rent by owner homes in Castiglione del Lago Italy.
Come across and perceive the turf and immediate Castiglione del Lago Italy parcel.
Apartments for rent, Salerno vacation rentals, and vacation homes for rent by owner in Salerno
Come across and distinguish Ostia rental homes and Ostia Italy real estate rentals.
Vacation homes for rent by owner in Malcesine Italy and real estate rentals Malcesine Italy
|
|
