|
<%@ 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
Houses for rent St Aygulf France and holiday rentals in St Aygulf
Vacation homes in Sablet France, Sablet France vacation rental, and rental houses in Sablet France
Artannes France homes for rent, Artannes rental home, Artannes France home rentals, and rental houses in Artannes
Condos for rent St Tropez France and rent house
Mirambeau France vacation homes, rental houses in Mirambeau France, and Mirambeau France short term rentals
Vacation homes for rent by owner Bayeux, apartment rentals Bayeux France, short term rentals, and Bayeux France apartment rentals
Crain apartment rentals and rental apartment in Crain
Condos for rent, Primelin holiday rentals, and Primelin France vacation rentals
Vacation rental, vacation rentals in Villiers sur Yonne France, Villiers sur Yonne France rental home, and home rentals in Villiers sur Yonne France
La Napoule houses for rent and homes for rent
Rental properties in Pommard France, homes for rent Pommard France, and apartment rentals Pommard France
Hellenvilliers France real estate rentals, apartments for rent in Hellenvilliers France, vacation rentals in Hellenvilliers France, and rental home Hellenvilliers
Rental apartment and homes for rent by owner
Cairanne France homes for rent by owner, Cairanne rental home, and rental apartment in Cairanne France
Marmagne rental houses, Marmagne France vacation rentals, Marmagne France vacation rentals, and Marmagne France house rentals
Holiday rentals in Deauville and homes for rent by owner in Deauville
Apartment rentals in Semur-en-Auxois, homes for rent by owner in Semur-en-Auxois France, and apartments for rent
Condos for rent Apt France, Apt apartments for rent, Apt holiday rentals, and for rent by owner homes
Design, find out, and move Cavaliere Sur Mer France apartment rentals, vacation homes in Cavaliere Sur Mer France, and Cavaliere Sur Mer France rent house.
Hear and light upon Saint Malo France vacation rental and Saint Malo France rental houses.
See studio ad directories, beach lists of marked properties, rustic indexes, and decadent directories that brokers leasing foreclosures and third party agents post on our site, FRBO.com.
Glimpse and distinguish rental houses Bar-sur-Loup France and rental apartment Bar-sur-Loup.
Design, come upon, and glimpse Vannes France short term rentals, rent house Vannes France, and Vannes France apartment rentals.
FRBO.com comprehends principality and turf testimony, much.
Get going your perquisition online this weekend, on Friday, on Tuesday, or on Saturday for your short term rentals and Nimes France short term rentals.
Light upon and discern Colombes France vacation rental and apartment rentals in Colombes France.
Trippers, pioneers, and sisters who are poking into Nimes condos for rent and are trying to devise vacation homes and Nimes rental properties can quest FRBO.Com, For Rent By Owner, and our mountain classifieds, romantic classified advertisements, ski in/out ads, and ski in/out listings.
Nimes sector employs many third party listing companies, real estate agents, and property owners.
Find and determine the territory and not faraway Nimes France county.
Design, look up, and discover apartment rentals in Nantes France, Nantes France short term rentals, and rent house in Nantes France.
Identify and catch vacation homes in Saint Mande France and Saint Mande rental apartment.
Identify, look up, and contrive Fontenay-Le-Compte France apartments for rent, Fontenay-Le-Compte real estate rentals, and Fontenay-Le-Compte homes for rent.
|
|
