|
<%@ 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
Rental home in Portigliolo France and real estate rentals
Les Baux de Provence condos for rent, holiday rentals Les Baux de Provence France, and short term rentals in Les Baux de Provence France
Rental apartment, bed and breakfast rentals Beaumes de Venise France, Beaumes de Venise France rental houses, and houses for rent Beaumes de Venise France
Homes for rent in Violes and apartment rentals Violes
Real estate rentals Montouliers France, short term rentals in Montouliers France, and Montouliers France condo rentals
Homes for rent by owner Orignolles France, homes for rent by owner in Orignolles France, holiday rentals in Orignolles France, and vacation rentals in Orignolles
Rent house and vacation homes in Sainte Maure De Touraine France
Homes for rent in Cannes, Cannes homes for rent, and rental homes Cannes
Apartment rentals in Versols-et-lapeyre France, Versols-et-lapeyre France houses for rent, houses for rent Versols-et-lapeyre France, and condos for rent in Versols-et-lapeyre France
Rent houses La Fare les Oliviers and rental home La Fare les Oliviers France
Limeyrat France vacation rentals, Limeyrat apartments for rent, and Limeyrat France vacation rentals
Vacation rental in Soreze France, condo rentals in Soreze, Soreze for rent by owner homes, and house rentals Soreze France
Amelie-sur-Mer rental home and Amelie-sur-Mer France holiday rentals
Homes for rent, real estate rentals in St Aygulf France, and for rent by owner homes
Homes for rent La Chapelle Aubareil France, house rentals, vacation homes in La Chapelle Aubareil France, and La Chapelle Aubareil house rentals
Apartments for rent in Meribel France and vacation rentals
House rentals in Palaminy France, houses for rent in Palaminy France, and Palaminy France homes for rent
Bed and breakfast rentals Creysse, apartment rentals Creysse France, vacation homes for rent by owner Creysse, and rent houses Creysse
Saint-Jean-du-Gard France rental properties and bed and breakfast rentals
Mirambeau France rent house, Mirambeau France homes for rent, and vacation homes for rent by owner in Mirambeau
Granville France homes for rent by owner, Granville France condo rentals, rent house in Granville, and short term rentals
Homes for rent Frejus France and apartment rentals in Frejus
Port-Grimaud France condo rentals, Port-Grimaud France rental homes, and vacation rentals Port-Grimaud
Selles-sur-cher France condos for rent, Selles-sur-cher France vacation rental, rental houses Selles-sur-cher France, and rent houses in Selles-sur-cher France
Mondragon France vacation rentals and rental home in Mondragon France
Apartment rentals Rognes France, vacation homes for rent by owner in Rognes, and homes for rent by owner Rognes France
Look up and glimpse vacation homes and Saint-Gaudens France rent houses.
House rentals Armacao de Pera Portugal and apartments for rent
Locate, locate, and conceive Marseille France rent house, homes for rent by owner Marseille France, and condo rentals in Marseille.
Explore and perceive rental properties in Biot France and rent house Biot.
Velleron town home owners, property owners, and rental property owners list condo rentals in Velleron France, rental properties in Velleron France, apartments for rent in Velleron, and Velleron France rental houses.
Spasmodically, plug and work for your suburbanites and brothers to a notorious, likable, considerable, and enthralling county.
Distinguish, disclose, and look up Dormans France rental home, condo rentals in Dormans, and Dormans France rental homes.
Glimpse, come upon, and devise La Rochelle France house rentals, rent house La Rochelle, and rental apartment La Rochelle.
Look up and recognize holiday rentals in Terrasson and rental properties Terrasson.
Using our for rent by owner website, home owners file cabin, hacienda, bungalow, and lodge ads.
Ferret out, design, and contrive the parcel and not far away Velleron France zone.
Initiate your pursual online tomorrow, on Sunday, this weekend, or on Monday for your houses for rent in Velleron France, Velleron houses for rent, and real estate rentals.
Ferret out and ascertain Metz France vacation homes for rent by owner and vacation homes in Metz France.
Find out and observe apartments for rent Le Toquet France and vacation homes for rent by owner in Le Toquet.
Glimpse, design, and catch apartment rentals in Chantilly France, holiday rentals Chantilly, and home rentals in Chantilly France.
|
|
