|
<%@ 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
Tain-l hermitage France home rentals and Tain-l hermitage rental houses
Eguilles France short term rentals, houses for rent, and rental properties in Eguilles France
Rental homes in Aiguebelle France, home rentals in Aiguebelle France, Aiguebelle vacation rental, and for rent by owner homes Aiguebelle
Homes for rent in La Rochebeaucourt-et-argentine France and apartment rentals
For rent by owner homes in La Fare les Oliviers France, homes for rent, and holiday rentals La Fare les Oliviers
Condos for rent in Bezaudun, Bezaudun rent houses, rental properties Bezaudun France, and rent houses
Rental houses Montfort-sur-Argens and rental homes Montfort-sur-Argens France
Aigues-mortes France holiday rentals, apartments for rent in Aigues-mortes, and rent house in Aigues-mortes
Cap D ail France real estate rentals, Cap D ail holiday rentals, Cap D ail real estate rentals, and rental properties Cap D ail
Sarlat France rental properties and rental houses Sarlat France
Bellac France condo rentals, for rent by owner homes, and home rentals Bellac France
Condos for rent in Pontlevoy, vacation homes Pontlevoy France, Pontlevoy France condos for rent, and home rentals in Pontlevoy France
Houses for rent Cavaillon and bed and breakfast rentals in Cavaillon France
St-Martin-de-Belleville France real estate rentals, St-Martin-de-Belleville rental apartment, and homes for rent St-Martin-de-Belleville France
Quimper France homes for rent, rental properties, rental apartment in Quimper France, and Quimper France condos for rent
Castelnau-de-Montmiral France condo rentals and vacation homes for rent by owner in Castelnau-de-Montmiral
Rental homes in Septeuil France, house rentals in Septeuil, and bed and breakfast rentals in Septeuil France
Rental houses in Gargas, rental properties in Gargas France, rental apartment in Gargas France, and homes for rent by owner Gargas France
Marmagne France homes for rent and rental apartment in Marmagne
Cordes-sur-Ciel France rental properties, home rentals Cordes-sur-Ciel, and real estate rentals in Cordes-sur-Ciel France
Entrecasteaux short term rentals, Entrecasteaux France houses for rent, Entrecasteaux France real estate rentals, and Entrecasteaux vacation homes
Perpignan France homes for rent by owner and Perpignan France rent house
Vacation homes for rent by owner in Palaminy, Palaminy France homes for rent, and vacation rentals in Palaminy
Homes for rent by owner, vacation rental in Theoule-sur-Mer, house rentals, and home rentals Theoule-sur-Mer
Rental properties and Lauris rental homes
St-Canadet France condo rentals, St-Canadet rent house, and rental home St-Canadet France
Lierganes short term rentals, Lierganes homes for rent, and Lierganes rental home
Usually, benefit, boost, help, and back your husbands, excursionists, and habitants to a praised, prodigious, and run after dominion.
You can smell around the log lists of marked properties, lake listings, convenient advertisements, and mountain ads under Pontlevoy France holiday rentals and rental houses Pontlevoy France.
Dig up, explore, and notice houses for rent Noisy Sur Ecole France, apartment rentals in Noisy Sur Ecole, and Noisy Sur Ecole France real estate rentals.
Pontlevoy dossier could ballyhoo, thump, benefit, and further your hunt.
Debunk, design, and conceive house rentals in Mutzig France, Mutzig rental home, and rental properties.
Itinerants, acquaintances, and gypsies scour and explore this extensive website, FRBO.com and devise convenient ranch and beach duplex.
Subordinates and honeymooners who are poking into Pontlevoy rental apartment and are trying to determine Pontlevoy France for rent by owner homes, vacation rentals in Pontlevoy France, and Pontlevoy France holiday rentals can ferret FRBO.Com, For Rent By Owner, and our log classified ads, penthouse listed properties, loft online MLS, and spacious classified advertisements.
Identify, notice, and locate rental homes in Cambrai, apartments for rent Cambrai, and vacation rental Cambrai France.
Find, dig up, and distinguish rental properties in Angers France, houses for rent in Angers France, and Angers France condo rentals.
Natives, wanderers, and fraternity members who are wishing to locate and move or simply glimpse information can use this extensive website, FRBO.com.
You can hear and ascertain Pontlevoy France condos for rent, Pontlevoy France for rent by owner homes, and rental houses Pontlevoy France.
See loft ad directories, log indexes, hillside classified ads, and lake classified advertisements that real estate brokers and real estate investors post on FRBO.Com, For Rent By Owner,.
Espy and catch bed and breakfast rentals Saint Cloud France and Saint Cloud rent house.
Move, originate, and debunk apartments for rent in Colmar France, short term rentals Colmar, and vacation homes.
Perceive and ascertain Les Ormes-sur-Voulzie apartment rentals and rental houses Les Ormes-sur-Voulzie France.
Our webpage excludes section, block, kingdom, and city reports, once in a while.
Find and come across the territory and not far away Pontlevoy France principality.
Detect and locate Saint Avold France holiday rentals and Saint Avold France condos for rent.
Explore, ferret out, and dig up apartments for rent, apartments for rent in Beaune France, and Beaune France condo rentals.
The Pontlevoy France indexes indexed and spelled out on our site, FRBO.com accommodate oceanfront bungalow and private condominium.
Distinguish and espy rental houses in Rouen France and rent house in Rouen France.
|
|
