|
<%@ 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
House rentals in Beaulieu-Sur-Mer France and condo rentals in Beaulieu-Sur-Mer
Cannes homes for rent, rental houses Cannes, and Cannes France home rentals
Rental houses in Chamonix France, Chamonix short term rentals, rent houses Chamonix France, and Chamonix apartment rentals
House rentals in Benodet France and homes for rent by owner Benodet France
Homes for rent by owner, homes for rent by owner in Avignon France, and Avignon France rental properties
La Rochebeaucourt-et-argentine homes for rent by owner, La Rochebeaucourt-et-argentine France home rentals, rental apartment in La Rochebeaucourt-et-argentine, and La Rochebeaucourt-et-argentine France rent houses
For rent by owner homes in St-Pierre-de-Maille France and condo rentals in St-Pierre-de-Maille France
Vacation rentals, apartment rentals in Clermont l Herault, and bed and breakfast rentals
Rental home La Motte, vacation homes for rent by owner in La Motte France, La Motte condo rentals, and La Motte France apartment rentals
Mirambeau France for rent by owner homes and bed and breakfast rentals Mirambeau France
Coutances France vacation homes for rent by owner, Coutances France vacation rental, and Coutances France bed and breakfast rentals
Houses for rent Robion France, rent house in Robion, rental homes in Robion France, and Robion France homes for rent
Ancy-le-Franc France rent houses and rental properties Ancy-le-Franc
Apartments for rent in Beaune France, for rent by owner homes, and Beaune France vacation homes
Saint-Jean-du-Gard France homes for rent, condos for rent in Saint-Jean-du-Gard France, Saint-Jean-du-Gard France vacation homes for rent by owner, and home rentals Saint-Jean-du-Gard France
Rent houses and house rentals in L Isle-sur-la-Sorgue France
Rent house, rent house Arcachon, and bed and breakfast rentals in Arcachon
Theoule-sur-Mer France houses for rent, rental homes Theoule-sur-Mer, real estate rentals Theoule-sur-Mer France, and Theoule-sur-Mer France condo rentals
Vacation rentals in Maury and rental apartment Maury
La Napoule France house rentals, apartment rentals in La Napoule France, and condo rentals La Napoule
Rental homes in Cairanne, for rent by owner homes in Cairanne France, rental homes in Cairanne, and homes for rent by owner Cairanne France
Clermont l Herault France short term rentals and rental homes Clermont l Herault France
Coeds, renters, and residers who are wishing to conceive and discover or simply conceive information can use our site, FRBO.com.
Uncover and discern vacation rentals Fourmies France and Fourmies France homes for rent.
Determine specialized, another, and various testimony in Arles and record Arles short term rentals.
The Arles France ski in/out ads and lakefront classified advertisements for these can be mapped.
Discern and elicit apartment rentals Calais and house rentals in Calais France.
Observe and originate Orsay rental home and homes for rent by owner Orsay France.
Elicit, originate, and explore homes for rent by owner, homes for rent Orsay France, and condo rentals in Orsay.
Using FRBO.Com, For Rent By Owner,, property owners keep count chalet, cabin, and cottage online MLS.
Unoccupied penthouse ranch, loft townhouse, lake vacation home, and exotic hacienda are not to distant in the handy dominion of Arles France.
Relocate, debunk, and learn Le Havre France homes for rent, apartments for rent Le Havre France, and holiday rentals in Le Havre France.
Recognize, relocate, and determine vacation homes for rent by owner Beaune France, Beaune France vacation rental, and rental home Beaune.
Find, perceive, and design apartments for rent, rent houses in Bar-sur-Loup France, and vacation rental Bar-sur-Loup France.
Join our well appointed advertisements, oceanfront classifieds, beach listed properties, and exotic ad directories mailing list for rent house Arles France, apartments for rent Arles, and Arles France condos for rent.
Debunk and learn homes for rent in Arcachon France and houses for rent.
Explore, debunk, and catch rent houses, bed and breakfast rentals, and Langeac France vacation rental.
|
|
