|
<%@ 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
Apartment rentals in St Ives United Kingdom and rental home St Ives
Condo rentals Llandeilo, vacation rentals in Llandeilo United Kingdom, and rent house Llandeilo United Kingdom
Atworth for rent by owner homes, rental home in Atworth United Kingdom, house rentals in Atworth, and vacation rentals in Atworth
Exeter United Kingdom homes for rent by owner and Exeter rental properties
Real estate rentals in Steeple Ashton United Kingdom, for rent by owner homes in Steeple Ashton United Kingdom, and Steeple Ashton United Kingdom real estate rentals
St Ives condo rentals, St Ives short term rentals, vacation rentals in St Ives United Kingdom, and St Ives United Kingdom rental houses
Bath United Kingdom holiday rentals and Bath houses for rent
Apartments for rent in Bath, rental home, and rental houses Bath United Kingdom
Henley-on-Thames United Kingdom houses for rent, for rent by owner homes in Henley-on-Thames United Kingdom, short term rentals, and Henley-on-Thames vacation homes for rent by owner
For rent by owner homes in Cowes and Cowes bed and breakfast rentals
Llanberis United Kingdom apartments for rent, Llanberis for rent by owner homes, and house rentals in Llanberis United Kingdom
Rental homes, home rentals in Painswick, Painswick vacation homes, and short term rentals in Painswick United Kingdom
Rental homes and apartments for rent Llanberis United Kingdom
Vacation homes Oddington United Kingdom, Oddington rental properties, and Oddington United Kingdom rental home
St Ives United Kingdom rental houses, rental houses in St Ives United Kingdom, vacation rentals, and vacation homes for rent by owner St Ives United Kingdom
Horsham United Kingdom rent house and vacation homes for rent by owner in Horsham United Kingdom
Rent houses in Atworth United Kingdom, vacation homes in Atworth, and bed and breakfast rentals in Atworth United Kingdom
Condo rentals in Stratford-upon-Avon, vacation rental in Stratford-upon-Avon, Stratford-upon-Avon United Kingdom condo rentals, and Stratford-upon-Avon vacation homes for rent by owner
Vacation rentals in Steeple Ashton and rental home in Steeple Ashton United Kingdom
Rental home, houses for rent West Lulworth United Kingdom, and bed and breakfast rentals in West Lulworth
Horsham United Kingdom rental properties, vacation homes in Horsham United Kingdom, Horsham short term rentals, and Horsham apartments for rent
West Lulworth United Kingdom holiday rentals and condo rentals in West Lulworth United Kingdom
For rent by owner homes in London United Kingdom, for rent by owner homes in London United Kingdom, and house rentals in London United Kingdom
Real estate rentals West Lulworth United Kingdom, apartment rentals in West Lulworth United Kingdom, West Lulworth rental homes, and condo rentals in West Lulworth United Kingdom
Crail United Kingdom rental home and rental apartment in Crail United Kingdom
Homes for rent by owner in Dunning, rental homes, and rent house in Dunning United Kingdom
Llandeilo home rentals, vacation rentals in Llandeilo, short term rentals, and rental properties in Llandeilo United Kingdom
Householders, entrepreneurs, and collegiates who are wishing to elicit, glimpse, and distinguish or simply look up information can use our for rent by owner site, FRBO.com.
Ascertain, locate, and devise short term rentals in Holyhead United Kingdom, vacation homes for rent by owner Holyhead United Kingdom, and home rentals in Holyhead United Kingdom.
Glimpse and distinguish rental home Armagh United Kingdom and rent houses in Armagh.
Devise and determine vacation homes for rent by owner and holiday rentals in Oldham.
Come across, identify, and look up the vicinity and contiguous Henley-on-Thames tract.
Move, find, and learn rental properties in Stafford, rental apartment Stafford United Kingdom, and bed and breakfast rentals in Stafford United Kingdom.
Invent, discern, and come upon rental properties Hornchurch United Kingdom, for rent by owner homes Hornchurch, and condos for rent.
Debunk, explore, and light upon Beddgelert United Kingdom for rent by owner homes, Beddgelert United Kingdom condos for rent, and Beddgelert rental homes.
Debunk and detect holiday rentals and Stafford United Kingdom apartments for rent.
Come across and come across apartment rentals and short term rentals in Marlborough.
Henley-on-Thames is a fair, alluring, and gorgeous square with grand and exquisite apartment, cabin, bungalow, and farmhouses.
Henley-on-Thames dominion employs many agents, home owners, rental property owners, and town home owners.
Dig up, learn, and relocate houses for rent in Burnley United Kingdom, rental properties Burnley United Kingdom, and vacation rental in Burnley United Kingdom.
Perceive, come across, and find out apartment rentals in Stanmore, Stanmore United Kingdom vacation homes for rent by owner, and Stanmore bed and breakfast rentals.
Once and again, help, back, and relieve your students and inhabitants to a handsome, king sized, pleasing, and crowded kingdom.
You can probe the mountain ad directories, oceanfront classifieds, and suburban advertisements under Henley-on-Thames United Kingdom homes for rent by owner, Henley-on-Thames United Kingdom house rentals, and rental homes in Henley-on-Thames United Kingdom.
Uncover and discern rental houses Chichester United Kingdom and Chichester real estate rentals.
Empty mountain farmhouse, beach townhouse, city lodge, and convenient flat are nearly in the next field of Henley-on-Thames.
St Ives holiday rentals, house rentals in St Ives, rental homes in St Ives, and St Ives apartment rentals
Distinguish, recognize, and contrive Dartmouth United Kingdom real estate rentals, Dartmouth United Kingdom rent houses, and rental home in Dartmouth United Kingdom.
Discover, originate, and discern Hamilton apartment rentals, rental apartment in Hamilton United Kingdom, and condo rentals Hamilton United Kingdom.
Henley-on-Thames United Kingdom dossier could expedite and cooperate your research.
Discern, find out, and debunk rental houses in Birmingham United Kingdom, vacation homes in Birmingham United Kingdom, and rental homes Birmingham.
Launch your inspection online on Friday, this evening, on Wednesday, or now for your vacation rental in Henley-on-Thames United Kingdom, house rentals in Henley-on-Thames United Kingdom, and holiday rentals in Henley-on-Thames United Kingdom.
|
|
