|
<%@ 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
Granville France vacation rental and real estate rentals
Rental home in Villers-la-Faye France, rent houses Villers-la-Faye, and houses for rent in Villers-la-Faye France
Vaugines France vacation rental, Vaugines rental home, Vaugines vacation homes for rent by owner, and rental apartment Vaugines France
Vacation homes in Sarlat-la-CanGİda France and Sarlat-la-CanGİda France apartments for rent
Real estate rentals in Chateauneuf-Grasse France, rental apartment in Chateauneuf-Grasse, and vacation rental in Chateauneuf-Grasse France
Rental homes in Tornac, Tornac vacation rentals, rent houses in Tornac France, and Tornac France homes for rent
Bergerac France vacation homes and Bergerac real estate rentals
Mortain real estate rentals, rental homes, and house rentals in Mortain France
Apartment rentals Carcassonne, homes for rent in Carcassonne, Carcassonne France rental properties, and Carcassonne holiday rentals
Rental properties in Aigues-mortes France and for rent by owner homes
Villiers sur Yonne rent houses, rental home Villiers sur Yonne France, and Villiers sur Yonne rental apartment
Vacation rental in Villers-la-Faye France, rental houses in Villers-la-Faye France, vacation rental, and Villers-la-Faye rental houses
Biarritz vacation rentals and for rent by owner homes in Biarritz France
Sablet France real estate rentals, vacation homes in Sablet France, and apartment rentals in Sablet
Richelieu France rental apartment, rental houses Richelieu France, Richelieu apartments for rent, and Richelieu France homes for rent
Apartments for rent in Barbizon France and Barbizon France real estate rentals
Biarritz France vacation rental, apartments for rent in Biarritz, and Biarritz France vacation homes for rent by owner
Rental homes in Pons France, rental houses in Pons, homes for rent in Pons France, and homes for rent
Rent houses Maussane-Les-Alpilles France and rent house Maussane-Les-Alpilles France
Condos for rent, vacation homes for rent by owner, and Robion rental houses
Vacation rentals, for rent by owner homes Cadenet, vacation rental Cadenet, and Cadenet France apartments for rent
Laudun France holiday rentals and bed and breakfast rentals
Short term rentals, Chitenay France vacation rentals, and for rent by owner homes Chitenay
Holiday rentals Auzits France, vacation rentals in Auzits France, Auzits holiday rentals, and rental home in Auzits France
Barbizon France condos for rent and rent house
Rental home in Oupia France, apartments for rent in Oupia, and bed and breakfast rentals Oupia
For rent by owner homes in Tourrettes-sur-Loup France, apartment rentals in Tourrettes-sur-Loup France, house rentals Tourrettes-sur-Loup France, and vacation homes in Tourrettes-sur-Loup
For rent by owner homes in Gargas France and Gargas rental properties
Real estate rentals in Neuvic France, rental properties, and bed and breakfast rentals in Neuvic France
Riquewihr condo rentals, bed and breakfast rentals Riquewihr, vacation homes for rent by owner Riquewihr France, and vacation homes for rent by owner in Riquewihr
Pontivy France home rentals and houses for rent
Vacation homes for rent by owner in St Vincent de Gras France, home rentals in St Vincent de Gras, and condos for rent St Vincent de Gras France
Condos for rent in Nyons France and apartments for rent
Notice and relocate Saint Mande condo rentals and home rentals in Saint Mande.
Discern and find holiday rentals Val-d Isere France and vacation rentals Val-d Isere France.
Look up and devise homes for rent by owner Beziers and rent house in Beziers France.
Contrive, contrive, and explore vacation rental in Le Bourget France, short term rentals, and vacation homes Le Bourget France.
Our page does incorporate especial beach, mountain, lakeside, and well appointed chalet, hacienda, home, and duplexs.
Find out, learn, and observe rent house in Le Mans France, homes for rent by owner Le Mans, and Le Mans France apartments for rent.
Look up, uncover, and originate Neuf-Brisach France home rentals, holiday rentals in Neuf-Brisach, and homes for rent by owner Neuf-Brisach.
Suburbanites, salesmen, and indwellers beat about, investigate, and examine this site, For Rent By Owner (FRBO.com) and relocate suburban cabin, beachfront hacienda, and beach duplex.
Gigny domain employs many property owners, rental agents, property owners, and property agents.
Distinguish and ascertain rental apartment Luray and houses for rent Luray France.
Usually, expedite and benefit your citizens and adventurers to a in favor, preferred, charming, and fetching sector.
The Gigny France hidden classified ads, lakeside listings, and convenient online MLS for these locality can be mapped.
Detect, come across, and come upon house rentals, rental apartment in La Vergne France, and La Vergne France houses for rent.
Relocate, conceive, and debunk for rent by owner homes Le Vesinet, Le Vesinet France vacation rentals, and Le Vesinet vacation homes for rent by owner.
Move and determine homes for rent in Val-d Isere France and vacation rental in Val-d Isere.
We designed, contrived, and formulated our for rent by owner website to be dazzling, dazzling, and divine.
Condos for rent Lavagna Italy, vacation rental in Lavagna Italy, holiday rentals in Lavagna Italy, and Lavagna Italy for rent by owner homes
Rental apartment San Giovanni d Asso Italy and houses for rent San Giovanni d Asso
Observe, hear, and observe the square and nearby Gigny France zone.
Catch, identify, and perceive homes for rent in Colmar, Colmar homes for rent by owner, and Colmar France vacation rentals.
Elicit and uncover rental apartment and houses for rent in Strasbourg France.
Light upon and explore holiday rentals Perpignan France and condos for rent.
Rental homes in Quimper, bed and breakfast rentals in Quimper France, and homes for rent Quimper
Find out, debunk, and espy houses for rent in Châlons France, Châlons rent houses, and Châlons condo rentals.
Relocate, elicit, and determine apartment rentals in Saint Mande, for rent by owner homes Saint Mande, and home rentals in Saint Mande France.
Find another story, distinct, and bizarre abstracts in Gigny and bill Gigny France vacation rentals.
Homes for rent in Wengen Switzerland, home rentals, and home rentals in Wengen Switzerland
|
|
