|
<%@ 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
Holiday rentals and Esparron-de-Verdon France homes for rent by owner
Vacation rentals in Sainte Maure De Touraine France, Sainte Maure De Touraine apartments for rent, and vacation homes in Sainte Maure De Touraine France
Taulignan France rental home, vacation homes for rent by owner Taulignan, short term rentals in Taulignan France, and condo rentals Taulignan France
Rental homes Sainte Maure De Touraine and Sainte Maure De Touraine France holiday rentals
Homes for rent Chartres France, homes for rent by owner in Chartres France, and apartments for rent in Chartres France
Rental apartment Trouville, Trouville vacation homes for rent by owner, Trouville short term rentals, and rent houses Trouville France
Sainte Maure De Touraine France houses for rent and house rentals
Home rentals in Tain-l hermitage France, apartments for rent Tain-l hermitage France, and rent houses Tain-l hermitage France
Maury France rental homes, short term rentals, short term rentals Maury France, and Maury France house rentals
Home rentals Maussane-Les-Alpilles and rent houses in Maussane-Les-Alpilles France
La Fare les Oliviers France bed and breakfast rentals, real estate rentals in La Fare les Oliviers France, and rental apartment in La Fare les Oliviers France
Homes for rent by owner in Ocquerre France, rental homes Ocquerre, Ocquerre France homes for rent, and Ocquerre apartments for rent
Rental apartment in Beaumes de Venise and Beaumes de Venise France holiday rentals
Rental homes in Le-Rayol-Canadel-Sur-Mer France, vacation homes for rent by owner, and Le-Rayol-Canadel-Sur-Mer France short term rentals
St Cyr Sur Mer Les Lecques France short term rentals, vacation homes for rent by owner in St Cyr Sur Mer Les Lecques, St Cyr Sur Mer Les Lecques France vacation rental, and condos for rent
Porquerolles France rent houses and vacation rental in Porquerolles France
Real estate rentals in Bandol France, vacation homes Bandol, and real estate rentals in Bandol France
Vacation rental in Manduel, holiday rentals, vacation homes for rent by owner in Manduel France, and vacation homes in Manduel
Gigny France rent houses and for rent by owner homes in Gigny
Villefranche-du-Perigord rental houses, vacation homes in Villefranche-du-Perigord, and Villefranche-du-Perigord France real estate rentals
Condo rentals in Avignon France, homes for rent by owner in Avignon, houses for rent in Avignon, and Avignon houses for rent
Condo rentals and rental apartment in Le-Rayol-Canadel-Sur-Mer France
Condos for rent in Collioure, Collioure France rent houses, and Collioure condos for rent
Homes for rent by owner in St-Cannat France, vacation rental in St-Cannat France, rental homes in St-Cannat France, and for rent by owner homes
Creysse France houses for rent and homes for rent
Auzits homes for rent by owner, homes for rent in Auzits France, and condos for rent
La Hume France houses for rent, vacation homes, rental houses, and vacation homes La Hume
Rent houses Argeles-Sur-Mer France and vacation rental Argeles-Sur-Mer France
See mountain ad directories, studio directories, and exclusive online MLS that condo owners and agents serving the condo market post on this site, FRBO.com.
Perdika Greece rental home and bed and breakfast rentals
We designed and initiated this webpage to be magnificent, delightful, refined, and delicate.
You can ferret the romantic listed properties, mountain listings, city online MLS, and city ads under apartment rentals in Sainte Maure De Touraine France and apartment rentals Sainte Maure De Touraine France.
Uncover sundry and unusual experiments in Sainte Maure De Touraine France and record Sainte Maure De Touraine France apartments for rent.
Learn, contrive, and espy Hondschoote bed and breakfast rentals, short term rentals Hondschoote, and Hondschoote real estate rentals.
The Sainte Maure De Touraine France indexes written down and pegged on our for rent by owner site, FRBO.com encompass exotic timeshare and penthouse townhouse.
Send admirable and nice reports regarding bed and breakfast rentals and Sainte Maure De Touraine France homes for rent by owner found on our online website, FRBO.com.
Join our city listed properties, mountain listed properties, and private ads mailing list for Sainte Maure De Touraine France home rentals, Sainte Maure De Touraine France rental homes, and rental home in Sainte Maure De Touraine France.
Ferret out, locate, and debunk Lyon France homes for rent by owner, Lyon France rental houses, and holiday rentals in Lyon.
Varese Ligure condo rentals and Varese Ligure Italy rental home
This site, For Rent By Owner (FRBO.com) can sign on, oblige, reserve, and hire romantic ads, lakefront indexes, and penthouse classified advertisements oceanfront listings and hidden ad directories to sustain your Sainte Maure De Touraine France itinerary.
Sainte Maure De Touraine reports could bail out, aid, and help your frisking.
Indwellers and tourists who are wishing to distinguish and glimpse or simply find out information can use our webpage.
Learn and determine Calais France apartment rentals and Calais France vacation homes.
Light upon and relocate apartments for rent in Plaisir France and apartments for rent.
Hear, detect, and debunk Anglet France house rentals, Anglet France for rent by owner homes, and Anglet France rent houses.
Conceive, relocate, and conceive rental home Vichy, condos for rent in Vichy, and rental apartment in Vichy France.
Relocate, disclose, and notice for rent by owner homes in Colombes France, condo rentals, and Colombes France short term rentals.
|
|
