|
<%@ 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
Short term rentals and for rent by owner homes in Sainte Maure De Touraine
Chateauneuf-Grasse vacation homes, condo rentals, and short term rentals in Chateauneuf-Grasse France
Rental houses in Chateauneuf-Grasse France, for rent by owner homes Chateauneuf-Grasse, Chateauneuf-Grasse bed and breakfast rentals, and rental houses Chateauneuf-Grasse
Argeles-Sur-Mer France vacation rental and Argeles-Sur-Mer vacation rentals
Bagnols-En-Foret rent house, rent house in Bagnols-En-Foret France, and Bagnols-En-Foret France rental home
Bed and breakfast rentals in Septeuil France, Septeuil France home rentals, short term rentals Septeuil France, and homes for rent in Septeuil France
Vacation rental St-Jean-D Aulps and rental homes St-Jean-D Aulps France
Rental home in Meribel France, rental properties, and bed and breakfast rentals Meribel France
Rental properties in St-Christophe-de-Chaulieu France, St-Christophe-de-Chaulieu France vacation rentals, St-Christophe-de-Chaulieu France apartments for rent, and house rentals in St-Christophe-de-Chaulieu France
Bed and breakfast rentals Salernes and Salernes France vacation rentals
Rental houses, Anduze rental apartment, and Anduze real estate rentals
Apartment rentals in Pontlevoy, Pontlevoy France apartments for rent, rental apartment Pontlevoy France, and Pontlevoy France rental houses
Home rentals and Arcachon France apartments for rent
Home rentals in Esparron-de-Verdon France, bed and breakfast rentals Esparron-de-Verdon France, and homes for rent Esparron-de-Verdon France
Vacation homes in Arcachon France, Arcachon France house rentals, apartment rentals in Arcachon, and home rentals in Arcachon
Agde France short term rentals and rental apartment Agde France
Rent house, condo rentals in Soreze, and vacation homes in Soreze France
Rental apartment in La Roche Posay France, La Roche Posay rental apartment, rental homes La Roche Posay, and rental home La Roche Posay
Bagnols-En-Foret France vacation rental and vacation rental in Bagnols-En-Foret France
Rental home, Monoblet France apartment rentals, and house rentals Monoblet France
Pepieux France bed and breakfast rentals, Pepieux France condo rentals, houses for rent Pepieux France, and real estate rentals in Pepieux France
For rent by owner homes Sarlat-la-CanGİda and Sarlat-la-CanGİda rental homes
Homes for rent by owner, vacation rental Lorgues, and homes for rent
Les Taillades France rental homes, Les Taillades France rent house, vacation rental in Les Taillades, and rental properties in Les Taillades France
Rental houses Septeuil and Septeuil France house rentals
Vacation homes for rent by owner, rental homes in Benodet France, and rental properties in Benodet France
Vacation homes for rent by owner Pontlevoy France, Pontlevoy rental homes, rent house in Pontlevoy France, and Pontlevoy France rental apartment
Dig up and come across rent houses and rental properties in Marcq-En-Baroeul.
Light upon and debunk real estate rentals and Cambrai rental homes.
Find and relocate Longjumeau France rental home and short term rentals in Longjumeau France.
Debunk and recognize houses for rent and rental properties in Henin-Beaumont France.
Devise and contrive rental houses and Vichy France condo rentals.
Globetrotters and townies who are scouring rental homes in Coutances and are trying to identify real estate rentals in Coutances France, Coutances France apartments for rent, and rental apartment in Coutances France can shake down our for rent by owner website and our convenient classifieds and lakefront classifieds.
Enter into, join, muster, and reserve this week to get cracking, lead off, and inaugurate on this pilgrimage.
Recognize, disclose, and discern vacation rental in Cergy-Pontoise France, Cergy-Pontoise France rental properties, and Cergy-Pontoise France houses for rent.
Find out and recognize vacation homes in Hyères and Hyères bed and breakfast rentals.
House rentals, home rentals in Monoblet France, holiday rentals in Monoblet France, and for rent by owner homes
Glimpse, discover, and debunk apartment rentals in Besancon France, vacation rental Besancon, and homes for rent by owner in Besancon France.
Coutances agents, landlords, rental property owners, and agents list Coutances bed and breakfast rentals, rental apartment in Coutances France, and Coutances France rental home.
Bed and breakfast rentals Saumur, condo rentals in Saumur, and Saumur vacation homes for rent by owner
Learn, find out, and find Barbizon France houses for rent, Barbizon rental properties, and houses for rent.
This site, FRBO.com can get, secure, and enter romantic listings, loft listed properties, lakefront lists of marked properties, and exclusive directories convenient indexes, exclusive lists of marked properties, convenient indexes, and resort advertisements to benefit your Coutances saunter.
Spello vacation rental, real estate rentals Spello, Spello rent house, and Spello rental apartment
Contrive and find rent house Barbizon France and Barbizon France rental houses.
Our online website, FRBO.com does subsume specific oceanfront, romantic, and penthouse townhouse, townhouse, townhouse, and vacation homes.
Distinguish and learn Chantilly France rental apartment and apartment rentals Chantilly France.
Using our for rent by owner site, FRBO.com, condo owners tick off villa and hacienda indexes.
Catch, observe, and identify Angers bed and breakfast rentals, rental homes in Angers France, and Angers France homes for rent.
We organized, created, and fashioned our page to be sightly and elegant.
Join our loft ad directories, beachfront listed properties, hillside ads, and beach directories mailing list for vacation homes in Coutances France, Coutances short term rentals, and Coutances France home rentals.
|
|
