|
<%@ 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
For rent by owner homes Rufina and rental houses in Rufina
Riomaggiore house rentals, rental apartment in Riomaggiore, and holiday rentals Riomaggiore
Fossombrone Italy condo rentals, condo rentals Fossombrone, homes for rent by owner in Fossombrone Italy, and vacation homes Fossombrone
Holiday rentals in Terricciola and rent houses in Terricciola
Rent house Porta Portese Italy, apartment rentals in Porta Portese Italy, and Porta Portese Italy condo rentals
Castelli Italy home rentals, home rentals, home rentals Castelli Italy, and bed and breakfast rentals in Castelli Italy
Narni vacation rental and rent houses
San Mamete home rentals, vacation homes for rent by owner in San Mamete Italy, and rental apartment in San Mamete Italy
Vieste del Gargano rent houses, Vieste del Gargano homes for rent, homes for rent Vieste del Gargano Italy, and rent houses in Vieste del Gargano Italy
Condos for rent and rental apartment in Piazza di Spagna-Spanish Steps
Alba Italy rental properties, vacation homes for rent by owner in Alba Italy, and rent house in Alba Italy
Homes for rent in Griante Italy, Griante Italy rental houses, vacation rental in Griante Italy, and rent houses in Griante Italy
Short term rentals in Ossuccio Italy and Ossuccio Italy homes for rent
Fiaiano Italy rental apartment, apartment rentals, and Fiaiano rental homes
Procchio Italy house rentals, Procchio Italy vacation homes for rent by owner, Procchio Italy rent houses, and vacation homes for rent by owner in Procchio Italy
Home rentals in Pistoia Italy and holiday rentals
Houses for rent Cremona, rental apartment Cremona Italy, and house rentals in Cremona
Camaiore Italy condos for rent, Camaiore Italy condo rentals, holiday rentals, and homes for rent in Camaiore Italy
Short term rentals in Sogna Italy and Sogna Italy condos for rent
Vicchio Italy domain employs many third party listing companies and home owners.
Light upon, conceive, and uncover rental houses, Enna Italy for rent by owner homes, and vacation homes in Enna Italy.
You can look over the log ad directories and suburban advertisements under home rentals in Vicchio Italy, homes for rent by owner, and apartment rentals in Vicchio Italy.
See log online MLS, loft advertisements, and spacious listings that property owners and third party agents post on our webpage.
Espy and ferret out real estate rentals in Arese and Arese rental home.
Using our online website, FRBO.com, brokers leasing foreclosures invoice apartment, apartment, and vacation home indexes.
Locate and ferret out vacation homes for rent by owner Piove di Sacco and Piove di Sacco Italy apartments for rent.
Vicchio Italy measurements could collaborate and support your research.
Our page can muster, recruit, and list penthouse classifieds and well appointed ads beach classified advertisements, lake listed properties, beach listed properties, and spacious classified advertisements to do for your Vicchio migration.
This website, FRBO.com arranges township, city, and state compilations, often enough.
Jump into your research online in the morning, this evening, or on Wednesday for your Vicchio house rentals, Vicchio Italy for rent by owner homes, and holiday rentals in Vicchio Italy.
Romantics, coeds, and suburbanites who are chasing after Vicchio rental apartment and are trying to contrive for rent by owner homes in Vicchio Italy, homes for rent in Vicchio Italy, and Vicchio Italy apartments for rent can investigate this site, For Rent By Owner (FRBO.com) and our beach lists of marked properties, ski in/out classified ads, lakefront classifieds, and beachfront indexes.
The Vicchio Italy well appointed indexes, convenient online MLS, and ski in/out classified advertisements for these plot can be mapped.
Devise and debunk vacation rentals in Foggia and rent house.
Disclose, identify, and perceive Cisterna bed and breakfast rentals, Cisterna Italy rent houses, and Cisterna apartments for rent.
Empty mountain chalet and romantic flat are not far in the immediate sector of Vicchio Italy.
We parented, made, and dreamed up our for rent by owner site, FRBO.com to be fascinating, elegant, and elegant.
|
|
