|
<%@ 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 Menton France and Menton vacation rental
Bed and breakfast rentals, apartments for rent Pezenas, and Pezenas France rental houses
Apartment rentals Entrecasteaux, apartment rentals, rental home, and homes for rent
Tornac France short term rentals and bed and breakfast rentals Tornac France
Apartments for rent in BerbiguiG¨res France, BerbiguiG¨res France rental houses, and for rent by owner homes BerbiguiG¨res France
Beaumes de Venise France vacation rental, Beaumes de Venise house rentals, apartment rentals, and home rentals in Beaumes de Venise France
Houses for rent in Aniane France and home rentals Aniane
Condos for rent Robion France, Robion France short term rentals, and holiday rentals
Houses for rent La Motte France, rental houses in La Motte France, La Motte France bed and breakfast rentals, and vacation homes in La Motte
Vacation homes in Villefranche-sur-Mer France and houses for rent in Villefranche-sur-Mer France
Condos for rent in Rambouillet France, vacation homes in Rambouillet, and vacation rental
Aniane rental homes, Aniane France rental home, rent house Aniane France, and Aniane France condos for rent
St Caradec France home rentals and St Caradec bed and breakfast rentals
Short term rentals Villecroze France, rent houses in Villecroze France, and Villecroze home rentals
Apartments for rent Saumur France, Saumur France apartment rentals, short term rentals Saumur, and house rentals in Saumur
Rental homes Loches and Loches France homes for rent by owner
Beziers France short term rentals, rent houses, and apartment rentals in Beziers France
Homes for rent, homes for rent in Amboise France, Amboise France homes for rent by owner, and vacation rental in Amboise
Lauzerte France real estate rentals and house rentals in Lauzerte France
Portigliolo France houses for rent, apartments for rent Portigliolo, and short term rentals in Portigliolo France
For rent by owner homes in Rambouillet France, Rambouillet France for rent by owner homes, rental apartment Rambouillet, and house rentals Rambouillet France
Condo rentals in Vacqueyras France and Vacqueyras France rental properties
Nyons rental houses, Nyons France vacation rentals, and Nyons France holiday rentals
For rent by owner homes Quimper France, rent houses in Quimper, Quimper France real estate rentals, and Quimper France house rentals
For rent by owner homes in Sainte Maure De Touraine and vacation homes in Sainte Maure De Touraine France
Rental apartment in Lamballe France, rental homes in Lamballe France, and rental homes in Lamballe France
Short term rentals Orignolles, condos for rent Orignolles France, Orignolles France rental properties, and Orignolles France condos for rent
Rental houses St Saveur de Carrouges France and home rentals in St Saveur de Carrouges France
Apartment rentals in Bezaudun, apartment rentals Bezaudun, and short term rentals in Bezaudun
Rental apartment Vallauris, condo rentals in Vallauris, Vallauris rental houses, and house rentals in Vallauris France
Home rentals in Mougins France and rental houses in Mougins France
Vacation rentals in Rognes, Rognes real estate rentals, and for rent by owner homes in Rognes
Houses for rent in Dieulefit France and bed and breakfast rentals in Dieulefit France
Vacation rentals in Ste Maxime France, Ste Maxime France rental homes, and Ste Maxime France holiday rentals
Call up and secure this evening to originate, open, inaugurate, and open on this voyage.
Elicit, discover, and uncover real estate rentals in Coubert France, Coubert France rent house, and Coubert home rentals.
Transmigrants and co-workers who are inquiring Limeyrat France apartment rentals and are trying to notice rental properties Limeyrat France and short term rentals Limeyrat France can scour For Rent By Owner and our exotic listings, beach advertisements, ski in/out listings, and private directories.
Move, locate, and come across Terrasson France vacation rental, Terrasson France vacation homes, and vacation rental in Terrasson France.
Look up and distinguish bed and breakfast rentals in Cognac and Cognac vacation homes for rent by owner.
Distinguish and notice condo rentals and Précy-sur-Oise rental houses.
Contrive and come upon vacation homes in Vichy and homes for rent by owner.
This site, For Rent By Owner (FRBO.com) can enter, hire, and sign on city advertisements, mountain directories, rustic classified advertisements, and waterfront online MLS loft listed properties, suburban advertisements, studio listings, and hidden classified advertisements to assist your Limeyrat France survey.
The Limeyrat France indexes numerated and recorded on our for rent by owner site, FRBO.com have spacious chalet and rustic duplex.
Observe and dig up real estate rentals in Luray France and apartments for rent in Luray France.
Discern and identify bed and breakfast rentals Chamonix and real estate rentals.
Originate, contrive, and discern houses for rent in Macon, Macon rental properties, and Macon France homes for rent by owner.
Bed and breakfast rentals Vale Do Lobo Portugal, home rentals in Vale Do Lobo Portugal, and holiday rentals
Find out, contrive, and find out Le Cannet condo rentals, Le Cannet apartments for rent, and homes for rent by owner in Le Cannet.
Oupia vacation rentals and house rentals in Oupia France
Our webpage does accommodate special sector oceanfront, rustic, well appointed, and waterfront cabin and houses.
Distinguish, glimpse, and disclose Albertville France houses for rent, bed and breakfast rentals in Albertville France, and house rentals Albertville.
Uncover, design, and conceive vacation homes for rent by owner Narbonne, rental homes in Narbonne France, and Narbonne France short term rentals.
You can rummage the spacious indexes, ski in/out listed properties, log classified advertisements, and rustic ad directories under Limeyrat France rental homes and vacation homes Limeyrat.
Limeyrat France measurements could thump, sustain, and bail out your pursual.
Using our for rent by owner site, FRBO.com, home owners peg villa, bungalow, condominium, and chalet classified advertisements.
La Motte France house rentals and condo rentals La Motte France
Short term rentals Merlischachen Switzerland, short term rentals in Merlischachen, rent house Merlischachen, and for rent by owner homes
Look up, observe, and hear La Vergne France rental properties, homes for rent La Vergne, and rental apartment in La Vergne France.
Locate, notice, and discern real estate rentals in Belfort, rental home Belfort, and holiday rentals in Belfort France.
Condo rentals La Napoule France, for rent by owner homes in La Napoule France, La Napoule holiday rentals, and La Napoule vacation rental
Roamers and inhabitants explore, search for , and forage our online website, FRBO.com and observe oceanfront lodge, decadent timeshare, city house, and beach duplex.
|
|
