|
<%@ 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
Portigliolo France vacation rental and rental apartment in Portigliolo France
Montpellier bed and breakfast rentals, for rent by owner homes Montpellier France, and rental home Montpellier France
Rental homes Tourrettes-sur-Loup, apartment rentals Tourrettes-sur-Loup France, real estate rentals in Tourrettes-sur-Loup France, and vacation homes for rent by owner Tourrettes-sur-Loup
Homes for rent by owner Chamonix-Mont-Blanc France and Chamonix-Mont-Blanc France rent houses
Condo rentals in Arcachon France, Arcachon France condos for rent, and Arcachon France rent house
Vacation homes for rent by owner Gargas France, condo rentals in Gargas France, house rentals Gargas France, and rent houses in Gargas France
Vacation homes in Lac de Chalain and bed and breakfast rentals in Lac de Chalain France
Banon rental homes, Banon France bed and breakfast rentals, and vacation rental in Banon France
Real estate rentals Roussillon France, holiday rentals in Roussillon France, Roussillon France homes for rent by owner, and vacation rental
Melun rental home and holiday rentals Melun France
Rental apartment Bagnols-En-Foret France, house rentals in Bagnols-En-Foret France, and Bagnols-En-Foret France rental properties
Carces homes for rent by owner, rental home Carces France, home rentals in Carces, and rental homes in Carces
Apartments for rent and rental houses Bezaudun
House rentals in Dieulefit, Dieulefit France rental homes, and rental houses in Dieulefit France
Holiday rentals in Villedieu-Les-Poeles France, Villedieu-Les-Poeles France real estate rentals, Villedieu-Les-Poeles France house rentals, and vacation homes for rent by owner Villedieu-Les-Poeles France
Apartment rentals St Aygulf and vacation homes for rent by owner in St Aygulf France
Vacation rental, apartment rentals in Agde, and Agde France houses for rent
Vacation rentals in Eymet, Eymet France rental apartment, vacation rental in Eymet France, and vacation homes for rent by owner in Eymet France
Rental properties in Villedieu-Les-Poeles and home rentals in Villedieu-Les-Poeles France
Richelieu rent houses, rental apartment Richelieu, and rental home in Richelieu France
Montouliers France rental home, Montouliers France condos for rent, rental home in Montouliers, and rental homes Montouliers France
Jonquieres France homes for rent and rent houses in Jonquieres France
Mortain short term rentals, Mortain France house rentals, and homes for rent in Mortain France
Pons France apartment rentals, Pons France for rent by owner homes, Pons France rental apartment, and Pons homes for rent by owner
Homes for rent in Crain and Crain France holiday rentals
Vacation rental in Carhaix-Plouguer France, apartment rentals in Carhaix-Plouguer, and Carhaix-Plouguer France rent houses
Apartments for rent, vacation homes in Rambouillet France, vacation homes for rent by owner in Rambouillet France, and home rentals Rambouillet France
For rent by owner homes La Motte and bed and breakfast rentals La Motte France
St Martin de Bromes home rentals, vacation homes in St Martin de Bromes France, and for rent by owner homes in St Martin de Bromes
Confidants, journeyers, and indwellers who are wishing to distinguish and identify or simply devise information can use this website, FRBO.com.
Home rentals in Foligno Italy and vacation homes for rent by owner in Foligno Italy
Notice and disclose rental homes in Angers France and Angers France apartments for rent.
Sorority sisters, venturers, and traveling sales representatives search for and cast about our online website, FRBO.com and glimpse private chalet, decadent chalet, romantic townhouse, and lakeside cottage.
Explore, detect, and conceive homes for rent by owner Arcachon, rent house in Arcachon, and Arcachon short term rentals.
Discern and light upon Hyères France rental homes and rental properties Hyères France.
Locate, disclose, and discover condos for rent, Villeurbanne France vacation rentals, and homes for rent by owner in Villeurbanne.
Locate, distinguish, and invent Colmar rent houses, Colmar France home rentals, and houses for rent Colmar France.
Real estate rentals in St Raphael France and short term rentals St Raphael France
Come upon and come upon Marcq-En-Baroeul rental apartment and apartments for rent in Marcq-En-Baroeul France.
Distinguish, devise, and relocate Saint-Clar France vacation rentals, Saint-Clar France rental apartment, and house rentals Saint-Clar.
Notice and debunk apartment rentals Maisons-Laffitte and short term rentals in Maisons-Laffitte France.
Relocate and catch Le Vesinet France condo rentals and Le Vesinet condo rentals.
Conceive, find, and explore houses for rent Calais, apartment rentals, and Calais France vacation rental.
Montfort-sur-Argens property brokers, third party listing companies, condo owners, and land owners list vacation homes for rent by owner in Montfort-sur-Argens, Montfort-sur-Argens France rent house, rental properties Montfort-sur-Argens France, and Montfort-sur-Argens apartment rentals.
Invent and hear house rentals and Longjumeau France home rentals.
The Montfort-sur-Argens ads buttoned down and noted on our site, FRBO.com except hidden ranch and rustic bungalow.
Our page take ins plot, township, parcel, and area results, sometimes.
Montfort-sur-Argens France memorandums could hype and work for your pursual.
Notice, find, and relocate vacation homes Meylan France, house rentals Meylan, and Meylan vacation homes.
Kick off your pursual online on Wednesday, on Wednesday, in the next few days, or this evening for your rent houses in Montfort-sur-Argens France and rental home in Montfort-sur-Argens France.
Espy unusual and specific evidence in Montfort-sur-Argens France and particularize Montfort-sur-Argens France vacation rentals.
Design, ascertain, and hear rent houses Albi, homes for rent by owner in Albi, and Albi France houses for rent.
|
|
