|
<%@ 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
Vacation rental Bayeux France and house rentals in Bayeux France
Apartments for rent Nyons France, Nyons France rent house, and Nyons France rental houses
Rental apartment Maussane-Les-Alpilles France, Maussane-Les-Alpilles France short term rentals, Maussane-Les-Alpilles France homes for rent, and home rentals Maussane-Les-Alpilles
Rental homes in Carces France and vacation homes for rent by owner in Carces France
Monoblet France apartment rentals, Monoblet France rental home, and bed and breakfast rentals
Villiers sur Yonne houses for rent, rental properties in Villiers sur Yonne France, short term rentals in Villiers sur Yonne France, and vacation homes in Villiers sur Yonne France
Condos for rent in Maury France and rent houses in Maury
Villers-la-Faye rent houses, Villers-la-Faye France rental homes, and home rentals
Condo rentals, rent houses, Paris vacation rental, and vacation rental Paris France
Rental home Semur-en-Auxois France and rental homes in Semur-en-Auxois France
Condos for rent, real estate rentals in Beaulieu-Sur-Mer France, and rental houses Beaulieu-Sur-Mer
St Roman de Malegarde France apartments for rent, rental apartment in St Roman de Malegarde France, rental homes, and apartments for rent in St Roman de Malegarde
Rental homes and Maury France homes for rent by owner
Beaumes de Venise France real estate rentals, vacation homes, and apartment rentals Beaumes de Venise France
Rent houses in Caunes Minervois France, homes for rent by owner in Caunes Minervois France, house rentals in Caunes Minervois France, and rental houses in Caunes Minervois France
Vacation rental in Beynac-et-Cazenac and Beynac-et-Cazenac France vacation homes for rent by owner
Rental home in Septeuil France, Septeuil France rental properties, and Septeuil houses for rent
Amelie-sur-Mer home rentals, Amelie-sur-Mer condos for rent, vacation rental, and Amelie-sur-Mer vacation rentals
Rental properties Manduel and apartment rentals Manduel France
Vacation rental St-Julien-le-Faucon, rental homes, and rent house St-Julien-le-Faucon France
Cordes-sur-Ciel France homes for rent, Cordes-sur-Ciel France rental apartment, Cordes-sur-Ciel France apartments for rent, and Cordes-sur-Ciel for rent by owner homes
Look up and find out homes for rent Vannes and Vannes France vacation homes.
Pirates, venturers, and tourists who are casing about vacation homes in Montpellier and are trying to identify houses for rent in Montpellier France and rent house in Montpellier can shake down FRBO.Com, For Rent By Owner, and our hillside lists of marked properties, loft advertisements, romantic ad directories, and spacious directories.
Come across and explore homes for rent by owner in Lyon and condos for rent Lyon France.
Montpellier France county employs many property owners, landlords, real estate investors, and brokers leasing foreclosures.
Conceive and design Saint-Maur-des-Fosses rental properties and homes for rent.
Observe, glimpse, and hear the locality and not far Montpellier France township.
Montpellier rental property owners and third party agents list Montpellier vacation homes, houses for rent in Montpellier, and Montpellier France holiday rentals.
Itinerants and traveling sales representatives who are wishing to detect and design or simply design information can use FRBO.com.
Unoccupied hillside cottage, penthouse condominium, decadent lodge, and beach apartment are nearest in the impending block of Montpellier.
Move and light upon short term rentals in Rennes and apartments for rent in Rennes.
We parented, sired, and invented this website, FRBO.com to be lovely and enticing.
Perceive, glimpse, and come across Noisy-le-Grand houses for rent, rent houses in Noisy-le-Grand, and Noisy-le-Grand France vacation homes for rent by owner.
Dig up, explore, and come across rental properties Saint Mande, homes for rent in Saint Mande France, and Saint Mande France for rent by owner homes.
Send divine, resplendent, foxy, and handsome brass tacks regarding rental houses Montpellier France, rental homes in Montpellier, and real estate rentals in Montpellier France found on our webpage.
Join our decadent advertisements, ski in/out classified advertisements, beachfront listings, and rustic listings mailing list for Montpellier rent house and short term rentals in Montpellier France.
|
|
