|
<%@ 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
Plougasnou France apartments for rent and rental properties Plougasnou
Rent house Velleron, homes for rent by owner in Velleron France, and Velleron France rental homes
Collioure France for rent by owner homes, bed and breakfast rentals, for rent by owner homes Collioure France, and condo rentals
Vacation homes Tain-l hermitage France and Tain-l hermitage France vacation rentals
Vacation homes St-Julien-le-Faucon, rental properties in St-Julien-le-Faucon, and St-Julien-le-Faucon France rental houses
Houses for rent Pommard, rent houses, bed and breakfast rentals in Pommard, and Pommard France vacation homes for rent by owner
Soreze France real estate rentals and vacation rental
Pezenas homes for rent, rental homes in Pezenas France, and short term rentals Pezenas
Apartment rentals in Hyeres France, Hyeres real estate rentals, Hyeres France rental apartment, and home rentals Hyeres France
Homes for rent by owner Uzes and Uzes real estate rentals
Beaune France condos for rent, rent house in Beaune France, and Beaune France home rentals
Short term rentals in Callas, holiday rentals in Callas France, Callas France rent house, and holiday rentals in Callas France
Cahors France for rent by owner homes and vacation rental Cahors
Avranches rental houses, Avranches condo rentals, and vacation rentals Avranches France
Houses for rent, Mirambeau France holiday rentals, real estate rentals Mirambeau France, and homes for rent in Mirambeau France
Initiate your examination online on Friday or day after tomorrow for your vacation rental Golfe du Morbihan, Golfe du Morbihan rental properties, and Golfe du Morbihan France rental home.
Join our ski in/out ad directories, romantic ads, and lake indexes mailing list for Golfe du Morbihan rental houses, Golfe du Morbihan France homes for rent by owner, and Golfe du Morbihan France condo rentals.
Trippers and traveling women who are smelling around short term rentals Golfe du Morbihan and are trying to disclose for rent by owner homes, rent houses in Golfe du Morbihan France, and houses for rent in Golfe du Morbihan can hunt for our webpage and our romantic ads, log indexes, beach ad directories, and beach listings.
Look up and recognize Reims rent houses and vacation homes for rent by owner.
The Golfe du Morbihan private lists of marked properties and penthouse ads for these precinct can be mapped.
Disclose and come across homes for rent in Henin-Beaumont France and houses for rent in Henin-Beaumont France.
We generated and formed our online website, FRBO.com to be marvelous, angelic, and grand.
Originate and come across holiday rentals Deauville and home rentals Deauville.
FRBO.Com, For Rent By Owner, does have especial ski in/out and resort cottage, cabin, and villas.
Our webpage can initiate and enroll beach classified advertisements, lakeside online MLS, and oceanfront classifieds hillside advertisements and romantic online MLS to plug your Golfe du Morbihan France march.
Golfe du Morbihan France domain employs many agents serving the condo market, property managers, and real estate agents.
Muster, admit, and secure on Wednesday to take up and begin on this promenade.
Come upon and discern rental home in Chambolle-Musigny France and rental homes in Chambolle-Musigny.
Hear and hear apartments for rent Montigny-le-Bretonneux and homes for rent in Montigny-le-Bretonneux France.
Originate, light upon, and learn Chavaniac France bed and breakfast rentals, house rentals Chavaniac, and Chavaniac bed and breakfast rentals.
The Golfe du Morbihan France listings manifested and inserted on our page involve city condominium and private farmhouse.
Perceive, uncover, and light upon holiday rentals, Morez France vacation homes for rent by owner, and homes for rent by owner Morez.
You can locate and come upon vacation homes in Golfe du Morbihan France and vacation rental.
Using this site, FRBO.com, property brokers enumerate hacienda, townhouse, castle, and ranch online MLS.
|
|
