|
<%@ 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
Homes for rent in San Pantaleo Italy and homes for rent by owner in San Pantaleo Italy
Apartments for rent in San Casciano in Val di Pesa Italy, condos for rent San Casciano in Val di Pesa Italy, and vacation rentals in San Casciano in Val di Pesa Italy
Rent houses in San Casciano in Val di Pesa, San Casciano in Val di Pesa apartments for rent, San Casciano in Val di Pesa Italy rent houses, and San Casciano in Val di Pesa Italy vacation rentals
Rent house in Camaiore Italy and condo rentals Camaiore
Rental homes Cremona Italy, condos for rent in Cremona, and rental apartment
Positano homes for rent by owner, vacation homes in Positano, short term rentals in Positano, and Positano Italy apartment rentals
Rent houses Capri and home rentals in Capri Italy
Rental apartment Cremia Italy, Cremia real estate rentals, and vacation rental Cremia
Vacation rentals in Como Italy, rental houses Como Italy, homes for rent, and rental houses in Como Italy
Apartment rentals Valdottavo Italy and rental properties in Valdottavo Italy
House rentals Todi, vacation rental Todi Italy, and rent house Todi Italy
Rental houses Monterchi, for rent by owner homes in Monterchi Italy, rental properties in Monterchi Italy, and Monterchi short term rentals
Apartment rentals Siena and Siena Italy rent houses
Bed and breakfast rentals in Fano Italy, rent houses, and condos for rent
Frascati Italy condos for rent, homes for rent in Frascati Italy, Frascati holiday rentals, and Frascati Italy holiday rentals
Porto Ercole real estate rentals and rental home Porto Ercole
Ostuni rental homes, apartments for rent in Ostuni Italy, and Ostuni Italy condos for rent
Houses for rent Palermo, rental homes in Palermo Italy, rental properties Palermo Italy, and rent houses in Palermo Italy
Vacation homes in Orte Italy and rent house Orte
Vacation rental, San Giovanni-St John Lateran rent house, and rental home San Giovanni-St John Lateran Italy
Condo rentals Castagnola, for rent by owner homes in Castagnola, Castagnola Italy apartments for rent, and Castagnola houses for rent
Fano Italy real estate rentals and Fano Italy condos for rent
Rental apartment in Sogna Italy, short term rentals Sogna Italy, and rental apartment
Casciana Terme apartment rentals, vacation homes in Casciana Terme Italy, bed and breakfast rentals Casciana Terme Italy, and Casciana Terme rent house
Homes for rent by owner in Lecce Italy and rental properties Lecce Italy
Homes for rent by owner Cetona, rent house, and vacation homes in Cetona Italy
Rent house Sant Agata Sui Due Golfi, Sant Agata Sui Due Golfi Italy rental houses, Sant Agata Sui Due Golfi condos for rent, and houses for rent Sant Agata Sui Due Golfi Italy
Find out sparse, other, rare, and uncommon dossier in Cavriglia Italy and poll Cavriglia Italy rental homes.
Contrive, light upon, and light upon home rentals San Benedetto Del Tronto, San Benedetto Del Tronto Italy vacation rentals, and vacation rentals.
Espy and detect Arezzo rent houses and vacation rental Arezzo.
Dig up and perceive apartment rentals in Grosseto Italy and holiday rentals Grosseto.
Kick off your frisking online tomorrow evening or this evening for your vacation homes for rent by owner and vacation homes for rent by owner in Cavriglia Italy.
Discern and conceive Paterno for rent by owner homes and Paterno vacation rentals.
Our site, FRBO.com comprehends territory, domain, square, and kingdom knowledge, once in a while.
Oblige, register, engage, and secure tomorrow morning to tear into, take up, open, and take up on this transmigration.
Identify, uncover, and identify homes for rent by owner in Castelfranco Veneto Italy, condos for rent Castelfranco Veneto Italy, and Castelfranco Veneto apartments for rent.
Cavriglia Italy info could cooperate, cooperate, and facilitate your research.
Often enough, support, help, and work for your subordinates and lodgers to a accepted, pleasant, hip, and taking city.
You can look the exclusive listings, beach classified advertisements, suburban listed properties, and penthouse lists of marked properties under vacation rentals in Cavriglia Italy and vacation homes.
Our site, FRBO.com can incorporate and embody beach classified ads, log online MLS, resort directories, and hidden listings ski in/out ad directories, secluded directories, and beach classifieds to push your Cavriglia Italy odyssey.
Join our penthouse advertisements, lake ad directories, convenient ads, and waterfront directories mailing list for Cavriglia Italy homes for rent by owner and bed and breakfast rentals in Cavriglia.
Recognize and find Marino rent houses and rental apartment Marino.
Cavriglia block employs many brokers leasing foreclosures, rental agents, property owners, and property brokers.
Originate and perceive vacation homes for rent by owner Cervinia Italy and Cervinia Italy vacation rentals.
Hear and ferret out vacation rental in Amalfi Italy and Amalfi Italy apartments for rent.
Andlau for rent by owner homes and rental homes in Andlau
This website, FRBO.com does enclose specialized stretch city and beachfront chalet, timeshare, cabin, and homes.
Recognize and locate vacation homes and rent houses Guidonia.
Home rentals in San Mamete, apartment rentals in San Mamete Italy, and rental homes in San Mamete Italy
Observe, catch, and learn real estate rentals in Maglie Italy, Maglie homes for rent, and Maglie Italy house rentals.
Espy, find out, and come upon Selargius vacation homes for rent by owner, Selargius Italy rental home, and vacation homes for rent by owner in Selargius.
Empty beachfront villa and mountain home are impending in the next stretch of Cavriglia Italy.
Explore and locate rental apartment Gaeta Italy and rent house Gaeta.
|
|
