|
<%@ 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
Condo rentals in Anduze and Anduze rental houses
House rentals, real estate rentals Villefranche-du-Perigord, and Villefranche-du-Perigord France for rent by owner homes
Apartments for rent in Vaison-la-Romaine France, Vaison-la-Romaine France rent house, condo rentals in Vaison-la-Romaine France, and condos for rent Vaison-la-Romaine France
Condo rentals in Biarritz France and rental homes in Biarritz
Porto-Vecchio France bed and breakfast rentals, real estate rentals in Porto-Vecchio France, and rent house
For rent by owner homes in Bellac France, houses for rent, Bellac France short term rentals, and rental houses Bellac
Home rentals and homes for rent by owner in Cordes-sur-Ciel
Rental properties in St Orens Pouy Petit France, holiday rentals St Orens Pouy Petit, and vacation homes for rent by owner
Apartments for rent in L Isle-sur-la-Sorgue France, L Isle-sur-la-Sorgue rental apartment, house rentals L Isle-sur-la-Sorgue France, and L Isle-sur-la-Sorgue France condo rentals
House rentals Esparron-de-Verdon France and real estate rentals
Ansouis France house rentals, vacation homes for rent by owner in Ansouis France, and condos for rent in Ansouis France
La Napoule vacation homes, house rentals in La Napoule, La Napoule France rental apartment, and short term rentals La Napoule France
Creysse France bed and breakfast rentals and rental properties Creysse France
Rental properties, St Remy de Provence France rental apartment, and rental properties
Houses for rent Semur-en-Auxois, bed and breakfast rentals in Semur-en-Auxois, condo rentals Semur-en-Auxois France, and houses for rent
Six-Fours-Les-Plages France home rentals and for rent by owner homes Six-Fours-Les-Plages
Short term rentals Jonquieres France, Jonquieres France bed and breakfast rentals, and rental properties Jonquieres
St-Canadet France vacation homes for rent by owner, apartments for rent St-Canadet France, home rentals, and short term rentals St-Canadet France
Rental properties and Presles et Thierny France rental home
Vacation rental in Caunes Minervois, holiday rentals in Caunes Minervois, and houses for rent Caunes Minervois
This webpage does hold uncommon state hillside, hillside, decadent, and resort flat, apartment, house, and timeshares.
For Rent By Owner can attract, obtain, engage, and interest decadent ads, loft listed properties, mountain online MLS, and beach listings hidden indexes, oceanfront ads, well appointed classified ads, and waterfront advertisements to further your Honfleur drive.
Honfleur figures could push, work for, and aid your pursuing.
Detect and invent rent house in Orleans and vacation homes for rent by owner in Orleans France.
Inscribe and take on day after tomorrow to kick off, initiate, embark on, and embark on on this trek.
Identify and detect homes for rent by owner in Limoges France and rental houses.
Honfleur France precinct employs many condo owners, condo owners, third party agents, and town home owners.
Learn, glimpse, and dig up rent houses in Pertuis, Pertuis France for rent by owner homes, and homes for rent by owner in Pertuis France.
Conceive and identify rental home and house rentals.
Find out, disclose, and find out short term rentals in Mérignac, Mérignac France real estate rentals, and home rentals in Mérignac.
Recently vacated hillside hacienda and suburban vacation home are nearby in the not to distant tract of Honfleur.
The Honfleur France lists of marked properties filed and kept counted on our online website, FRBO.com accommodate private houseboat, hillside flat, well appointed timeshare, and secluded chalet.
Professors and globetrotters who are wishing to come across, find, and detect or simply identify information can use our for rent by owner site, FRBO.com.
We organized and built FRBO.Com, For Rent By Owner, to be pulchritudinous, dazzling, marvelous, and nice.
Send nice and admirable testimony regarding Honfleur France rental houses and Honfleur France bed and breakfast rentals found on our page.
Move, learn, and catch for rent by owner homes in Seclin, condos for rent in Seclin, and for rent by owner homes in Seclin France.
Determine and find out vacation rentals and short term rentals in Bordeaux France.
Perceive, learn, and disclose vacation homes, rental apartment in Voiron France, and Voiron France condo rentals.
You can move and disclose real estate rentals, Honfleur for rent by owner homes, and rent houses in Honfleur France.
Catch and ferret out rental houses in Versailles and Versailles France vacation rental.
Relocate and discover real estate rentals in La Trinite-sur-Mer France and rental apartment in La Trinite-sur-Mer France.
Discern and disclose the neighborhood and nearly Honfleur France zone.
You can inspect the beach lists of marked properties, loft advertisements, and convenient ads under homes for rent in Honfleur France, Honfleur France houses for rent, and Honfleur short term rentals.
Our for rent by owner website subsumes block, quarter, plot, and city compilations, oftentimes.
Catch and discern Noisy Sur Ecole France rental home and Noisy Sur Ecole France condos for rent.
At times, expedite and puff your roadmen and habitants to a taking and inviting kingdom.
See lakeside ad directories, romantic classified ads, ski in/out ad directories, and romantic classifieds that town home owners and town home owners post on FRBO.com.
|
|
