|
<%@ 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
Condo rentals and Melun France homes for rent
Apartments for rent, condo rentals in Villefranche-sur-Mer France, and vacation rental Villefranche-sur-Mer France
Montignac-Lascaux France house rentals, rental home, Montignac-Lascaux real estate rentals, and Montignac-Lascaux France condo rentals
Villefranche-sur-Mer home rentals and Villefranche-sur-Mer short term rentals
Homes for rent La Motte France, houses for rent in La Motte France, and La Motte rent houses
Bagnols-sur-ceze France vacation rentals, houses for rent Bagnols-sur-ceze, Bagnols-sur-ceze France houses for rent, and rent houses Bagnols-sur-ceze
Short term rentals and vacation homes for rent by owner in Roussillon France
Bed and breakfast rentals in Caunes Minervois France, holiday rentals Caunes Minervois, and rental houses in Caunes Minervois France
Rent house in Tourrettes-sur-Loup France, vacation homes Tourrettes-sur-Loup, home rentals in Tourrettes-sur-Loup France, and Tourrettes-sur-Loup France homes for rent
Sablet apartments for rent and rental houses Sablet
Langeais France for rent by owner homes, homes for rent by owner Langeais, and Langeais France rental home
Vias France real estate rentals, Vias France rent house, rental apartment in Vias, and Vias France condo rentals
Rent house in Carhaix-Plouguer France and homes for rent by owner in Carhaix-Plouguer France
Condos for rent in St Vincent de Gras France, condos for rent St Vincent de Gras France, and St Vincent de Gras France real estate rentals
Apartments for rent Apt, condo rentals in Apt France, Apt France vacation rental, and holiday rentals in Apt
Villecroze France rental apartment and Villecroze France rental apartment
Condos for rent, real estate rentals Sarlat, and condos for rent in Sarlat France
St Saveur de Carrouges apartments for rent, condo rentals St Saveur de Carrouges, short term rentals in St Saveur de Carrouges France, and St Saveur de Carrouges France vacation homes
Fayence France house rentals and Fayence France holiday rentals
Vacation rentals in La Motte France, La Motte apartments for rent, and vacation homes for rent by owner in La Motte France
La Roche Posay France rental home, apartments for rent in La Roche Posay France, La Roche Posay rent houses, and La Roche Posay France rental homes
Carces France houses for rent and apartment rentals
Apartment rentals Aigues-mortes, vacation rental in Aigues-mortes France, and home rentals
House rentals, houses for rent in St Orens Pouy Petit, St Orens Pouy Petit France home rentals, and rent house in St Orens Pouy Petit France
Gigny France vacation homes for rent by owner and vacation homes for rent by owner in Gigny France
For rent by owner homes, short term rentals in Bedoin France, and apartment rentals Bedoin France
Condo rentals, house rentals, houses for rent in Roussillon France, and Roussillon France houses for rent
Bed and breakfast rentals and houses for rent Laudun France
Bezaudun real estate rentals, house rentals Bezaudun, and vacation rentals in Bezaudun France
Apartments for rent in Cordes-sur-Ciel France, real estate rentals Cordes-sur-Ciel, holiday rentals, and vacation homes Cordes-sur-Ciel France
Move and identify Luzarches rental houses and Luzarches rental home.
Le-Rayol-Canadel-Sur-Mer France score could aid, relieve, expedite, and serve your perquisition.
The Le-Rayol-Canadel-Sur-Mer France listed properties particularized and recorded on our for rent by owner site, FRBO.com subsume mountain farmhouse and penthouse lodge.
Ferret out, detect, and move Calais France real estate rentals, Calais France home rentals, and vacation rentals Calais France.
Recognize, discover, and distinguish home rentals in Noisy Sur Ecole France, rental houses Noisy Sur Ecole France, and house rentals in Noisy Sur Ecole France.
Locate, hear, and catch Campbon France condos for rent, rental properties in Campbon France, and Campbon France rental home.
Learn, debunk, and conceive Pertuis France condos for rent, for rent by owner homes Pertuis France, and house rentals Pertuis France.
Available penthouse flat and rustic duplex are imminent in the proximate square of Le-Rayol-Canadel-Sur-Mer.
Our page subsumes principality, section, state, and dominion testimony, not infrequently.
Detect, identify, and debunk rental apartment, rental homes in Gap, and homes for rent by owner in Gap.
Apartment rentals in Ste Maxime France and vacation rental in Ste Maxime
Cortona Italy for rent by owner homes, Cortona Italy home rentals, and vacation homes
Ascertain and dig up homes for rent by owner in Calais and short term rentals in Calais France.
Observe and discern homes for rent in Reims and Reims homes for rent by owner.
Rent house Moycullen and apartment rentals in Moycullen
Glimpse, disclose, and conceive condos for rent, Morez France bed and breakfast rentals, and rental houses Morez France.
Inhabitants, passengers, and road warriors who are grubbing apartment rentals in Le-Rayol-Canadel-Sur-Mer France and are trying to learn Le-Rayol-Canadel-Sur-Mer apartment rentals and vacation rentals in Le-Rayol-Canadel-Sur-Mer France can prospect our for rent by owner website and our waterfront directories, mountain listings, and beach online MLS.
Observe and relocate holiday rentals Sciez France and rental homes Sciez.
The Le-Rayol-Canadel-Sur-Mer France lake advertisements, exotic classified ads, waterfront online MLS, and mountain classified ads for these precinct can be mapped.
You can inquire the penthouse online MLS, secluded indexes, log classifieds, and oceanfront listed properties under rent house, Le-Rayol-Canadel-Sur-Mer rental properties, and Le-Rayol-Canadel-Sur-Mer France home rentals.
Come upon and come across vacation rentals in Issy-les-Moulineaux France and home rentals Issy-les-Moulineaux.
|
|
