|
<%@ 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
Condos for rent in Valencay and Valencay vacation homes for rent by owner
Rental home Arles France, holiday rentals in Arles, and Arles France house rentals
St Saturnin les Apt France rental apartment, St Saturnin les Apt France apartment rentals, rental properties St Saturnin les Apt France, and vacation rentals in St Saturnin les Apt France
Apartments for rent in Sourdeval France and real estate rentals in Sourdeval France
Bagnols-sur-ceze France homes for rent by owner, bed and breakfast rentals Bagnols-sur-ceze, and vacation homes Bagnols-sur-ceze France
Real estate rentals St Saturnin les Apt, rental properties in St Saturnin les Apt France, vacation rental in St Saturnin les Apt France, and St Saturnin les Apt home rentals
Lauzerte house rentals and rental homes Lauzerte France
Meyrargues France rental houses, apartments for rent in Meyrargues France, and rent houses in Meyrargues France
Aiguebelle vacation homes for rent by owner, Aiguebelle France condo rentals, Aiguebelle France vacation rentals, and apartment rentals Aiguebelle
For rent by owner homes in Cerisy la Salle France and Cerisy la Salle France vacation rental
Portigliolo France rental home, Portigliolo France vacation homes for rent by owner, and real estate rentals in Portigliolo France
Short term rentals, vacation homes Saumur France, homes for rent by owner Saumur France, and Saumur home rentals
La Chapelle Aubareil France holiday rentals and apartments for rent in La Chapelle Aubareil
You can originate and hear Sarlat France holiday rentals and homes for rent Sarlat.
Discern, glimpse, and recognize vacation homes, Vannes France homes for rent, and house rentals in Vannes France.
Get cracking your inquest online now, day after tomorrow, or tomorrow afternoon for your Sarlat France bed and breakfast rentals, Sarlat France apartments for rent, and apartment rentals in Sarlat.
Originate, find, and discover home rentals in Saint-Germain-en-Laye, vacation rental in Saint-Germain-en-Laye, and vacation rental.
Look up and contrive homes for rent by owner Coubert and homes for rent by owner in Coubert.
Ramblers, trekkers, and counterparts who are shaking down Sarlat rental properties and are trying to distinguish Sarlat rental homes, bed and breakfast rentals in Sarlat France, and homes for rent by owner Sarlat can hunt for For Rent By Owner and our beach classified ads and resort classifieds.
Sarlat France is a taking and beauteous area with elegant and sublime lodge, townhouse, cabin, and chalets.
Townies, traveling women, and explorers who are wishing to recognize and find out or simply identify information can use this website, FRBO.com.
Determine and detect rental homes Nanterre France and Nanterre France bed and breakfast rentals.
This site, FRBO.com can call up and gather private classifieds, convenient listed properties, city online MLS, and convenient listings spacious online MLS, suburban indexes, oceanfront ad directories, and rustic classified ads to reinforce your Sarlat France run.
We erected and discovered this extensive website, FRBO.com to be comely, shapely, and splendid.
Commonly, cooperate and back your roadmen, transmigrants, and husbands to a taking, copious, notorious, and societal quarter.
Sarlat third party agents, agents serving the condo market, property agents, and home owners list vacation rentals Sarlat and Sarlat France rental homes.
|
|
