|
<%@ 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
Cadenet France bed and breakfast rentals and rental homes in Cadenet France
Condos for rent, rent house Creysse, and Creysse France rental properties
Home rentals, homes for rent Cavaillon France, holiday rentals in Cavaillon France, and houses for rent Cavaillon France
Homes for rent in St Cyr Sur Mer Les Lecques France and bed and breakfast rentals in St Cyr Sur Mer Les Lecques France
La Rochebeaucourt-et-argentine condos for rent, house rentals, and rent houses in La Rochebeaucourt-et-argentine France
Vacation rental Septeuil, apartments for rent Septeuil, apartments for rent, and for rent by owner homes Septeuil
Vacation rentals in Cagnes-sur-Mer France and vacation rental Cagnes-sur-Mer France
House rentals in St Saturnin les Apt France, vacation homes St Saturnin les Apt, and rental houses in St Saturnin les Apt France
Arles France vacation rental, rental apartment Arles France, vacation homes for rent by owner in Arles France, and vacation rentals Arles
Vacation rentals Beaune France and vacation rentals in Beaune
Menerbes vacation rentals, rental properties, and vacation rental Menerbes France
Le Bugue France apartments for rent, rental apartment in Le Bugue France, for rent by owner homes Le Bugue France, and vacation homes for rent by owner Le Bugue
Short term rentals in Chateauneuf-Grasse and rental apartment Chateauneuf-Grasse France
For rent by owner homes Apt, vacation rentals in Apt France, and Apt France condos for rent
See rustic classified advertisements, private classified advertisements, ski in/out classified advertisements, and beach indexes that rental agents and property managers post on our site, FRBO.com.
The Aix en Provence France indexes catalogued and calendar on FRBO.Com, For Rent By Owner, encompass log cabin and waterfront cabin.
Disclose and design rental home in Les Ormes-sur-Voulzie and Les Ormes-sur-Voulzie France rent houses.
Relocate and espy real estate rentals Beaune and Beaune home rentals.
Send pretty, radiant, admirable, and well-formed reports regarding Aix en Provence vacation rental, Aix en Provence France rental home, Aix en Provence France homes for rent by owner, and homes for rent by owner in Aix en Provence France found on our webpage.
Notice, distinguish, and come across Barbizon France bed and breakfast rentals, Barbizon rental houses, and rental properties.
Get going your exploration online this weekend, in the next few days, or on Sunday for your short term rentals Aix en Provence France and rental homes in Aix en Provence France.
This website, FRBO.com can join up, sign on, and draft resort lists of marked properties, exclusive indexes, beachfront directories, and loft advertisements suburban ads, rustic classifieds, beachfront ads, and private ad directories to collaborate your Aix en Provence route.
Discern various and specific dope in Aix en Provence and tabulate real estate rentals Aix en Provence.
Venturers and rovers who are wishing to look up and discover or simply identify information can use this website, FRBO.com.
Aix en Provence France whole story could collaborate and open doors your expedition.
|
|
