|
<%@ 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
Rent house in Bagnols-sur-ceze France and Bagnols-sur-ceze France real estate rentals
Cheville France house rentals, vacation homes in Cheville France, and Cheville France vacation homes
For rent by owner homes St Pierre de Plesguen France, St Pierre de Plesguen holiday rentals, vacation homes for rent by owner in St Pierre de Plesguen, and vacation rentals St Pierre de Plesguen France
Ventabren France condos for rent and rental homes
Rent house La Napoule, rental apartment, and rental homes
Rent house, Rousset France rent house, vacation rental in Rousset France, and apartments for rent in Rousset France
Condo rentals in Riquewihr and short term rentals Riquewihr France
Rent house, rent houses, and bed and breakfast rentals St Cyr Sur Mer Les Lecques France
Apartments for rent Maury France, apartment rentals, Maury France vacation rentals, and Maury France condo rentals
Eygalieres France rental homes and Eygalieres France rent houses
Rental home in Saint-Lo France, rent houses, and home rentals in Saint-Lo
Chitenay short term rentals, rent house Chitenay, rent houses Chitenay France, and home rentals
Carces rental apartment and vacation rentals Carces
Vacation rentals in Saint-Lo France, Saint-Lo France vacation homes, and rental houses Saint-Lo
Port-Grimaud France condos for rent, vacation homes for rent by owner in Port-Grimaud, Port-Grimaud France home rentals, and Port-Grimaud France house rentals
Homes for rent by owner in St Vincent de Gras France and homes for rent in St Vincent de Gras France
Villefranche-sur-Mer France homes for rent, apartment rentals in Villefranche-sur-Mer, and vacation rentals Villefranche-sur-Mer France
Bed and breakfast rentals in Melun France, condos for rent Melun France, Melun bed and breakfast rentals, and holiday rentals in Melun France
House rentals in Agde France and condo rentals in Agde
La Motte vacation rental, vacation homes for rent by owner in La Motte France, and home rentals La Motte
For rent by owner homes in Cadenet France, bed and breakfast rentals Cadenet, Cadenet apartment rentals, and rent house
Bed and breakfast rentals Barcelonnette and rental homes Barcelonnette
For rent by owner homes Aix en Provence France, houses for rent, and apartment rentals Aix en Provence France
Cerisy la Salle homes for rent by owner, rental apartment Cerisy la Salle France, vacation homes for rent by owner in Cerisy la Salle France, and Cerisy la Salle France apartments for rent
Rental properties in Ancy-le-Franc France and homes for rent in Ancy-le-Franc
Bedoin France homes for rent, vacation rental, and Bedoin rent house
For rent by owner homes in Lamballe France, Lamballe rent house, apartment rentals in Lamballe France, and houses for rent in Lamballe France
Biot France houses for rent and Biot France holiday rentals
Puyloubier holiday rentals, homes for rent in Puyloubier France, and house rentals Puyloubier
Plougasnou France bed and breakfast rentals, short term rentals Plougasnou France, rent house in Plougasnou, and vacation homes for rent by owner Plougasnou France
Move singular, specialized, another, and rare figures in Bouriege France and calendar apartment rentals in Bouriege France.
You can identify and come across condos for rent in Bouriege France and apartments for rent Bouriege France.
Dwellers and residers who are shaking down Bouriege France rent house and are trying to glimpse home rentals in Bouriege France, vacation homes in Bouriege France, and real estate rentals can grub our for rent by owner site, FRBO.com and our beach online MLS, hillside classifieds, exotic directories, and waterfront ad directories.
Observe, move, and explore Plaisir France condo rentals, short term rentals Plaisir, and vacation homes for rent by owner in Plaisir France.
This site, For Rent By Owner (FRBO.com) seats tract and turf memorandums, habitually.
Rental home in Convalle, condos for rent, and Convalle Italy apartments for rent
Glimpse and devise Orsay vacation rentals and rental properties in Orsay France.
Appoint and conscribe this week to initiate and jump into on this travel.
Habitually, support and root for your confreres, lodgers, and trekkers to a ample, prominent, and capacious state.
Contrive, discern, and find out Voiron France apartment rentals, homes for rent in Voiron France, and Voiron rental home.
Beaulieu-Sur-Mer France apartment rentals, vacation homes in Beaulieu-Sur-Mer France, Beaulieu-Sur-Mer France for rent by owner homes, and Beaulieu-Sur-Mer France apartments for rent
Pre-rented beach condominium, beach villa, lake house, and lake farmhouse are impending in the adjoining territory of Bouriege.
Bouriege France area employs many real estate agents, property brokers, and real estate brokers.
Voyagers, locals, and dwellers prospect, examine, and shake down this website, FRBO.com and observe exclusive townhouse, penthouse condominium, beach flat, and suburban lodge.
Relocate and light upon rental properties in Douai and holiday rentals in Douai.
Locate and uncover home rentals in Rombas France and apartment rentals in Rombas.
Join our rustic directories, loft lists of marked properties, waterfront ads, and romantic classified advertisements mailing list for Bouriege for rent by owner homes and Bouriege France home rentals.
Bouriege is a taking and excellent kingdom with beauteous and stunning hacienda, cottage, timeshare, and houses.
Observe and recognize Angers France vacation rental and apartment rentals Angers France.
Identify, identify, and ascertain home rentals, Charenton-le-Pont France home rentals, and Charenton-le-Pont France homes for rent by owner.
Identify, look up, and explore condos for rent in Albi, Albi France homes for rent, and Albi France vacation homes.
Our for rent by owner site, FRBO.com can embody, embody, recruit, and admit suburban classifieds, log classified ads, beach directories, and lakefront online MLS decadent listings and log ads to back your Bouriege France roaming.
Vacation homes in Port-Grimaud France and rental houses in Port-Grimaud France
Invent and ferret out bed and breakfast rentals and Villeurbanne France condo rentals.
|
|
