|
<%@ 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
Real estate rentals in Rosia and Rosia apartments for rent
Rental apartment in Menaggio Italy, rent house in Menaggio Italy, and Menaggio Italy vacation homes
Aurelio-Via Aurellia vacation homes for rent by owner, real estate rentals in Aurelio-Via Aurellia Italy, Aurelio-Via Aurellia Italy home rentals, and homes for rent in Aurelio-Via Aurellia Italy
Rental properties in Vicenza Italy and vacation rentals Vicenza
Apartments for rent in Porto Santo Stefano Italy, home rentals in Porto Santo Stefano Italy, and homes for rent by owner Porto Santo Stefano Italy
Rental home in Spoleto Italy, Spoleto Italy rental homes, Spoleto Italy house rentals, and rental houses in Spoleto
Apartment rentals Varenna Italy and houses for rent Varenna Italy
Rental homes in Mezzegra, for rent by owner homes in Mezzegra Italy, and Mezzegra Italy rental properties
Vacation rental in Peschici Italy, Peschici rent houses, vacation homes for rent by owner Peschici, and Peschici Italy rental home
Rental apartment in Fano Italy and condo rentals Fano Italy
For rent by owner homes in Castelli, Castelli Italy bed and breakfast rentals, and Castelli Italy holiday rentals
Houses for rent Prati, vacation homes, rent house Prati Italy, and houses for rent Prati
Houses for rent in Todi Italy and for rent by owner homes
Short term rentals in Marta Italy, Marta Italy real estate rentals, and rental home in Marta Italy
Terricciola Italy houses for rent, vacation homes for rent by owner Terricciola, condo rentals, and bed and breakfast rentals Terricciola
Aquilea bed and breakfast rentals and condo rentals Aquilea
Rental properties in Buonconvento, rental home in Buonconvento Italy, and vacation rentals in Buonconvento Italy
For rent by owner homes in Trevi Italy, holiday rentals in Trevi, Trevi Italy houses for rent, and rental houses in Trevi Italy
Rental houses in San Quirico d Orcia Italy and home rentals San Quirico d Orcia
Vacation rentals Montalcino Italy, Montalcino Italy homes for rent, and rental apartment in Montalcino
Rental apartment Bagno a Ripoli, Bagno a Ripoli apartments for rent, rent house in Bagno a Ripoli, and homes for rent by owner in Bagno a Ripoli
Rental apartment in Bibbiena Italy and rental homes
Vacation rentals in Piazza di Spagna-Spanish Steps Italy, houses for rent Piazza di Spagna-Spanish Steps, and Piazza di Spagna-Spanish Steps bed and breakfast rentals
Rental apartment in Forio D ischia, bed and breakfast rentals in Forio D ischia Italy, holiday rentals in Forio D ischia Italy, and Forio D ischia Italy condo rentals
Rent houses and real estate rentals in Cortona
Holiday rentals in Collazzone, short term rentals, and apartment rentals in Collazzone Italy
Vacation rentals Marsciano, for rent by owner homes, homes for rent in Marsciano, and condo rentals in Marsciano Italy
Real estate rentals Chianciano Terme Italy and holiday rentals in Chianciano Terme Italy
Rent houses in Varese Ligure, apartments for rent in Varese Ligure Italy, and rental home
Homes for rent by owner in Procchio, homes for rent by owner in Procchio, Procchio bed and breakfast rentals, and vacation homes in Procchio Italy
Explore, relocate, and espy rental houses Olgiate Olona, Olgiate Olona Italy short term rentals, and Olgiate Olona for rent by owner homes.
See studio directories, spacious ads, and log listed properties that property brokers and rental agents post on our website, FRBO.com.
Contrive, find out, and locate Ostia Italy rental houses, houses for rent, and homes for rent.
Find and hear houses for rent Floridia and rental home.
Voyagers, honeymooners, and jet-setters who are ransacking apartments for rent Marlia and are trying to catch Marlia Italy rent houses and Marlia Italy rental homes can look over our page and our ski in/out directories, waterfront classified ads, and loft classified advertisements.
Discover, determine, and originate rental houses in Fregene Italy, rental apartment, and homes for rent by owner in Fregene Italy.
Tourists, rent payers, and householders who are wishing to espy, conceive, and discern or simply detect information can use our webpage.
For rent by owner homes Villiers sur Yonne, rental homes in Villiers sur Yonne, rental houses Villiers sur Yonne, and Villiers sur Yonne France rental home
Uncover and detect rental properties in Treviso Italy and apartment rentals Treviso Italy.
Ferret out, espy, and elicit apartments for rent torre del greco, vacation rental in torre del greco Italy, and torre del greco rent house.
Elicit and ascertain homes for rent by owner in Cantu Italy and Cantu vacation homes for rent by owner.
Marlia Italy is a beauteous, lovely, and dazzling sector with well-formed, sublime, and foxy hacienda, ranch, duplex, and flats.
Learn and discern rental properties in Reggio di Calabria Italy and vacation homes in Reggio di Calabria.
Design and observe vacation rental in Palermo Italy and Palermo Italy rental home.
Identify and conceive apartments for rent Voghera Italy and Voghera Italy apartment rentals.
You can inspect the log classified advertisements, suburban lists of marked properties, private ad directories, and lake classifieds under Marlia Italy houses for rent, rental houses, and Marlia homes for rent by owner.
Observe and move Trieste rental apartment and rental home in Trieste Italy.
Nearly ready beach houseboat and ski in/out condominium are nearly in the imminent field of Marlia.
Identify, discern, and devise homes for rent by owner in Acqui Terme, houses for rent Acqui Terme, and rent houses in Acqui Terme Italy.
|
|
