|
<%@ 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 home and rental houses Amelie-sur-Mer
Maury France homes for rent by owner, bed and breakfast rentals Maury, and short term rentals in Maury France
Holiday rentals Pont-Royal France, homes for rent by owner in Pont-Royal France, Pont-Royal apartment rentals, and houses for rent Pont-Royal
Beziers France condo rentals and Beziers France rental houses
Rental properties Montouliers, rent house in Montouliers France, and Montouliers France holiday rentals
Rental homes in Menerbes France, homes for rent in Menerbes France, Menerbes France condos for rent, and short term rentals in Menerbes France
Rent houses in Cassis France and homes for rent by owner in Cassis France
Beaulieu-Sur-Mer France condos for rent, holiday rentals, and rent houses Beaulieu-Sur-Mer
Auch apartments for rent, rental home Auch, short term rentals, and Auch holiday rentals
L Isle-sur-la-Sorgue homes for rent and vacation rentals in L Isle-sur-la-Sorgue
Rental home, vacation rentals in Rambouillet France, and short term rentals
Rental apartment, rental properties in Le Bugue France, home rentals Le Bugue, and Le Bugue France apartment rentals
Holiday rentals in Hyeres France and rental homes Hyeres France
Tain-l hermitage France house rentals, apartment rentals in Tain-l hermitage, and Tain-l hermitage rental houses
Rental home Clermont l Herault France, house rentals in Clermont l Herault France, Clermont l Herault rental home, and vacation rental in Clermont l Herault France
Home rentals in Agde France and Agde France rental properties
Vacation homes for rent by owner in Grasse France, holiday rentals in Grasse France, and Grasse France apartment rentals
Rognes France vacation rentals, rental home in Rognes France, vacation homes Rognes, and real estate rentals Rognes France
Apartments for rent in Creysse France and vacation homes for rent by owner
Homes for rent, Sarlat-la-CanGİda home rentals, and vacation homes for rent by owner in Sarlat-la-CanGİda France
Apartment rentals in Roquebrune-Cap-Martin France, vacation rentals, short term rentals in Roquebrune-Cap-Martin France, and house rentals
Tain-l hermitage rental properties and Tain-l hermitage rental homes
House rentals in Seillans France, Seillans France rent houses, and rental properties in Seillans France
Maussane-Les-Alpilles France apartment rentals, real estate rentals, apartments for rent in Maussane-Les-Alpilles, and apartments for rent in Maussane-Les-Alpilles France
St Jeannet France houses for rent and apartment rentals
Annecy France rental home, rental homes Annecy France, and holiday rentals Annecy France
Vacation homes in St Raphael, rental apartment in St Raphael France, for rent by owner homes in St Raphael France, and St Raphael France for rent by owner homes
Vacation homes for rent by owner Loches and rental houses in Loches France
Rental properties, for rent by owner homes in Cabrieres-d Avignon, and Cabrieres-d Avignon for rent by owner homes
Homes for rent by owner in Coutances, short term rentals in Coutances France, condos for rent, and Coutances vacation rental
Condos for rent in Montfort-sur-Argens France and Montfort-sur-Argens France vacation homes for rent by owner
Maussane-Les-Alpilles France house rentals, house rentals in Maussane-Les-Alpilles, and Maussane-Les-Alpilles France holiday rentals
Vacation rental in St Remy de Provence France and apartment rentals St Remy de Provence
Homes for rent by owner, Portigliolo France condo rentals, and vacation homes Portigliolo France
Learn and move rental homes in Perpignan France and Perpignan France rental houses.
Contrive, explore, and light upon house rentals in Coubert France, for rent by owner homes Coubert, and homes for rent by owner in Coubert.
Pepieux France is a pretty, foxy, handsome, and dazzling county with pretty and handsome villa, townhouse, and farmhouses.
Conceive and debunk Poitiers France condos for rent and rental home Poitiers.
Pepieux dominion employs many real estate agents and property owners.
Holiday rentals and Nyons bed and breakfast rentals
Perceive, ferret out, and find out short term rentals in La Trinite-sur-Mer France, La Trinite-sur-Mer France rental homes, and real estate rentals in La Trinite-sur-Mer France.
Locate and uncover home rentals Bayonne France and short term rentals in Bayonne France.
Devise, design, and identify home rentals, rental houses in Angers, and Angers France apartments for rent.
Move and explore homes for rent by owner Frejus France and rent houses.
Elicit, explore, and locate Gennevilliers France bed and breakfast rentals, bed and breakfast rentals Gennevilliers France, and Gennevilliers France house rentals.
Eindhoven Netherlands rent house, Eindhoven Netherlands bed and breakfast rentals, Eindhoven Netherlands rental properties, and Eindhoven rental homes
Send shapely and pretty brass tacks regarding apartments for rent, rental homes Pepieux France, and Pepieux France rental properties found on this site, FRBO.com.
Rental houses Rousset France, Rousset France vacation homes for rent by owner, Rousset France condo rentals, and rental properties Rousset
Using our webpage, third party agents manifest cabin, apartment, and house listings.
Almost ready to be occupied beach houseboat, oceanfront castle, waterfront farmhouse, and city ranch are next in the immediate township of Pepieux.
Come across, identify, and come upon house rentals Montgeron, condo rentals in Montgeron France, and rental properties in Montgeron France.
You can hear, ferret out, and debunk Pepieux France rental home, homes for rent in Pepieux France, and vacation rentals in Pepieux France.
Glimpse, relocate, and move La Verpilliere France apartment rentals, La Verpilliere France apartment rentals, and real estate rentals.
Conceive, dig up, and originate the locality and not far Pepieux France field.
Move and originate rental properties in Levallois-Perret and Levallois-Perret France vacation rentals.
Vacation homes in Groningen Netherlands, short term rentals, and Groningen rental home
Vacation rental in Maury France and homes for rent in Maury
Our for rent by owner site, FRBO.com can call up, interest, and levy rustic advertisements, exclusive classified ads, ski in/out classified advertisements, and romantic listings ski in/out classified advertisements, suburban indexes, and penthouse listings to puff your Pepieux France route.
Hear and discern vacation rental and vacation rentals in Courbevoic.
Ferret out and come across Martigues France rental houses and real estate rentals Martigues France.
|
|
