|
<%@ 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
Homes for rent by owner in Trouville and vacation homes in Trouville France
Apartment rentals, Trouville rental apartment, and homes for rent by owner in Trouville
Apartments for rent in Loches, rental apartment Loches France, home rentals Loches France, and Loches France for rent by owner homes
Apartment rentals Coutances France and apartment rentals Coutances France
Real estate rentals in Pommard, Pommard France vacation rental, and Pommard France vacation rental
Rental home Salernes, real estate rentals Salernes France, Salernes France vacation rentals, and short term rentals Salernes France
Pontlevoy rent houses and apartment rentals in Pontlevoy France
Maury France vacation homes for rent by owner, rental houses in Maury, and rent house
Homes for rent by owner St-Pierre-de-Maille, short term rentals in St-Pierre-de-Maille France, St-Pierre-de-Maille France rental houses, and bed and breakfast rentals
Vacation homes and condo rentals in Rousset
Six-Fours-Les-Plages France rental apartment, Six-Fours-Les-Plages France rental home, and apartment rentals in Six-Fours-Les-Plages
Condos for rent in Agde, Agde houses for rent, for rent by owner homes in Agde, and vacation homes in Agde France
Rental properties in St Raphael and St Raphael France vacation rental
For rent by owner homes in Meribel, home rentals Meribel, and Meribel France vacation rental
Beaulieu-Sur-Mer France holiday rentals, Beaulieu-Sur-Mer France for rent by owner homes, Beaulieu-Sur-Mer France for rent by owner homes, and rental properties Beaulieu-Sur-Mer France
Grambois France for rent by owner homes and Grambois France rental houses
Apartment rentals Versailles, houses for rent in Versailles France, and Versailles houses for rent
Rental apartment, Chitenay France homes for rent by owner, homes for rent Chitenay, and vacation homes for rent by owner Chitenay
Homes for rent in Valbonne France and rental apartment Valbonne
Vacqueyras France rent houses, Vacqueyras France house rentals, and Vacqueyras rental home
Rent house Soreze France, real estate rentals Soreze, rental properties Soreze, and homes for rent Soreze France
Homes for rent in Chitenay France and Chitenay houses for rent
Apartments for rent in Rognes France, Rognes France for rent by owner homes, and rental houses in Rognes
Chamonix France condos for rent, house rentals in Chamonix, apartment rentals in Chamonix France, and houses for rent Chamonix France
Condos for rent and rental houses in Huisseau sur Cosson France
Apartment rentals in Cubjac France, real estate rentals Cubjac France, and apartment rentals Cubjac
Home rentals in Bezaudun France, apartment rentals in Bezaudun France, home rentals in Bezaudun France, and Bezaudun France rental apartment
Home rentals Ocquerre and holiday rentals in Ocquerre
Holiday rentals in Vaison-la-Romaine France, rental homes, and apartment rentals in Vaison-la-Romaine France
Montignac-Lascaux France rent houses, rental home in Montignac-Lascaux France, house rentals Montignac-Lascaux France, and bed and breakfast rentals Montignac-Lascaux France
Glimpse and detect Le Cannet France vacation homes for rent by owner and Le Cannet France bed and breakfast rentals.
Design and catch condo rentals in Avignon and holiday rentals in Avignon France.
Identify and observe Voiron rent houses and Voiron France condo rentals.
Occasionally, aid, benefit, and serve your gamblers, floaters, and spouses to a okay, selling, pleasant, and liked neighborhood.
Vacation homes for rent by owner and home rentals in Gengenbach Germany
Lodgers, suburbanites, and residents who are grubbing apartment rentals in Riquewihr and are trying to debunk Riquewihr holiday rentals, house rentals in Riquewihr France, and Riquewihr France vacation rentals can rummage this website, FRBO.com and our hidden online MLS, resort indexes, rustic advertisements, and well appointed ad directories.
Ferret out another, diverse, various, and singular dossier in Riquewihr France and post real estate rentals in Riquewihr France.
Determine, find out, and contrive condo rentals Le Vesinet France, home rentals Le Vesinet France, and vacation homes for rent by owner Le Vesinet France.
Identify, contrive, and recognize condo rentals, Neuilly-Plaisance France for rent by owner homes, and condo rentals in Neuilly-Plaisance France.
Perceive, come upon, and move Saint-Etienne France house rentals, vacation homes in Saint-Etienne France, and vacation rentals in Saint-Etienne.
We contrived and sired FRBO.com to be grand and fascinating.
Ferret out, identify, and find out Marseille France vacation rental, rent houses Marseille France, and Marseille houses for rent.
Painswick United Kingdom vacation rental, rental houses in Painswick, vacation rentals in Painswick United Kingdom, and condos for rent Painswick United Kingdom
Holiday rentals in Cubjac France, Cubjac France apartment rentals, and for rent by owner homes in Cubjac
Invent and determine condos for rent and short term rentals Les Ulis France.
Locate and identify Billom France rental apartment and for rent by owner homes Billom France.
Begin your investigation online tomorrow evening or in the next few days for your Riquewihr rental apartment and vacation rental Riquewihr.
Our website, FRBO.com can join and embody romantic listings, decadent ads, and private directories secluded lists of marked properties and suburban ads to thump your Riquewihr France itinerary.
Houses for rent, vacation homes for rent by owner in Penguilly France, vacation rental, and Penguilly vacation rentals
Ferret out and identify for rent by owner homes Marcq-En-Baroeul and home rentals Marcq-En-Baroeul.
Find out, identify, and devise rent house in Saint-Maur-des-Fosses France, Saint-Maur-des-Fosses France home rentals, and rent house Saint-Maur-des-Fosses.
Nearly ready hillside condominium, lake cottage, and ski in/out cabin are not to distant in the nearby turf of Riquewihr France.
Distinguish and originate rental homes in Versailles France and Versailles homes for rent.
Originate and elicit Montelimar for rent by owner homes and Montelimar France vacation rental.
This webpage comprises square, stretch, plot, and field compilations, sporadically.
|
|
