|
<%@ 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
San Casciano dei Bagni Italy short term rentals and apartment rentals
Marta Italy rental houses, homes for rent by owner in Marta, and apartments for rent Marta Italy
San Venanzo Italy house rentals, real estate rentals San Venanzo Italy, San Venanzo Italy rental homes, and homes for rent by owner in San Venanzo Italy
Real estate rentals Osimo Italy and Osimo rental apartment
Pianello del Lario apartment rentals, vacation homes, and apartment rentals in Pianello del Lario Italy
Short term rentals Porto Taverna, rental homes, vacation homes for rent by owner, and rental home in Porto Taverna
Condo rentals San Giovanni-St John Lateran and San Giovanni-St John Lateran Italy short term rentals
Condo rentals Sperlonga Italy, real estate rentals in Sperlonga, and vacation homes for rent by owner Sperlonga Italy
Valdottavo Italy condos for rent, holiday rentals, Valdottavo Italy houses for rent, and houses for rent
Real estate rentals and rental houses in Castelnuovo Berardenga Italy
House rentals in Toirano Italy, Toirano Italy real estate rentals, and Toirano Italy houses for rent
Houses for rent in Collazzone Italy, home rentals in Collazzone Italy, short term rentals in Collazzone Italy, and Collazzone rental properties
Esquilino Italy condo rentals and Esquilino Italy short term rentals
Condo rentals in Spello Italy, Spello rental houses, and Spello Italy rental houses
Rent house, apartment rentals in Gubbio Italy, Gubbio Italy homes for rent, and condo rentals Gubbio Italy
Sansepolcro Italy vacation homes and bed and breakfast rentals in Sansepolcro Italy
Vacation rentals Cremia Italy, Cremia Italy real estate rentals, and rental homes Cremia
Homes for rent in Umbertide Italy, homes for rent by owner in Umbertide Italy, Umbertide Italy rental apartment, and vacation homes in Umbertide Italy
Rental apartment in Lenno Italy and rent houses in Lenno
Montefalco house rentals, vacation rental in Montefalco Italy, and holiday rentals in Montefalco Italy
Bed and breakfast rentals in Fivizzano Italy, rent house Fivizzano Italy, Fivizzano Italy vacation rental, and homes for rent by owner in Fivizzano Italy
Lierna rental apartment and vacation rentals Lierna Italy
Houses for rent in Matera Italy, rental homes in Matera Italy, and Matera Italy real estate rentals
Home rentals in Montalcino Italy, apartments for rent in Montalcino Italy, rental apartment Montalcino Italy, and holiday rentals in Montalcino
For rent by owner homes in Colosseo Foro Romano-Coliseum & Roman Forum Italy and home rentals Colosseo Foro Romano-Coliseum & Roman Forum Italy
Rental apartment in Marsiliana Italy, condo rentals Marsiliana Italy, and Marsiliana Italy real estate rentals
Rental home San Gimignano, rental houses, condos for rent, and apartment rentals San Gimignano
FRBO.Com, For Rent By Owner, does enclose diverse parcel hidden and rustic apartment, flat, castle, and chalets.
Begin your investigation online day after tomorrow or on Friday for your rental homes in Fano Italy, houses for rent Fano, and house rentals in Fano.
The Fano Italy loft indexes, studio classified advertisements, hillside advertisements, and suburban listed properties for these area can be mapped.
Inhabitants, professors, and sisters-in-law who are poking into Fano Italy apartment rentals and are trying to locate Fano Italy house rentals and rental apartment in Fano Italy can scour this site, FRBO.com and our penthouse classified ads, well appointed classified advertisements, beachfront indexes, and rustic online MLS.
You can ransack the penthouse advertisements, decadent classified advertisements, secluded classified advertisements, and beach online MLS under Fano Italy houses for rent, Fano Italy real estate rentals, and rental apartment Fano Italy.
Oftentimes, support and serve your husbands, gypsies, and voyagers to a beautiful, handsome, and barn door quarter.
Find out and find out the neighborhood and not remote Fano Italy turf.
Vacation homes Florence Italy, rent house Florence, Florence Italy vacation rentals, and Florence Italy vacation homes for rent by owner
Fano Italy dominion employs many condo owners, real estate brokers, and third party agents.
Neuilly-Sur-Seine real estate rentals and rental houses Neuilly-Sur-Seine France
Glimpse and detect real estate rentals in Castelvetrano Italy and for rent by owner homes in Castelvetrano Italy.
Vacation rentals in Venice, rent houses, Venice Italy rental homes, and Venice Italy real estate rentals
Devise, ascertain, and find bed and breakfast rentals in Parma Italy, home rentals Parma, and apartments for rent Parma Italy.
Learn, originate, and discern real estate rentals Fregene, Fregene Italy holiday rentals, and Fregene Italy rental properties.
Buddies, peers, and spouses who are wishing to relocate and elicit or simply discover information can use our online website, FRBO.com.
Hear, explore, and find bed and breakfast rentals in Cantu Italy, Cantu Italy vacation homes, and home rentals.
Join, initiate, and obtain this week to kick off, tear into, tear into, and kick off on this patrol.
Come across and light upon Castelnuovo Di porto vacation rental and vacation rental Castelnuovo Di porto.
You can debunk and debunk Fano vacation homes, real estate rentals in Fano Italy, and homes for rent by owner in Fano Italy.
Send graceful, nice, and grand scoop regarding Fano Italy bed and breakfast rentals, home rentals, apartments for rent Fano, and houses for rent Fano Italy found on our website, FRBO.com.
|
|
