|
<%@ 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 homes Cassis and houses for rent in Cassis
Apt France rent houses, rental properties in Apt France, and apartments for rent in Apt France
Houses for rent in St Aquilin, St Aquilin France vacation homes, rent houses St Aquilin, and short term rentals in St Aquilin
Houses for rent Jonquieres France and holiday rentals Jonquieres
Houses for rent in Bormes-les-Mimosas France, rental home Bormes-les-Mimosas France, and Bormes-les-Mimosas France rent houses
St-Christophe-de-Chaulieu France rent house, for rent by owner homes, holiday rentals St-Christophe-de-Chaulieu France, and short term rentals St-Christophe-de-Chaulieu
Houses for rent Biarritz France and vacation homes for rent by owner in Biarritz France
For rent by owner homes Aniane France, rent houses Aniane, and rent houses in Aniane
Armagnac Region house rentals, holiday rentals in Armagnac Region France, homes for rent in Armagnac Region France, and houses for rent in Armagnac Region France
Apartment rentals in Gigny France and Gigny France rental homes
Short term rentals, Nimes vacation rentals, and condos for rent in Nimes France
Bed and breakfast rentals, bed and breakfast rentals, rental apartment in Salernes, and rental homes
Vacation homes for rent by owner in Cordes-sur-Ciel France and condo rentals Cordes-sur-Ciel
Meribel homes for rent by owner, house rentals Meribel, and apartment rentals in Meribel France
Porto-Vecchio house rentals, rental homes in Porto-Vecchio France, house rentals in Porto-Vecchio France, and Porto-Vecchio France apartment rentals
House rentals in Bezaudun and Bezaudun for rent by owner homes
Caunes Minervois France real estate rentals, Caunes Minervois France bed and breakfast rentals, and vacation homes for rent by owner in Caunes Minervois
Rent house in St Paul de Vence France, homes for rent by owner in St Paul de Vence, house rentals in St Paul de Vence France, and St Paul de Vence rental houses
Rental properties and holiday rentals
Home rentals in Coutances France, vacation homes for rent by owner in Coutances France, and Coutances France bed and breakfast rentals
St Raphael France real estate rentals, rental properties in St Raphael France, St Raphael France real estate rentals, and rent house in St Raphael France
Rental homes in Cannes and Cannes France homes for rent by owner
St Aquilin rental properties, vacation homes for rent by owner in St Aquilin, and condos for rent in St Aquilin
Holiday rentals in Pons, Pons France apartments for rent, condo rentals, and for rent by owner homes Pons
Houses for rent in Meursault France and Meursault France rental houses
Vacation rentals Menerbes, real estate rentals Menerbes France, and vacation homes in Menerbes France
Montfort-sur-Argens vacation homes, Montfort-sur-Argens homes for rent, holiday rentals in Montfort-sur-Argens France, and real estate rentals
Versols-et-lapeyre France is a wonderful, fine, delightful, and sightly city with enticing, taking, wonderful, and elegant chalet and castles.
The Versols-et-lapeyre France romantic lists of marked properties, ski in/out listed properties, private ads, and waterfront indexes for these stretch can be mapped.
The Versols-et-lapeyre France lists of marked properties chronicled and enumerated on this website, FRBO.com accommodate decadent chalet, beach cabin, and waterfront chalet.
Record and join on Tuesday to get going and kick off on this transmigration.
Relocate and perceive Sophia-Antipolis condos for rent and bed and breakfast rentals.
Originate and relocate rental home in Noisy Sur Ecole and Noisy Sur Ecole France houses for rent.
Colleagues and migrants who are rifling through rental home and are trying to hear homes for rent in Versols-et-lapeyre and homes for rent by owner in Versols-et-lapeyre France can seek our page and our penthouse online MLS, beachfront online MLS, and secluded lists of marked properties.
Montalto delle Marche Italy homes for rent by owner, apartment rentals in Montalto delle Marche Italy, Montalto delle Marche vacation homes for rent by owner, and Montalto delle Marche Italy house rentals
Hear original and special knowledge in Versols-et-lapeyre and bill vacation homes for rent by owner in Versols-et-lapeyre.
Light upon, find out, and move apartment rentals in Orleans France, rent houses in Orleans, and Orleans France rent houses.
Discover, elicit, and originate condo rentals in Gennevilliers France, rental properties in Gennevilliers, and vacation homes Gennevilliers France.
We started, fabricated, and contrived For Rent By Owner to be appealing and charming.
Versols-et-lapeyre France experiments could help and assist your inspection.
Devise and determine rental apartment Pontivy and rental homes in Pontivy.
Almost ready to be occupied studio house and exclusive vacation home are near-at-hand in the neighboring parcel of Versols-et-lapeyre.
Light upon and perceive bed and breakfast rentals in Maisons-Laffitte and real estate rentals Maisons-Laffitte.
Contrive and discern Mérignac France holiday rentals and Mérignac France rental homes.
You can move, dig up, and conceive bed and breakfast rentals in Versols-et-lapeyre France, rental properties, and rental apartment Versols-et-lapeyre France.
Look up, determine, and originate homes for rent by owner in Cergy-Pontoise, Cergy-Pontoise France rental homes, and Cergy-Pontoise France vacation homes for rent by owner.
See ski in/out listed properties, lakeside directories, well appointed indexes, and beachfront ads that agents serving the condo market and rental owners post on our webpage.
Rental home Warder Netherlands, real estate rentals in Warder Netherlands, and vacation rentals Warder
|
|
