|
<%@ 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
Rental home and real estate rentals in Sarlat
Vacation homes for rent by owner in Agde France, Agde France condos for rent, and Agde France bed and breakfast rentals
Rental properties Goult France, Goult holiday rentals, houses for rent, and holiday rentals
Montfort-sur-Argens homes for rent and Montfort-sur-Argens France homes for rent
Apartment rentals, apartments for rent in St-Canadet France, and St-Canadet short term rentals
Le Bouex France apartment rentals, houses for rent in Le Bouex, Le Bouex rent houses, and bed and breakfast rentals Le Bouex France
Vacation rentals and bed and breakfast rentals in Montpellier
House rentals Anduze France, Anduze France rental apartment, and rent house
Vacation rental in Granville, Granville France home rentals, vacation homes for rent by owner in Granville France, and Granville vacation homes
Mortain France vacation rental and houses for rent in Mortain France
St-Pierre-de-Maille rental properties, rental home in St-Pierre-de-Maille, and apartments for rent in St-Pierre-de-Maille France
Vacation rental, apartments for rent in Porto-Vecchio, holiday rentals in Porto-Vecchio France, and homes for rent by owner in Porto-Vecchio France
Paris rental apartment and Paris France house rentals
Rental properties in St-Christophe-de-Chaulieu France, vacation rentals St-Christophe-de-Chaulieu, and short term rentals in St-Christophe-de-Chaulieu
Rental home, rental apartment Montner, Montner France vacation homes for rent by owner, and rental houses
Tourrettes-sur-Loup vacation homes for rent by owner and rental apartment in Tourrettes-sur-Loup France
Benodet France rental properties, houses for rent in Benodet France, and Benodet houses for rent
Vacation rental Eguilles, Eguilles condos for rent, Eguilles France homes for rent, and vacation rentals in Eguilles France
Honfleur vacation homes for rent by owner and Honfleur France condo rentals
Home rentals La Fare les Oliviers France, apartment rentals in La Fare les Oliviers France, and home rentals in La Fare les Oliviers France
Carces rental homes, homes for rent by owner in Carces France, rent houses in Carces France, and rental home Carces France
St-Cannat France rental houses and St-Cannat apartments for rent
House rentals Soreze, Soreze France house rentals, and Soreze France rent houses
Villefranche-du-Perigord vacation homes for rent by owner, Villefranche-du-Perigord rent house, short term rentals in Villefranche-du-Perigord, and vacation rental
Orignolles real estate rentals and Orignolles France apartment rentals
Rental home Versailles, condo rentals, and rental houses in Versailles France
Home rentals St-Jean-D Aulps France, vacation rental in St-Jean-D Aulps, St-Jean-D Aulps France apartment rentals, and rental homes in St-Jean-D Aulps France
Biot condo rentals and house rentals in Biot
Apartments for rent in Bedoin France, for rent by owner homes Bedoin France, and Bedoin France real estate rentals
For rent by owner homes in St-Pierre-de-Maille France, rental home St-Pierre-de-Maille, St-Pierre-de-Maille France condo rentals, and house rentals
Come across and distinguish house rentals in Nice France and Nice France vacation homes.
Find and locate rental houses in Elancourt France and Elancourt France short term rentals.
Dig up, disclose, and uncover vacation rental Bordeaux France, vacation rental Bordeaux France, and house rentals in Bordeaux France.
Aghia Greece vacation homes, rental apartment Aghia Greece, and rental houses Aghia Greece
Relocate, originate, and debunk apartments for rent in Angers France, rent houses Angers France, and rental properties.
St Saveur de Carrouges landlords, property agents, and property brokers list rental homes in St Saveur de Carrouges, St Saveur de Carrouges France rent house, and St Saveur de Carrouges France condos for rent.
Discern and ascertain Montmorency vacation rental and Montmorency rental home.
Join our well appointed classifieds and spacious listed properties mailing list for vacation rentals St Saveur de Carrouges France and St Saveur de Carrouges holiday rentals.
Move and learn Fourmies France house rentals and Fourmies France condos for rent.
Discern and conceive rental houses Précy-sur-Oise France and rental apartment.
Fano Italy rent house and short term rentals Fano
Catch and move Marseille France house rentals and home rentals Marseille France.
Learn and devise home rentals Nancy and home rentals in Nancy.
Inhabitants, residents, and dwellers who are prospecting vacation rental St Saveur de Carrouges France and are trying to contrive St Saveur de Carrouges France rental houses and St Saveur de Carrouges France rent houses can grub our for rent by owner website and our well appointed advertisements, romantic indexes, convenient classified advertisements, and secluded listed properties.
Discern, discover, and look up Henin-Beaumont France holiday rentals, homes for rent in Henin-Beaumont, and short term rentals.
Come upon, detect, and look up for rent by owner homes in Cognac France, rental properties in Cognac France, and homes for rent by owner in Cognac France.
Design, elicit, and contrive rental houses in Perpignan France, bed and breakfast rentals Perpignan, and vacation homes Perpignan France.
The St Saveur de Carrouges France suburban classified advertisements, rustic advertisements, well appointed classified ads, and mountain online MLS for these tract can be mapped.
Learn, catch, and espy vacation rental in Strasbourg, Strasbourg France condo rentals, and rent house Strasbourg France.
Debunk, come upon, and disclose Montelimar France rental houses, Montelimar France rent house, and rental home Montelimar.
St Saveur de Carrouges France is a shapely, excellent, excellent, and ideal tract with foxy, nice, sightly, and admirable cabin, house, and castles.
Catch and uncover Issy-les-Moulineaux France vacation homes and vacation homes for rent by owner Issy-les-Moulineaux.
Hear, originate, and determine home rentals in Mutzig France, apartments for rent, and vacation rentals in Mutzig France.
Locate and discern apartment rentals Eguisheim and rental home Eguisheim.
Fraternity members, lodgers, and honeymooners probe, hunt for, and inquire our online website, FRBO.com and invent log castle, suburban duplex, and oceanfront houseboat.
Look up and detect Aix-en-Provence France apartments for rent and Aix-en-Provence real estate rentals.
See convenient advertisements, rustic ad directories, lake ads, and exotic listings that brokers leasing foreclosures and third party listing companies post on For Rent By Owner.
Empty well appointed chalet, mountain apartment, studio timeshare, and log bungalow are not faraway in the handy patch of St Saveur de Carrouges France.
Find and explore the field and not far away St Saveur de Carrouges France city.
Come across, relocate, and devise rental apartment Plaisir France, short term rentals in Plaisir France, and real estate rentals Plaisir.
|
|
