|
<%@ 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
Homes for rent in St Caradec France and real estate rentals St Caradec
Vacation rentals Ocquerre, houses for rent Ocquerre France, and rental houses in Ocquerre
Grambois apartments for rent, bed and breakfast rentals in Grambois France, Grambois France homes for rent, and Grambois France vacation homes for rent by owner
Bed and breakfast rentals in Manduel France and condo rentals Manduel
Bed and breakfast rentals, vacation homes for rent by owner in Plougasnou France, and rent houses Plougasnou France
Chinon holiday rentals, vacation homes in Chinon, rental apartment in Chinon France, and short term rentals
Condo rentals Sourdeval and vacation homes for rent by owner in Sourdeval France
Rent houses Chinon, Chinon France rent house, and vacation homes in Chinon France
Carces house rentals, condos for rent, Carces houses for rent, and Carces France rental houses
Carcassonne France rental homes and Carcassonne France rental homes
Condos for rent, for rent by owner homes Erce, and home rentals in Erce France
Apartments for rent, holiday rentals in Mirabeau France, vacation homes for rent by owner in Mirabeau, and Mirabeau France short term rentals
Signes for rent by owner homes and vacation rental in Signes
Rental home, Hyeres France condos for rent, and Hyeres France vacation homes for rent by owner
Nimes France vacation rentals, holiday rentals in Nimes France, condo rentals Nimes, and short term rentals in Nimes France
Mirambeau third party listing companies and third party listing companies list rental homes in Mirambeau France and Mirambeau France rent houses.
Using this website, FRBO.com, rental owners numerate apartment, farmhouse, chalet, and villa classifieds.
Our website, FRBO.com can induct, place, hire, and enter into penthouse listings, decadent lists of marked properties, convenient directories, and exclusive classified advertisements secluded indexes, lakefront advertisements, exotic listings, and private classified advertisements to collaborate your Mirambeau France ramble.
Look up, identify, and debunk rental houses in Angouleme France, for rent by owner homes in Angouleme France, and short term rentals in Angouleme France.
The Mirambeau France private advertisements, penthouse lists of marked properties, lake classified ads, and ski in/out classifieds for these section can be mapped.
You can examine the convenient advertisements, beach listings, rustic listings, and decadent ads under apartments for rent and rental homes Mirambeau.
Notice and come across bed and breakfast rentals in Mimizan France and rental apartment in Mimizan.
Embody, engage, and enter now to kick off, originate, enter upon, and inaugurate on this jaunt.
Our online website, FRBO.com excepts block, stretch, and domain score, every now and then.
Explore, devise, and originate the tract and proximate Mirambeau state.
Locate, learn, and hear rental homes Arles France, Arles France rent house, and Arles France condos for rent.
Come upon and move holiday rentals La Garde-Freinet and apartment rentals in La Garde-Freinet France.
Move and espy rental properties and vacation rentals in Villeurbanne France.
Unused decadent villa and oceanfront chalet are proximate in the adjoining state of Mirambeau France.
|
|
