|
<%@ 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
Saint-Jean-du-Gard France rental apartment and Saint-Jean-du-Gard France real estate rentals
Rent houses, Septeuil homes for rent, and Septeuil France bed and breakfast rentals
Apartment rentals in Avranches France, rent houses in Avranches France, rent house, and rental home Avranches
Bed and breakfast rentals Carrieres sur Seine and house rentals Carrieres sur Seine
Holiday rentals in Maubec, vacation rental in Maubec, and for rent by owner homes in Maubec France
Condos for rent Chantilly France, real estate rentals, Chantilly France rent house, and holiday rentals in Chantilly France
Rent houses in Venasque France and Venasque France condo rentals
Apartments for rent in Aniane France, bed and breakfast rentals Aniane France, and apartment rentals
Soreze France for rent by owner homes, for rent by owner homes Soreze, Soreze France rental home, and real estate rentals in Soreze France
Montclus France rent house and Montclus France house rentals
Vacation homes Eguilles, apartments for rent in Eguilles France, and short term rentals Eguilles
Vacation rentals St Aygulf France, vacation homes in St Aygulf, St Aygulf vacation homes for rent by owner, and for rent by owner homes in St Aygulf France
Apartment rentals Vacqueyras and rental apartment in Vacqueyras France
House rentals in Aix en Provence France, vacation homes for rent by owner Aix en Provence France, and house rentals Aix en Provence France
Vernon France houses for rent, for rent by owner homes, Vernon France holiday rentals, and rental properties in Vernon
St Jeannet France rental properties and rental houses in St Jeannet
Castelnau-de-Montmiral France holiday rentals, rental properties, and house rentals Castelnau-de-Montmiral France
Rental homes Beaulieu-Sur-Mer, rental home, Beaulieu-Sur-Mer rent house, and Beaulieu-Sur-Mer France short term rentals
Relocate and identify apartments for rent in Laval and rent house in Laval.
Contrive and determine rental homes in Saint-Julien-en-Genevois and rental properties in Saint-Julien-en-Genevois France.
Elicit, discern, and ascertain apartment rentals in Mulhouse, homes for rent in Mulhouse France, and Mulhouse France homes for rent.
Distinguish and perceive holiday rentals in Saint Etienne France and rent house Saint Etienne France.
Discover and look up the township and near-at-hand Ste Colombe de Duras France parcel.
Ste Colombe de Duras rental property owners and property brokers list rent houses and vacation homes in Ste Colombe de Duras.
Determine and ferret out Auxerre vacation homes for rent by owner and vacation homes for rent by owner in Auxerre France.
Conceive, uncover, and explore condo rentals in Levallois-Perret France, vacation rentals, and homes for rent by owner in Levallois-Perret France.
Ste Colombe de Duras France is a fine, handsome, charming, and delicate zone with delicate, ideal, excellent, and beauteous duplex, flat, timeshare, and townhouses.
This website, FRBO.com can obtain, place, draft, and mobilize loft listed properties, spacious classifieds, mountain classifieds, and mountain indexes lakeside ads, beach ads, ski in/out ads, and private advertisements to puff your Ste Colombe de Duras march.
Send foxy and appealing experiments regarding Ste Colombe de Duras France apartments for rent, vacation homes for rent by owner, and rental apartment in Ste Colombe de Duras France found on this website, FRBO.com.
Ferret out, discover, and ferret out Biot condo rentals, rent house in Biot France, and Biot France house rentals.
Hire, place, and serve on Tuesday to originate, open, lead off, and get going on this traverse.
Get going your inspection online on Tuesday, this evening, this weekend, or tomorrow evening for your rental home Ste Colombe de Duras and Ste Colombe de Duras France short term rentals.
We fashioned, formed, and hatched our webpage to be sublime, shapely, ravishing, and fascinating.
Using this site, For Rent By Owner (FRBO.com), property owners register timeshare, bungalow, flat, and ranch listed properties.
Look up, identify, and discover rent houses in Marcq-En-Baroeul France, Marcq-En-Baroeul France real estate rentals, and Marcq-En-Baroeul France rental apartment.
Vacant exotic townhouse, romantic townhouse, oceanfront castle, and hillside condominium are adjoining in the not to distant township of Ste Colombe de Duras France.
Glimpse and dig up vacation rental in Lyon and rental apartment in Lyon.
|
|
