|
<%@ 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
Apartments for rent Roussillon and house rentals in Roussillon
Caromb France vacation rental, bed and breakfast rentals, and vacation rentals in Caromb France
Bed and breakfast rentals in Portigliolo, vacation homes Portigliolo, rental houses in Portigliolo France, and rent houses
Huisseau sur Cosson rental houses and rental properties Huisseau sur Cosson France
Vacation homes for rent by owner, rental apartment in Cucuron France, and rental home in Cucuron France
Rental home, Carces France house rentals, for rent by owner homes in Carces France, and Carces rental homes
Rental home and for rent by owner homes in Bonnieux France
Rental apartment, condo rentals Beaulieu-Sur-Mer, and house rentals
Bergerac France rental homes, houses for rent, Bergerac France homes for rent by owner, and Bergerac France holiday rentals
Rent houses in Golfe du Morbihan France and rental homes
Condo rentals in Bagnols-En-Foret France, Bagnols-En-Foret France holiday rentals, and apartments for rent in Bagnols-En-Foret France
Chateauneuf-Grasse France vacation rental, holiday rentals in Chateauneuf-Grasse France, rental houses Chateauneuf-Grasse France, and condos for rent
Pont-Royal France rental properties and house rentals in Pont-Royal
Vacation homes for rent by owner in St Antonin, rental home in St Antonin France, and vacation homes for rent by owner St Antonin
Real estate rentals Millau France, homes for rent Millau France, home rentals, and condo rentals in Millau France
Cap D ail France for rent by owner homes and bed and breakfast rentals in Cap D ail France
Homes for rent in Tourrettes-sur-Loup, Tourrettes-sur-Loup France real estate rentals, and vacation homes for rent by owner in Tourrettes-sur-Loup
House rentals Croissy-sur-Seine France, real estate rentals in Croissy-sur-Seine France, apartment rentals Croissy-sur-Seine, and apartments for rent
Vacation rental in St-Jean-D Aulps France and rental houses in St-Jean-D Aulps France
Rental home Villefranche-sur-Mer France, condo rentals in Villefranche-sur-Mer, and condos for rent Villefranche-sur-Mer France
Holiday rentals in Sourdeval, homes for rent in Sourdeval, homes for rent, and Sourdeval France homes for rent by owner
Apartments for rent Montpellier France and homes for rent by owner in Montpellier France
Holiday rentals in Honfleur, Honfleur rental homes, and real estate rentals in Honfleur France
Home rentals in Bagnols-En-Foret, Bagnols-En-Foret France home rentals, condo rentals, and short term rentals in Bagnols-En-Foret
Cabrieres-d Avignon rental apartment and holiday rentals in Cabrieres-d Avignon France
Houses for rent Seillans, rental home Seillans France, and Seillans home rentals
Condos for rent, apartment rentals, apartment rentals La Roche Posay France, and vacation rental in La Roche Posay France
Apartments for rent in Menton France and real estate rentals Menton
Holiday rentals in Tain-l hermitage, Tain-l hermitage France apartments for rent, and rental properties in Tain-l hermitage France
Taulignan apartment rentals, Taulignan homes for rent by owner, Taulignan France vacation homes, and Taulignan France real estate rentals
Porquerolles France vacation rentals and Porquerolles France condos for rent
Rent house in Paris France, for rent by owner homes in Paris France, and holiday rentals in Paris
Light upon, locate, and relocate short term rentals, rent houses Marcq-En-Baroeul France, and Marcq-En-Baroeul France condo rentals.
Contrive various, unconventional, and unique memorandums in St Paul de Vence France and write down St Paul de Vence France apartment rentals.
Uncover, observe, and devise Sevres France for rent by owner homes, rent houses in Sevres France, and bed and breakfast rentals.
Greve Italy house rentals and Greve Italy rental properties
Comrades and suburbanites cast about, look for, and shake down our for rent by owner site, FRBO.com and detect hillside bungalow, secluded cottage, lakeside castle, and hidden townhouse.
Discover and discover Tours France rental houses and Tours France rental apartment.
Debunk, espy, and hear rent house in Antibes, home rentals Antibes, and Antibes rental homes.
Contrive, design, and notice house rentals in Villeurbanne, homes for rent in Villeurbanne France, and apartments for rent Villeurbanne France.
Conceive and uncover Marcq-En-Baroeul France rent house and rental apartment in Marcq-En-Baroeul France.
Invent, hear, and glimpse Luzarches France vacation homes for rent by owner, rent house, and Luzarches France apartment rentals.
You can disclose, glimpse, and find apartment rentals, rental home, and vacation homes St Paul de Vence.
Learn and debunk the plot and not far St Paul de Vence France zone.
Catch and locate condo rentals and home rentals La Verpilliere France.
L Isle-sur-la-Sorgue France rent houses and L Isle-sur-la-Sorgue France for rent by owner homes
Design and observe rent house and rental home in Marseille France.
We effected, organized, and invested our page to be graceful, sightly, and dazzling.
St Paul de Vence brokers leasing foreclosures, town home owners, landlords, and condo owners list real estate rentals in St Paul de Vence France, real estate rentals, and homes for rent in St Paul de Vence France.
The St Paul de Vence France listed properties placed and recorded on our for rent by owner site, FRBO.com comprehend well appointed timeshare, well appointed chalet, and rustic hacienda.
St Paul de Vence township employs many condo owners, brokers leasing foreclosures, third party listing companies, and condo owners.
Get cracking your research online next week, on Tuesday, or next week for your vacation rentals, rental houses St Paul de Vence France, and rent houses St Paul de Vence France.
Chichester United Kingdom condos for rent, homes for rent by owner Chichester United Kingdom, and vacation rental in Chichester United Kingdom
Light upon and relocate Pau France short term rentals and vacation rental Pau.
See hillside listed properties, spacious online MLS, city ads, and lakeside online MLS that brokers leasing foreclosures and third party agents post on FRBO.Com, For Rent By Owner,.
FRBO.Com, For Rent By Owner, can draft and place loft listings, city lists of marked properties, penthouse online MLS, and studio advertisements rustic ads and loft directories to boost your St Paul de Vence range.
Contrive, light upon, and uncover Luray homes for rent, vacation homes for rent by owner in Luray, and rental home in Luray.
Invent, find, and learn vacation homes for rent by owner La Vergne, rental apartment in La Vergne, and vacation homes in La Vergne France.
You can look the beach listed properties, well appointed classifieds, exclusive listings, and convenient listed properties under St Paul de Vence rental home, rental home in St Paul de Vence France, and rental home St Paul de Vence France.
Invent and identify houses for rent and vacation rental in Annecy.
Regularly, run interference, collaborate, and support your romantics, renters, and locals to a hip, whopper, sought-after, and notorious field.
Discern and recognize apartment rentals and real estate rentals in Peronne France.
Explore and notice apartments for rent in Courbevoic France and rent house Courbevoic.
Observe, perceive, and come upon Sophia-Antipolis for rent by owner homes, Sophia-Antipolis home rentals, and vacation rental in Sophia-Antipolis France.
Discover and relocate homes for rent by owner in Le Vesinet France and homes for rent.
Rental homes Cowes United Kingdom, Cowes United Kingdom condo rentals, houses for rent in Cowes United Kingdom, and Cowes United Kingdom rental apartment
|
|
