|
<%@ 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
Minori Italy vacation homes and apartments for rent
Servigliano Italy vacation rentals, apartment rentals in Servigliano, and Servigliano rental apartment
Apartments for rent Campana, vacation rentals in Campana Italy, rental homes in Campana, and holiday rentals in Campana Italy
Bellagio Italy rental apartment and Bellagio Italy rental apartment
Holiday rentals in Villasimius, Villasimius Italy bed and breakfast rentals, and apartments for rent Villasimius
Apartment rentals Val di Vara, house rentals Val di Vara, rental apartment Val di Vara Italy, and Val di Vara Italy vacation homes
Vicenza Italy vacation homes and Vicenza short term rentals
Home rentals in Montelupo Fiorentino, rental home Montelupo Fiorentino, and bed and breakfast rentals in Montelupo Fiorentino
Vacation homes Varenna, rental homes Varenna Italy, home rentals in Varenna Italy, and Varenna real estate rentals
Home rentals and apartment rentals Lecce
Vacation homes Pistoia Italy, apartments for rent in Pistoia Italy, and rental apartment
Siena Italy bed and breakfast rentals, bed and breakfast rentals Siena Italy, vacation homes Siena Italy, and rental home Siena Italy
Marlia Italy vacation homes for rent by owner and Marlia condo rentals
Castelfiorentino Italy house rentals, bed and breakfast rentals in Castelfiorentino Italy, and vacation homes for rent by owner Castelfiorentino
Salento Italy vacation rental, Salento Italy bed and breakfast rentals, Salento Italy vacation homes, and houses for rent in Salento Italy
Apartment rentals in Capri Italy and house rentals Capri Italy
Rent houses in Carate Urio Italy, homes for rent Carate Urio Italy, and Carate Urio Italy rent houses
Forio D ischia Italy condos for rent, Forio D ischia Italy vacation homes, houses for rent Forio D ischia Italy, and rental home
Home rentals and vacation rental
Houses for rent Salerno, rental houses Salerno, and rent houses in Salerno Italy
Rental properties in Dervio Italy, real estate rentals, Dervio Italy vacation rentals, and condo rentals Dervio
Rezzonico rental homes and Rezzonico Italy homes for rent by owner
Argegno rental home, houses for rent in Argegno Italy, and short term rentals
Vacation rentals in Baschi Italy, rent house, rental home Baschi, and house rentals
Rental homes and rent house Fondi
Marta Italy rental home, homes for rent in Marta, and Marta Italy homes for rent by owner
Rental properties in Collazzone Italy, rental homes, Collazzone Italy rental apartment, and rental houses in Collazzone Italy
Marsiliana apartments for rent and Marsiliana Italy apartments for rent
Alassio Italy house rentals, vacation homes in Alassio, and short term rentals
Certaldo rent house, Certaldo rental houses, rental homes, and vacation rentals in Certaldo
Amalfi homes for rent by owner and condos for rent in Amalfi
Sansepolcro Italy house rentals, apartment rentals in Sansepolcro Italy, and Sansepolcro Italy vacation rental
Homes for rent and short term rentals in Carmignano Italy
House rentals in Ossuccio Italy, short term rentals, home rentals Ossuccio, and rental properties in Ossuccio
Recognize, move, and come upon Bergamo Italy rental houses, condos for rent in Bergamo Italy, and apartments for rent in Bergamo Italy.
We formulated and occasioned our online website, FRBO.com to be fascinating, fair, and dazzling.
Notice and observe rent houses Ostia and homes for rent by owner in Ostia.
Hear and come upon Modena Italy apartment rentals and rent houses in Modena Italy.
Vacation rentals in Jastrzebia Gora, rental homes Jastrzebia Gora Poland, and Jastrzebia Gora Poland condo rentals
Gubbio Italy is a refined, wonderful, taking, and ideal stretch with fine, lovely, fair, and alluring houseboat, houseboat, bungalow, and apartments.
Join our secluded listed properties and decadent listings mailing list for Gubbio real estate rentals and rental apartment Gubbio.
Uncover, learn, and discern rental properties, Pavia Italy apartments for rent, and vacation rental Pavia Italy.
Perceive and hear rental home solofra and rental home in solofra.
Come upon, find, and catch rental home Fregene Italy, Fregene condos for rent, and apartment rentals in Fregene Italy.
Observe, devise, and disclose rent house in Cortina d Ampezzo Italy, real estate rentals in Cortina d Ampezzo, and homes for rent by owner Cortina d Ampezzo Italy.
Gubbio Italy zone employs many third party listing companies, property brokers, rental agents, and real estate brokers.
Argegno Italy rental home, Argegno rental home, Argegno homes for rent by owner, and vacation homes in Argegno Italy
Disclose, discern, and perceive apartments for rent Paterno Italy, homes for rent Paterno, and bed and breakfast rentals Paterno.
Find and identify houses for rent in Palermo Italy and vacation rentals.
You can discover, dig up, and observe home rentals in Gubbio Italy and home rentals Gubbio Italy.
Ascertain and ferret out rental houses in Rome Italy and vacation homes for rent by owner in Rome Italy.
Ascertain, detect, and come across Arezzo Italy houses for rent, real estate rentals in Arezzo Italy, and rent houses in Arezzo Italy.
Civray France condo rentals, Civray France rent house, and vacation homes in Civray France
Learn and design rent house and apartments for rent in Thiene Italy.
Determine and look up rental houses in Mantova and rent houses Mantova Italy.
Bedarieux France rental home and rent house Bedarieux
Elicit, ascertain, and catch Massa Italy houses for rent, Massa Italy vacation homes, and Massa Italy home rentals.
Habitually, relieve, aid, and serve your sightseers, traveling men, and sorority sisters to a tantalizing, thundering, and taking parcel.
Ascertain and ascertain home rentals in Conversano Italy and Conversano Italy rental houses.
|
|
