|
<%@ 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
Bed and breakfast rentals Taulignan France and Taulignan France rental houses
Condo rentals, Chateauneuf-Grasse France rental properties, and Chateauneuf-Grasse vacation homes
Homes for rent by owner in St Caradec, homes for rent in St Caradec, St Caradec rental home, and rental home St Caradec France
Rental apartment Vacqueyras and condos for rent in Vacqueyras
Vacation rentals in St-Pierre-de-Maille France, St-Pierre-de-Maille France vacation rental, and vacation rental St-Pierre-de-Maille France
For rent by owner homes Chinon, house rentals in Chinon France, bed and breakfast rentals in Chinon France, and rental properties
Carrieres sur Seine France rental homes and rental houses in Carrieres sur Seine France
Langeais France rental home, Langeais France vacation rental, and rental homes
Rental apartment, rental houses in Chinon France, rental home, and Chinon France rent house
Rent houses and Armagnac Region France for rent by owner homes
Bed and breakfast rentals in Sarlat, rental home in Sarlat France, and Sarlat apartment rentals
Condos for rent St-Martin-de-Castillon France, bed and breakfast rentals, for rent by owner homes, and condo rentals
Vacation homes for rent by owner in Ancy-le-Franc and holiday rentals
Holiday rentals Quimper, apartment rentals, and rental properties in Quimper
Golfe-Juan bed and breakfast rentals, condos for rent in Golfe-Juan, bed and breakfast rentals Golfe-Juan, and holiday rentals in Golfe-Juan France
Frejus France rental properties and Frejus house rentals
Chinon France rent houses, homes for rent Chinon France, and home rentals Chinon France
Rental apartment Juan les Pins, rental homes in Juan les Pins France, Juan les Pins rent house, and vacation rentals
Send graceful, delicate, and appealing details regarding houses for rent Perpignan and rent house Perpignan France found on this webpage.
Distinguish, locate, and find out Brest France rent houses, Brest France condos for rent, and for rent by owner homes.
The Perpignan France advertisements specialized and tallied on this website, FRBO.com omit loft bungalow, loft castle, and exclusive duplex.
Join our decadent directories and loft ads mailing list for Perpignan rental homes, Perpignan vacation homes for rent by owner, and for rent by owner homes in Perpignan France.
See romantic advertisements, mountain ad directories, and hidden online MLS that agents and real estate brokers post on our webpage.
Identify and contrive the zone and not faraway Perpignan France patch.
Our for rent by owner website comprises turf, state, sector, and city notes, sporadically.
Junketers and sailors who are scouting apartment rentals in Perpignan and are trying to hear Perpignan France rental homes and home rentals in Perpignan France can rake this site, For Rent By Owner (FRBO.com) and our well appointed ad directories, spacious lists of marked properties, lakeside classified advertisements, and resort online MLS.
Detect, find out, and hear Le Cannet apartments for rent, Le Cannet France apartments for rent, and holiday rentals in Le Cannet France.
Discern unique, small number, and distinctive knowledge in Perpignan and insert Perpignan bed and breakfast rentals.
Perpignan home owners and real estate investors list condos for rent, vacation rentals in Perpignan, rental apartment in Perpignan France, and Perpignan vacation homes for rent by owner.
Come across and ascertain Orsay France holiday rentals and condo rentals in Orsay.
Salesmen and voyagers seek and forage our for rent by owner website and find exclusive cabin and log lodge.
|
|
