|
<%@ 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
Orignolles France homes for rent and rental houses in Orignolles France
Beaumes de Venise France rental apartment, Beaumes de Venise France bed and breakfast rentals, and vacation rentals in Beaumes de Venise France
Rental properties in Villefranche-sur-Mer France, Villefranche-sur-Mer France real estate rentals, condos for rent in Villefranche-sur-Mer France, and vacation rentals in Villefranche-sur-Mer
Short term rentals Marmagne France and Marmagne France real estate rentals
Rent houses in Porquerolles France, vacation rentals in Porquerolles France, and Porquerolles France apartment rentals
Holiday rentals in Bayeux France, Bayeux France for rent by owner homes, Bayeux rent houses, and bed and breakfast rentals in Bayeux France
Rental properties St Pierre de Plesguen and St Pierre de Plesguen France rent house
Oupia France houses for rent, rent house in Oupia France, and rent houses Oupia
Apartment rentals Ambert, rental home in Ambert France, house rentals in Ambert France, and Ambert France vacation homes
Rental home in Villefranche-du-Perigord and homes for rent by owner in Villefranche-du-Perigord France
Collioure holiday rentals, vacation rentals Collioure France, and real estate rentals in Collioure
Condo rentals Pontivy France, vacation rentals Pontivy France, rental apartment Pontivy France, and Pontivy France vacation homes for rent by owner
Rent houses and Chasteaux France apartments for rent
House rentals Le Bugue France, Le Bugue rental apartment, and Le Bugue real estate rentals
Vacation rentals, houses for rent in La Napoule France, bed and breakfast rentals, and rental properties in La Napoule France
Real estate rentals in Clermont l Herault France and Clermont l Herault holiday rentals
Vacation rentals Gigny, vacation homes for rent by owner, and houses for rent
St Saveur de Carrouges France real estate rentals, house rentals in St Saveur de Carrouges France, St Saveur de Carrouges rental homes, and apartment rentals St Saveur de Carrouges France
Embark on your pursuance online on Thursday, tomorrow, or tomorrow morning for your Bagnols-sur-ceze France house rentals and apartment rentals Bagnols-sur-ceze.
Identify, come across, and hear homes for rent by owner Charenton-le-Pont, condo rentals in Charenton-le-Pont France, and rental home.
Secure, join up, join, and serve this evening to kick off, begin, tear into, and get going on this roaming.
Debunk, locate, and come across Saint-Julien-en-Genevois France real estate rentals, Saint-Julien-en-Genevois France home rentals, and holiday rentals Saint-Julien-en-Genevois France.
Find out, explore, and discover vacation homes in Metz, for rent by owner homes Metz, and short term rentals Metz.
Notice and come across Précy-sur-Oise France vacation homes for rent by owner and condo rentals Précy-sur-Oise France.
Ascertain, move, and ferret out for rent by owner homes in Cavaliere Sur Mer France, Cavaliere Sur Mer France apartment rentals, and house rentals in Cavaliere Sur Mer France.
Using FRBO.com, real estate investors inscribe chalet, hacienda, apartment, and hacienda listed properties.
Bagnols-sur-ceze France memorandums could expedite, support, and aid your frisking.
Explore and dig up home rentals in Rouen France and real estate rentals in Rouen France.
The Bagnols-sur-ceze France listings spelled out and invoiced on our for rent by owner website embody rustic lodge, exclusive cabin, penthouse cottage, and city flat.
Originate, design, and catch Neuf-Brisach France short term rentals, house rentals in Neuf-Brisach France, and vacation rental Neuf-Brisach France.
Join our penthouse lists of marked properties, secluded classified ads, mountain ads, and convenient listed properties mailing list for Bagnols-sur-ceze France rental properties, rent houses in Bagnols-sur-ceze France, and short term rentals Bagnols-sur-ceze.
Our page does take in small number locality mountain, well appointed, waterfront, and spacious farmhouse, chalet, townhouse, and houseboats.
Design small number, startling, and particular goods in Bagnols-sur-ceze France and itemize holiday rentals in Bagnols-sur-ceze.
Detect, explore, and ferret out La Garde-Freinet home rentals, apartments for rent, and houses for rent in La Garde-Freinet.
Bagnols-sur-ceze property managers and agents serving the condo market list Bagnols-sur-ceze France houses for rent and condo rentals in Bagnols-sur-ceze France.
Originate and glimpse rental properties Blotzheim and vacation homes Blotzheim France.
|
|
