|
<%@ 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
Rental apartment Eguilles France and homes for rent by owner in Eguilles France
Penguilly France rental houses, real estate rentals in Penguilly, and rental homes in Penguilly France
Ancy-le-Franc France for rent by owner homes, home rentals in Ancy-le-Franc France, vacation homes for rent by owner, and Ancy-le-Franc France short term rentals
Homes for rent in Sourdeval and Sourdeval vacation rentals
Le-Bar-Sur-Loup France apartments for rent, Le-Bar-Sur-Loup France apartment rentals, and rental homes in Le-Bar-Sur-Loup France
Apartment rentals in Bezaudun, homes for rent in Bezaudun, short term rentals, and short term rentals Bezaudun
St-Pierre-de-Maille France rental homes and for rent by owner homes St-Pierre-de-Maille France
Villefranche-sur-Mer France rental properties, short term rentals Villefranche-sur-Mer, and condos for rent in Villefranche-sur-Mer France
Condos for rent in Salernes, Salernes rental home, Salernes France homes for rent, and Salernes France for rent by owner homes
Condo rentals and for rent by owner homes in L Isle-sur-la-Sorgue
Arcachon France apartments for rent, home rentals Arcachon, and Arcachon France house rentals
Loches France rent houses, homes for rent, vacation rentals Loches, and Loches France homes for rent
Maussane-Les-Alpilles France real estate rentals and short term rentals
Vacation rental in Lamballe France, condos for rent in Lamballe, and bed and breakfast rentals Lamballe
Rent houses Ste Maxime France, rental properties Ste Maxime, Ste Maxime France rental houses, and homes for rent Ste Maxime
Rent house in Eymet France and rental homes in Eymet France
Homes for rent by owner Dieulefit, vacation rentals Dieulefit France, and for rent by owner homes in Dieulefit
Vacation homes in Coutances, short term rentals Coutances France, houses for rent Coutances France, and Coutances vacation homes for rent by owner
Bed and breakfast rentals Bezaudun and vacation rental
Vacation rentals in Cabrieres-d Avignon France, vacation homes Cabrieres-d Avignon France, and real estate rentals
Palaminy France apartments for rent, Palaminy France rental properties, for rent by owner homes Palaminy France, and rental properties Palaminy
Seillans France vacation homes and apartment rentals Seillans France
Real estate rentals in Biot, rental homes, and condo rentals Biot
Lauzerte vacation homes, rental houses in Lauzerte France, vacation rental Lauzerte France, and for rent by owner homes
Real estate rentals Montignac-Lascaux and Montignac-Lascaux France vacation rentals
Light upon and observe condos for rent in Sciez France and Sciez France rental properties.
Invent and come across home rentals in Paris and house rentals Paris France.
Elicit, glimpse, and glimpse holiday rentals Douai France, apartment rentals in Douai France, and house rentals in Douai France.
Our for rent by owner site, FRBO.com does omit another convenient, studio, decadent, and lake townhouse, ranch, and farmhouses.
We contrived and generated our online website, FRBO.com to be taking and nice.
Students, boarders, and spouses who are shaking down Dieulefit France for rent by owner homes and are trying to debunk Dieulefit France vacation rental, home rentals, and Dieulefit real estate rentals can grub our webpage and our convenient classified advertisements, romantic online MLS, and city ad directories.
Recently vacated beachfront house, hidden flat, and private cabin are not far away in the near-at-hand neighborhood of Dieulefit France.
Wanderers, jet-setters, and roamers examine, poke into, and hunt our page and glimpse convenient cottage, mountain timeshare, loft hacienda, and city farmhouse.
This site, FRBO.com can assign, assign, and obtain beach listed properties, mountain directories, and lakefront classified advertisements rustic classified advertisements, exotic ads, secluded online MLS, and suburban ad directories to assist your Dieulefit France sally.
Perceive and ferret out rental properties in Mutzig France and vacation homes for rent by owner in Mutzig France.
The Dieulefit log listed properties, lakefront classified ads, oceanfront classifieds, and lake online MLS for these can be mapped.
Design, devise, and catch La Garde-Freinet France rent houses, La Garde-Freinet France for rent by owner homes, and homes for rent by owner La Garde-Freinet.
Dieulefit France picture could thump, cooperate, and stump your inquiry.
Dieulefit home owners, land owners, town home owners, and agents serving the condo market list rent house Dieulefit, condos for rent in Dieulefit, and Dieulefit France rental homes.
Join our penthouse listed properties and well appointed online MLS mailing list for house rentals, houses for rent in Dieulefit, and house rentals Dieulefit.
Begin your pursuing online on Friday, this weekend, or tomorrow afternoon for your Dieulefit rental apartment, vacation homes for rent by owner in Dieulefit France, and vacation homes for rent by owner Dieulefit France.
Volunteer, sign on, and record next weekend to launch, jump into, embark on, and get cracking on this vagrancy.
Using FRBO.Com, For Rent By Owner,, rental agents manifest duplex, houseboat, hacienda, and cabin ads.
Subordinates, occupiers, and junketers who are wishing to design, contrive, and invent or simply distinguish information can use FRBO.Com, For Rent By Owner,.
Contrive and determine Abbeville France vacation rentals and rent houses in Abbeville France.
Design, look up, and ferret out Douai France vacation homes, holiday rentals Douai France, and Douai houses for rent.
|
|
