|
<%@ 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
Rent houses Callas France and vacation homes in Callas France
Millau France for rent by owner homes, Millau homes for rent by owner, and Millau France holiday rentals
St Roman de Malegarde short term rentals, St Roman de Malegarde houses for rent, rental properties St Roman de Malegarde, and St Roman de Malegarde France house rentals
Olonzac France homes for rent by owner and houses for rent in Olonzac France
Bed and breakfast rentals, Chasteaux rental home, and vacation homes in Chasteaux
Real estate rentals Eguilles France, Eguilles vacation rental, apartments for rent, and houses for rent in Eguilles France
Vacation homes for rent by owner Saint-Lo and rental houses in Saint-Lo France
Houses for rent La Hume, rental apartment in La Hume France, and rental houses in La Hume
Condos for rent Port-Grimaud France, condo rentals in Port-Grimaud France, Port-Grimaud France holiday rentals, and Port-Grimaud France house rentals
Roussillon France holiday rentals and vacation homes for rent by owner Roussillon
Bellac France holiday rentals, house rentals Bellac, and vacation homes in Bellac France
Rent house in Maury, vacation homes for rent by owner in Maury France, Maury France vacation rentals, and Maury France apartments for rent
Sarlat-la-CanGİda France rental home and rental homes Sarlat-la-CanGİda
Rental home Aniane France, homes for rent by owner, and rental houses Aniane France
Port-Grimaud France homes for rent by owner, vacation rentals in Port-Grimaud, Port-Grimaud France vacation rentals, and Port-Grimaud apartment rentals
Rental home in Aniane France and rental properties in Aniane France
Marseille France holiday rentals, Marseille real estate rentals, and Marseille France bed and breakfast rentals
Vacation homes for rent by owner in Neuilly-Sur-Seine France, short term rentals in Neuilly-Sur-Seine France, Neuilly-Sur-Seine holiday rentals, and homes for rent Neuilly-Sur-Seine France
Home rentals in St-Cannat France and rental home in St-Cannat France
Bezaudun France rental home, Bezaudun homes for rent, and homes for rent
House rentals Roussillon, for rent by owner homes in Roussillon France, rental houses Roussillon, and Roussillon France houses for rent
Vacation homes in Antibes France and homes for rent by owner in Antibes
Dwellers and locals look over and forage this site, For Rent By Owner (FRBO.com) and look up penthouse lodge, lakefront house, convenient ranch, and beachfront vacation home.
For Rent By Owner embodys zone, plot, area, and county measurements, by ordinary.
Detect, come across, and ferret out holiday rentals Cognac France, short term rentals in Cognac France, and rental houses in Cognac France.
Devise and find short term rentals in Pontivy France and house rentals Pontivy.
Light upon and catch rental properties and condo rentals Blotzheim France.
Locate and notice rental home in Senonches France and houses for rent in Senonches France.
Join our lakeside listed properties, log indexes, and city classifieds mailing list for real estate rentals Marseille, rent houses, and vacation homes Marseille France.
Marseille poop could work for, assist, and support your inquest.
Elicit, discern, and perceive Beaune France short term rentals, short term rentals in Beaune France, and short term rentals Beaune France.
Conceive and originate homes for rent by owner Bruyeres France and rental homes in Bruyeres.
You can shake down the convenient listings, lake ad directories, and rustic listings under home rentals in Marseille France, rent house in Marseille, and houses for rent in Marseille France.
Marseille France is a delightful and fascinating field with enticing and well-formed lodge, flat, and castles.
Relocate, uncover, and debunk bed and breakfast rentals, short term rentals in Neuf-Brisach, and rental homes Neuf-Brisach.
Pre-rented lake houseboat and suburban vacation home are nearest in the abutting turf of Marseille.
|
|
