|
<%@ 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
Rental home in Imperia and rental homes
Vacation rental in Pisa, houses for rent in Pisa Italy, and Pisa Italy short term rentals
Home rentals Montemiccioli Italy, house rentals Montemiccioli, Montemiccioli Italy rent house, and vacation rentals Montemiccioli
Florence rental houses and bed and breakfast rentals
Apartment rentals, apartment rentals in Baschi, and for rent by owner homes Baschi Italy
Homes for rent, holiday rentals in Fiumefreddo Italy, vacation homes Fiumefreddo, and rental houses Fiumefreddo Italy
Rental properties in Rosia Italy and for rent by owner homes
Vacation homes, for rent by owner homes Alghero Italy, and Alghero houses for rent
Houses for rent in Piazza di Spagna-Spanish Steps Italy, condo rentals in Piazza di Spagna-Spanish Steps, Piazza di Spagna-Spanish Steps Italy rent house, and Piazza di Spagna-Spanish Steps Italy houses for rent
Carate Urio apartments for rent and Carate Urio Italy rental houses
Calasetta Italy house rentals, Calasetta houses for rent, and houses for rent in Calasetta
Rezzonico rental homes, rent houses, holiday rentals in Rezzonico, and vacation rentals in Rezzonico Italy
Home rentals and rental apartment in Feltre Italy
Rental homes in Barberino di Mugello, vacation homes for rent by owner, and bed and breakfast rentals
Homes for rent in Trani Italy, vacation homes in Trani Italy, vacation rental Trani, and rental houses Trani
Holiday rentals in Castiglione del Lago and Castiglione del Lago Italy rental home
Rental apartment Assisi, Assisi bed and breakfast rentals, and home rentals Assisi Italy
Vacation homes Cetona, rental homes Cetona, rent house, and Cetona home rentals
Houses for rent Spinetoli and Spinetoli Italy houses for rent
Rent house in Pisa Italy, rent house in Pisa Italy, and Pisa short term rentals
Rental homes Cernobbio, homes for rent by owner in Cernobbio Italy, for rent by owner homes Cernobbio Italy, and Cernobbio Italy rental homes
Rent house in Laglio Italy and apartments for rent
Perugia rental properties, holiday rentals in Perugia Italy, and rental properties in Perugia Italy
Vacation rental Barga, houses for rent in Barga, condos for rent in Barga, and Barga rent houses
Napoli Italy real estate rentals and rental apartment in Napoli Italy
Rental home in Monteroni d Arbia, Monteroni d Arbia Italy vacation homes for rent by owner, and rental houses Monteroni d Arbia Italy
Positano for rent by owner homes, apartments for rent in Positano Italy, rental apartment Positano Italy, and Positano Italy for rent by owner homes
Bagno a Ripoli bed and breakfast rentals and Bagno a Ripoli Italy house rentals
Condos for rent, Lesa Italy apartment rentals, and Lesa Italy vacation rentals
Bed and breakfast rentals in Terricciola, Terricciola Italy vacation homes, homes for rent by owner Terricciola Italy, and Terricciola Italy vacation rentals
Homes for rent in Ferrara Italy and Ferrara homes for rent by owner
Apartment rentals Trani Italy, rental home in Trani, and Trani Italy condo rentals
Livorno Italy vacation homes for rent by owner and apartment rentals Livorno Italy
We invested, formed, and dreamed up this site, FRBO.com to be bewitching and gorgeous.
Rental properties Prati Italy, condo rentals, houses for rent Prati, and real estate rentals in Prati Italy
Rental properties in Flaminio-Piazza del Popolo & Parioli Italy and Flaminio-Piazza del Popolo & Parioli homes for rent
Borgo a Mozzano vacation rental, condo rentals Borgo a Mozzano, vacation rental in Borgo a Mozzano Italy, and for rent by owner homes in Borgo a Mozzano
Notice, catch, and disclose apartments for rent, Vicenza Italy rental houses, and Vicenza condos for rent.
You can identify, determine, and recognize short term rentals Monterosso al Mare Italy, Monterosso al Mare Italy condos for rent, and Monterosso al Mare short term rentals.
Monterosso al Mare Italy locality employs many rental agents and brokers leasing foreclosures.
This site, For Rent By Owner (FRBO.com) does accommodate other studio, secluded, private, and rustic ranch, villa, flat, and cottages.
Move and glimpse the area and immediate Monterosso al Mare locality.
Determine, explore, and explore rental homes in Cologno Monzese, Cologno Monzese home rentals, and homes for rent by owner Cologno Monzese Italy.
Recognize, look up, and discover short term rentals in Imola Italy, Imola Italy rent house, and rental apartment in Imola.
Light upon, contrive, and come across Pescara Italy apartments for rent, Pescara rental apartment, and Pescara Italy short term rentals.
Send excellent, sublime, and angelic picture regarding apartments for rent in Monterosso al Mare Italy, vacation homes for rent by owner, and vacation homes for rent by owner in Monterosso al Mare Italy found on this site, For Rent By Owner (FRBO.com).
Register and draft tomorrow to begin and enter upon on this junket.
You can root the beach classified advertisements, hillside indexes, suburban online MLS, and rustic classifieds under vacation homes for rent by owner in Monterosso al Mare and rental houses.
Discover, identify, and distinguish Taranto rental houses, rent house Taranto, and Taranto Italy apartment rentals.
Design and observe Biella Italy vacation rentals and Biella vacation homes for rent by owner.
Identify, identify, and dig up condos for rent Vigevano Italy, apartment rentals in Vigevano Italy, and Vigevano Italy rental home.
Dig up and determine Carugate Italy bed and breakfast rentals and rent houses Carugate.
Nearly ready beach chalet and lakefront duplex are not faraway in the nearly field of Monterosso al Mare Italy.
Devise and hear apartment rentals and houses for rent Florence.
Disclose and learn rental houses in Civitavecchia Italy and for rent by owner homes Civitavecchia.
|
|
