|
<%@ 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 homes for rent by owner in Andlau France and rental apartment in Andlau
Carrieres sur Seine France rental houses, Carrieres sur Seine France real estate rentals, and Carrieres sur Seine homes for rent
Lacoste vacation homes, Lacoste France rental properties, rental houses Lacoste France, and homes for rent by owner in Lacoste
Rental homes in La Fare les Oliviers France and rental homes in La Fare les Oliviers France
Rental houses in St-Julien-le-Faucon France, St-Julien-le-Faucon France rental houses, and condo rentals in St-Julien-le-Faucon France
Vence France vacation homes for rent by owner, Vence vacation rentals, apartment rentals Vence France, and rental apartment in Vence France
Chasteaux France real estate rentals and Chasteaux bed and breakfast rentals
Deauville France real estate rentals, rental properties in Deauville France, and Deauville France condos for rent
Versols-et-lapeyre France vacation rental, rent houses, Versols-et-lapeyre France apartments for rent, and Versols-et-lapeyre France rental houses
Apartment rentals in Antibes France and vacation rental Antibes
Richelieu France rental apartment, vacation rental in Richelieu, and Richelieu France homes for rent
Crain rental home, rent houses Crain, for rent by owner homes in Crain France, and Crain France vacation homes for rent by owner
Robion France vacation homes and house rentals Robion
Anduze home rentals, rent houses, and rental apartment Anduze
Embres-et-Castelmaure rent houses, Embres-et-Castelmaure rental apartment, vacation homes Embres-et-Castelmaure France, and Embres-et-Castelmaure France real estate rentals
Chamonix-Mont-Blanc houses for rent and Chamonix-Mont-Blanc vacation homes
Menton vacation homes, rent house in Menton, and apartment rentals in Menton
Lac de Chalain holiday rentals, Lac de Chalain France condos for rent, Lac de Chalain France short term rentals, and homes for rent Lac de Chalain France
Holiday rentals Eymet and real estate rentals
Le Bugue France bed and breakfast rentals, house rentals in Le Bugue, and holiday rentals
Rental houses, Loches France rental home, condo rentals, and homes for rent by owner Loches
Homes for rent in Le-Bar-Sur-Loup France and real estate rentals Le-Bar-Sur-Loup
Rent houses in Aubais France, vacation homes Aubais France, and home rentals in Aubais France
Apartments for rent in Bonnieux France, vacation rentals Bonnieux, Bonnieux France houses for rent, and rental home in Bonnieux France
Disclose, come across, and ferret out Arcachon house rentals, rental properties in Arcachon France, and Arcachon France houses for rent.
Disclose, originate, and distinguish Hyères France holiday rentals, rental properties Hyères France, and Hyères house rentals.
Clermont l Herault France is a marvelous, delicate, stunning, and elegant principality with appealing, superb, and admirable home and cabins.
Light upon and look up Aubigny-sur-Nere rental properties and condos for rent in Aubigny-sur-Nere.
Recognize, discern, and identify holiday rentals Saint Avold, Saint Avold houses for rent, and holiday rentals in Saint Avold France.
Join our exclusive indexes and exclusive classified advertisements mailing list for condo rentals in Clermont l Herault France, real estate rentals Clermont l Herault, and home rentals in Clermont l Herault France.
Ascertain, discern, and move condo rentals in Reims France, for rent by owner homes in Reims France, and Reims France homes for rent by owner.
Send elegant and well-formed conclusions regarding apartments for rent Clermont l Herault France, condo rentals in Clermont l Herault France, and vacation rentals in Clermont l Herault France found on our for rent by owner website.
Collegiates, twins, and occupiers who are raking Clermont l Herault vacation rentals and are trying to elicit homes for rent by owner Clermont l Herault France, rent house, and rent house Clermont l Herault France can scour this site, For Rent By Owner (FRBO.com) and our romantic listings, spacious classifieds, convenient lists of marked properties, and studio lists of marked properties.
Locate, look up, and light upon Bordeaux France houses for rent, Bordeaux vacation homes, and short term rentals.
Come upon and contrive Meylan France vacation rental and Meylan France condos for rent.
Ferret out, relocate, and come upon Aix-en-Provence France vacation homes, home rentals in Aix-en-Provence France, and rent houses in Aix-en-Provence France.
Clermont l Herault France field employs many agents serving the condo market, landlords, rental property owners, and agents.
Espy distinctive, small number, specialized, and peculiar proof in Clermont l Herault France and itemize home rentals in Clermont l Herault France.
You can seek the convenient ads, studio ad directories, convenient indexes, and exclusive classifieds under rental homes Clermont l Herault, Clermont l Herault France apartments for rent, and condos for rent in Clermont l Herault.
Espy, glimpse, and move short term rentals, rental houses Lons-le-Saunier, and Lons-le-Saunier France houses for rent.
Discover and perceive vacation homes for rent by owner in Saint-Julien-en-Genevois France and Saint-Julien-en-Genevois France apartments for rent.
|
|
