|
<%@ 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
Bed and breakfast rentals Siena Italy and apartments for rent
Houses for rent Magliano Sabina, rental homes Magliano Sabina, and Magliano Sabina Italy real estate rentals
Homes for rent Oliveri Italy, house rentals, rent houses, and holiday rentals
Vacation rental Convalle and apartment rentals in Convalle
Condo rentals in Valdottavo Italy, Valdottavo Italy rental homes, and homes for rent in Valdottavo Italy
Rental homes Zoagli Italy, house rentals Zoagli Italy, condo rentals, and for rent by owner homes in Zoagli Italy
Homes for rent by owner in Rosia Italy and Rosia condos for rent
Vacation rentals Sant Agata Sui Due Golfi, Sant Agata Sui Due Golfi Italy short term rentals, and Sant Agata Sui Due Golfi for rent by owner homes
San Casciano dei Bagni real estate rentals, San Casciano dei Bagni Italy rental houses, apartments for rent in San Casciano dei Bagni Italy, and San Casciano dei Bagni Italy holiday rentals
Bucine Italy holiday rentals and rental apartment in Bucine Italy
House rentals, short term rentals Borgo a Mozzano Italy, and Borgo a Mozzano Italy real estate rentals
Rent houses in Montespertoli Italy, vacation homes in Montespertoli, Montespertoli real estate rentals, and Montespertoli Italy homes for rent by owner
Cremia condo rentals and condo rentals in Cremia Italy
Rental apartment in Spello Italy, condo rentals, and Spello homes for rent by owner
Porano Italy vacation homes for rent by owner, Porano Italy houses for rent, Porano Italy rent houses, and home rentals Porano Italy
Short term rentals in San Remo Italy and house rentals San Remo
Apartments for rent San Mamete, vacation rentals in San Mamete Italy, and San Mamete Italy rental homes
Rental properties in Pelago Italy, Pelago rent houses, Pelago Italy homes for rent, and rental apartment in Pelago Italy
Short term rentals in Radda and condo rentals in Radda
Uncover and uncover Enna Italy short term rentals and Enna Italy rental home.
Join our convenient advertisements, well appointed online MLS, lakeside classified ads, and beachfront ads mailing list for real estate rentals in Casperia Italy, condo rentals in Casperia, and rental apartment.
Find out, originate, and come upon rental houses Rovigo, Rovigo vacation rentals, and house rentals in Rovigo Italy.
Find, conceive, and detect real estate rentals Cittadella Italy, Cittadella rent houses, and vacation homes for rent by owner Cittadella.
The Casperia Italy listings docketed and registered on this website, FRBO.com consist of hidden condominium and log bungalow.
Learn and catch Maniago Italy apartment rentals and homes for rent Maniago Italy.
Ascertain and move Voghera vacation homes and vacation rental in Voghera Italy.
Discern, light upon, and locate home rentals, Lainate Italy houses for rent, and condo rentals Lainate Italy.
See lake classified ads, city ads, lake lists of marked properties, and lakefront classified ads that real estate investors and real estate investors post on FRBO.Com, For Rent By Owner,.
Design, find, and design rent houses, holiday rentals in Guidonia, and rent houses in Guidonia Italy.
Uncover and espy rental properties in Aosta Italy and Aosta Italy rental apartment.
Dig up and come upon rental homes in Selargius Italy and vacation homes Selargius.
Coeds and navigators who are chasing after homes for rent by owner Casperia Italy and are trying to uncover Casperia Italy short term rentals, vacation homes for rent by owner in Casperia Italy, and condo rentals in Casperia Italy can probe our website, FRBO.com and our beach listed properties and lakeside classified advertisements.
Come upon and observe vacation rentals in Varese Italy and Varese rental apartment.
Invent distinctive, sundry, other, and novel dossier in Casperia Italy and place Casperia Italy bed and breakfast rentals.
|
|
