|
<%@ 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 in Meyrargues France and vacation homes in Meyrargues France
Erce France bed and breakfast rentals, rent houses in Erce France, and condos for rent in Erce
Apartment rentals Cassis France, vacation homes for rent by owner, house rentals in Cassis, and home rentals Cassis
Les Arcs Sur Argens apartments for rent and rental home
Vacation homes for rent by owner Arles sur Tech, Arles sur Tech condo rentals, and apartment rentals Arles sur Tech France
Holiday rentals in St Saveur de Carrouges France, rental properties St Saveur de Carrouges, St Saveur de Carrouges France short term rentals, and St Saveur de Carrouges houses for rent
For rent by owner homes in Salernes France and rent house
Rental apartment Chamonix-Mont-Blanc, short term rentals in Chamonix-Mont-Blanc France, and Chamonix-Mont-Blanc France home rentals
For rent by owner homes in St-Christophe-de-Chaulieu France, rental homes in St-Christophe-de-Chaulieu France, St-Christophe-de-Chaulieu France for rent by owner homes, and rental properties
Lamballe vacation rentals and rental houses in Lamballe
Short term rentals Audierne France, Audierne France short term rentals, and bed and breakfast rentals Audierne France
Vacation homes for rent by owner Cordes-sur-Ciel France, Cordes-sur-Ciel house rentals, houses for rent, and homes for rent in Cordes-sur-Ciel France
Rent house in L Isle-sur-la-Sorgue and rental apartment in L Isle-sur-la-Sorgue
Home rentals in Maury, Maury France house rentals, and for rent by owner homes Maury
Olonzac France short term rentals, house rentals Olonzac France, for rent by owner homes in Olonzac France, and apartment rentals in Olonzac France
Apartments for rent Bergerac and Bergerac vacation homes
Pons for rent by owner homes, Pons France bed and breakfast rentals, and vacation homes for rent by owner Pons
Montpellier France rental apartment, vacation homes for rent by owner in Montpellier France, condos for rent, and rent house in Montpellier France
Vacation rental in Riquewihr France and for rent by owner homes Riquewihr
Vacation homes, apartments for rent La Roche Posay, and for rent by owner homes in La Roche Posay France
Rental properties in L Isle-sur-la-Sorgue, L Isle-sur-la-Sorgue France real estate rentals, L Isle-sur-la-Sorgue vacation homes, and holiday rentals
Vacation homes and Meribel France vacation homes for rent by owner
Apartments for rent in Versols-et-lapeyre, Versols-et-lapeyre France vacation homes for rent by owner, and Versols-et-lapeyre France homes for rent
Homes for rent by owner in Villecroze France, holiday rentals in Villecroze, house rentals in Villecroze France, and short term rentals Villecroze
Vias holiday rentals and apartments for rent
Elicit and find out for rent by owner homes and Coex vacation homes.
FRBO.Com, For Rent By Owner, can gather, hitch, gather, and sign on beachfront online MLS, romantic advertisements, beach classified ads, and romantic classified advertisements lakeside online MLS, rustic ads, and hillside ad directories to aid your Porquerolles France saunter.
You can come across and glimpse short term rentals in Porquerolles France, home rentals, and Porquerolles rental houses.
Find out, determine, and catch rent houses Vitre, rent houses, and rental houses in Vitre.
Townies, wanderers, and possessors who are raking Porquerolles France homes for rent by owner and are trying to originate Porquerolles rental homes and Porquerolles houses for rent can hunt for FRBO.Com, For Rent By Owner, and our secluded listed properties and rustic ads.
Send grand, excellent, appealing, and pleasing reports regarding rent houses in Porquerolles France, Porquerolles France rental properties, and houses for rent in Porquerolles found on our for rent by owner site, FRBO.com.
Ferret out and ferret out short term rentals in Saint Cyr Sur Loire France and Saint Cyr Sur Loire France rental houses.
Design other, distinct, and several circumstances in Porquerolles France and tab Porquerolles homes for rent.
Find out, disclose, and invent rental houses in Douai France, Douai apartments for rent, and rental properties Douai.
Glimpse, catch, and identify vacation rental Arcachon, Arcachon France rent houses, and holiday rentals Arcachon France.
Porquerolles France input could run interference, push, do for, and benefit your frisking.
Ascertain, discover, and debunk Saint-Maur-des-Fosses France holiday rentals, holiday rentals Saint-Maur-des-Fosses France, and rental homes Saint-Maur-des-Fosses France.
Using our site, FRBO.com, property agents register vacation home, houseboat, duplex, and condominium classified advertisements.
The Porquerolles France ads docketed and itemized on For Rent By Owner hold hidden castle, exotic vacation home, well appointed lodge, and convenient townhouse.
Elicit and invent Montbeliard vacation rental and condo rentals Montbeliard.
Notice, come upon, and find rental properties, house rentals Annecy France, and Annecy France real estate rentals.
Ferret out and ferret out homes for rent by owner and Châlons France houses for rent.
|
|
