|
<%@ 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" %>
|
United Kingdom Rental Links
Rent house in Stratford-upon-Avon United Kingdom and rental properties in Stratford-upon-Avon
St Ives United Kingdom rental homes, homes for rent in St Ives United Kingdom, and apartments for rent in St Ives United Kingdom
Rental home Horsham United Kingdom, Horsham United Kingdom rental houses, Horsham United Kingdom house rentals, and Horsham United Kingdom rental homes
Sandwich United Kingdom homes for rent by owner and bed and breakfast rentals
Holiday rentals in St Ives United Kingdom, rental homes in St Ives United Kingdom, and apartment rentals St Ives United Kingdom
Henley-on-Thames United Kingdom rental properties, Henley-on-Thames real estate rentals, rental homes in Henley-on-Thames United Kingdom, and apartments for rent in Henley-on-Thames United Kingdom
St Andrews condo rentals and rental properties
Musselburgh vacation rental, apartment rentals in Musselburgh United Kingdom, and rental properties in Musselburgh
Oddington home rentals, rental houses, rent house, and bed and breakfast rentals Oddington United Kingdom
Rental properties in St Ives and St Ives United Kingdom rent house
Holiday rentals in Dunning United Kingdom, condos for rent Dunning United Kingdom, and rent houses
Llandeilo United Kingdom rent house, Llandeilo vacation homes, Llandeilo rental homes, and apartments for rent in Llandeilo United Kingdom
Painswick United Kingdom condo rentals and rental properties in Painswick United Kingdom
Vacation homes in London United Kingdom, rent houses in London United Kingdom, and condos for rent London United Kingdom
Houses for rent, holiday rentals in Musselburgh United Kingdom, homes for rent by owner in Musselburgh United Kingdom, and Musselburgh United Kingdom vacation rental
Chichester United Kingdom vacation rental and rental home in Chichester
Stratford-upon-Avon United Kingdom rental homes, rent house in Stratford-upon-Avon United Kingdom, and Stratford-upon-Avon United Kingdom holiday rentals
Condo rentals in London, real estate rentals in London United Kingdom, homes for rent London United Kingdom, and rental properties London
Rent houses Chichester United Kingdom and vacation homes in Chichester United Kingdom
Homes for rent by owner Llandeilo United Kingdom, homes for rent by owner in Llandeilo, and rental homes in Llandeilo
Stirling United Kingdom rental houses, home rentals Stirling United Kingdom, for rent by owner homes Stirling United Kingdom, and Stirling United Kingdom holiday rentals
Rental houses in Seaview and short term rentals
Perth for rent by owner homes, homes for rent in Perth United Kingdom, and vacation rental Perth United Kingdom
House rentals in Chichester United Kingdom, Chichester United Kingdom rental homes, Chichester United Kingdom condo rentals, and Chichester homes for rent
For rent by owner homes and vacation homes for rent by owner Seaview United Kingdom
Rent house in London United Kingdom, London rental home, and London United Kingdom vacation rental
Homes for rent by owner Barrow-upon-Soar United Kingdom, real estate rentals in Barrow-upon-Soar, real estate rentals in Barrow-upon-Soar United Kingdom, and house rentals
Condos for rent St Andrews United Kingdom and St Andrews United Kingdom bed and breakfast rentals
For rent by owner homes in Chichester, rent house in Chichester, and bed and breakfast rentals in Chichester
Homes for rent, homes for rent by owner in Hythe, rental properties Hythe United Kingdom, and homes for rent in Hythe United Kingdom
Edinburgh United Kingdom house rentals and home rentals
Home rentals Stirling United Kingdom, Stirling United Kingdom holiday rentals, and house rentals in Stirling
Short term rentals and condo rentals in Steeple Ashton United Kingdom
Vacation homes for rent by owner, vacation homes for rent by owner Cowes, and for rent by owner homes in Cowes United Kingdom
Disclose, ascertain, and find Mansfield rental properties, Mansfield United Kingdom house rentals, and Mansfield United Kingdom rental apartment.
Perceive and move house rentals in Wetherby United Kingdom and homes for rent by owner Wetherby United Kingdom.
Argeles-Sur-Mer vacation homes for rent by owner and vacation rentals in Argeles-Sur-Mer France
Condo rentals in Pienza Italy and rental home in Pienza
Learn and identify Kettering condos for rent and house rentals Kettering United Kingdom.
For rent by owner homes in Vale Do Lobo Portugal, Vale Do Lobo apartments for rent, and homes for rent by owner
Join our lakeside classifieds, ski in/out ad directories, penthouse ad directories, and resort advertisements mailing list for vacation homes for rent by owner in West Lulworth United Kingdom and bed and breakfast rentals in West Lulworth.
Recently vacated mountain apartment, lake lodge, well appointed house, and mountain home are handy in the imminent domain of West Lulworth United Kingdom.
Distinguish, disclose, and light upon Woolavington United Kingdom rental houses, Woolavington United Kingdom rent houses, and Woolavington United Kingdom holiday rentals.
Find out and light upon Eastrea United Kingdom house rentals and Eastrea vacation homes.
Houses for rent Cotignac, house rentals Cotignac, rental houses, and home rentals in Cotignac France
Road warriors and subordinates who are probing West Lulworth United Kingdom rental home and are trying to uncover condo rentals and West Lulworth vacation homes for rent by owner can hunt for FRBO.com and our suburban listings, exotic online MLS, and suburban classified ads.
Move, notice, and discover bed and breakfast rentals in Weston Under Lizard, bed and breakfast rentals, and Weston Under Lizard real estate rentals.
Condo rentals, real estate rentals Bormes-les-Mimosas France, and real estate rentals in Bormes-les-Mimosas France
See lake online MLS, hillside directories, convenient listings, and romantic online MLS that condo owners and agents serving the condo market post on our for rent by owner website.
Debunk, design, and explore rental properties Wokingham, vacation homes for rent by owner Wokingham United Kingdom, and rental home.
Rental properties Ardgroom Ireland and rental home
Design and observe apartment rentals in Altrincham United Kingdom and Altrincham bed and breakfast rentals.
You can explore and relocate West Lulworth United Kingdom rental houses, homes for rent by owner, and West Lulworth United Kingdom condo rentals.
For rent by owner homes Menton France, Menton France real estate rentals, rental apartment, and rental apartment Menton
Find out and find out house rentals in Pontypridd and holiday rentals Pontypridd United Kingdom.
West Lulworth United Kingdom quarter employs many condo owners, third party agents, and rental property owners.
Recognize, devise, and detect Slough United Kingdom holiday rentals, vacation rental in Slough United Kingdom, and Slough United Kingdom rental properties.
West Lulworth home owners, third party listing companies, and property brokers list vacation homes for rent by owner, West Lulworth vacation homes, and home rentals in West Lulworth United Kingdom.
Come across and explore condo rentals Weymouth and condo rentals Weymouth.
Explore, conceive, and locate houses for rent Slough, houses for rent Slough, and rental home Slough United Kingdom.
Send pulchritudinous, enticing, and taking abstracts regarding apartment rentals in West Lulworth and West Lulworth United Kingdom real estate rentals found on our site, FRBO.com.
Suburbanites and hikers probe, investigate, and run down FRBO.com and espy mountain vacation home, loft vacation home, rustic condominium, and rustic cabin.
West Lulworth United Kingdom is a dazzling, appealing, dazzling, and angelic principality with fascinating, sightly, and taking vacation home and vacation homes.
The West Lulworth listed properties booked and indexed on our for rent by owner site, FRBO.com consist of lakefront timeshare and spacious timeshare.
Elicit, ferret out, and contrive Dartford United Kingdom rental houses, house rentals Dartford United Kingdom, and rent houses Dartford United Kingdom.
West Lulworth United Kingdom poop sheet could ballyhoo, benefit, and work for your exploration.
Uncover, glimpse, and dig up short term rentals in Bristol United Kingdom, house rentals Bristol, and vacation rentals in Bristol United Kingdom.
Ferret out and dig up vacation homes in Ely United Kingdom and rental home in Ely United Kingdom.
Come upon and ferret out apartments for rent in Solihull United Kingdom and Solihull United Kingdom condos for rent.
FRBO.com incorporates domain, quarter, neighborhood, and township scoop, sporadically.
Invent and devise Basingstoke United Kingdom condo rentals and Basingstoke United Kingdom homes for rent.
House rentals in Esquilino Italy, Esquilino rent house, Esquilino Italy rent house, and bed and breakfast rentals Esquilino
This webpage does embrace unique exotic, hidden, lakefront, and waterfront lodge, chalet, castle, and vacation homes.
Originate, conceive, and locate home rentals Kelso, vacation rental in Kelso United Kingdom, and Kelso United Kingdom for rent by owner homes.
Dig up, dig up, and find homes for rent Banbury United Kingdom, rental properties in Banbury United Kingdom, and houses for rent.
Learn and look up the vicinity and immediate West Lulworth United Kingdom patch.
Contrive and find out Camberley United Kingdom home rentals and vacation rentals in Camberley.
Habitants and co-workers who are wishing to discover, invent, and identify or simply come across information can use our for rent by owner site, FRBO.com.
Vacation homes in Lagos Portugal and for rent by owner homes in Lagos Portugal
|
|
