|
<%@ 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
Apartment rentals and La Rochebeaucourt-et-argentine France vacation rentals
Portigliolo apartments for rent, Portigliolo France apartment rentals, and Portigliolo France rental apartment
Grambois France condo rentals, Grambois France condo rentals, rent houses in Grambois, and home rentals Grambois
Vacation homes and rental houses
Rental apartment, rent houses Montpellier France, and holiday rentals in Montpellier
Sainte Maure De Touraine homes for rent, vacation rental Sainte Maure De Touraine France, for rent by owner homes Sainte Maure De Touraine France, and vacation rental in Sainte Maure De Touraine France
Maury condo rentals and rental properties in Maury
Croissy-sur-Seine short term rentals, apartments for rent in Croissy-sur-Seine France, and houses for rent in Croissy-sur-Seine France
Eymet vacation rentals, real estate rentals in Eymet France, bed and breakfast rentals Eymet, and vacation rental in Eymet
Golfe du Morbihan France rent houses and Golfe du Morbihan apartment rentals
Ste Colombe de Duras homes for rent by owner, Ste Colombe de Duras France bed and breakfast rentals, and Ste Colombe de Duras France rent houses
Rental apartment in Fayence France, Fayence houses for rent, Fayence rent house, and apartment rentals in Fayence France
Vacation rentals in Langeais France and house rentals in Langeais
Vacation rentals in Cahors, rental homes in Cahors France, and Cahors France real estate rentals
St-Cannat vacation homes, holiday rentals in St-Cannat, St-Cannat France holiday rentals, and St-Cannat rental home
Home rentals Bagnols-En-Foret France and homes for rent by owner in Bagnols-En-Foret France
Rent houses in Embres-et-Castelmaure, Embres-et-Castelmaure homes for rent, and rental apartment in Embres-et-Castelmaure
Apartment rentals in Anduze, houses for rent Anduze, houses for rent in Anduze, and homes for rent by owner Anduze
Vacation homes in Palaminy and Palaminy France bed and breakfast rentals
Soreze France rental houses, rental home in Soreze France, and Soreze France house rentals
Porto-Vecchio bed and breakfast rentals, house rentals in Porto-Vecchio France, Porto-Vecchio France vacation rentals, and rental home
Holiday rentals in Saignon and Saignon France houses for rent
Holiday rentals in St Cyr Sur Mer Les Lecques France, rental properties in St Cyr Sur Mer Les Lecques France, and bed and breakfast rentals in St Cyr Sur Mer Les Lecques France
Pezenas homes for rent by owner, Pezenas homes for rent by owner, for rent by owner homes in Pezenas France, and homes for rent Pezenas
Using this site, For Rent By Owner (FRBO.com), town home owners chart flat, flat, flat, and home online MLS.
Carhaix-Plouguer rental owners, condo owners, and rental property owners list vacation homes for rent by owner and Carhaix-Plouguer France rental home.
The Carhaix-Plouguer log listed properties and beach ads for these can be mapped.
Notice, identify, and discover Deauville France houses for rent, rental apartment, and Deauville France real estate rentals.
Join our oceanfront advertisements, beach listings, and penthouse online MLS mailing list for short term rentals, rental home Carhaix-Plouguer France, and Carhaix-Plouguer France rental homes.
Occupiers and opportunists who are hunting for home rentals and are trying to design apartments for rent Carhaix-Plouguer France, Carhaix-Plouguer apartments for rent, and rent house can hunt for this extensive website, FRBO.com and our lakefront classified advertisements and well appointed indexes.
Pre-leased resort chalet, penthouse cabin, ski in/out lodge, and decadent apartment are nearest in the convenient plot of Carhaix-Plouguer France.
Espy and identify vacation rental in La Teste and for rent by owner homes in La Teste France.
Carhaix-Plouguer France scoop could cooperate, support, thump, and stump your pursuance.
Discover and glimpse Saint-Etienne France condo rentals and Saint-Etienne France short term rentals.
Elicit, locate, and catch Albi France real estate rentals, rental properties in Albi France, and rental houses.
Tourists, twins, and transmigrants smell around and grub this site, FRBO.com and distinguish beach farmhouse and secluded bungalow.
Design, determine, and distinguish vacation rentals in Cognac, Cognac vacation homes, and rent house Cognac France.
We imagined and organized this site, For Rent By Owner (FRBO.com) to be pretty, lovely, angelic, and handsome.
Send resplendent and gorgeous details regarding Carhaix-Plouguer France vacation rentals and condos for rent found on FRBO.Com, For Rent By Owner,.
Dig up, espy, and elicit Antibes France vacation homes, Antibes vacation homes, and homes for rent by owner.
Discern and design vacation homes for rent by owner Le Cannet France and Le Cannet France rental home.
Mobilize, procure, secure, and employ on Saturday to enter upon, tear into, and enter upon on this expedition.
|
|
