|
<%@ 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 Tourrettes-sur-Loup and Tourrettes-sur-Loup house rentals
Villecroze bed and breakfast rentals, Villecroze France houses for rent, and Villecroze France rent houses
Fayence vacation rentals, condo rentals Fayence France, condo rentals, and apartment rentals Fayence France
For rent by owner homes and Septeuil France for rent by owner homes
Gordes France real estate rentals, Gordes France for rent by owner homes, and home rentals in Gordes
Versols-et-lapeyre France rental properties, rental houses in Versols-et-lapeyre France, houses for rent in Versols-et-lapeyre France, and for rent by owner homes in Versols-et-lapeyre France
Vacation homes Velleron and apartment rentals
Carhaix-Plouguer France rent houses, home rentals in Carhaix-Plouguer France, and rent houses Carhaix-Plouguer France
L Isle-sur-la-Sorgue France home rentals, L Isle-sur-la-Sorgue France holiday rentals, rental properties in L Isle-sur-la-Sorgue, and vacation homes L Isle-sur-la-Sorgue
Primelin France homes for rent by owner and Primelin homes for rent by owner
Houses for rent in Saignon France, for rent by owner homes in Saignon France, and rental apartment Saignon France
Rent houses in Montclus France, rent house in Montclus France, rent houses in Montclus France, and Montclus France short term rentals
Saint-Jean-du-Gard vacation rentals and Saint-Jean-du-Gard France home rentals
Eymet France apartment rentals, vacation homes for rent by owner, and Eymet France apartments for rent
Condo rentals Dieulefit France, vacation rentals in Dieulefit France, vacation homes, and apartments for rent in Dieulefit France
Short term rentals in St-Jean-D Aulps France and St-Jean-D Aulps condo rentals
Determine and come upon rental apartment in Chavaniac and rental apartment in Chavaniac France.
Salesmen, natives, and junketers who are seeking Amboise France apartment rentals and are trying to originate rental properties and vacation homes can go through FRBO.Com, For Rent By Owner, and our lakeside indexes, studio classifieds, romantic advertisements, and decadent ads.
Recognize, espy, and ascertain Biot France houses for rent, Biot France holiday rentals, and rental homes Biot.
Distinguish and observe Strasbourg France bed and breakfast rentals and Strasbourg vacation homes.
Determine and identify short term rentals Paris France and condos for rent.
Amboise abstracts could plug and run interference your witch hunt.
Identify, detect, and originate house rentals Saint-Etienne, houses for rent, and vacation rental.
Hear and hear rental apartment and rental homes in Elancourt France.
FRBO.Com, For Rent By Owner, can levy, obtain, and initiate mountain classified ads, rustic lists of marked properties, studio lists of marked properties, and lakeside classified ads lake classified advertisements, waterfront online MLS, waterfront listings, and well appointed lists of marked properties to reinforce your Amboise exploration.
Amboise France is a stunning, pleasing, and graceful locality with dazzling and fine hacienda and bungalows.
Discern novel and startling facts in Amboise France and manifest houses for rent in Amboise France.
Light upon, conceive, and observe Gap France homes for rent by owner, Gap France apartments for rent, and apartment rentals in Gap.
You can learn and devise rental apartment Amboise, vacation homes for rent by owner, and Amboise vacation homes.
|
|
