|
<%@ 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 home in Pezenas France and Pezenas France short term rentals
Arles holiday rentals, homes for rent in Arles, and Arles France bed and breakfast rentals
For rent by owner homes in Montouliers, vacation rental, Montouliers France house rentals, and home rentals in Montouliers France
Home rentals and rental properties in Cannes
Homes for rent by owner in Langeais France, rent houses Langeais France, and home rentals
Condo rentals Cordes-sur-Ciel, Cordes-sur-Ciel France rent house, vacation rental in Cordes-sur-Ciel, and rental homes in Cordes-sur-Ciel France
Vacation rentals Beziers France and rent house in Beziers
Soreze France vacation rentals, vacation rental, and rent houses
Cavaillon France real estate rentals, Cavaillon France rent houses, real estate rentals Cavaillon, and Cavaillon France bed and breakfast rentals
Juan les Pins France vacation homes and vacation rentals
Vacation homes for rent by owner in Loches, rental properties in Loches France, and rental home in Loches
Rental houses, Aigues-mortes France rental houses, Aigues-mortes France vacation homes for rent by owner, and condos for rent
Vacation rental Mirambeau and Mirambeau France holiday rentals
St Romain en Viennois France apartment rentals, rental properties St Romain en Viennois France, and homes for rent by owner
Vacation homes in Antibes France, Antibes homes for rent by owner, apartments for rent in Antibes France, and vacation homes in Antibes France
Vacation homes for rent by owner Villefranche-du-Perigord and homes for rent by owner
Peers, friends, and entrepreneurs rake and ransack our webpage and come upon resort farmhouse and decadent bungalow.
Our website, FRBO.com does seat uncommon domain lakeside, beach, well appointed, and hillside flat, hacienda, cabin, and vacation homes.
Observe and perceive condo rentals in Eguisheim France and for rent by owner homes Eguisheim France.
Recognize, espy, and dig up Frejus France vacation rentals, homes for rent by owner Frejus, and rent house Frejus.
See exotic listed properties, studio listed properties, exotic lists of marked properties, and loft online MLS that real estate investors and rental owners post on our online website, FRBO.com.
Successively, bail out, run interference, and support your opportunists and residers to a winning, awash, and enthralling locality.
Croissy-sur-Seine poop sheet could benefit and serve your witch hunt.
You can frisk the beach classifieds and spacious listed properties under vacation rentals in Croissy-sur-Seine France and real estate rentals in Croissy-sur-Seine France.
Get going your witch hunt online on Tuesday or in the morning for your vacation rentals in Croissy-sur-Seine, vacation rental in Croissy-sur-Seine, and vacation homes Croissy-sur-Seine.
Espy and perceive Le Cannet houses for rent and holiday rentals in Le Cannet France.
The Croissy-sur-Seine France exclusive online MLS and well appointed indexes for these can be mapped.
Croissy-sur-Seine brokers leasing foreclosures, real estate agents, real estate investors, and agents serving the condo market list house rentals and Croissy-sur-Seine real estate rentals.
Hitch, induct, and attract tomorrow afternoon to take up and launch on this survey.
Croissy-sur-Seine France is a charming and comely square with well-formed and well-formed farmhouse and haciendas.
|
|
