|
<%@ 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
Six-Fours-Les-Plages short term rentals and Six-Fours-Les-Plages France for rent by owner homes
Rental home in Montouliers, house rentals Montouliers France, and Montouliers house rentals
Croissy-sur-Seine France for rent by owner homes, houses for rent in Croissy-sur-Seine, Croissy-sur-Seine France rent house, and Croissy-sur-Seine France real estate rentals
Rousset rental home and house rentals
Real estate rentals in Ancy-le-Franc, short term rentals, and Ancy-le-Franc France rental houses
Condos for rent Puyloubier France, bed and breakfast rentals in Puyloubier France, condo rentals, and rental home in Puyloubier France
Condo rentals Tourrettes-sur-Loup and homes for rent by owner in Tourrettes-sur-Loup France
Rental apartment, holiday rentals in Pont-Royal France, and Pont-Royal France homes for rent
Vacation homes for rent by owner in Mortagne-sur-Gironde France, vacation rentals in Mortagne-sur-Gironde France, Mortagne-sur-Gironde rental properties, and Mortagne-sur-Gironde home rentals
Homes for rent by owner Marmagne and rental houses
Chamonix-Mont-Blanc France apartment rentals, for rent by owner homes Chamonix-Mont-Blanc France, and Chamonix-Mont-Blanc apartments for rent
Home rentals Velleron, Velleron France homes for rent by owner, Velleron France vacation homes for rent by owner, and for rent by owner homes Velleron
Bed and breakfast rentals Cahors and rent house in Cahors
Light upon, recognize, and design Eguisheim France rent house, vacation rentals in Eguisheim, and holiday rentals Eguisheim France.
St Raphael France is a foxy, radiant, and foxy township with pulchritudinous and delightful condominium, houseboat, and timeshares.
Come across and debunk Strasbourg France apartments for rent and apartment rentals in Strasbourg.
You can ferret the lakeside online MLS, beach listings, spacious lists of marked properties, and exclusive indexes under apartments for rent St Raphael France, for rent by owner homes in St Raphael France, and rent house St Raphael France.
Espy, learn, and light upon apartments for rent in Peronne France, for rent by owner homes in Peronne, and apartment rentals in Peronne France.
Perceive and light upon Précy-sur-Oise vacation rentals and apartments for rent Précy-sur-Oise France.
Pre-rented lake farmhouse, lakeside apartment, resort apartment, and penthouse bungalow are not far in the not to distant zone of St Raphael France.
Contrive, conceive, and find out vacation homes in Le Vesinet France, rent house, and condos for rent.
Roomers, cohorts, and commuters who are ransacking apartment rentals St Raphael France and are trying to conceive condo rentals in St Raphael France and St Raphael vacation rental can investigate this webpage and our rustic classifieds, beach classified advertisements, and hidden classifieds.
St Raphael landlords, landlords, rental agents, and property brokers list rental apartment in St Raphael France, vacation rental St Raphael France, and bed and breakfast rentals St Raphael France.
Come across and learn condo rentals in Arcachon France and holiday rentals Arcachon.
|
|
