|
<%@ 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
Cagnes-sur-Mer home rentals and Cagnes-sur-Mer France vacation rental
Rental apartment St Vincent de Gras France, vacation rental in St Vincent de Gras France, and condos for rent in St Vincent de Gras
Clermont l Herault France rental properties, Clermont l Herault rental home, Clermont l Herault France rental apartment, and Clermont l Herault rental homes
Fayence France homes for rent and real estate rentals in Fayence France
Homes for rent by owner, Gordes France homes for rent by owner, and short term rentals Gordes France
Rent house in Cairanne, Cairanne France short term rentals, home rentals Cairanne France, and Cairanne condos for rent
Dieulefit France home rentals and apartments for rent in Dieulefit France
Versailles France homes for rent, Versailles France rental home, and Versailles France rental home
For rent by owner homes Septeuil France, house rentals, rental homes Septeuil, and vacation homes for rent by owner Septeuil France
Erce France vacation rentals and Erce homes for rent
Theoule-sur-Mer France bed and breakfast rentals, rental houses in Theoule-sur-Mer France, and house rentals Theoule-sur-Mer
Vacation rental, Saint-Jean-du-Gard France rent house, rent houses in Saint-Jean-du-Gard France, and Saint-Jean-du-Gard rent houses
Vacation rentals in Arles France and Arles rental apartment
Homes for rent, rental houses, and vacation rentals Callas
St Paul de Vence France real estate rentals, condo rentals St Paul de Vence, houses for rent St Paul de Vence, and St Paul de Vence France rental homes
Anduze France vacation rentals and for rent by owner homes in Anduze France
Vacation rentals in Cucuron France, Cucuron France bed and breakfast rentals, and vacation rental in Cucuron France
Andlau apartments for rent, Andlau rent house, for rent by owner homes in Andlau, and apartments for rent Andlau France
Rental houses in Mirabeau France and Mirabeau France rental homes
Vacation rental in Fayence France, Fayence France rental home, and Fayence France houses for rent
Pezenas France rent houses, rental properties in Pezenas France, Pezenas France vacation homes for rent by owner, and vacation rental Pezenas France
Versailles France vacation rental and Versailles France bed and breakfast rentals
Vacation rental Chamonix-Mont-Blanc, homes for rent Chamonix-Mont-Blanc France, and apartment rentals in Chamonix-Mont-Blanc France
Rent house in Riquewihr, home rentals in Riquewihr France, for rent by owner homes in Riquewihr, and Riquewihr France vacation homes for rent by owner
Vacation rental and Villefranche-sur-Mer France for rent by owner homes
Condos for rent in Les Arcs Sur Argens, vacation homes for rent by owner in Les Arcs Sur Argens France, and apartment rentals Les Arcs Sur Argens
Condos for rent Frejus France, real estate rentals Frejus, Frejus France rent house, and Frejus France rental properties
Pezenas France vacation rentals and houses for rent
Rental properties in Cavaillon France, Cavaillon France rent houses, and condo rentals in Cavaillon France
Rental apartment Plougasnou France, Plougasnou vacation rentals, Plougasnou apartment rentals, and Plougasnou France apartments for rent
House rentals St Saturnin les Apt France and holiday rentals St Saturnin les Apt
Real estate rentals in Porquerolles France, apartment rentals, and Porquerolles France vacation rental
Relocate and ascertain bed and breakfast rentals in Le Havre France and Le Havre real estate rentals.
Vacation rental in Dieulefit and Dieulefit rent house
Identify and ferret out apartments for rent and Les Ormes-sur-Voulzie rental home.
Pre-rented hidden villa and romantic cabin are not far in the not remote plot of Beaumes de Venise.
Catch, disclose, and discern Carcassonne condo rentals, apartment rentals Carcassonne, and Carcassonne condos for rent.
Beaumes de Venise is a ideal and marvelous zone with splendid, angelic, pulchritudinous, and fair lodge and lodges.
You can search for the convenient indexes and mountain advertisements under rental properties and Beaumes de Venise France real estate rentals.
Take up your witch hunt online tomorrow evening or this weekend for your short term rentals Beaumes de Venise France and houses for rent in Beaumes de Venise France.
Identify and ferret out rental apartment Elancourt France and vacation rental Elancourt France.
Come across and debunk vacation homes and real estate rentals in La Vergne France.
Look up and distinguish homes for rent by owner Fontenay-Le-Compte and Fontenay-Le-Compte France houses for rent.
Vacation rental Montespertoli, Montespertoli Italy short term rentals, and apartment rentals
Rental home in Bari Italy and condo rentals
Catch and light upon apartment rentals in La Rochelle and rent houses.
Rent payers, roomers, and dwellers who are wishing to catch, determine, and discern or simply learn information can use FRBO.com.
Identify, determine, and disclose rental home Toulouse France, house rentals Toulouse France, and vacation homes for rent by owner in Toulouse France.
Identify, conceive, and find out for rent by owner homes, Nantes France rental apartment, and Nantes vacation rentals.
Beaumes de Venise France precinct employs many land owners, town home owners, property managers, and rental agents.
You can catch, contrive, and determine rent houses Beaumes de Venise France and houses for rent in Beaumes de Venise France.
Identify, identify, and design vacation rentals in Luray France, Luray rental homes, and Luray France rent houses.
The Beaumes de Venise France lake classified ads, exclusive lists of marked properties, decadent classified advertisements, and hidden lists of marked properties for these field can be mapped.
Chateauneuf-Grasse France real estate rentals, Chateauneuf-Grasse France houses for rent, Chateauneuf-Grasse France condo rentals, and apartments for rent Chateauneuf-Grasse
Rental home, rental houses, and homes for rent by owner in L Isle-sur-la-Sorgue France
Detect and come across Arles France homes for rent by owner and Arles France apartments for rent.
Bed and breakfast rentals Panicale, rental apartment, and Panicale vacation homes for rent by owner
Our for rent by owner site, FRBO.com does seat ad hoc exclusive, hidden, convenient, and decadent cottage, cabin, townhouse, and townhouses.
Originate, uncover, and relocate vacation homes in Cannes France, houses for rent, and short term rentals in Cannes France.
Relocate, conceive, and come upon short term rentals Anglet, short term rentals in Anglet France, and vacation homes Anglet.
Beaumes de Venise third party agents, condo owners, third party listing companies, and agents list rental properties in Beaumes de Venise France and house rentals.
Bed and breakfast rentals in Los Cristianos and holiday rentals in Los Cristianos
Notice, move, and ferret out Belfort France homes for rent, rental homes in Belfort France, and apartments for rent in Belfort France.
Rent payers, roomers, and dwellers who are probing condos for rent in Beaumes de Venise France and are trying to uncover Beaumes de Venise rental properties, house rentals in Beaumes de Venise France, and rental houses Beaumes de Venise can go through this site, For Rent By Owner (FRBO.com) and our suburban classified ads, loft classifieds, resort ads, and exclusive indexes.
Discover and perceive condos for rent and short term rentals in Cannes France.
Find and contrive Les Ulis apartment rentals and bed and breakfast rentals.
Inscribe, enter, interest, and serve this weekend to jump into, take up, and inaugurate on this survey.
|
|
