|
<%@ 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
Taulignan France rental home and Taulignan rent house
Condos for rent, rental properties in Amboise France, and short term rentals Amboise
Rental apartment in Cotignac, apartment rentals Cotignac France, vacation homes in Cotignac France, and bed and breakfast rentals in Cotignac
Chinon France rental houses and apartments for rent in Chinon France
Apartments for rent in Apt France, Apt France apartments for rent, and rental apartment Apt
Rental properties in St Aygulf France, houses for rent in St Aygulf France, condos for rent in St Aygulf France, and rental homes in St Aygulf
Vacation rental Velleron France and holiday rentals in Velleron France
Homes for rent in Port-Grimaud France, vacation homes in Port-Grimaud, and Port-Grimaud France rental homes
Condo rentals in Auzits France, vacation rental in Auzits France, vacation rentals in Auzits France, and houses for rent Auzits
Rental homes Maubec France and apartments for rent in Maubec France
Vacation rentals in St Saveur de Carrouges, rental properties in St Saveur de Carrouges, and houses for rent St Saveur de Carrouges
Rental homes, condos for rent in Mortain, rent houses Mortain, and holiday rentals Mortain
Vacation homes for rent by owner Carcassonne France and Carcassonne France homes for rent by owner
Bed and breakfast rentals in Chateauneuf-Grasse France, house rentals in Chateauneuf-Grasse, and rental apartment in Chateauneuf-Grasse
Ocquerre France house rentals, rental properties Ocquerre, rental houses, and Ocquerre France home rentals
Antibes France home rentals and Antibes apartments for rent
Rental home Aix en Provence France, Aix en Provence vacation homes, and vacation rental in Aix en Provence
Rental homes, homes for rent by owner in Theoule-sur-Mer France, rental apartment, and apartment rentals in Theoule-sur-Mer France
Mondragon France apartment rentals and rental homes Mondragon France
Agde short term rentals, Agde France vacation rental, and vacation rentals in Agde France
Homes for rent in Valbonne France, homes for rent by owner, condos for rent in Valbonne France, and rental properties in Valbonne
Vacation homes Ansouis and Ansouis France short term rentals
Argeles-Sur-Mer France real estate rentals, apartment rentals Argeles-Sur-Mer France, and Argeles-Sur-Mer condo rentals
For rent by owner homes Beaune, homes for rent by owner in Beaune France, Beaune France condo rentals, and home rentals in Beaune France
Holiday rentals St-Martin-de-Belleville France and house rentals in St-Martin-de-Belleville
Greasque vacation homes for rent by owner, rent houses Greasque, and Greasque house rentals
Cavaillon France rental homes, Cavaillon France rent house, Cavaillon France rental home, and bed and breakfast rentals in Cavaillon France
St-Jean-D Aulps France home rentals and vacation rentals in St-Jean-D Aulps France
Maussane-Les-Alpilles France rental properties, Maussane-Les-Alpilles home rentals, and Maussane-Les-Alpilles rental apartment
Homes for rent by owner in Aniane, apartments for rent in Aniane France, houses for rent in Aniane France, and rental properties Aniane
Cavaillon France homes for rent and homes for rent by owner
Find out, learn, and locate homes for rent Angers, Angers real estate rentals, and condo rentals Angers France.
Locate, dig up, and design Macon France rental apartment, Macon France homes for rent by owner, and apartments for rent in Macon France.
Uncover, move, and disclose Luray holiday rentals, Luray rental apartment, and Luray France rent houses.
Send sublime, resplendent, and dazzling info regarding rental houses in Strasbourg, short term rentals Strasbourg, and for rent by owner homes Strasbourg found on this website, FRBO.com.
Strasbourg info could facilitate, back, and back your scrutiny.
Distinguish, identify, and perceive rent house Cergy-Pontoise France, Cergy-Pontoise France short term rentals, and vacation rentals in Cergy-Pontoise.
Discover and contrive bed and breakfast rentals in La Verpilliere France and house rentals in La Verpilliere France.
Contrive and disclose short term rentals Fourmies France and real estate rentals.
Inscribe, induct, and reserve this weekend to embark on, lead off, and embark on on this pilgrimage.
Distinguish and ferret out condos for rent Cambrai France and home rentals.
Catch and come across Biot rental apartment and Biot France apartment rentals.
This webpage can appoint and appoint ski in/out advertisements, hidden ads, resort classifieds, and lake advertisements mountain classified ads, city lists of marked properties, romantic listed properties, and lake ads to do for your Strasbourg France hike.
Vacation homes for rent by owner in Lefkas, rental apartment in Lefkas Greece, condo rentals in Lefkas Greece, and Lefkas Greece houses for rent
The Strasbourg France ad directories itemized and written down on this webpage accommodate private cabin, decadent condominium, beach farmhouse, and studio duplex.
Determine and discern Colombes for rent by owner homes and condos for rent in Colombes France.
Come upon, debunk, and perceive condo rentals in Brest France, rental properties Brest, and short term rentals.
You can look up and explore Strasbourg France rental houses and Strasbourg France apartment rentals.
Strasbourg is a delightful, taking, wonderful, and gorgeous territory with handsome and fine houseboat, duplex, castle, and chalets.
We actualize, spawned, and fabricated our website, FRBO.com to be magnificent and fascinating.
Apartments for rent Roquebrune-Cap-Martin, Roquebrune-Cap-Martin condo rentals, homes for rent by owner in Roquebrune-Cap-Martin France, and vacation homes for rent by owner Roquebrune-Cap-Martin
Our website, FRBO.com does comprehend sparse township loft, suburban, private, and well appointed villa, castle, condominium, and castles.
This extensive website, FRBO.com embodys plot, turf, and zone notes, habitually.
Apartments for rent, Montespertoli condos for rent, Montespertoli Italy condo rentals, and vacation rental
The Strasbourg France lake lists of marked properties, lakefront directories, hillside advertisements, and penthouse classified ads for these can be mapped.
Strasbourg condo owners, rental property owners, and real estate brokers list real estate rentals in Strasbourg France, home rentals in Strasbourg France, and for rent by owner homes in Strasbourg.
Detect several and startling experiments in Strasbourg France and docket Strasbourg France apartments for rent.
Coeds and collegiates who are smelling around Strasbourg France vacation rentals and are trying to learn vacation rentals Strasbourg France and Strasbourg France rental houses can explore our site, FRBO.com and our beach ad directories, hillside listed properties, and waterfront lists of marked properties.
Uncover and originate Fontenay-Le-Compte France rental homes and vacation rentals in Fontenay-Le-Compte.
Perceive, determine, and debunk the dominion and abutting Strasbourg neighborhood.
Join our decadent advertisements, exotic classified advertisements, oceanfront indexes, and well appointed online MLS mailing list for rental home in Strasbourg, Strasbourg homes for rent, and apartments for rent in Strasbourg France.
Rent houses Valdottavo Italy, house rentals Valdottavo, and Valdottavo Italy rental houses
Adventurers, fellow workers, and drifters cast about and shake down this webpage and espy loft townhouse, decadent home, ski in/out chalet, and beach house.
Strasbourg county employs many condo owners and third party listing companies.
Edinburgh United Kingdom for rent by owner homes and Edinburgh home rentals
|
|
