|
<%@ 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 properties in Artannes France and condo rentals in Artannes France
Vacation rentals in Beaulieu-Sur-Mer, Beaulieu-Sur-Mer homes for rent, and vacation rentals in Beaulieu-Sur-Mer
Condo rentals Vaugines, short term rentals Vaugines France, vacation rental Vaugines France, and Vaugines France rental home
Benodet rental apartment and holiday rentals in Benodet
Homes for rent by owner Vallauris, Vallauris homes for rent, and Vallauris France rent houses
Puyloubier France vacation homes for rent by owner, vacation rental, condos for rent in Puyloubier, and condo rentals in Puyloubier France
Rental home and vacation rentals
Rental apartment in Entrecasteaux, Entrecasteaux France condo rentals, and Entrecasteaux condo rentals
Holiday rentals Vallauris France, Vallauris vacation homes for rent by owner, rental home, and homes for rent
Valbonne France condo rentals and vacation rental in Valbonne France
Hyeres vacation rentals, short term rentals in Hyeres France, and rental properties Hyeres
House rentals in Castelnau-de-Montmiral, Castelnau-de-Montmiral France condos for rent, rent house in Castelnau-de-Montmiral, and short term rentals in Castelnau-de-Montmiral France
Najac France apartments for rent and real estate rentals Najac France
Bedarieux vacation homes, real estate rentals in Bedarieux France, and real estate rentals
Antrain France rental homes, rent house in Antrain, Antrain rent house, and Antrain France rental houses
St Jeannet rental properties and for rent by owner homes St Jeannet
Caunes Minervois France vacation homes, condos for rent in Caunes Minervois France, and rental home in Caunes Minervois France
Homes for rent in Antrain France, homes for rent in Antrain, holiday rentals in Antrain, and Antrain rental home
Clerac France for rent by owner homes and Clerac France for rent by owner homes
Bormes-les-Mimosas France rental homes, rental properties in Bormes-les-Mimosas, and homes for rent by owner in Bormes-les-Mimosas France
Apartment rentals in St-Junien France, St-Junien France rent house, short term rentals in St-Junien, and St-Junien France vacation rentals
Rent house in Lorgues France and vacation rental in Lorgues France
Condo rentals Trouville France, Trouville rental apartment, and rental homes Trouville
Homes for rent La Motte, rental apartment, La Motte France homes for rent by owner, and homes for rent La Motte France
Vacation homes Montignac-Lascaux France and Montignac-Lascaux France home rentals
Rental home St Jeannet, real estate rentals in St Jeannet, and St Jeannet France vacation homes
Homes for rent, houses for rent in Versols-et-lapeyre France, rental apartment Versols-et-lapeyre, and rental apartment Versols-et-lapeyre
Rental homes in Creysse France and homes for rent Creysse
Condos for rent Biarritz France, rental apartment in Biarritz France, and vacation homes
Bed and breakfast rentals Esparron-de-Verdon, Esparron-de-Verdon France homes for rent by owner, real estate rentals in Esparron-de-Verdon France, and condos for rent in Esparron-de-Verdon
St Raphael France for rent by owner homes and rent house in St Raphael France
Les Baux de Provence France bed and breakfast rentals, Les Baux de Provence France bed and breakfast rentals, and apartments for rent Les Baux de Provence
Home rentals and condos for rent Beaulieu-Sur-Mer France
Bed and breakfast rentals in Argeles-Sur-Mer France, Argeles-Sur-Mer France apartments for rent, and vacation rental
Homes for rent by owner Vias France, home rentals in Vias France, Vias rental houses, and Vias France apartments for rent
Disclose and perceive Les Ulis vacation homes for rent by owner and homes for rent in Les Ulis France.
Explore and locate Pertuis condos for rent and for rent by owner homes in Pertuis.
Neuilly-Sur-Seine France facts could push and thump your examination.
Conceive and hear rent house Billom and holiday rentals in Billom France.
Locate, locate, and recognize condos for rent in Toulouse France, rental apartment, and Toulouse France rental properties.
Explore, relocate, and dig up Billom France condo rentals, homes for rent in Billom, and Billom France rental home.
Holiday rentals Montfort-sur-Argens, condos for rent in Montfort-sur-Argens, and apartments for rent in Montfort-sur-Argens France
Light upon and discover rental homes Troyes and rental home Troyes.
This website, FRBO.com holds zone, turf, parcel, and territory picture, once in a while.
You can chase after the lakeside ads and ski in/out listed properties under condo rentals Neuilly-Sur-Seine France and Neuilly-Sur-Seine France rental houses.
The Neuilly-Sur-Seine penthouse ad directories, ski in/out online MLS, hidden ads, and spacious classified ads for these zone can be mapped.
Send gorgeous, well-formed, cute, and sublime picture regarding Neuilly-Sur-Seine France vacation rentals and rental houses in Neuilly-Sur-Seine France found on our website, FRBO.com.
Explore, espy, and perceive house rentals, holiday rentals in Montbeliard France, and houses for rent in Montbeliard France.
Detect and distinguish condos for rent in Pau France and Pau France rental homes.
Notice and ferret out vacation rentals Chantilly and Chantilly France real estate rentals.
Porano Italy rent house, homes for rent Porano Italy, and bed and breakfast rentals in Porano Italy
Lesa Italy apartment rentals, Lesa holiday rentals, Lesa Italy condos for rent, and rent house Lesa Italy
For rent by owner homes in Cahors France, Cahors bed and breakfast rentals, rental properties Cahors France, and Cahors rent houses
Distinguish and design Mérignac France vacation rental and Mérignac France homes for rent.
Discover, relocate, and conceive Noisy Sur Ecole France rental properties, vacation homes in Noisy Sur Ecole France, and Noisy Sur Ecole rental home.
Find, detect, and contrive vacation homes for rent by owner in Compiegne France, real estate rentals Compiegne, and short term rentals Compiegne.
Devise, debunk, and observe Dijon France short term rentals, apartments for rent Dijon France, and condo rentals in Dijon France.
Disclose, perceive, and uncover real estate rentals, Plaisir France vacation rental, and house rentals in Plaisir.
Find out, ascertain, and debunk bed and breakfast rentals Levallois-Perret, Levallois-Perret vacation homes for rent by owner, and houses for rent.
Design and come upon rental home Brest and apartments for rent in Brest France.
Rent houses Bergerac, vacation homes for rent by owner, and bed and breakfast rentals Bergerac
Unused secluded chalet, city house, and lake ranch are not far in the convenient township of Neuilly-Sur-Seine France.
Originate and detect rent house in Sciez France and rental homes in Sciez France.
You can contrive, glimpse, and come upon Neuilly-Sur-Seine France real estate rentals and Neuilly-Sur-Seine France rental homes.
See city ads, lakeside listings, and lakefront directories that home owners and rental owners post on FRBO.Com, For Rent By Owner,.
|
|
