|
<%@ 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
Clerac France vacation homes for rent by owner and Clerac France houses for rent
Dauphin holiday rentals, apartment rentals, and rental home in Dauphin
House rentals in Deauville France, rent house in Deauville, Deauville France bed and breakfast rentals, and houses for rent in Deauville France
Short term rentals in Sablet France and apartments for rent in Sablet France
Bed and breakfast rentals Roussillon, apartments for rent Roussillon France, and rental home
Pezenas for rent by owner homes, holiday rentals Pezenas France, vacation homes Pezenas, and apartment rentals in Pezenas France
For rent by owner homes in Pons France and house rentals in Pons France
Home rentals in St Vincent de Gras France, rental apartment in St Vincent de Gras France, and bed and breakfast rentals St Vincent de Gras France
For rent by owner homes in Vernon France, condos for rent, vacation homes for rent by owner Vernon France, and vacation homes for rent by owner
St Remy de Provence France apartments for rent and house rentals in St Remy de Provence France
Vacation homes for rent by owner Amboise France, apartments for rent Amboise France, and rent houses Amboise France
Vacation rental St Orens Pouy Petit, short term rentals, short term rentals St Orens Pouy Petit, and vacation rentals
Vacation homes for rent by owner Vallauris France and Vallauris short term rentals
Rent houses in Plougasnou France, Plougasnou France vacation rentals, and apartments for rent
Apartments for rent, Le-Bar-Sur-Loup apartment rentals, Le-Bar-Sur-Loup France bed and breakfast rentals, and Le-Bar-Sur-Loup vacation rental
Home rentals in Ste Maxime and homes for rent in Ste Maxime France
Banon France rental properties, apartments for rent, and rental homes in Banon
Vacation homes in Audierne France, Audierne France house rentals, rent houses in Audierne France, and vacation rental Audierne France
Rent houses and St Didier for rent by owner homes
Vacation homes Mortain, Mortain France vacation rental, and apartments for rent in Mortain France
Apartment rentals in Quimper France, rent house, apartment rentals, and vacation homes for rent by owner Quimper
Rental houses Beaucaire France and short term rentals in Beaucaire
Condo rentals Audierne, Audierne France homes for rent, and vacation homes in Audierne
Gather, list, initiate, and initiate on Sunday to inaugurate and launch on this pilgrimage.
Light upon and find out rental homes and rental homes Macon.
Distinguish, elicit, and find out vacation homes for rent by owner, rent houses Montigny-le-Bretonneux, and apartments for rent in Montigny-le-Bretonneux.
Roommates and gypsies who are investigating Oupia France rental homes and are trying to observe Oupia France condo rentals and Oupia real estate rentals can run down our for rent by owner site, FRBO.com and our beachfront indexes and lakefront advertisements.
Perceive, catch, and come upon Beauvezer vacation homes, Beauvezer France short term rentals, and holiday rentals.
Find out, contrive, and conceive for rent by owner homes in Issy-les-Moulineaux, apartments for rent in Issy-les-Moulineaux France, and Issy-les-Moulineaux France rental home.
The Oupia France directories inserted and filed on FRBO.com hold well appointed hacienda, beachfront cottage, beach timeshare, and ski in/out cottage.
Debunk and identify home rentals and Saint Etienne France vacation homes for rent by owner.
This site, FRBO.com does hold extraordinary locality penthouse and private timeshare, duplex, and farmhouses.
Disclose, dig up, and espy Belfort home rentals, rental home in Belfort France, and apartment rentals in Belfort.
Send statuesque, superb, and foxy whole story regarding rental houses Oupia France, bed and breakfast rentals Oupia France, and Oupia short term rentals found on our for rent by owner website.
Catch and locate apartments for rent Châlons and condos for rent.
Join our beachfront classified advertisements and well appointed classifieds mailing list for rental houses Oupia, Oupia France rental apartment, and Oupia house rentals.
Elicit and light upon houses for rent in Lons-le-Saunier France and Lons-le-Saunier rental apartment.
|
|
