|
<%@ 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
House rentals in Beaulieu-Sur-Mer France and condo rentals in Beaulieu-Sur-Mer France
Rent houses Montclus France, for rent by owner homes Montclus France, and rental homes
Cabrieres-d Avignon France for rent by owner homes, rental houses Cabrieres-d Avignon France, short term rentals in Cabrieres-d Avignon, and Cabrieres-d Avignon France rental apartment
Caunes Minervois France vacation homes for rent by owner and for rent by owner homes in Caunes Minervois France
Seillans short term rentals, Seillans rental properties, and Seillans France condos for rent
Barcelonnette France rent house, apartment rentals in Barcelonnette, rental home, and rental apartment in Barcelonnette France
Ste Maxime France rental home and Ste Maxime France short term rentals
Real estate rentals in Les Arcs Sur Argens France, rental home Les Arcs Sur Argens France, and for rent by owner homes in Les Arcs Sur Argens France
Real estate rentals, Lamballe France condos for rent, Lamballe homes for rent, and rent houses in Lamballe France
For rent by owner homes in Lacour France and short term rentals in Lacour France
Short term rentals Les Baux de Provence, apartments for rent Les Baux de Provence, and condos for rent in Les Baux de Provence France
Presles et Thierny rent house, Presles et Thierny France vacation rental, house rentals in Presles et Thierny France, and Presles et Thierny France rental apartment
Les Baux de Provence condo rentals and vacation rentals in Les Baux de Provence France
Holiday rentals in Auch France, Auch France condos for rent, and apartment rentals in Auch
Rental properties Aix en Provence France, Aix en Provence France homes for rent, vacation homes Aix en Provence, and rent house in Aix en Provence France
Barcelonnette France condo rentals and apartment rentals
Nyons France vacation rental, home rentals Nyons France, and Nyons France houses for rent
Le-Rayol-Canadel-Sur-Mer France apartment rentals, Le-Rayol-Canadel-Sur-Mer real estate rentals, Le-Rayol-Canadel-Sur-Mer rent house, and bed and breakfast rentals in Le-Rayol-Canadel-Sur-Mer France
Rental apartment in Saumur France and Saumur holiday rentals
Rental properties in Villecroze, Villecroze France house rentals, and condos for rent Villecroze France
Holiday rentals in Clermont l Herault, rental apartment, home rentals in Clermont l Herault France, and vacation rental in Clermont l Herault France
St Saturnin les Apt France houses for rent and rent houses in St Saturnin les Apt
Houses for rent Cassis France, rental houses Cassis, and Cassis France real estate rentals
Perpignan rental houses, vacation rental in Perpignan France, Perpignan France homes for rent, and apartment rentals Perpignan France
Oupia France condos for rent and Oupia France bed and breakfast rentals
St Tropez France condos for rent, St Tropez France condos for rent, and St Tropez France vacation rental
Theoule-sur-Mer France vacation rental, short term rentals in Theoule-sur-Mer France, homes for rent, and Theoule-sur-Mer holiday rentals
Uzes France rent houses and short term rentals Uzes
Ascertain, uncover, and locate Carcassonne France homes for rent, Carcassonne France rent house, and short term rentals.
Salesmen, fortune-hunters, and soldiers who are raking for rent by owner homes in Juan les Pins and are trying to originate Juan les Pins France short term rentals and vacation rentals in Juan les Pins can smell around this webpage and our well appointed ad directories, hillside advertisements, waterfront indexes, and exotic classifieds.
Our site, FRBO.com embodys turf, principality, quarter, and parcel scoop, very often.
Learn and distinguish Narbonne France houses for rent and Narbonne vacation homes for rent by owner.
Vacation homes in Capo Vaticano Italy and condo rentals Capo Vaticano
Muster and volunteer on Monday to get going, inaugurate, enter upon, and kick off on this ramble.
Dig up, recognize, and relocate condo rentals Vitre, vacation homes, and rental properties Vitre.
Conceive, glimpse, and come across homes for rent by owner, vacation rental Toulon, and vacation homes Toulon.
Rental homes St Didier France, condo rentals in St Didier France, St Didier homes for rent, and rent houses in St Didier
Juan les Pins France is a enticing and lovely zone with pulchritudinous and wonderful duplex, apartment, timeshare, and flats.
Ascertain, originate, and originate home rentals in Gap, home rentals, and Gap vacation rental.
Distinguish, distinguish, and disclose Martigues rent house, Martigues short term rentals, and Martigues France vacation rentals.
Light upon and explore house rentals in Mulhouse France and Mulhouse France short term rentals.
The Juan les Pins listings entered and polled on our for rent by owner website have lakeside home, city apartment, loft houseboat, and exclusive condominium.
Glimpse and notice homes for rent by owner in Saint-Germain-en-Laye and rental homes in Saint-Germain-en-Laye.
Discover, elicit, and determine homes for rent Biot France, condos for rent Biot France, and Biot France houses for rent.
Design and distinguish Coex France rental houses and apartment rentals.
The Juan les Pins France exotic lists of marked properties, log ads, loft directories, and city classified ads for these can be mapped.
Discern, light upon, and find Vendome apartment rentals, homes for rent by owner in Vendome France, and apartments for rent in Vendome France.
Espy and come upon Coex France rent house and vacation rental.
Recently vacated hidden hacienda, exotic villa, beach ranch, and suburban cabin are next in the imminent stretch of Juan les Pins.
Dig up and identify Neuf-Brisach France apartments for rent and vacation rentals in Neuf-Brisach France.
|
|
