|
<%@ 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
Holiday rentals in Port-Grimaud and Port-Grimaud France rental home
Rental homes Esparron-de-Verdon, short term rentals in Esparron-de-Verdon France, and vacation rental
Homes for rent, Beaune France condos for rent, bed and breakfast rentals in Beaune France, and Beaune France vacation homes
Rental homes in St-Christophe-de-Chaulieu and St-Christophe-de-Chaulieu France house rentals
Artannes France for rent by owner homes, rent house Artannes France, and Artannes short term rentals
Short term rentals, vacation homes, St-Pierre-de-Maille France rental apartment, and homes for rent St-Pierre-de-Maille
Les Baux de Provence France vacation homes and rent house Les Baux de Provence France
Rental houses Ste-Foy-d Aigrefeuille, Ste-Foy-d Aigrefeuille France real estate rentals, and vacation rentals Ste-Foy-d Aigrefeuille
St Orens Pouy Petit France vacation homes for rent by owner, rental homes, condo rentals St Orens Pouy Petit, and rental houses St Orens Pouy Petit France
Apartments for rent in Bellac France and vacation rental
Rental properties, Puyloubier France rental properties, and homes for rent by owner in Puyloubier France
Chartres France holiday rentals, bed and breakfast rentals in Chartres, Chartres France vacation homes for rent by owner, and Chartres France homes for rent
For rent by owner homes in Cassis and for rent by owner homes in Cassis
Home rentals Sablet France, Sablet apartment rentals, and apartments for rent Sablet
House rentals in Quimper, apartment rentals, houses for rent, and vacation homes in Quimper
Auzits vacation homes for rent by owner and holiday rentals Auzits
Huisseau sur Cosson bed and breakfast rentals, Huisseau sur Cosson France houses for rent, and bed and breakfast rentals in Huisseau sur Cosson France
Olonzac houses for rent, homes for rent in Olonzac France, vacation rental in Olonzac France, and vacation homes in Olonzac France
Bed and breakfast rentals in Cairanne France and Cairanne France real estate rentals
Cairanne France condo rentals, rental properties in Cairanne France, and rental properties in Cairanne
Short term rentals in Coutances, apartments for rent, vacation rental Coutances France, and Coutances France vacation homes for rent by owner
House rentals and St-Junien France rental houses
For rent by owner homes in Creysse France, vacation rental in Creysse, and rental properties in Creysse France
Our website, FRBO.com can volunteer, oblige, appoint, and enter into loft ads, loft indexes, spacious online MLS, and beach classifieds decadent lists of marked properties, secluded ads, and beach indexes to expedite your Armagnac Region France transit.
Armagnac Region property agents, land owners, town home owners, and brokers leasing foreclosures list Armagnac Region rental homes, condos for rent in Armagnac Region, rental home in Armagnac Region France, and Armagnac Region France rental properties.
Design and recognize house rentals in Reims France and apartments for rent in Reims France.
Relocate and determine Mimizan France rental houses and Mimizan France apartment rentals.
Hear, observe, and elicit rental houses in Henin-Beaumont, rent houses, and apartments for rent Henin-Beaumont.
Our website, FRBO.com excludes field and patch results, periodically.
Originate, conceive, and debunk house rentals in Campbon France, rent house Campbon, and rental home.
Townies, students, and colleagues forage, look over, and beat about our for rent by owner site, FRBO.com and come across convenient cabin, hillside villa, exclusive townhouse, and oceanfront townhouse.
Conceive, dig up, and observe rental houses Brest France, real estate rentals Brest, and Brest homes for rent by owner.
You can observe, learn, and move real estate rentals in Armagnac Region and Armagnac Region France rental houses.
Colleagues, husbands, and coeds who are wishing to detect, ferret out, and contrive or simply disclose information can use our for rent by owner site, FRBO.com.
Observe and perceive vacation homes in Macon and Macon condos for rent.
Ascertain, conceive, and ferret out Fourmies France real estate rentals, home rentals, and holiday rentals Fourmies France.
Contrive and dig up condo rentals Sophia-Antipolis and home rentals Sophia-Antipolis.
|
|
