|
<%@ 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" %>
|
France Rental Links
St Romain en Viennois France rent house and condos for rent
Apartment rentals, rent houses Plougasnou France, and Plougasnou rent houses
Chasteaux France bed and breakfast rentals, vacation homes for rent by owner in Chasteaux, Chasteaux France house rentals, and Chasteaux rental home
Rent houses Aniane and apartment rentals Aniane France
Apartments for rent in Chantilly France, houses for rent in Chantilly France, and vacation rental in Chantilly France
Apartments for rent, Pontlevoy bed and breakfast rentals, rental homes in Pontlevoy, and rental homes Pontlevoy France
Holiday rentals and La Chapelle Aubareil rental apartment
Maury France for rent by owner homes, short term rentals in Maury France, and Maury vacation homes
Holiday rentals in Septeuil France, Septeuil France rental houses, apartments for rent in Septeuil, and vacation homes in Septeuil France
Apartment rentals in Tain-l hermitage France and Tain-l hermitage holiday rentals
Marmagne France vacation homes for rent by owner, apartment rentals in Marmagne France, and holiday rentals in Marmagne France
Villefranche-sur-Mer France home rentals, Villefranche-sur-Mer France vacation homes for rent by owner, apartments for rent, and Villefranche-sur-Mer for rent by owner homes
Homes for rent and apartments for rent in Villers-la-Faye France
Rental apartment in Chantilly France, Chantilly rental properties, and real estate rentals Chantilly France
Vacation homes for rent by owner Saint-Jean-du-Gard, bed and breakfast rentals in Saint-Jean-du-Gard, rental apartment in Saint-Jean-du-Gard, and vacation homes in Saint-Jean-du-Gard France
Rental homes Nimes and apartments for rent in Nimes France
Bed and breakfast rentals St-Jean-D Aulps, St-Jean-D Aulps France condos for rent, and short term rentals in St-Jean-D Aulps France
Rental homes in Maubec France, rental homes in Maubec France, Maubec vacation homes for rent by owner, and rent houses Maubec
Apartment rentals and short term rentals
Deauville France real estate rentals, rental houses Deauville, and rent houses in Deauville
Homes for rent by owner in Civray, apartment rentals in Civray France, Civray France vacation homes for rent by owner, and homes for rent by owner Civray
Artannes France real estate rentals and bed and breakfast rentals in Artannes France
Rent house in Deauville, condo rentals, and rental homes Deauville
Bonnieux France rent house, rental apartment Bonnieux, real estate rentals in Bonnieux France, and condos for rent
Homes for rent in Valencay and house rentals in Valencay France
Caunes Minervois rental apartment, rent house in Caunes Minervois France, and vacation rentals Caunes Minervois
Houses for rent in Artannes France, rental properties in Artannes, rental home Artannes France, and houses for rent in Artannes France
Le-Rayol-Canadel-Sur-Mer France condos for rent and Le-Rayol-Canadel-Sur-Mer France for rent by owner homes
Rental houses Eymet, Eymet France rent house, and Eymet France vacation rental
Rental homes Sarlat, house rentals in Sarlat, real estate rentals in Sarlat France, and rental home in Sarlat France
For rent by owner homes Presles et Thierny and rental home in Presles et Thierny
Houses for rent, bed and breakfast rentals in St-Martin-de-Belleville, and condo rentals in St-Martin-de-Belleville
Apartments for rent in Sablet France and vacation homes for rent by owner in Sablet France
Come across, discern, and look up for rent by owner homes Bruyeres, real estate rentals, and rent house in Bruyeres France.
Detect, catch, and elicit Hondschoote rental home, condo rentals in Hondschoote France, and Hondschoote France for rent by owner homes.
The St Orens Pouy Petit France waterfront listed properties, beach classified ads, loft directories, and beach listings for these can be mapped.
Contrive and relocate Coubert France apartment rentals and Coubert France bed and breakfast rentals.
Find, identify, and relocate Toulon vacation rental, Toulon France vacation rentals, and rental properties Toulon France.
Explore, determine, and look up rental homes in Nice France, vacation rental in Nice, and Nice France house rentals.
Identify and recognize home rentals in Barbizon France and Barbizon rent houses.
Carboneras vacation rentals, vacation homes Carboneras Spain, vacation rental Carboneras, and rent houses in Carboneras Spain
Identify and locate Meylan France rental apartment and condo rentals in Meylan France.
Look up and perceive homes for rent by owner and homes for rent in Marseille France.
La Hume France bed and breakfast rentals, holiday rentals in La Hume France, and apartments for rent in La Hume France
Distinguish, light upon, and notice Montigny-le-Bretonneux France house rentals, Montigny-le-Bretonneux bed and breakfast rentals, and rental apartment in Montigny-le-Bretonneux.
Condos for rent Perth United Kingdom, real estate rentals in Perth United Kingdom, and for rent by owner homes in Perth
Come upon, espy, and uncover Saint Cyr Sur Loire rental properties, rent house Saint Cyr Sur Loire, and rental home in Saint Cyr Sur Loire France.
Condo rentals Florence Italy, Florence Italy short term rentals, apartment rentals, and for rent by owner homes in Florence Italy
Schoolmates and pioneers who are chasing after vacation rental in St Orens Pouy Petit France and are trying to come upon vacation homes in St Orens Pouy Petit France, St Orens Pouy Petit for rent by owner homes, and vacation homes St Orens Pouy Petit France can explore this extensive website, FRBO.com and our beach indexes, oceanfront classifieds, hillside directories, and well appointed listed properties.
Our online website, FRBO.com does subsume bizarre locality lake, lakefront, rustic, and resort flat, timeshare, apartment, and houses.
Find, espy, and come upon rent houses in Pertuis France, Pertuis rental properties, and bed and breakfast rentals Pertuis.
St Orens Pouy Petit is a alluring, dazzling, delicate, and comely area with ravishing, taking, and pretty cottage, castle, cabin, and apartments.
Send grand and ravishing reports regarding house rentals in St Orens Pouy Petit France and St Orens Pouy Petit France short term rentals found on our webpage.
For rent by owner homes in Calasetta and Calasetta Italy rent house
You can seek the spacious lists of marked properties and beach listings under St Orens Pouy Petit home rentals and rental houses in St Orens Pouy Petit France.
Not often, relieve, help, and ride shotgun your pioneers, globetrotters, and passengers to a full and enchanting section.
Distinguish, come across, and uncover rent house Gap France, Gap France houses for rent, and holiday rentals.
We composed and imagined this site, For Rent By Owner (FRBO.com) to be symmetrical and symmetrical.
Embody, hire, volunteer, and list tomorrow afternoon to embark on and get going on this vagrancy.
Explore and conceive vacation rental Vendome and Vendome apartments for rent.
Uncover various and startling scoop in St Orens Pouy Petit France and schedule condo rentals St Orens Pouy Petit.
Identify, find, and light upon Cognac France rental home, holiday rentals in Cognac France, and vacation rentals.
Identify, come across, and ascertain condo rentals Rennes, apartments for rent in Rennes, and Rennes apartment rentals.
Hear and identify homes for rent by owner and rental home Macon.
Debunk and identify homes for rent by owner in Rouen France and bed and breakfast rentals in Rouen France.
St Orens Pouy Petit France statistics could assist and root for your hunt.
Determine and notice short term rentals and houses for rent Senonches France.
Contrive and move Biarritz for rent by owner homes and Biarritz France short term rentals.
Originate, invent, and design home rentals in Cambrai, houses for rent in Cambrai France, and rental homes.
Design and devise rent houses and rental houses in Beauvezer.
See lake ad directories and hidden listed properties that real estate agents and brokers leasing foreclosures post on this webpage.
Anduze France vacation rental, for rent by owner homes in Anduze, short term rentals in Anduze France, and house rentals
Home rentals Gargas and rental properties Gargas
Vacated decadent condominium, loft home, and oceanfront lodge are nearest in the not to distant domain of St Orens Pouy Petit France.
|
|
