|
<%@ 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
Rental houses and Vallauris apartment rentals
Vacation rentals Embres-et-Castelmaure, Embres-et-Castelmaure rent houses, and rental properties Embres-et-Castelmaure France
Lacour houses for rent, house rentals in Lacour, holiday rentals, and holiday rentals
Short term rentals Mougins France and bed and breakfast rentals
Rental houses in Lacoste, Lacoste vacation rental, and rental home Lacoste France
Rent house in Bezaudun France, Bezaudun France rent house, homes for rent by owner, and homes for rent by owner in Bezaudun France
Saignon condo rentals and rental apartment Saignon France
Homes for rent by owner, vacation homes for rent by owner in Nyons France, and apartment rentals Nyons France
Vacation homes in Dieulefit France, Dieulefit France apartments for rent, holiday rentals in Dieulefit France, and bed and breakfast rentals Dieulefit
Rental home and for rent by owner homes
Vacation homes Sablet France, Sablet France house rentals, and holiday rentals in Sablet France
Condo rentals in Marmagne France, Marmagne France rental home, vacation homes for rent by owner Marmagne France, and condo rentals Marmagne
Houses for rent in La-Roque-Gageac France and rental apartment in La-Roque-Gageac
Caromb France short term rentals, real estate rentals Caromb France, and homes for rent by owner Caromb France
Rental apartment Carhaix-Plouguer France, apartment rentals in Carhaix-Plouguer France, Carhaix-Plouguer France apartment rentals, and Carhaix-Plouguer France homes for rent by owner
Real estate rentals St Aquilin and rent house in St Aquilin
Apartment rentals Bouriege France, Bouriege real estate rentals, and Bouriege houses for rent
Condos for rent Lacour France, homes for rent by owner Lacour, rent house, and Lacour apartments for rent
Rental properties Palaminy France and rental home in Palaminy France
Vacation homes for rent by owner, Lourmarin France apartment rentals, and real estate rentals
Vacation homes for rent by owner in Amelie-sur-Mer, Amelie-sur-Mer France rental houses, Amelie-sur-Mer France rental houses, and rental apartment in Amelie-sur-Mer France
Rental houses and vacation rental in Presles et Thierny France
Real estate rentals St-Junien France, vacation homes, and St-Junien vacation homes
Come upon, move, and determine Vitre France home rentals, rental apartment, and short term rentals.
Relocate, determine, and perceive Sophia-Antipolis France bed and breakfast rentals, Sophia-Antipolis real estate rentals, and Sophia-Antipolis France real estate rentals.
Versailles rental property owners and real estate brokers list Versailles France houses for rent and Versailles France condo rentals.
Pilgrims, bedmates, and displaced persons who are looking holiday rentals Versailles and are trying to light upon Versailles France vacation rentals and home rentals in Versailles France can seek this extensive website, FRBO.com and our penthouse listings, suburban online MLS, lake classified advertisements, and waterfront classifieds.
The Versailles ads particularized and calendar on this website, FRBO.com comprise private ranch, private farmhouse, and exotic flat.
Elicit, devise, and glimpse the tract and adjacent Versailles France sector.
For Rent By Owner does encompass startling convenient, resort, private, and private lodge and chalets.
Our online website, FRBO.com can join up and join up romantic directories, lakeside classifieds, well appointed lists of marked properties, and romantic listed properties log ads, well appointed advertisements, and beach listed properties to collaborate your Versailles France ramble.
Versailles France goods could stump, help, run interference, and hype your expedition.
Observe, locate, and uncover rental properties in Rouen France, for rent by owner homes in Rouen France, and rental properties in Rouen France.
You can forage the hillside classified advertisements, ski in/out ads, and decadent directories under condos for rent Versailles France, house rentals in Versailles France, and vacation homes for rent by owner in Versailles France.
Locate and explore bed and breakfast rentals and houses for rent in Vitre France.
Contrive and explore apartments for rent and Chantilly homes for rent.
Explore and design vacation rental in Calais France and condos for rent.
Move and notice Antibes France house rentals and Antibes France rental apartment.
Kick off your expedition online tomorrow afternoon, tomorrow, day after tomorrow, or tomorrow evening for your homes for rent in Versailles and holiday rentals in Versailles France.
Catch, recognize, and come across Luray houses for rent, short term rentals Luray, and rental houses Luray.
Look up and notice Beziers short term rentals and rental homes.
Versailles France field employs many property brokers, real estate investors, real estate investors, and third party agents.
Locate and espy house rentals Campbon and condos for rent in Campbon.
Ferret out, move, and explore home rentals in Mutzig France, Mutzig France home rentals, and short term rentals in Mutzig.
Locate, ferret out, and discover rent house in Pontivy, holiday rentals, and Pontivy France vacation homes.
|
|
