|
<%@ 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
St-Martin-de-Belleville France bed and breakfast rentals and St-Martin-de-Belleville France home rentals
Apartments for rent Avignon, Avignon apartments for rent, and apartments for rent
Home rentals in Hellenvilliers, vacation homes for rent by owner Hellenvilliers France, rent houses Hellenvilliers, and vacation rentals in Hellenvilliers
Homes for rent by owner Bouriege and house rentals in Bouriege
Vacation rentals, rental properties Chantilly, and vacation rentals Chantilly France
Salernes France rental houses, home rentals in Salernes, short term rentals in Salernes France, and holiday rentals in Salernes France
Apartments for rent in St-Canadet and vacation rentals in St-Canadet
Ansouis homes for rent, rental properties in Ansouis France, and Ansouis France home rentals
Condo rentals Montouliers, rental apartment in Montouliers, rental properties, and vacation homes in Montouliers France
Vacation homes and Chanterac France vacation homes for rent by owner
Portigliolo vacation homes, Portigliolo France vacation homes for rent by owner, and vacation homes for rent by owner Portigliolo France
Home rentals in Roquebrune-Cap-Martin France, rental homes Roquebrune-Cap-Martin France, Roquebrune-Cap-Martin France houses for rent, and Roquebrune-Cap-Martin France vacation homes for rent by owner
Vacation homes and short term rentals
Pepieux France apartments for rent, Pepieux rent house, and for rent by owner homes in Pepieux
Montfort-sur-Argens real estate rentals, home rentals in Montfort-sur-Argens France, holiday rentals, and apartment rentals
Homes for rent in Mondragon France and real estate rentals in Mondragon
Vacation rentals, Violes France bed and breakfast rentals, and rental home
Ascertain and ferret out Noisy-le-Grand apartments for rent and homes for rent.
Debunk, design, and glimpse Montgeron France homes for rent by owner, Montgeron apartment rentals, and homes for rent.
Soldiers and salesmen forage, beat about, and hunt our site, FRBO.com and identify city hacienda, beach chalet, and waterfront flat.
Glimpse, distinguish, and conceive condos for rent in Blotzheim, holiday rentals Blotzheim, and condos for rent in Blotzheim France.
Ferret out, debunk, and conceive apartments for rent in Besancon France, rental home in Besancon France, and rental apartment in Besancon France.
Hellenvilliers rental owners, landlords, and land owners list Hellenvilliers France for rent by owner homes, homes for rent in Hellenvilliers, vacation rentals in Hellenvilliers France, and house rentals in Hellenvilliers.
Launch your pursuing online tomorrow evening, this weekend, or this weekend for your for rent by owner homes in Hellenvilliers and house rentals Hellenvilliers France.
Reserve and inscribe on Friday to lead off, begin, get going, and get going on this peregrination.
Using our page, agents serving the condo market insert chalet and hacienda advertisements.
Ascertain and disclose homes for rent Biarritz and home rentals in Biarritz France.
Hellenvilliers turf employs many land owners and real estate brokers.
Light upon and recognize Colombes France rental home and home rentals Colombes.
Originate and glimpse vacation rental Eguisheim France and homes for rent in Eguisheim France.
Hellenvilliers testimony could work with, aid, and cooperate your hunt.
Detect and distinguish vacation homes for rent by owner Paris France and homes for rent by owner in Paris France.
Glimpse and detect vacation rental in Cambrai and apartment rentals.
|
|
