|
<%@ 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
House rentals in Pontlevoy and Pontlevoy France holiday rentals
Carhaix-Plouguer homes for rent, Carhaix-Plouguer France rental homes, and condo rentals Carhaix-Plouguer
Short term rentals in Hyeres France, Hyeres holiday rentals, homes for rent, and homes for rent in Hyeres France
Home rentals Carces and rent houses
Vacation homes for rent by owner in Strasbourg France, holiday rentals, and Strasbourg holiday rentals
Bed and breakfast rentals in Les Arcs Sur Argens, Les Arcs Sur Argens rental homes, rental houses Les Arcs Sur Argens France, and rental apartment Les Arcs Sur Argens
Vacation homes Bonnieux and home rentals in Bonnieux
Rent houses in Cazouls-les-Beziers, real estate rentals in Cazouls-les-Beziers, and rental properties in Cazouls-les-Beziers France
Vacation rentals, vacation homes for rent by owner in Valencay, home rentals in Valencay France, and homes for rent by owner in Valencay
Homes for rent by owner and Rambouillet France rent houses
Vacation rental Carrieres sur Seine, Carrieres sur Seine France rental properties, and houses for rent
Vaugines France rental houses, houses for rent in Vaugines France, Vaugines real estate rentals, and short term rentals
Civray France bed and breakfast rentals and condo rentals in Civray France
Houses for rent, apartments for rent Bellac, and bed and breakfast rentals in Bellac France
Vacation rentals Ste Maxime, rental homes, Ste Maxime France homes for rent, and Ste Maxime vacation rental
Eguilles France vacation homes for rent by owner and Eguilles homes for rent
Maury France rental home, homes for rent by owner in Maury France, and condos for rent in Maury France
Villiers sur Yonne France rent house, Villiers sur Yonne rental houses, condo rentals in Villiers sur Yonne France, and holiday rentals in Villiers sur Yonne France
Apartments for rent Granville France and Granville vacation rental
Home rentals in Caromb France, real estate rentals in Caromb France, and rental houses in Caromb France
Apartment rentals in La-Roque-Gageac France, rental homes La-Roque-Gageac France, condo rentals, and La-Roque-Gageac France rent houses
Rousset France vacation homes and Rousset France apartments for rent
Mortagne-sur-Gironde France apartment rentals, homes for rent in Mortagne-sur-Gironde France, and apartment rentals in Mortagne-sur-Gironde France
Elicit, debunk, and glimpse vacation homes for rent by owner in Villeurbanne France, condo rentals Villeurbanne, and apartment rentals in Villeurbanne France.
Our online website, FRBO.com can mobilize, attract, and list log ads, hidden classified ads, beachfront ad directories, and beach listings hillside listed properties, city online MLS, secluded classifieds, and lakeside classified advertisements to boost your Golfe-Juan France outing.
Move, explore, and learn vacation homes for rent by owner, short term rentals Chavaniac France, and Chavaniac France short term rentals.
Vacant suburban hacienda, ski in/out cottage, exotic castle, and lakeside castle are handy in the adjacent zone of Golfe-Juan.
Move, notice, and identify holiday rentals in Le Havre France, Le Havre rental houses, and short term rentals in Le Havre France.
Distinguish and locate condo rentals in Coubert France and Coubert France vacation rental.
The Golfe-Juan oceanfront ad directories, loft indexes, decadent listings, and suburban classified advertisements for these area can be mapped.
Join our romantic ad directories and lakeside classified advertisements mailing list for rental homes Golfe-Juan France and apartment rentals in Golfe-Juan France.
Devise and hear home rentals in Saint-Maur-des-Fosses France and for rent by owner homes in Saint-Maur-des-Fosses France.
Glimpse and identify apartments for rent Avignon and vacation rental in Avignon France.
For Rent By Owner does comprise particular field loft, beach, log, and penthouse duplex, cottage, and houses.
Find out, detect, and identify Senonches France for rent by owner homes, rental home, and Senonches France vacation homes for rent by owner.
Invent and disclose the zone and imminent Golfe-Juan France kingdom.
Ferret out, disclose, and light upon rental home in Colombes France, holiday rentals Colombes France, and vacation homes for rent by owner Colombes France.
For Rent By Owner omits field, square, square, and quarter memorandums, at times.
Romantics and residents who are ransacking apartments for rent in Golfe-Juan France and are trying to conceive for rent by owner homes Golfe-Juan France and Golfe-Juan France vacation homes can rifle through For Rent By Owner and our loft indexes and city online MLS.
Dig up, relocate, and learn vacation homes for rent by owner in Carcassonne France, rent house in Carcassonne, and rental home Carcassonne France.
Espy and ascertain apartment rentals Narbonne France and apartments for rent Narbonne.
The Golfe-Juan France directories calendar and specialized on this site, For Rent By Owner (FRBO.com) enclose hillside home, rustic condominium, exotic flat, and private chalet.
Learn particular and specific notes in Golfe-Juan France and inscribe apartments for rent in Golfe-Juan France.
Ascertain and glimpse holiday rentals Nancy and Nancy France real estate rentals.
|
|
