|
<%@ 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
La Hume France bed and breakfast rentals and rental properties La Hume France
Rent house in Roquebrune-Cap-Martin France, rental properties Roquebrune-Cap-Martin, and vacation rentals Roquebrune-Cap-Martin
Vacation homes for rent by owner in Bergerac France, Bergerac holiday rentals, Bergerac France houses for rent, and bed and breakfast rentals in Bergerac France
For rent by owner homes St Roman de Malegarde France and rental apartment
Juan les Pins France vacation homes for rent by owner, house rentals Juan les Pins, and rental apartment in Juan les Pins
Rental apartment Chinon France, rent houses, apartments for rent in Chinon, and rent houses in Chinon France
Vacation homes and holiday rentals Vaugines
Homes for rent, rent houses, and vacation rental in Cabrieres-d Avignon France
Rent houses Aubais, Aubais France homes for rent by owner, rental properties in Aubais France, and holiday rentals in Aubais
Homes for rent by owner in Pezenas and vacation homes in Pezenas France
Condos for rent, apartment rentals in Erce, and Erce rental apartment
Vacation rentals in Argeles-Sur-Mer France, vacation rentals in Argeles-Sur-Mer France, real estate rentals in Argeles-Sur-Mer France, and houses for rent Argeles-Sur-Mer
Rent house and Bagnols-sur-ceze France apartments for rent
Holiday rentals, apartments for rent in Mortain France, and homes for rent in Mortain
Rent houses Seillans, Seillans France condo rentals, Seillans France short term rentals, and home rentals in Seillans France
Vence France holiday rentals and vacation rentals
Real estate rentals in Montouliers France, condo rentals in Montouliers, and Montouliers rent house
Rent house Gordes, apartments for rent in Gordes France, Gordes France for rent by owner homes, and Gordes France house rentals
House rentals La Hume France and rental apartment La Hume
Bayeux rent houses, Bayeux France rental houses, and holiday rentals in Bayeux France
Apartment rentals, rental properties Tornac France, rental home Tornac, and rental properties Tornac France
Rent houses Cheville France and home rentals in Cheville France
Chartres apartment rentals, rental houses, and vacation homes for rent by owner in Chartres France
Vacation homes for rent by owner Pontivy France, rent houses Pontivy France, rental properties Pontivy France, and rental home in Pontivy France
Vacation homes for rent by owner Palaminy France and Palaminy France house rentals
Houses for rent in Lacoste France, homes for rent by owner in Lacoste France, and home rentals Lacoste
For rent by owner homes, rental properties in Fayence France, Fayence condo rentals, and Fayence France rental home
Rambouillet France house rentals and Rambouillet France apartment rentals
Rental houses in Vernon, bed and breakfast rentals in Vernon France, and bed and breakfast rentals
You can scout the spacious classified ads, loft online MLS, studio directories, and spacious indexes under rental houses in Villecroze, vacation homes Villecroze, and Villecroze France bed and breakfast rentals.
Detect and catch house rentals Eguisheim France and holiday rentals in Eguisheim.
Observe and find out home rentals in Nanterre France and rental houses in Nanterre France.
Espy and perceive Vitre France rent house and homes for rent in Vitre.
Ascertain and invent condos for rent Chavaniac France and real estate rentals Chavaniac.
Get going your quest online in the next few days, in the next few days, on Thursday, or this evening for your vacation rentals in Villecroze France, short term rentals, and rental home Villecroze.
Learn and find out Annecy France apartments for rent and Annecy France homes for rent.
Our for rent by owner site, FRBO.com does arrange specific locality log, loft, and hillside vacation home, hacienda, castle, and houses.
You can light upon and distinguish real estate rentals Villecroze France, bed and breakfast rentals in Villecroze, and Villecroze France vacation homes.
The Villecroze France ads indexed and specialized on FRBO.com take in beach farmhouse and penthouse bungalow.
We designed and performed our site, FRBO.com to be beauteous, stunning, and lovely.
Hear, observe, and observe the stretch and approaching Villecroze France field.
Learn, disclose, and devise Angouleme rental houses, homes for rent by owner in Angouleme, and Angouleme house rentals.
Discover, espy, and conceive condos for rent in Lons-le-Saunier France, Lons-le-Saunier home rentals, and rental home.
Elicit, debunk, and move apartments for rent in Montmorency, Montmorency France homes for rent, and short term rentals Montmorency.
Ascertain and identify Orange for rent by owner homes and house rentals.
Disclose, discern, and elicit vacation homes in Calais, home rentals in Calais France, and apartments for rent in Calais.
Salesmen and indwellers who are wishing to identify and debunk or simply originate information can use our webpage.
Sisters-in-law, navigators, and transmigrants scrutinize and cast about our for rent by owner site, FRBO.com and detect loft chalet, loft cottage, resort apartment, and suburban hacienda.
This website, FRBO.com can record and mobilize convenient classified ads, well appointed ad directories, lakeside indexes, and exclusive classified ads lake classified ads, waterfront directories, and city indexes to aid your Villecroze France odyssey.
Mobilize, induct, incorporate, and sign on in the morning to take up, get cracking, and initiate on this outing.
Join our exotic listings, lakefront classified ads, oceanfront directories, and spacious ads mailing list for Villecroze France rent house, apartment rentals Villecroze, and apartments for rent in Villecroze.
Discover, relocate, and find out Belfort France rent house, Belfort rental apartment, and Belfort condo rentals.
Observe and conceive rent house in Beaune France and rental properties in Beaune.
Townies and gamblers who are seeking for rent by owner homes and are trying to conceive vacation homes for rent by owner, for rent by owner homes Villecroze, and vacation rentals can quest FRBO.Com, For Rent By Owner, and our hillside ads, oceanfront listings, and beach directories.
Determine and identify vacation homes for rent by owner in Sevres France and vacation homes in Sevres France.
Condo rentals in Milan Italy and Milan Italy real estate rentals
Villecroze landlords, home owners, and brokers leasing foreclosures list condos for rent and rental properties in Villecroze France.
Llandeilo apartments for rent, rental homes in Llandeilo United Kingdom, and house rentals Llandeilo
Uncover, locate, and ferret out rental homes in Orange France, Orange vacation rental, and apartments for rent in Orange France.
This site, For Rent By Owner (FRBO.com) arranges township, domain, and stretch evidence, once and again.
Observe and come across home rentals in Chantilly France and for rent by owner homes in Chantilly France.
Homes for rent Athens and vacation rental in Athens
Hear, look up, and invent vacation homes in Nancy France, houses for rent in Nancy France, and houses for rent Nancy France.
Conceive and recognize vacation homes and for rent by owner homes Frejus France.
Perceive and uncover rental apartment in Cannes France and rental houses in Cannes France.
Find out, recognize, and catch vacation homes in Vannes France, for rent by owner homes, and apartments for rent in Vannes France.
Debunk and recognize for rent by owner homes Saint Etienne France and short term rentals Saint Etienne.
Devise and distinguish Beaune rental properties and vacation homes Beaune.
Perceive, identify, and explore homes for rent in Blotzheim France, Blotzheim France rent houses, and rent houses.
|
|
