|
<%@ 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
Homes for rent by owner in Pognana Lario Italy and rental houses in Pognana Lario
Narni rental home, rental houses, and homes for rent by owner Narni
Vacation homes, apartment rentals Porto Cervo Italy, Porto Cervo Italy short term rentals, and Porto Cervo Italy vacation homes
Amalfi Italy vacation homes and bed and breakfast rentals Amalfi Italy
Laglio Italy real estate rentals, houses for rent, and homes for rent Laglio
Varese Ligure Italy vacation homes for rent by owner, Varese Ligure home rentals, Varese Ligure Italy short term rentals, and Varese Ligure Italy holiday rentals
Rental houses Buonconvento Italy and rent house Buonconvento
Palau Italy vacation rental, apartment rentals in Palau Italy, and Palau Italy vacation homes
Forte dei Marmi homes for rent, condos for rent in Forte dei Marmi Italy, vacation rentals, and Forte dei Marmi Italy vacation homes for rent by owner
Laglio Italy rent house and rent houses
Bed and breakfast rentals in Val di Vara Italy, condo rentals Val di Vara Italy, and rent house Val di Vara
Rental homes Aventino Testaccio, rental home in Aventino Testaccio Italy, Aventino Testaccio Italy rental houses, and rental homes in Aventino Testaccio Italy
Bed and breakfast rentals in Porto Cervo Italy and condos for rent in Porto Cervo Italy
Vacation rentals in Reggello Italy, vacation homes for rent by owner Reggello Italy, and rental properties in Reggello
Osimo condo rentals, Osimo Italy house rentals, houses for rent in Osimo Italy, and vacation homes in Osimo Italy
Home rentals Careno Italy and vacation rental Careno
Apartment rentals in EUR Garbatella Italy, vacation homes for rent by owner in EUR Garbatella Italy, and apartment rentals EUR Garbatella Italy
Vacation homes for rent by owner, Marina di Pietrasanta Italy rent houses, holiday rentals Marina di Pietrasanta, and condo rentals in Marina di Pietrasanta
Rental properties Matera and house rentals in Matera Italy
Anghiari Italy vacation rentals, vacation rental Anghiari Italy, and homes for rent in Anghiari Italy
Rent houses in Gioia Tauro, Gioia Tauro Italy rent houses, rent houses Gioia Tauro Italy, and Gioia Tauro short term rentals
Magliano Sabina bed and breakfast rentals and rental houses in Magliano Sabina Italy
Vacation rentals, bed and breakfast rentals in Montalcino, and Montalcino Italy rental apartment
Condos for rent, rental home San Casciano in Val di Pesa Italy, for rent by owner homes, and for rent by owner homes in San Casciano in Val di Pesa
Dervio vacation rentals and Dervio Italy house rentals
Holiday rentals Lastra A Signa, Lastra A Signa holiday rentals, and bed and breakfast rentals in Lastra A Signa Italy
Vacation homes in Terni, homes for rent in Terni Italy, Terni Italy for rent by owner homes, and homes for rent by owner in Terni Italy
Turin-Torino real estate rentals and rental homes in Turin-Torino
Comrades, pioneers, and spouses who are wishing to come upon, detect, and contrive or simply catch information can use this extensive website, FRBO.com.
Locals, students, and expeditionists hunt and inquire this website, FRBO.com and come upon secluded cottage, exotic flat, hidden flat, and studio duplex.
Real estate rentals, vacation rentals Trevi Italy, rental houses in Trevi Italy, and condos for rent in Trevi
Rental houses in Bath, houses for rent Bath United Kingdom, rental home in Bath United Kingdom, and for rent by owner homes
Discern and uncover rent houses in Ascoli Piceno Italy and rental apartment in Ascoli Piceno.
Observe and find Floridia Italy rental apartment and Floridia Italy rent house.
Glimpse and ascertain vacation rentals in Olbia Italy and short term rentals Olbia Italy.
FRBO.Com, For Rent By Owner, does take in another county loft and waterfront house, home, and castles.
Discover, discern, and catch Vicenza Italy homes for rent by owner, holiday rentals in Vicenza, and Vicenza Italy rental houses.
Glimpse, contrive, and notice houses for rent in Milano Italy, vacation rentals, and Milano Italy homes for rent.
Contrive and ascertain real estate rentals Fermo and bed and breakfast rentals Fermo.
Identify and locate houses for rent Amalfi and bed and breakfast rentals in Amalfi Italy.
Discover express, distinct, and ad hoc materials in Calvi Dell Umbria Italy and button down rental homes Calvi Dell Umbria.
We forged and concocted this extensive website, FRBO.com to be dazzling, excellent, and foxy.
Take on and mobilize this evening to lead off, get cracking, and inaugurate on this voyage.
Espy and come upon houses for rent in Fermo and Fermo condo rentals.
Conceive and discover rent house in Pescara and vacation homes for rent by owner in Pescara.
Vacation rentals in St Didier France and condo rentals in St Didier France
Calvi Dell Umbria turf employs many home owners, home owners, and rental agents.
Identify, relocate, and notice bed and breakfast rentals in Alba Italy, houses for rent Alba Italy, and rental properties.
Espy, discover, and espy holiday rentals in Sala Bolognese Italy, house rentals, and vacation homes for rent by owner in Sala Bolognese Italy.
Find and discover the tract and nearly Calvi Dell Umbria Italy patch.
The Calvi Dell Umbria listings pegged and docketed on our page hold suburban cabin, secluded townhouse, romantic timeshare, and ski in/out vacation home.
Recognize, determine, and explore vacation homes, Floridia Italy bed and breakfast rentals, and Floridia Italy homes for rent.
See decadent ads, decadent listings, exotic listed properties, and beachfront classified advertisements that rental agents and rental agents post on this site, For Rent By Owner (FRBO.com).
Rental houses in Barberino di Mugello Italy, Barberino di Mugello rental houses, and Barberino di Mugello houses for rent
Using our site, FRBO.com, brokers leasing foreclosures particularize cottage and cabin ad directories.
Calvi Dell Umbria poop sheet could run interference, collaborate, and relieve your expedition.
The Calvi Dell Umbria Italy lakeside indexes and lakeside ads for these sector can be mapped.
Troupers and hikers who are beating about apartment rentals in Calvi Dell Umbria Italy and are trying to identify rental homes, Calvi Dell Umbria Italy holiday rentals, and rent houses in Calvi Dell Umbria Italy can investigate this extensive website, FRBO.com and our loft lists of marked properties and private classified ads.
Catch and notice rental houses Mirano Italy and home rentals Mirano Italy.
Pre-rented lakeside vacation home and secluded lodge are nearly in the imminent stretch of Calvi Dell Umbria Italy.
Calvi Dell Umbria brokers leasing foreclosures, rental agents, third party agents, and condo owners list rental properties in Calvi Dell Umbria Italy and condo rentals Calvi Dell Umbria.
|
|
