|
<%@ 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 properties in Pont-Royal and Pont-Royal France homes for rent
Holiday rentals Andlau, vacation homes for rent by owner Andlau France, and rental properties in Andlau
Short term rentals Langeais, holiday rentals, Langeais France rental apartment, and condos for rent Langeais France
Rent houses Manduel and apartments for rent Manduel France
Vacation homes for rent by owner in Dauphin France, Dauphin France rent houses, and Dauphin France condo rentals
House rentals in Gigny France, short term rentals in Gigny France, condo rentals, and home rentals Gigny
Rental homes in Biot and holiday rentals in Biot
Apartment rentals in Montner France, Montner rent house, and house rentals in Montner
Lamballe France vacation homes for rent by owner, holiday rentals, vacation rental in Lamballe France, and homes for rent in Lamballe France
Nice apartments for rent and Nice holiday rentals
Homes for rent by owner in Bandol France, holiday rentals Bandol France, and rental apartment in Bandol
Homes for rent by owner Vaugines, rent house Vaugines France, real estate rentals, and Vaugines France rental houses
Perpignan France for rent by owner homes and homes for rent Perpignan France
Le Bugue France rental home, Le Bugue France bed and breakfast rentals, and vacation homes for rent by owner in Le Bugue
Vacation rentals in Chamonix-Mont-Blanc, rent houses Chamonix-Mont-Blanc France, homes for rent, and rental apartment
Rental apartment and bed and breakfast rentals Lourmarin
Rental apartment Rousset, rental houses in Rousset France, and Rousset France vacation rentals
Real estate rentals Golfe du Morbihan France, rental home, Golfe du Morbihan France for rent by owner homes, and rental properties Golfe du Morbihan France
Condo rentals in Avignon France and Avignon bed and breakfast rentals
Mortain France home rentals, Mortain rental houses, and Mortain France vacation rentals
For rent by owner homes St Didier France, St Didier France for rent by owner homes, St Didier France vacation homes for rent by owner, and rental properties St Didier
Rental home Aiguebelle and Aiguebelle rent houses
Vacation homes for rent by owner Aix en Provence France, Aix en Provence France rental houses, and Aix en Provence France rent houses
Vacation homes in Ste-Foy-d Aigrefeuille France, Ste-Foy-d Aigrefeuille France rent houses, homes for rent in Ste-Foy-d Aigrefeuille, and home rentals in Ste-Foy-d Aigrefeuille
Beaune homes for rent and rental properties in Beaune France
Erce vacation rentals, rental home Erce France, and homes for rent by owner Erce
Civray France houses for rent, Civray France rental apartment, rental home Civray, and Civray France rental homes
Apartment rentals and houses for rent
Gargas France vacation rentals, Gargas France rental properties, and condo rentals Gargas France
Najac rental houses, vacation rentals in Najac France, house rentals in Najac France, and Najac apartments for rent
Home rentals and Beaune France vacation homes
St Aygulf apartment rentals, homes for rent by owner St Aygulf, and vacation rentals in St Aygulf
Rental houses in Eymet and vacation rental in Eymet France
Identify small number and specific info in Ste Maxime and set down Ste Maxime real estate rentals.
Identify, contrive, and explore rent houses in Le Mans, vacation homes, and condo rentals.
Conceive and contrive Mutzig France rental properties and vacation homes in Mutzig.
Ferret out and come upon Abbeville France condo rentals and home rentals Abbeville.
Determine and conceive Saint-Etienne France holiday rentals and vacation homes for rent by owner Saint-Etienne.
Join our private directories and beach advertisements mailing list for vacation rental in Ste Maxime France, rent house Ste Maxime, and Ste Maxime France vacation rentals.
Recognize and uncover Le Vesinet condos for rent and Le Vesinet France rental apartment.
Inhabitants, traveling men, and jet-setters who are studying houses for rent in Ste Maxime France and are trying to disclose rental apartment in Ste Maxime, Ste Maxime France condo rentals, and homes for rent in Ste Maxime can quest our website, FRBO.com and our hidden ads and spacious listings.
Observe, locate, and explore short term rentals in La Trinite-sur-Mer France, rent houses La Trinite-sur-Mer, and rental properties.
At times, serve and root for your pioneers and renters to a pretty, hep, and the rage state.
You can move and distinguish homes for rent in Ste Maxime and Ste Maxime France short term rentals.
Ste Maxime is a dazzling, fine, and refined township with grand, ideal, magnificent, and graceful flat, cabin, bungalow, and vacation homes.
Ste Maxime France reports could reinforce, open doors, and ride shotgun your quest.
Townies, occupiers, and rent payers look and cast about our for rent by owner website and explore mountain vacation home, lakeside flat, and lake lodge.
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures post condominium and home classified ads.
Glimpse and perceive real estate rentals Orsay France and Orsay vacation rentals.
Rental homes Roquebrune-Cap-Martin France and apartments for rent in Roquebrune-Cap-Martin France
Ste Maxime land owners and home owners list Ste Maxime France vacation rentals, home rentals Ste Maxime, Ste Maxime for rent by owner homes, and Ste Maxime rental apartment.
Discern, perceive, and debunk rent houses in Reims, for rent by owner homes in Reims France, and apartments for rent Reims.
Catch, disclose, and observe Antibes France rent houses, Antibes condos for rent, and real estate rentals in Antibes France.
Detect, design, and learn rental homes Romorantin France, vacation rental, and Romorantin vacation rental.
Ste Maxime zone employs many rental property owners and home owners.
Determine and espy Caen France condo rentals and Caen France short term rentals.
Rental homes in San Giovanni d Asso and San Giovanni d Asso Italy vacation rental
Holiday rentals in Bellagio Italy, real estate rentals in Bellagio, and short term rentals in Bellagio
For Rent By Owner does encompass unconventional patch city, studio, and convenient house, timeshare, duplex, and cabins.
Invent, come across, and come across Pau France vacation rental, vacation homes in Pau, and Pau France rental properties.
Our page seats zone, dominion, and square goods, every now and then.
Catch and come across rent houses and rental properties.
We composed, organized, and established our page to be enticing and splendid.
Discover, originate, and catch apartment rentals in Colmar, vacation rentals in Colmar, and homes for rent by owner in Colmar.
See city online MLS, beachfront classified advertisements, city indexes, and exotic ad directories that property agents and rental agents post on our website, FRBO.com.
Lezzeno Italy rental houses, short term rentals in Lezzeno, Lezzeno Italy for rent by owner homes, and apartments for rent
Identify and design condo rentals in Colmar and rental houses Colmar France.
Find out, locate, and notice vacation homes in Chavaniac France, Chavaniac apartment rentals, and homes for rent Chavaniac France.
Dig up, originate, and disclose homes for rent by owner Anglet France, Anglet rent house, and rental houses Anglet France.
Come upon, discover, and notice rental properties Metz, holiday rentals Metz France, and homes for rent by owner in Metz.
|
|
