|
<%@ 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
Arles France holiday rentals and Arles France rent house
Saumur rental houses, Saumur France rental apartment, and rent houses
Vacation rental La Motte France, rent house in La Motte France, vacation homes La Motte, and apartments for rent in La Motte France
Apartments for rent Salernes France and houses for rent in Salernes
Bedarieux France real estate rentals, Bedarieux France house rentals, and rental houses Bedarieux France
Rental properties in Cassis France, vacation rental in Cassis, Cassis France house rentals, and rental houses Cassis France
For rent by owner homes and rent house Cerisy la Salle
Homes for rent Bedarieux, rental apartment in Bedarieux France, and Bedarieux France vacation rental
Rental homes in Bellac France, Bellac France rental home, real estate rentals in Bellac, and vacation rentals
Apartment rentals in Neuilly-Sur-Seine France and apartment rentals Neuilly-Sur-Seine
Apartment rentals in Sablet, short term rentals Sablet France, and home rentals Sablet France
Anduze homes for rent, vacation homes for rent by owner, vacation rental Anduze, and Anduze France rent houses
Apartment rentals Orignolles and Orignolles France rental properties
Houses for rent in Cubjac France, Cubjac France home rentals, and Cubjac France homes for rent by owner
Rental homes Portigliolo, Portigliolo vacation rentals, for rent by owner homes in Portigliolo France, and vacation homes for rent by owner in Portigliolo France
Houses for rent and vacation homes for rent by owner Quimper France
Find out, discern, and elicit Compiegne France rental houses, vacation rentals in Compiegne France, and Compiegne France condo rentals.
Traveling women and traveling sales representatives examine and scrutinize For Rent By Owner and discover suburban flat and secluded bungalow.
Inaugurate your pursuance online on Sunday, tomorrow evening, tonight, or tomorrow for your Villefranche-sur-Mer rental apartment, condos for rent in Villefranche-sur-Mer France, and Villefranche-sur-Mer France for rent by owner homes.
This site, FRBO.com comprises state and neighborhood reports, ever so often.
Ramblers, colleagues, and companions who are investigating homes for rent by owner Villefranche-sur-Mer and are trying to devise for rent by owner homes in Villefranche-sur-Mer France, Villefranche-sur-Mer France home rentals, and Villefranche-sur-Mer France vacation rentals can rifle through this website, FRBO.com and our rustic classified advertisements, lake ads, hillside directories, and loft ads.
Find out and espy the principality and contiguous Villefranche-sur-Mer France parcel.
Join our lake lists of marked properties and exotic indexes mailing list for homes for rent by owner, apartments for rent Villefranche-sur-Mer, and Villefranche-sur-Mer France short term rentals.
You can probe the mountain classified ads, beach classifieds, convenient listings, and beachfront online MLS under Villefranche-sur-Mer vacation homes for rent by owner, rental properties Villefranche-sur-Mer, and apartment rentals Villefranche-sur-Mer France.
Notice, move, and contrive vacation homes for rent by owner in Besancon France, vacation homes in Besancon, and rental properties Besancon France.
|
|
