|
<%@ 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 properties in Septeuil France and apartments for rent in Septeuil
Vacation homes for rent by owner in Versols-et-lapeyre France, house rentals, and Versols-et-lapeyre France holiday rentals
Honfleur France apartment rentals, Honfleur rent house, rental houses Honfleur, and rental houses
Vacation rental and rental houses
Rental home Carhaix-Plouguer, vacation rentals in Carhaix-Plouguer, and Carhaix-Plouguer rental home
Rental apartment in Vence France, rent houses Vence, Vence homes for rent, and Vence France rental properties
St Raphael France condos for rent and rent houses in St Raphael
Holiday rentals in Melun, Melun France rental apartment, and Melun short term rentals
Mirabeau France apartments for rent, Mirabeau vacation homes, bed and breakfast rentals Mirabeau, and Mirabeau France house rentals
Vacation rental in Cerisy la Salle and bed and breakfast rentals
Rent house Hyeres France, holiday rentals Hyeres, and vacation homes for rent by owner in Hyeres
Vacation rental in Cazouls-les-Beziers France, apartment rentals Cazouls-les-Beziers, Cazouls-les-Beziers France homes for rent, and apartment rentals
Relocate and move rental houses in Montmorency and houses for rent in Montmorency France.
Come upon and ascertain rental homes in Arles France and Arles France rental home.
Move, come upon, and discern apartment rentals Viry Noureuil, Viry Noureuil rent house, and Viry Noureuil France rent houses.
Les Arcs Sur Argens block employs many third party listing companies and real estate brokers.
Join our exclusive ad directories, loft online MLS, suburban classified ads, and hillside lists of marked properties mailing list for condo rentals Les Arcs Sur Argens, apartment rentals in Les Arcs Sur Argens France, and condos for rent in Les Arcs Sur Argens.
Using our page, town home owners run down home, cabin, duplex, and ranch classified advertisements.
Identify, uncover, and identify vacation homes for rent by owner in Le Toquet France, rental homes in Le Toquet France, and Le Toquet France rental homes.
See lakefront listed properties, romantic indexes, loft ads, and exclusive listed properties that rental agents and home owners post on FRBO.Com, For Rent By Owner,.
Dig up and glimpse for rent by owner homes Barbizon France and condos for rent in Barbizon.
Subordinates and subordinates who are wishing to move and glimpse or simply catch information can use our page.
Take up your fishing expedition online in the morning, this week, tomorrow evening, or tonight for your house rentals in Les Arcs Sur Argens France and rental properties in Les Arcs Sur Argens.
You can move and invent short term rentals in Les Arcs Sur Argens France and apartments for rent Les Arcs Sur Argens France.
|
|
