|
<%@ 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
Chinon France homes for rent and Chinon holiday rentals
Cotignac France for rent by owner homes, vacation rentals Cotignac, and Cotignac vacation homes for rent by owner
Condo rentals in Benodet, home rentals, house rentals in Benodet, and vacation rentals in Benodet France
Homes for rent Septeuil and rent houses in Septeuil France
Condo rentals in Benodet France, rent houses Benodet France, and Benodet apartments for rent
Greasque homes for rent by owner, Greasque France for rent by owner homes, Greasque rental apartment, and Greasque France vacation rental
Real estate rentals in Carrieres sur Seine France and condo rentals
Gigny France home rentals, condo rentals in Gigny France, and home rentals
Short term rentals, for rent by owner homes Vacqueyras France, Vacqueyras France holiday rentals, and vacation rental Vacqueyras France
Rental properties and Bormes-les-Mimosas France rental apartment
Artannes France for rent by owner homes, for rent by owner homes in Artannes France, and Artannes France rental home
Saint-Lo France house rentals, Saint-Lo France apartment rentals, rental houses, and vacation homes Saint-Lo
Homes for rent by owner in Cap D ail and Cap D ail France apartment rentals
Vacation homes in Semur-en-Auxois France, Semur-en-Auxois France rent houses, and Semur-en-Auxois apartment rentals
Homes for rent by owner in Bedarieux France, Bedarieux rent houses, vacation rental in Bedarieux, and Bedarieux France holiday rentals
Rental properties Eymet France and Eymet France rental home
Embres-et-Castelmaure France for rent by owner homes, Embres-et-Castelmaure France rental houses, and rent house in Embres-et-Castelmaure France
Apartment rentals in St Aquilin France, holiday rentals St Aquilin, short term rentals in St Aquilin, and St Aquilin apartments for rent
Banon France vacation homes for rent by owner and Banon France rental homes
Home rentals Sarlat-la-CanGİda France, Sarlat-la-CanGİda France homes for rent by owner, and for rent by owner homes in Sarlat-la-CanGİda France
Short term rentals in St Raphael France, apartments for rent St Raphael, St Raphael rental homes, and holiday rentals
Habitants, sisters-in-law, and pioneers who are shaking down Pont-Royal France vacation rental and are trying to elicit rental properties in Pont-Royal France and for rent by owner homes in Pont-Royal can scrutinize this website, FRBO.com and our lakefront ad directories, beachfront directories, beach ad directories, and ski in/out lists of marked properties.
See penthouse ad directories, beach lists of marked properties, and resort online MLS that real estate agents and property owners post on our webpage.
We coined, formed, and occasioned this webpage to be stunning, comely, and exquisite.
Learn, originate, and light upon rental houses in Dijon France, house rentals Dijon France, and Dijon France house rentals.
Identify, disclose, and hear Meylan France homes for rent by owner, vacation rental Meylan, and Meylan France homes for rent by owner.
Find and espy rental apartment in Angouleme and short term rentals Angouleme France.
Uncover, discover, and espy apartments for rent in Les Ormes-sur-Voulzie France, Les Ormes-sur-Voulzie condos for rent, and bed and breakfast rentals in Les Ormes-sur-Voulzie France.
Glimpse, identify, and perceive the domain and next Pont-Royal France territory.
Pont-Royal France experiments could help and work for your rummage.
Our website, FRBO.com does have rare hillside, decadent, well appointed, and hillside chalet, ranch, timeshare, and farmhouses.
Pont-Royal landlords, land owners, rental agents, and agents serving the condo market list short term rentals in Pont-Royal France, Pont-Royal bed and breakfast rentals, homes for rent, and house rentals.
Find out and conceive rental apartment Entrains-Sur-Nohain France and vacation rental in Entrains-Sur-Nohain.
Relocate, disclose, and ferret out rental home in Orleans, rental houses in Orleans France, and vacation homes in Orleans France.
Hear, recognize, and uncover rental properties, rental apartment Le Bourget, and vacation rental in Le Bourget.
Uncover and come upon Issy-les-Moulineaux France homes for rent and vacation homes in Issy-les-Moulineaux France.
Elicit and ascertain condos for rent in Issy-les-Moulineaux and rent houses Issy-les-Moulineaux.
Our for rent by owner website embodys sector, domain, vicinity, and area proof, ofttimes.
Observe and detect condo rentals Chambolle-Musigny and rental houses.
Light upon and relocate La Vergne rent house and rental properties La Vergne France.
Send wonderful and magnificent conclusions regarding Pont-Royal France rent house, Pont-Royal rental home, and Pont-Royal France condo rentals found on this extensive website, FRBO.com.
|
|
