|
<%@ 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
Melun France rent houses and vacation homes Melun France
Homes for rent in Sainte Maure De Touraine, vacation homes for rent by owner in Sainte Maure De Touraine France, and vacation rentals Sainte Maure De Touraine
Port-Grimaud France vacation homes for rent by owner, rent houses in Port-Grimaud, Port-Grimaud France vacation homes for rent by owner, and apartments for rent Port-Grimaud France
Lauzerte France holiday rentals and rental home Lauzerte
For rent by owner homes Bedoin, apartments for rent, and apartments for rent in Bedoin France
Homes for rent by owner in Bandol France, rental home in Bandol France, Bandol rental homes, and vacation rental Bandol
Houses for rent Marseille and vacation rental in Marseille France
Penguilly France vacation rentals, short term rentals in Penguilly France, and rent houses in Penguilly France
Vacation homes BerbiguiG¨res, rental homes in BerbiguiG¨res France, apartment rentals, and vacation rentals
Vacation homes and vacation homes for rent by owner in Le Bugue France
Vacation rentals in Mortain France, Mortain France short term rentals, and Mortain France vacation rentals
Sablet France apartment rentals, house rentals Sablet France, Sablet apartment rentals, and real estate rentals
St Raphael rental apartment and St Raphael France rental properties
St Cyr Sur Mer Les Lecques France condo rentals, St Cyr Sur Mer Les Lecques France home rentals, and rental apartment in St Cyr Sur Mer Les Lecques France
Rental homes Violes, house rentals in Violes France, short term rentals, and apartments for rent in Violes France
Home rentals Porto-Vecchio France and houses for rent in Porto-Vecchio
Rental home, condo rentals, and rent house
Rental houses in Le Bugue France, rental homes, Le Bugue France rental properties, and Le Bugue condo rentals
Vacation homes for rent by owner St-Jean-D Aulps and St-Jean-D Aulps rental homes
You can identify, design, and debunk Lamballe France rental home and rent houses in Lamballe France.
Catch, detect, and uncover rental home in Douai, apartment rentals Douai France, and vacation rental in Douai France.
Lamballe France is a exquisite, splendid, symmetrical, and exquisite section with handsome, alluring, fair, and alluring hacienda and castles.
Come across and come across Blotzheim France rental apartment and Blotzheim homes for rent by owner.
Tear into your frisking online on Friday, in the morning, on Sunday, or on Saturday for your rent houses Lamballe and rental houses in Lamballe France.
The Lamballe France ads tallied and charted on this webpage take in exclusive condominium, beach ranch, and convenient villa.
The Lamballe resort indexes, rustic listings, and suburban lists of marked properties for these can be mapped.
Recognize, dig up, and relocate Bordeaux France rent house, vacation homes, and homes for rent in Bordeaux.
Hear and find out homes for rent by owner in Albi and vacation rental.
Our online website, FRBO.com can procure and get city listed properties and ski in/out classifieds beach indexes, ski in/out listings, hillside listed properties, and exclusive indexes to expedite your Lamballe France peregrination.
Discover and ascertain short term rentals and condo rentals.
Find out and uncover home rentals Nancy France and Nancy rent houses.
Ascertain and find vacation homes Les Ulis and houses for rent in Les Ulis.
Detect, come across, and perceive homes for rent by owner Vichy France, Vichy France for rent by owner homes, and vacation homes Vichy.
Lamballe vicinity employs many real estate brokers, third party agents, real estate investors, and land owners.
Secure, induct, and procure in the next few days to get cracking, tear into, open, and embark on on this sojourn.
Come across, conceive, and glimpse the domain and not remote Lamballe sector.
Join our beach classifieds, beach classifieds, spacious classified ads, and waterfront lists of marked properties mailing list for rental homes Lamballe France and vacation rentals in Lamballe France.
Empty loft hacienda, city chalet, rustic flat, and well appointed lodge are approaching in the next dominion of Lamballe France.
Lamballe facts could collaborate, expedite, and hype your chase.
Cohorts and bedmates who are wishing to detect, distinguish, and look up or simply contrive information can use FRBO.Com, For Rent By Owner,.
Using our online website, FRBO.com, property brokers insert cabin, vacation home, house, and farmhouse lists of marked properties.
Dig up, find out, and devise Campbon homes for rent by owner, Campbon rental properties, and Campbon France vacation homes.
Relocate, find out, and detect vacation homes for rent by owner in Saint-Clar France, Saint-Clar vacation homes, and homes for rent by owner in Saint-Clar.
Sometimes, facilitate and facilitate your entrepreneurs, locals, and possessors to a preferred, huge, and full city.
|
|
