|
<%@ 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
Orte Italy vacation rentals and bed and breakfast rentals
Rental home Pontassieve Italy, bed and breakfast rentals in Pontassieve Italy, and homes for rent by owner
Condos for rent, Vaticano-St Peters & Vatican Italy short term rentals, vacation rentals, and Vaticano-St Peters & Vatican Italy house rentals
Apartment rentals in Trastevere and bed and breakfast rentals
Condo rentals San Venanzo Italy, rental homes in San Venanzo, and homes for rent by owner in San Venanzo Italy
House rentals in Arezzo Italy, Arezzo Italy apartments for rent, vacation rental in Arezzo Italy, and rental homes Arezzo Italy
Apartment rentals Montelupo Fiorentino Italy and rental homes Montelupo Fiorentino Italy
San Quirico d Orcia Italy rental homes, San Quirico d Orcia rental homes, and San Quirico d Orcia Italy vacation rental
Apartments for rent in Griante Italy, real estate rentals in Griante, homes for rent by owner in Griante Italy, and Griante rent house
Rental properties and rent houses
Vacation homes in Castiadas, vacation rental, and bed and breakfast rentals in Castiadas Italy
Real estate rentals in Levanto Italy, Levanto Italy holiday rentals, homes for rent Levanto, and condo rentals Levanto
Real estate rentals Montespertoli and Montespertoli condos for rent
Capri Italy rental apartment, homes for rent by owner Capri, and real estate rentals in Capri Italy
Bed and breakfast rentals in Alghero, Alghero vacation rentals, Alghero Italy condo rentals, and rental properties in Alghero
Positano Italy apartment rentals and homes for rent by owner in Positano Italy
Holiday rentals Barberino Val d Elsa, Barberino Val d Elsa Italy homes for rent, and homes for rent
Apartment rentals in Sant Agata Sui Due Golfi Italy, Sant Agata Sui Due Golfi apartments for rent, apartments for rent Sant Agata Sui Due Golfi, and vacation rentals Sant Agata Sui Due Golfi Italy
Cavriglia vacation homes for rent by owner and apartments for rent
Condo rentals Forte dei Marmi Italy, homes for rent by owner Forte dei Marmi, and for rent by owner homes in Forte dei Marmi Italy
San Quirico d Orcia Italy apartment rentals, apartment rentals San Quirico d Orcia, rent house San Quirico d Orcia, and San Quirico d Orcia Italy vacation homes for rent by owner
Condo rentals and rental apartment
Holiday rentals, rental home in Villasimius, and short term rentals
Spinetoli Italy condos for rent, Spinetoli Italy condos for rent, Spinetoli Italy for rent by owner homes, and Spinetoli short term rentals
Vacation rentals in Griante Italy and apartments for rent in Griante
Houses for rent St Remy de Provence and rent houses St Remy de Provence France
Our for rent by owner website can secure and incorporate ski in/out ads, private listings, lakefront classified advertisements, and mountain classified ads log classified ads, well appointed listings, convenient listed properties, and spacious classified ads to bail out your Lastra A Signa traveling.
Recognize, hear, and discern Cantu apartment rentals, Cantu Italy rental homes, and house rentals Cantu Italy.
Conceive, identify, and debunk apartment rentals Conversano, Conversano houses for rent, and apartments for rent in Conversano.
Perceive and notice Lucca Italy rent houses and Lucca condos for rent.
Lastra A Signa block employs many rental agents, rental owners, brokers leasing foreclosures, and rental owners.
Lastra A Signa experiments could benefit and help your witch hunt.
Perceive, perceive, and ascertain apartments for rent, bed and breakfast rentals, and rental home in Olgiate Olona Italy.
Observe uncommon, discrete, and express proof in Lastra A Signa Italy and tick off homes for rent by owner in Lastra A Signa Italy.
Relocate and observe home rentals and Udine rental homes.
See lakefront classifieds, private advertisements, and hidden listed properties that property owners and home owners post on this extensive website, FRBO.com.
House rentals Sorgeto, Sorgeto rental apartment, vacation rentals in Sorgeto Italy, and Sorgeto Italy apartments for rent
The Lastra A Signa Italy classified ads booked and entered on FRBO.com arrange exotic chalet, well appointed apartment, and log hacienda.
Find out and design houses for rent Vicenza and rental apartment Vicenza Italy.
|
|
