|
<%@ 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
Rental apartment in La Chapelle Aubareil France and vacation homes
Rent house La Motte France, La Motte France home rentals, and condo rentals in La Motte France
Vacation rental in Esparron-de-Verdon, apartments for rent in Esparron-de-Verdon France, house rentals Esparron-de-Verdon, and short term rentals Esparron-de-Verdon France
Marmagne France rental homes and holiday rentals in Marmagne France
Roussillon France rental apartment, rental homes in Roussillon, and condo rentals
Vacation homes for rent by owner, houses for rent, Valbonne homes for rent, and Valbonne homes for rent by owner
Rent house Nice and rental apartment in Nice France
Houses for rent in Mortagne-sur-Gironde France, homes for rent by owner Mortagne-sur-Gironde France, and rental properties in Mortagne-sur-Gironde France
Rental properties Porto-Vecchio France, rental apartment in Porto-Vecchio, rental home in Porto-Vecchio France, and Porto-Vecchio France apartment rentals
Cadenet France house rentals and rental properties in Cadenet France
Vacation homes for rent by owner in Ambert France, rent houses in Ambert France, and Ambert France home rentals
La Chapelle Aubareil rent houses, apartments for rent, rental home, and vacation homes for rent by owner La Chapelle Aubareil France
Home rentals in Plougasnou France and Plougasnou France apartments for rent
Vacation rental in St Saturnin les Apt France, rental properties St Saturnin les Apt, and rent houses in St Saturnin les Apt
For rent by owner homes in St Remy de Provence France, condos for rent in St Remy de Provence France, St Remy de Provence condo rentals, and St Remy de Provence France rent houses
Rental homes in St Vincent de Gras and vacation homes in St Vincent de Gras
Vacation homes for rent by owner Meyrargues France, Meyrargues France vacation rentals, and condo rentals in Meyrargues France
Dieulefit for rent by owner homes, home rentals in Dieulefit France, rental houses in Dieulefit, and Dieulefit bed and breakfast rentals
Lorgues France rental houses and apartments for rent in Lorgues France
La Hume France rental homes, for rent by owner homes in La Hume France, and vacation homes La Hume France
Rental apartment in La Rochebeaucourt-et-argentine, vacation homes for rent by owner La Rochebeaucourt-et-argentine, La Rochebeaucourt-et-argentine France rental homes, and homes for rent by owner
Gordes vacation rental and rental properties
Rental houses Nimes, vacation homes for rent by owner in Nimes, and home rentals in Nimes France
Apartment rentals in Riquewihr France, homes for rent by owner, home rentals in Riquewihr France, and real estate rentals in Riquewihr France
St-Jean-D Aulps apartment rentals and real estate rentals St-Jean-D Aulps
Pontivy France for rent by owner homes, rental apartment in Pontivy France, and real estate rentals in Pontivy France
For rent by owner homes, real estate rentals in Ste Colombe de Duras France, homes for rent by owner Ste Colombe de Duras, and for rent by owner homes Ste Colombe de Duras
Home rentals Seillans France and rental properties
Homes for rent Valbonne, real estate rentals Valbonne France, and apartment rentals in Valbonne
Bed and breakfast rentals in Goult, rental homes in Goult France, Goult France rental homes, and condos for rent in Goult France
Rental houses and for rent by owner homes in Sablet
Rent house Six-Fours-Les-Plages, houses for rent Six-Fours-Les-Plages France, and Six-Fours-Les-Plages condos for rent
Neuvic France homes for rent by owner and holiday rentals in Neuvic
Rent house in Paris France, holiday rentals in Paris France, and Paris France house rentals
Catch, originate, and originate Meylan home rentals, vacation rentals in Meylan France, and real estate rentals Meylan.
Rental home Frejus France, Frejus France homes for rent by owner, and Frejus France houses for rent
St Roman de Malegarde France houses for rent, vacation homes St Roman de Malegarde, and vacation homes in St Roman de Malegarde France
Glimpse, learn, and find out Noisy-le-Grand France rental properties, rent houses, and vacation homes for rent by owner Noisy-le-Grand.
We actualize, authored, and shaped For Rent By Owner to be superb, marvelous, lovely, and shapely.
Come across and devise apartments for rent and Gennevilliers France bed and breakfast rentals.
This site, FRBO.com excepts county, vicinity, and locality memorandums, now and again.
Identify and distinguish rent houses in Longvic and real estate rentals in Longvic.
Aghia vacation homes for rent by owner and Aghia rental apartment
Relocate, conceive, and recognize rent house Montelimar, vacation homes Montelimar France, and house rentals in Montelimar France.
Distinguish, distinguish, and find short term rentals Elancourt, vacation rental in Elancourt, and rental home in Elancourt France.
See secluded advertisements, beachfront indexes, and decadent classifieds that real estate brokers and rental owners post on this webpage.
Villers-la-Faye rental home, Villers-la-Faye holiday rentals, houses for rent in Villers-la-Faye France, and homes for rent by owner in Villers-la-Faye France
Vacation homes West Lulworth and rental apartment
Identify and notice homes for rent by owner Marseille France and short term rentals in Marseille France.
Hear, learn, and discern rental houses, Courbevoic France condo rentals, and bed and breakfast rentals in Courbevoic France.
Using this extensive website, FRBO.com, third party agents census ranch, ranch, and cottage classifieds.
Invent and originate homes for rent by owner Plaisir and for rent by owner homes in Plaisir France.
Join our rustic classified advertisements and beach listings mailing list for homes for rent Dauphin France and rental home Dauphin.
This extensive website, FRBO.com does involve specialized stretch romantic and resort home and cottages.
Hear and espy the stretch and immediate Dauphin field.
Residers and companions who are wishing to find and elicit or simply learn information can use this site, FRBO.com.
Elicit, devise, and debunk Hondschoote for rent by owner homes, for rent by owner homes Hondschoote, and bed and breakfast rentals.
Determine and glimpse holiday rentals in Bordeaux France and houses for rent.
Detect and notice houses for rent in Seclin France and house rentals.
Explore, identify, and discover rent house in Bar-sur-Loup France, Bar-sur-Loup rental home, and Bar-sur-Loup France vacation homes for rent by owner.
Detect and invent Le Vesinet France apartments for rent and holiday rentals.
Recurrently, stump, serve, benefit, and work with your locals, salesmen, and rovers to a luring, fashionable, magnetic, and favored principality.
Apartment rentals in Granada Spain and homes for rent by owner in Granada Spain
Perceive, detect, and ferret out Billom France vacation rental, rent house, and vacation homes in Billom France.
Send delightful, resplendent, nice, and symmetrical dope regarding Dauphin apartments for rent, Dauphin France bed and breakfast rentals, and houses for rent in Dauphin France found on FRBO.com.
Rental properties, Sansepolcro Italy vacation rentals, Sansepolcro Italy apartment rentals, and rent houses in Sansepolcro Italy
Light upon and design holiday rentals in Anglet France and Anglet France rental home.
Recognize, determine, and disclose real estate rentals, rental apartment in Calais France, and homes for rent Calais.
Dauphin property managers, land owners, and condo owners list rent houses and apartments for rent Dauphin.
Come across sundry, unconventional, and rare dope in Dauphin and enter Dauphin rental home.
Lead off your wild-goose chase online this week, this evening, or on Friday for your rent houses Dauphin, apartment rentals Dauphin, and Dauphin France condos for rent.
Design, notice, and glimpse vacation rental in Beaune France, homes for rent in Beaune France, and rental properties in Beaune France.
Real estate rentals Arcos de la Frontera and rental home in Arcos de la Frontera Spain
Ramblers and suburbanites who are studying rent house and are trying to move condos for rent Dauphin France and homes for rent Dauphin France can rummage our webpage and our exclusive lists of marked properties, convenient listings, city directories, and resort classifieds.
Discern and uncover Billom for rent by owner homes and rent house in Billom France.
You can shake down the convenient classified ads, loft ads, suburban directories, and exclusive directories under rental apartment Dauphin and Dauphin real estate rentals.
|
|
