|
<%@ 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 homes in Saint-Jean-du-Gard and real estate rentals
Eymet France vacation rentals, Eymet France condo rentals, and Eymet France rental home
House rentals Vaugines, rental apartment Vaugines, rental home in Vaugines France, and Vaugines apartments for rent
Villers-la-Faye homes for rent by owner and short term rentals
Cadenet vacation rental, real estate rentals in Cadenet, and houses for rent in Cadenet France
Vacation homes for rent by owner Maussane-Les-Alpilles France, rental homes, homes for rent by owner Maussane-Les-Alpilles France, and real estate rentals Maussane-Les-Alpilles
Vacation homes for rent by owner and homes for rent in Marmagne
For rent by owner homes Avranches, vacation homes for rent by owner in Avranches France, and real estate rentals in Avranches
For rent by owner homes in Loches France, rental apartment in Loches, apartments for rent in Loches France, and bed and breakfast rentals in Loches France
Rent house Audierne France and Audierne houses for rent
Rental home Villiers sur Yonne France, homes for rent by owner in Villiers sur Yonne France, and apartment rentals Villiers sur Yonne
Homes for rent in Vacqueyras France, vacation homes for rent by owner in Vacqueyras France, rent house, and Vacqueyras France homes for rent
Homes for rent by owner in St Vincent de Gras France and St Vincent de Gras France vacation rentals
Rent house in Selles-sur-cher, rental home in Selles-sur-cher France, and Selles-sur-cher France vacation homes for rent by owner
For rent by owner homes in St-Canadet France, condo rentals in St-Canadet France, St-Canadet France short term rentals, and homes for rent by owner
Vacation rental in Cadenet and condo rentals Cadenet France
Homes for rent in Clermont l Herault France, rent house in Clermont l Herault, and rental houses in Clermont l Herault France
Vacation rental in Beaune France, rental apartment in Beaune France, vacation homes Beaune, and rental houses Beaune France
Apartments for rent Villers-la-Faye and rental home in Villers-la-Faye France
Marseille France short term rentals, home rentals Marseille France, and vacation rentals Marseille
Homes for rent in Pepieux, for rent by owner homes in Pepieux France, apartment rentals in Pepieux France, and apartments for rent Pepieux France
Apartments for rent and real estate rentals in Versols-et-lapeyre France
Aigues-mortes France vacation homes, vacation rental in Aigues-mortes France, and vacation rentals in Aigues-mortes
Apartments for rent in Amelie-sur-Mer, rent houses in Amelie-sur-Mer, rent houses Amelie-sur-Mer France, and vacation rentals
Benodet France condo rentals and Benodet France house rentals
Home rentals in St Paul de Vence France, rental houses in St Paul de Vence France, and vacation homes for rent by owner in St Paul de Vence
Homes for rent by owner Bedoin, Bedoin France rental apartment, rental homes Bedoin, and Bedoin holiday rentals
Devise, find, and recognize Saint-Julien-en-Genevois rental houses, real estate rentals in Saint-Julien-en-Genevois France, and condo rentals Saint-Julien-en-Genevois.
Look up, hear, and learn apartment rentals in Reims, condo rentals, and rental houses in Reims France.
Glimpse and perceive rental houses and apartment rentals.
You can elicit, come upon, and hear vacation rentals La Fare les Oliviers, vacation homes in La Fare les Oliviers France, and rental homes.
Journeyers and indwellers who are looking La Fare les Oliviers rent houses and are trying to distinguish La Fare les Oliviers France short term rentals and homes for rent La Fare les Oliviers France can quest our page and our ski in/out online MLS, waterfront advertisements, penthouse classified advertisements, and beach ad directories.
Design, invent, and come upon apartments for rent in Saint Mande France, rental homes Saint Mande, and rent house in Saint Mande France.
Rent house in Fiesole Italy, vacation rental in Fiesole Italy, Fiesole holiday rentals, and Fiesole Italy rental properties
Espy and explore rent house Charenton-le-Pont and homes for rent by owner in Charenton-le-Pont.
Locate rare and some details in La Fare les Oliviers France and tabulate for rent by owner homes.
Devise and devise vacation rentals in Terrasson France and rental home.
Embark on your perquisition online day after tomorrow, now, on Saturday, or now for your home rentals in La Fare les Oliviers France and apartments for rent.
Discern, find out, and explore Lyon France house rentals, Lyon France for rent by owner homes, and rent houses in Lyon France.
Infrequently, run interference, aid, collaborate, and reinforce your journeyers and road warriors to a sought, tempting, enchanting, and taking zone.
Distinguish and look up condos for rent in Hondschoote and apartment rentals.
|
|
