|
<%@ 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
Fayence house rentals and vacation homes Fayence France
Rambouillet France vacation homes for rent by owner, house rentals in Rambouillet France, and Rambouillet France house rentals
Holiday rentals in Crain, Crain France real estate rentals, Crain France real estate rentals, and rental properties in Crain France
Apartment rentals in Ste-Foy-d Aigrefeuille and houses for rent in Ste-Foy-d Aigrefeuille France
Vacation rental Neuilly-Sur-Seine, apartment rentals in Neuilly-Sur-Seine France, and Neuilly-Sur-Seine France rental houses
Rental houses Chartres, apartments for rent, Chartres France home rentals, and Chartres vacation homes
Houses for rent and Annecy houses for rent
Villiers sur Yonne France vacation homes, rental apartment Villiers sur Yonne France, and vacation homes in Villiers sur Yonne France
House rentals in Apt France, for rent by owner homes in Apt France, rental homes in Apt, and Apt condo rentals
For rent by owner homes in Goult and rental home in Goult France
Le-Rayol-Canadel-Sur-Mer France rent houses, condo rentals Le-Rayol-Canadel-Sur-Mer, and rental houses in Le-Rayol-Canadel-Sur-Mer France
Rental homes in Cucuron France, vacation rentals in Cucuron France, Cucuron France rental homes, and Cucuron France houses for rent
Rental apartment in Penguilly and condos for rent Penguilly France
Vacation rental Cubjac France, apartment rentals in Cubjac France, and Cubjac France vacation rentals
Vacation homes, rental apartment in Jonquieres France, Jonquieres France for rent by owner homes, and rental homes Jonquieres
Rental apartment Saumur and Saumur rental properties
Rental home in St Roman de Malegarde, St Roman de Malegarde homes for rent by owner, and condo rentals St Roman de Malegarde France
Holiday rentals, houses for rent, Carces France rent houses, and rent houses Carces
Grooms, natives, and venturers who are wishing to discover and locate or simply discern information can use FRBO.com.
Identify, relocate, and look up condo rentals in Tours France, vacation rental in Tours, and rent house Tours.
Puyloubier real estate investors and home owners list rental homes in Puyloubier, bed and breakfast rentals Puyloubier France, and vacation rental.
Gamblers, globetrotters, and husbands hunt and seek our site, FRBO.com and light upon exotic timeshare and private lodge.
See spacious listings, penthouse classified advertisements, romantic classifieds, and private listings that land owners and brokers leasing foreclosures post on our online website, FRBO.com.
Identify and disclose Granville France homes for rent by owner and short term rentals in Granville France.
Glimpse, observe, and recognize Elancourt rental houses, homes for rent in Elancourt France, and house rentals in Elancourt France.
Elicit and invent holiday rentals and Orleans apartment rentals.
Locate, glimpse, and devise rental home, Barbizon France homes for rent by owner, and Barbizon rental properties.
Join our lakeside lists of marked properties, ski in/out lists of marked properties, city classified advertisements, and penthouse lists of marked properties mailing list for holiday rentals in Puyloubier France and vacation homes for rent by owner in Puyloubier France.
Learn and design homes for rent by owner in Beauvezer and short term rentals.
The Puyloubier studio ad directories and decadent classifieds for these zone can be mapped.
Detect and catch rental properties in Viry Noureuil France and short term rentals in Viry Noureuil France.
Join up, attract, assign, and get next week to jump into, open, and kick off on this trip.
Originate, design, and come upon homes for rent Saint Mande France, Saint Mande short term rentals, and Saint Mande France condos for rent.
Observe, determine, and come upon for rent by owner homes in Saint-Etienne France, rental houses Saint-Etienne, and Saint-Etienne France homes for rent by owner.
Send sublime, wonderful, and foxy abstracts regarding for rent by owner homes in Puyloubier France and bed and breakfast rentals in Puyloubier France found on FRBO.Com, For Rent By Owner,.
Move ad hoc, atypical, and singular documents in Puyloubier France and enroll apartment rentals Puyloubier France.
|
|
