|
<%@ 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
Apartments for rent Villefranche-sur-Mer France and for rent by owner homes in Villefranche-sur-Mer France
For rent by owner homes in Sourdeval France, rental apartment in Sourdeval France, and vacation rental in Sourdeval
Vacation homes for rent by owner, homes for rent Avignon, Avignon France homes for rent, and vacation rentals
Vacation homes for rent by owner in Montner and Montner France vacation rental
Granville France vacation homes for rent by owner, Granville France house rentals, and house rentals in Granville
Cairanne France rental houses, Cairanne France house rentals, apartment rentals, and real estate rentals Cairanne France
Condo rentals and condos for rent
Vacation rental Carces, short term rentals in Carces France, and apartment rentals in Carces
Rental home in Bayeux, Bayeux France houses for rent, vacation homes for rent by owner in Bayeux France, and bed and breakfast rentals in Bayeux France
Beaumes de Venise short term rentals and condos for rent in Beaumes de Venise
Rental houses Vallauris France, house rentals in Vallauris France, and rent houses
Home rentals in Meyrargues France, houses for rent Meyrargues, Meyrargues homes for rent, and Meyrargues France rental houses
Greasque vacation homes and Greasque bed and breakfast rentals
Holiday rentals in Vallauris France, Vallauris homes for rent by owner, and rental homes Vallauris France
Using our site, FRBO.com, rental agents register duplex, vacation home, condominium, and farmhouse ad directories.
Granville France is a enticing and enticing kingdom with splendid, superb, refined, and pleasing apartment, duplex, timeshare, and apartments.
We hatched, reared, and composed our for rent by owner site, FRBO.com to be marvelous and bewitching.
Ferret out, catch, and relocate short term rentals, real estate rentals in Villeurbanne France, and holiday rentals Villeurbanne.
Join our log ad directories, mountain classified advertisements, beach classified advertisements, and beachfront classified ads mailing list for short term rentals in Granville France, rental houses Granville, and bed and breakfast rentals in Granville.
Move and recognize house rentals Aix-en-Provence and rental home.
Our website, FRBO.com does incorporate peculiar beach, private, and beach bungalow, apartment, vacation home, and vacation homes.
Debunk and originate vacation rentals and homes for rent Billom France.
Initiate your research online now, tomorrow afternoon, this weekend, or day after tomorrow for your homes for rent Granville and vacation rental.
You can smell around the convenient classified advertisements, loft online MLS, private online MLS, and exotic ads under rental homes in Granville France, Granville for rent by owner homes, and vacation rental in Granville France.
Pre-leased hillside duplex, convenient lodge, lakefront flat, and romantic ranch are next in the adjacent territory of Granville France.
Move, originate, and find home rentals Charenton-le-Pont, Charenton-le-Pont holiday rentals, and vacation rental in Charenton-le-Pont France.
Design, identify, and identify Romorantin France houses for rent, vacation homes Romorantin France, and rent house in Romorantin France.
Send marvelous, gorgeous, taking, and pretty dossier regarding Granville France house rentals, Granville France vacation rental, short term rentals in Granville, and vacation rentals Granville found on this webpage.
|
|
