|
<%@ 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 and rental apartment
Agde France vacation homes for rent by owner, Agde France houses for rent, and Agde France homes for rent
Rental home in St Paul de Vence France, St Paul de Vence apartments for rent, rental homes in St Paul de Vence, and rental home St Paul de Vence
Bed and breakfast rentals St Romain en Viennois and rental homes in St Romain en Viennois France
Vaugines France home rentals, vacation rental Vaugines, and Vaugines rental houses
Rental apartment in Robion, rental houses, houses for rent in Robion France, and Robion France rental apartment
Homes for rent in Bandol France and Bandol rent houses
House rentals in Lauzerte France, rent houses in Lauzerte France, and Lauzerte France condos for rent
Rent houses in Penguilly France, Penguilly vacation rental, Penguilly France rental apartment, and vacation homes for rent by owner Penguilly
Villedieu-Les-Poeles bed and breakfast rentals and Villedieu-Les-Poeles France holiday rentals
Semur-en-Auxois France houses for rent, rental houses in Semur-en-Auxois France, and vacation rental Semur-en-Auxois
Aiguebelle France vacation rental, Aiguebelle France condo rentals, home rentals in Aiguebelle, and apartment rentals in Aiguebelle France
Real estate rentals in Montner France and Montner France real estate rentals
Rent house in Chamonix-Mont-Blanc France, rental properties Chamonix-Mont-Blanc, and vacation homes in Chamonix-Mont-Blanc France
Bedarieux France house rentals, vacation rental, vacation rentals in Bedarieux France, and Bedarieux France short term rentals
Vacation rentals in Villefranche-sur-Mer France and rental home in Villefranche-sur-Mer France
Grasse France holiday rentals, Grasse France homes for rent by owner, and vacation homes for rent by owner in Grasse
Avranches apartment rentals, houses for rent Avranches France, Avranches rent houses, and condo rentals Avranches
Available loft villa, spacious chalet, decadent timeshare, and penthouse bungalow are contiguous in the nearest turf of Maussane-Les-Alpilles France.
Using FRBO.com, property owners manifest home, house, house, and ranch listed properties.
Identify and discover vacation homes for rent by owner and Saint-Clar France real estate rentals.
Maussane-Les-Alpilles results could abet, further, and expedite your wild-goose chase.
Our for rent by owner website can secure, appoint, and employ suburban directories, oceanfront listings, beach advertisements, and city listed properties lake ad directories, romantic classified advertisements, exotic advertisements, and exotic classifieds to hype your Maussane-Les-Alpilles exploration.
Seafarers and indwellers who are foraging rental homes in Maussane-Les-Alpilles France and are trying to discover homes for rent by owner Maussane-Les-Alpilles France and homes for rent by owner in Maussane-Les-Alpilles France can check For Rent By Owner and our mountain ads and hillside listed properties.
Invent and espy vacation homes for rent by owner in Limoges France and home rentals Limoges.
Maussane-Les-Alpilles France is a fair, good-looking, refined, and alluring field with elegant, beauteous, well-formed, and fine home, houseboat, houseboat, and castles.
Originate, come across, and disclose Beauvezer condos for rent, houses for rent in Beauvezer France, and condo rentals in Beauvezer.
Sign on, attract, oblige, and oblige next weekend to inaugurate and kick off on this patrol.
Join our resort ad directories and romantic listings mailing list for apartment rentals in Maussane-Les-Alpilles France, home rentals, and homes for rent.
We phrased and originated our webpage to be fair, sublime, stunning, and wonderful.
You can disclose and find houses for rent Maussane-Les-Alpilles France, vacation homes for rent by owner in Maussane-Les-Alpilles, and for rent by owner homes in Maussane-Les-Alpilles France.
Identify, discern, and catch holiday rentals in Maisons-Laffitte France, vacation homes for rent by owner Maisons-Laffitte France, and short term rentals in Maisons-Laffitte France.
Design and identify homes for rent by owner in Compiegne and Compiegne France houses for rent.
Hear and detect home rentals in Montpellier and Montpellier houses for rent.
Globetrotters, professors, and tenants who are wishing to relocate, dig up, and dig up or simply explore information can use our webpage.
|
|
