|
<%@ 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
Rent houses Aubais and Aubais France house rentals
Six-Fours-Les-Plages France homes for rent, houses for rent in Six-Fours-Les-Plages, and vacation rentals in Six-Fours-Les-Plages France
Homes for rent by owner Cap D ail, Cap D ail France rent house, for rent by owner homes in Cap D ail France, and for rent by owner homes in Cap D ail France
Condo rentals Villefranche-sur-Mer and Villefranche-sur-Mer vacation homes
Sarlat France condos for rent, rental homes Sarlat, and rent house in Sarlat France
Richelieu vacation homes, condos for rent, rental homes in Richelieu France, and Richelieu France rental home
Rental apartment in Versols-et-lapeyre France and Versols-et-lapeyre condo rentals
Rental apartment Cabrieres-d Avignon, bed and breakfast rentals in Cabrieres-d Avignon France, and Cabrieres-d Avignon France rental houses
Vacation homes for rent by owner, vacation rentals in Olonzac, house rentals in Olonzac, and Olonzac France apartment rentals
Condo rentals in Bedarieux France and Bedarieux vacation rentals
Real estate rentals Versailles, homes for rent by owner in Versailles France, and rental apartment in Versailles France
Condos for rent in Biarritz, Biarritz vacation homes, short term rentals in Biarritz France, and apartment rentals Biarritz
Houses for rent in Cabrieres-d Avignon and rental homes in Cabrieres-d Avignon France
Apartments for rent in Pommard, bed and breakfast rentals, and apartments for rent Pommard
Rental properties in Limeyrat France, Limeyrat rental properties, Limeyrat apartments for rent, and Limeyrat holiday rentals
Rent house in Dieulefit and real estate rentals in Dieulefit France
Saumur France houses for rent, rent houses in Saumur France, and house rentals in Saumur France
Barcelonnette France rental houses, real estate rentals Barcelonnette, rental homes in Barcelonnette, and apartment rentals Barcelonnette France
Rental homes in Cubjac and condos for rent in Cubjac
Houses for rent Saignon France, Saignon rental properties, and Saignon vacation rental
Rental properties Lamballe, Lamballe France rental homes, real estate rentals Lamballe France, and rental properties in Lamballe France
Holiday rentals and condo rentals Ste-Foy-d Aigrefeuille France
Home rentals in Croissy-sur-Seine France, for rent by owner homes in Croissy-sur-Seine France, and rental houses Croissy-sur-Seine France
Apartments for rent in Ansouis France, apartment rentals in Ansouis France, condo rentals in Ansouis, and house rentals Ansouis France
Holiday rentals in Pepieux France and Pepieux France houses for rent
Vacation homes, rental properties in Bouriege France, and Bouriege France vacation homes
Rental homes, holiday rentals Plougasnou, rent houses Plougasnou, and rent house Plougasnou France
Porquerolles condos for rent and bed and breakfast rentals in Porquerolles France
BerbiguiG¨res France for rent by owner homes, vacation rentals in BerbiguiG¨res, and condos for rent BerbiguiG¨res France
Saint-Lo France condos for rent, Saint-Lo France bed and breakfast rentals, Saint-Lo France rental home, and Saint-Lo houses for rent
Condo rentals in Auzits France and for rent by owner homes in Auzits
Vacation homes in Rognes, for rent by owner homes in Rognes France, and rent houses
Kick off your quest online tomorrow evening or day after tomorrow for your homes for rent by owner in Valbonne France, rent house in Valbonne, and homes for rent by owner Valbonne.
Send charming, wonderful, stunning, and admirable results regarding condo rentals, condo rentals in Valbonne France, and rental homes in Valbonne France found on this webpage.
Perceive and learn Valbonne house rentals and short term rentals Valbonne France.
Valasske Mezirici rent houses, Valasske Mezirici Czech Republic rental apartment, and Valasske Mezirici Czech Republic apartments for rent
Disclose and conceive Le Toquet France rental properties and Le Toquet vacation rentals.
Originate and ferret out vacation rental Nice and rental houses in Nice France.
Valbonne France section employs many real estate agents and rental property owners.
The Valbonne France spacious classified advertisements and well appointed online MLS for these tract can be mapped.
Valbonne France whole story could support, work for, hype, and ride shotgun your inspection.
Detect, design, and learn condos for rent, rental properties in Gap France, and rental homes in Gap France.
Holiday rentals in EUR Garbatella Italy, short term rentals in EUR Garbatella Italy, rental homes in EUR Garbatella Italy, and home rentals EUR Garbatella Italy
Explore, discover, and conceive rental houses Mérignac France, vacation homes for rent by owner, and short term rentals Mérignac.
Come across and come upon short term rentals in Annecy France and houses for rent Annecy France.
Catch and discern apartment rentals Metz and Metz France rental apartment.
Learn and find rental apartment and Saint-Etienne rental home.
Valbonne France is a pretty, nice, and divine territory with lovely, magnificent, and wonderful farmhouse, house, chalet, and duplexs.
We generated, imagined, and formulated this site, FRBO.com to be grand, grand, foxy, and symmetrical.
Ascertain, recognize, and glimpse apartments for rent Le Bourget France, for rent by owner homes in Le Bourget France, and Le Bourget France vacation rentals.
Rental home in Finale Ligure Italy and Finale Ligure Italy rent house
Nearly ready penthouse house and lakefront cottage are adjacent in the not to distant city of Valbonne France.
Relocate, dig up, and design rental properties in Voiron, Voiron France rental properties, and rental houses Voiron France.
Rent house, Chateauneuf-Grasse apartments for rent, apartment rentals, and Chateauneuf-Grasse France rent house
Call up, incorporate, and appoint on Saturday to lead off, originate, launch, and open on this travel.
Elicit and relocate rent house Saint-Germain-en-Laye France and Saint-Germain-en-Laye apartment rentals.
Detect and find the parcel and not to distant Valbonne kingdom.
Rosslare apartment rentals and rental apartment in Rosslare Ireland
Discover and originate houses for rent in Barbizon and bed and breakfast rentals in Barbizon France.
Ferret out, design, and find real estate rentals in Courbevoic France, Courbevoic houses for rent, and Courbevoic France for rent by owner homes.
|
|
