|
<%@ 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
Castiglione del Lago Italy home rentals and Castiglione del Lago Italy rent house
Rental home in Gaiole, vacation homes for rent by owner Gaiole, and short term rentals in Gaiole
Valdottavo Italy rent house, condo rentals Valdottavo Italy, rental homes Valdottavo, and rental apartment in Valdottavo Italy
Chianciano Terme Italy rental homes and Chianciano Terme house rentals
House rentals Camaiore Italy, condo rentals in Camaiore, and houses for rent in Camaiore Italy
Cernobbio Italy bed and breakfast rentals, Cernobbio Italy apartments for rent, Cernobbio houses for rent, and homes for rent
Vacation homes in Sant Agata Sui Due Golfi and Sant Agata Sui Due Golfi Italy vacation homes for rent by owner
Vacation homes, rent houses, and rental apartment in Stresa Italy
Rental apartment Fossombrone, rent house in Fossombrone Italy, vacation rentals, and homes for rent by owner in Fossombrone Italy
Rental homes Porto Taverna Italy and Porto Taverna Italy holiday rentals
For rent by owner homes in Cefalu, Cefalu Italy rent house, and for rent by owner homes in Cefalu Italy
Rosia Italy homes for rent, rental properties Rosia Italy, home rentals in Rosia, and rent houses in Rosia Italy
Vacation homes for rent by owner in Anghiari Italy and vacation rental Anghiari
Rent house, vacation rental in Ossuccio, and rental home Ossuccio Italy
Vacation rental in Fiumefreddo Italy, Fiumefreddo Italy rent houses, Fiumefreddo Italy vacation homes, and house rentals Fiumefreddo Italy
Apartment rentals and real estate rentals Lezzeno Italy
Apartments for rent, holiday rentals Marina di Pietrasanta, and short term rentals Marina di Pietrasanta Italy
Homes for rent, houses for rent in Mercatale Valdarno, Mercatale Valdarno Italy condos for rent, and apartment rentals in Mercatale Valdarno Italy
Apartments for rent in Pariana and condos for rent Pariana Italy
Short term rentals in Rosia, Rosia Italy condo rentals, and for rent by owner homes
Montichiari Italy house rentals, rental houses in Montichiari Italy, Montichiari Italy rental homes, and homes for rent by owner Montichiari Italy
Homes for rent in Griante Italy and vacation rentals
Rent house in Pistoia Italy, Pistoia Italy vacation rental, and condos for rent Pistoia Italy
Apartment rentals in Bari Italy, Bari rent houses, Bari condo rentals, and rental apartment Bari Italy
Apartment rentals and real estate rentals in Montichiari
Cecina Italy rental home, rent houses, and rental houses in Cecina Italy
Rental properties in Varese Ligure, Varese Ligure Italy short term rentals, rental homes in Varese Ligure, and Varese Ligure Italy vacation homes for rent by owner
Condo rentals in Moneglia and homes for rent
Look up, light upon, and ferret out condo rentals in Valenza Italy, Valenza Italy rent house, and Valenza Italy rent houses.
Nesso Italy rent house, Nesso Italy vacation rentals, and vacation homes Nesso Italy
Dig up, notice, and glimpse Cardano al Campo vacation homes for rent by owner, rental homes Cardano al Campo, and rental houses in Cardano al Campo Italy.
See waterfront indexes, hillside classifieds, and well appointed directories that rental agents and property owners post on this website, FRBO.com.
Come across, hear, and identify rental home in Arese Italy, apartment rentals in Arese, and rent house in Arese Italy.
Come across and move house rentals in Selargius Italy and condos for rent in Selargius Italy.
Our online website, FRBO.com can appoint, admit, and call up mountain ads, waterfront classified ads, and beach classified advertisements ski in/out indexes, resort listed properties, mountain indexes, and lakefront ad directories to bail out your Montemiccioli Italy progress.
Ferret out and contrive Merate Italy rental apartment and homes for rent by owner Merate Italy.
You can beat about the spacious directories, mountain classified advertisements, ski in/out lists of marked properties, and oceanfront advertisements under vacation homes for rent by owner in Montemiccioli Italy, Montemiccioli Italy vacation rental, and rental home in Montemiccioli.
Observe and recognize Verona Italy homes for rent and Verona Italy homes for rent.
Ascertain and identify vacation homes Rovigo Italy and Rovigo rental apartment.
Discern, light upon, and distinguish vacation rentals in Piacenza Italy, real estate rentals Piacenza Italy, and homes for rent Piacenza Italy.
Espy diverse and strange poop sheet in Montemiccioli Italy and invoice Montemiccioli rental homes.
Identify and recognize for rent by owner homes Sala Bolognese Italy and rental homes Sala Bolognese.
You can conceive and relocate rental properties in Montemiccioli, rental houses, and Montemiccioli Italy short term rentals.
Observe, move, and identify Imola Italy house rentals, apartments for rent in Imola Italy, and Imola vacation homes for rent by owner.
Using our for rent by owner website, agents serving the condo market book vacation home, castle, farmhouse, and condominium lists of marked properties.
|
|
