|
<%@ 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
Cotignac France rental home and home rentals Cotignac
St-Martin-de-Belleville France apartment rentals, St-Martin-de-Belleville France for rent by owner homes, and holiday rentals in St-Martin-de-Belleville France
Vacation homes, Meursault France holiday rentals, bed and breakfast rentals, and Meursault houses for rent
Condo rentals in Hellenvilliers France and rental houses
Nimes France bed and breakfast rentals, rent houses Nimes, and rent houses in Nimes
St-Julien-le-Faucon France house rentals, apartment rentals St-Julien-le-Faucon, vacation rentals in St-Julien-le-Faucon, and rental homes St-Julien-le-Faucon France
Rental properties Septeuil France and Septeuil France rent house
Condo rentals in Hellenvilliers France, bed and breakfast rentals Hellenvilliers, and house rentals Hellenvilliers
Vacation homes for rent by owner in Pons France, Pons France houses for rent, houses for rent in Pons, and Pons apartments for rent
Vacation rental and rent houses
Crain rental properties, Crain condo rentals, and condo rentals Crain
Rental home in Lamballe France, homes for rent by owner Lamballe, home rentals in Lamballe, and house rentals in Lamballe
Tornac France condo rentals and rental properties Tornac
Rental apartment in Ambert, Ambert France home rentals, and Ambert France rent house
Rental properties in Arles sur Tech, rental homes in Arles sur Tech, vacation homes in Arles sur Tech, and rental homes in Arles sur Tech France
Bedarieux France vacation homes and vacation homes for rent by owner
Palaminy France for rent by owner homes, homes for rent in Palaminy, and Palaminy for rent by owner homes
Apartment rentals in Menton, vacation homes Menton France, Menton France rental homes, and rent houses Menton France
Bed and breakfast rentals Argeles-Sur-Mer France and rental home Argeles-Sur-Mer France
Rent houses in Dauphin France, Dauphin apartment rentals, and Dauphin vacation homes
Open your investigation online tomorrow afternoon, on Monday, or on Tuesday for your St Remy de Provence France bed and breakfast rentals, holiday rentals St Remy de Provence France, and homes for rent by owner in St Remy de Provence France.
Our for rent by owner website does enclose some county exotic and spacious duplex and apartments.
Distinguish, disclose, and find out Seclin France rent house, rental home Seclin, and condo rentals.
Detect, ascertain, and conceive rental houses in Compiegne, rent house Compiegne, and homes for rent by owner Compiegne France.
Using our online website, FRBO.com, land owners chronicle townhouse and houseboat online MLS.
Learn, light upon, and disclose Saint Etienne condo rentals, vacation homes for rent by owner in Saint Etienne, and houses for rent in Saint Etienne France.
Send sightly, fine, and superb knowledge regarding apartments for rent in St Remy de Provence, apartment rentals, rental home in St Remy de Provence France, and St Remy de Provence vacation rental found on our for rent by owner site, FRBO.com.
Discern, look up, and recognize short term rentals in Cambrai France, homes for rent by owner, and Cambrai condos for rent.
St Remy de Provence France materials could plug, reinforce, and assist your investigation.
Identify and find Bourges home rentals and Bourges vacation rentals.
St Remy de Provence France is a admirable, classy, and charming county with pretty and shapely vacation home, timeshare, and townhouses.
Devise, detect, and locate rent houses Cambrai France, Cambrai France bed and breakfast rentals, and Cambrai France vacation homes for rent by owner.
Catch and find short term rentals in Terrasson France and Terrasson France vacation homes for rent by owner.
Light upon and ascertain rental houses in Reims France and vacation rental.
FRBO.Com, For Rent By Owner, can enter into, sign on, and take on decadent directories, well appointed listed properties, and penthouse indexes decadent classified advertisements, beachfront classified advertisements, exotic classifieds, and private listed properties to abet your St Remy de Provence France ramble.
|
|
