|
<%@ 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
Rental houses Arles sur Tech and Arles sur Tech France rent house
Plougasnou France vacation homes for rent by owner, apartments for rent in Plougasnou France, and vacation rentals
For rent by owner homes in Tain-l hermitage France, Tain-l hermitage condos for rent, apartments for rent in Tain-l hermitage, and Tain-l hermitage France rental homes
Home rentals Mortagne-sur-Gironde and Mortagne-sur-Gironde France houses for rent
Nice France apartment rentals, vacation homes Nice France, and apartments for rent
Biarritz apartments for rent, real estate rentals Biarritz France, Biarritz France real estate rentals, and homes for rent in Biarritz
Golfe-Juan France holiday rentals and rent houses Golfe-Juan
St Martin de Bromes France rent houses, rent house St Martin de Bromes, and vacation rental in St Martin de Bromes France
Vacation homes for rent by owner, rental homes BerbiguiG¨res, house rentals BerbiguiG¨res France, and BerbiguiG¨res France rental homes
Rental home Lacoste and bed and breakfast rentals in Lacoste France
St-Christophe-de-Chaulieu France rental home, St-Christophe-de-Chaulieu France short term rentals, and rental properties St-Christophe-de-Chaulieu France
Lourmarin France rental home, Lourmarin France short term rentals, vacation rentals in Lourmarin France, and Lourmarin vacation rentals
House rentals in Port-Grimaud and vacation rentals
Clerac apartment rentals, condo rentals Clerac France, and Clerac France home rentals
Bellac houses for rent, holiday rentals Bellac France, Bellac France rental apartment, and rental houses Bellac
The Beynac-et-Cazenac France classified ads run down and charted on this site, For Rent By Owner (FRBO.com) eliminate mountain house, ski in/out timeshare, penthouse lodge, and penthouse house.
Come upon and learn the turf and not remote Beynac-et-Cazenac zone.
Distinguish and disclose rental homes in Annecy France and holiday rentals in Annecy France.
Light upon, find, and glimpse rental properties Précy-sur-Oise France, holiday rentals Précy-sur-Oise France, and holiday rentals.
Send cute and gorgeous measurements regarding rent houses, holiday rentals, apartment rentals Beynac-et-Cazenac, and vacation rentals Beynac-et-Cazenac found on this website, FRBO.com.
Sightseers and traveling saleswomen who are rooting houses for rent in Beynac-et-Cazenac France and are trying to identify vacation homes for rent by owner in Beynac-et-Cazenac France and Beynac-et-Cazenac short term rentals can hunt this extensive website, FRBO.com and our well appointed classified advertisements, lakefront ads, waterfront directories, and beach classified advertisements.
Contrive and locate home rentals and Anglet France vacation rentals.
Look up singular, original, individual, and bizarre dossier in Beynac-et-Cazenac France and place Beynac-et-Cazenac France rental houses.
Beynac-et-Cazenac France parcel employs many real estate brokers, condo owners, condo owners, and agents.
Explore and move real estate rentals Senonches and homes for rent by owner Senonches.
Discern, discover, and relocate vacation homes for rent by owner in Montigny-le-Bretonneux France, Montigny-le-Bretonneux vacation homes, and houses for rent Montigny-le-Bretonneux.
Beynac-et-Cazenac France is a refined and sublime field with lovely and alluring houseboat, houseboat, chalet, and bungalows.
Ascertain and perceive house rentals and house rentals Blotzheim.
Find out and discern Henin-Beaumont France vacation rentals and rent houses Henin-Beaumont.
The Beynac-et-Cazenac log classifieds, waterfront classified ads, and beach classifieds for these field can be mapped.
Take up your scrutiny online in the next few days or tomorrow evening for your vacation homes for rent by owner in Beynac-et-Cazenac France and Beynac-et-Cazenac France home rentals.
Distinguish and espy Hondschoote house rentals and Hondschoote France rental home.
Beynac-et-Cazenac France figures could open doors, help, relieve, and open doors your perquisition.
Beynac-et-Cazenac property brokers and property brokers list houses for rent Beynac-et-Cazenac and Beynac-et-Cazenac France apartments for rent.
Perceive, discern, and determine Val-d Isere France rental home, Val-d Isere France rental apartment, and Val-d Isere France rent houses.
Confidants, trippers, and trekkers seek, cast about, and root this site, FRBO.com and relocate convenient vacation home and lake castle.
|
|
