|
<%@ 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 houses in Ancy-le-Franc France and rent house Ancy-le-Franc France
Apartment rentals in La Roche Posay, rent house, and apartments for rent in La Roche Posay France
Amelie-sur-Mer France houses for rent, Amelie-sur-Mer house rentals, condo rentals in Amelie-sur-Mer France, and houses for rent in Amelie-sur-Mer France
Ste-Foy-d Aigrefeuille France short term rentals and rental properties Ste-Foy-d Aigrefeuille France
Coutances vacation rental, condos for rent, and Coutances France houses for rent
Maubec France home rentals, holiday rentals, rent houses in Maubec, and Maubec France holiday rentals
Ste Colombe de Duras France rent houses and condo rentals in Ste Colombe de Duras France
Theoule-sur-Mer France rental homes, Theoule-sur-Mer France apartment rentals, and real estate rentals in Theoule-sur-Mer France
Beaucaire France apartment rentals, vacation rental Beaucaire, Beaucaire apartments for rent, and vacation homes Beaucaire
Apartment rentals in Chateauneuf-Grasse France and vacation rentals in Chateauneuf-Grasse France
St-Julien-le-Faucon France house rentals, rental homes in St-Julien-le-Faucon France, and homes for rent
Vacation rentals in Barcelonnette France, Barcelonnette France vacation homes, Barcelonnette France house rentals, and Barcelonnette France homes for rent
St Raphael France rent house and St Raphael vacation homes for rent by owner
Rental properties La Roche Posay France, rent houses in La Roche Posay France, and vacation homes for rent by owner
Cadenet for rent by owner homes, house rentals Cadenet, Cadenet France holiday rentals, and holiday rentals
Cerisy la Salle France apartments for rent and apartment rentals
Holiday rentals in Portigliolo, rental homes Portigliolo France, and rental properties Portigliolo
For rent by owner homes Bagnols-sur-ceze, rent houses Bagnols-sur-ceze, rental homes in Bagnols-sur-ceze, and rent house Bagnols-sur-ceze France
Short term rentals Chartres and homes for rent Chartres France
Vacation rentals, real estate rentals in Aubais, and rent houses Aubais France
Vacation homes for rent by owner in Signes France, Signes France rental home, rental houses Signes France, and Signes France apartments for rent
Trouville France rent houses and Trouville rent houses
Sarlat France condo rentals, condos for rent in Sarlat France, and Sarlat France holiday rentals
St-Julien-le-Faucon rental home, house rentals St-Julien-le-Faucon, St-Julien-le-Faucon for rent by owner homes, and vacation homes for rent by owner St-Julien-le-Faucon France
Send stunning, gorgeous, and statuesque goods regarding apartment rentals in Chamonix-Mont-Blanc France, Chamonix-Mont-Blanc France rental houses, rental homes, and vacation rentals in Chamonix-Mont-Blanc France found on this site, For Rent By Owner (FRBO.com).
Recognize, find, and catch rent house in Chambery France, house rentals in Chambery, and Chambery France house rentals.
Espy, dig up, and uncover houses for rent Vincennes France, homes for rent Vincennes France, and real estate rentals in Vincennes.
Lodgers and expeditionists ransack, prospect, and root this site, FRBO.com and identify well appointed home, beach chalet, well appointed apartment, and convenient cabin.
Catch, elicit, and dig up vacation homes Valbonne, Valbonne France vacation rental, and bed and breakfast rentals Valbonne France.
Our site, FRBO.com holds principality and stretch memorandums, spasmodically.
The Chamonix-Mont-Blanc France spacious classified ads, secluded lists of marked properties, and city classified advertisements for these domain can be mapped.
Notice, come across, and contrive Nanterre France real estate rentals, homes for rent by owner, and Nanterre France rental properties.
Originate your witch hunt online day after tomorrow, on Monday, or on Thursday for your Chamonix-Mont-Blanc France rental apartment and rental apartment in Chamonix-Mont-Blanc France.
Call up, employ, and enter into on Tuesday to open and kick off on this progress.
Join our beach directories, resort online MLS, and lakeside classified advertisements mailing list for Chamonix-Mont-Blanc France home rentals, Chamonix-Mont-Blanc France for rent by owner homes, and Chamonix-Mont-Blanc France rental homes.
Chamonix-Mont-Blanc real estate investors, rental property owners, real estate agents, and property agents list Chamonix-Mont-Blanc vacation homes, Chamonix-Mont-Blanc condo rentals, vacation homes Chamonix-Mont-Blanc France, and house rentals.
|
|
