|
<%@ 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
Rent houses in Radda and vacation rental in Radda Italy
Rental apartment in Marsciano, rental houses Marsciano, and bed and breakfast rentals in Marsciano Italy
Condos for rent in Malcesine Italy, Malcesine Italy rental home, vacation rental Malcesine, and Malcesine Italy rent house
Rental apartment Sorrento and vacation homes for rent by owner Sorrento Italy
Apartments for rent Citta della Pieve, homes for rent in Citta della Pieve Italy, and rental home Citta della Pieve
Vacation rental in Portovenere, Portovenere Italy house rentals, Portovenere Italy vacation rentals, and Portovenere Italy short term rentals
Como Italy condo rentals and Como Italy vacation rental
Borgo a Mozzano Italy real estate rentals, Borgo a Mozzano apartment rentals, and apartment rentals in Borgo a Mozzano Italy
Vacation rentals Castellabate, rent houses, apartments for rent Castellabate Italy, and vacation rentals Castellabate
Rental properties and holiday rentals in Finale Ligure Italy
House rentals in CittG di Castello Italy, condos for rent CittG di Castello Italy, and CittG di Castello house rentals
Real estate rentals in San Giovanni d Asso, rent houses in San Giovanni d Asso Italy, condo rentals San Giovanni d Asso Italy, and rental homes in San Giovanni d Asso Italy
Short term rentals and house rentals in Dervio
Houses for rent Montelupo Fiorentino Italy, Montelupo Fiorentino Italy vacation rentals, and rental homes in Montelupo Fiorentino Italy
Vacation rentals in Cavriglia, houses for rent in Cavriglia Italy, rental home in Cavriglia Italy, and Cavriglia Italy homes for rent by owner
Terni rent house and vacation rental Terni Italy
Homes for rent by owner Pietraviva Italy, homes for rent by owner in Pietraviva Italy, and Pietraviva Italy real estate rentals
Bed and breakfast rentals in Valdottavo, rental houses, rent house in Valdottavo Italy, and rental home Valdottavo
Rent houses in San Remo Italy and San Remo Italy rental properties
Orvieto homes for rent, rental homes in Orvieto Italy, and Orvieto rental properties
Bed and breakfast rentals in Mezzegra Italy, rental houses Mezzegra, condo rentals, and for rent by owner homes
Careno condos for rent and rental homes in Careno Italy
Cernobbio Italy real estate rentals, rent house in Cernobbio Italy, and apartments for rent Cernobbio Italy
Bed and breakfast rentals in Chianciano Terme, rent houses Chianciano Terme Italy, Chianciano Terme vacation rentals, and Chianciano Terme Italy vacation rentals
Bibbiena Italy apartments for rent and bed and breakfast rentals in Bibbiena Italy
Paciano Italy holiday rentals, Paciano condos for rent, and apartments for rent
Homes for rent in Carate Urio Italy, Carate Urio Italy homes for rent by owner, bed and breakfast rentals Carate Urio Italy, and vacation homes in Carate Urio Italy
Vacation rental in Alassio Italy and homes for rent in Alassio Italy
Praiano Italy apartments for rent, for rent by owner homes, and Praiano Italy homes for rent
Vacation rental, house rentals Rufina, rental houses Rufina, and vacation homes
Chianciano Terme vacation rental and rent house Chianciano Terme Italy
Pistoia Italy vacation rental, vacation homes in Pistoia, and Pistoia Italy house rentals
Borgo a Mozzano house rentals and rental homes in Borgo a Mozzano Italy
Bezaudun real estate rentals, vacation rentals, and vacation homes in Bezaudun
Send fascinating, graceful, classy, and ideal abstracts regarding bed and breakfast rentals in Pantheon and Pantheon Italy vacation homes for rent by owner found on our page.
Design, relocate, and learn short term rentals Siracusa, Siracusa Italy vacation homes for rent by owner, and rent houses.
Adventurers and residers look and ransack this website, FRBO.com and identify studio timeshare and exclusive bungalow.
Initiate your inquest online this week, this weekend, or in the morning for your Pantheon Italy short term rentals, Pantheon Italy rental home, and rental home Pantheon.
Originate, identify, and locate Spoleto rental properties, bed and breakfast rentals in Spoleto Italy, and houses for rent in Spoleto Italy.
Come upon, debunk, and originate Sorrento Italy vacation rental, Sorrento rental home, and holiday rentals in Sorrento.
Come upon and move holiday rentals in Settimo Torinese and vacation rental in Settimo Torinese Italy.
See resort ads, secluded classifieds, and beach indexes that land owners and real estate brokers post on our for rent by owner site, FRBO.com.
Explore and uncover condo rentals in Grosseto Italy and rent houses Grosseto Italy.
Pantheon third party agents and real estate agents list rental apartment Pantheon, rent house in Pantheon, bed and breakfast rentals in Pantheon Italy, and home rentals Pantheon Italy.
Contrive, conceive, and ferret out rental properties in Amalfi Italy, Amalfi Italy rental homes, and Amalfi Italy short term rentals.
Disclose, observe, and look up short term rentals in Torino Italy, homes for rent by owner in Torino Italy, and real estate rentals in Torino Italy.
Civray France vacation rental and rental homes
Inscribe and conscribe on Wednesday to initiate and open on this wayfaring.
Pantheon Italy goods could expedite and benefit your scrutiny.
Discern and move apartments for rent Imola and Imola apartments for rent.
Come upon and disclose condo rentals in Genzano Di Lucania Italy and bed and breakfast rentals in Genzano Di Lucania.
Contrive and disclose Terni Italy rental homes and apartments for rent Terni Italy.
Espy and explore Lainate Italy real estate rentals and rental apartment Lainate.
Rent houses in Trevi, Trevi real estate rentals, apartments for rent Trevi, and rent houses
Recognize and come upon home rentals in Milano Italy and for rent by owner homes Milano Italy.
Invent and observe bed and breakfast rentals and Chieti apartments for rent.
Explore, come across, and invent Vigevano rent houses, rental homes, and vacation homes for rent by owner in Vigevano Italy.
Detect and find out houses for rent and holiday rentals Padova Italy.
Disclose small number and sundry input in Pantheon and numerate Pantheon Italy homes for rent.
|
|
