|
<%@ 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
Real estate rentals Montner France and home rentals in Montner
Condo rentals in Coutances France, Coutances rent house, and homes for rent Coutances
Cap D ail apartments for rent, Cap D ail France condos for rent, home rentals in Cap D ail, and rent house Cap D ail
Vacation rental and holiday rentals in Honfleur
Short term rentals in Golfe du Morbihan, Golfe du Morbihan France vacation homes, and vacation homes for rent by owner Golfe du Morbihan France
Home rentals in Menerbes, homes for rent by owner in Menerbes France, apartments for rent in Menerbes France, and vacation homes for rent by owner in Menerbes France
Short term rentals and Pontlevoy France homes for rent
Rental home Goult France, home rentals Goult, and Goult France apartments for rent
Meyrargues France rental home, Meyrargues France short term rentals, apartment rentals in Meyrargues France, and rental homes
Homes for rent in Roussillon France and Roussillon rent houses
Villers-la-Faye France rent houses, rental homes in Villers-la-Faye, and vacation homes for rent by owner Villers-la-Faye France
Vacation homes in St Orens Pouy Petit France, rental properties St Orens Pouy Petit France, for rent by owner homes in St Orens Pouy Petit, and short term rentals
Apartments for rent Pontlevoy France and holiday rentals in Pontlevoy France
Uncover strange, bizarre, novel, and unique input in Venasque France and detail houses for rent in Venasque France.
Invent and detect real estate rentals Avignon France and apartments for rent Avignon France.
Using our for rent by owner site, FRBO.com, property brokers write down condominium and cottage listed properties.
The Venasque ads itemized and spelled out on this extensive website, FRBO.com comprise suburban hacienda and loft apartment.
Venasque territory employs many third party listing companies, rental property owners, third party listing companies, and property brokers.
Our for rent by owner website can oblige, list, and record well appointed classified advertisements, ski in/out listings, and beach classified advertisements penthouse directories, decadent classified ads, ski in/out listings, and mountain ads to plug your Venasque France ramble.
We concocted and sired our for rent by owner website to be delicate, pulchritudinous, lovely, and nice.
Venturers, sisters, and honeymooners who are scanning Venasque France homes for rent and are trying to dig up rental homes Venasque France, home rentals Venasque France, and rental home in Venasque can inquire our webpage and our lakefront listings, resort ad directories, and log indexes.
The Venasque France loft online MLS, hillside lists of marked properties, and hidden listings for these city can be mapped.
Venasque France is a radiant, stunning, and charming zone with shapely and wonderful condominium, bungalow, chalet, and cottages.
Venasque France poop sheet could boost, serve, and puff your pursuance.
Citizens, venturers, and displaced persons who are wishing to catch, invent, and discern or simply espy information can use our webpage.
Determine and conceive the turf and contiguous Venasque France dominion.
Catch, find, and light upon holiday rentals Chambery, houses for rent in Chambery, and Chambery France rental home.
Catch and find out for rent by owner homes in Antibes and rental properties in Antibes France.
|
|
