|
<%@ 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
Home rentals in St Andrews United Kingdom and St Andrews United Kingdom holiday rentals
Turnberry rental apartment, homes for rent by owner Turnberry, and short term rentals in Turnberry United Kingdom
Cowes United Kingdom homes for rent by owner, home rentals Cowes United Kingdom, rent houses in Cowes United Kingdom, and short term rentals Cowes United Kingdom
St Andrews homes for rent and St Andrews homes for rent by owner
Exeter United Kingdom real estate rentals, Exeter condo rentals, and vacation rental
Llanberis vacation rentals, vacation rental, rental apartment in Llanberis United Kingdom, and apartment rentals in Llanberis
Vacation homes for rent by owner Steeple Ashton and Steeple Ashton United Kingdom rental apartment
Barrow-upon-Soar United Kingdom houses for rent, Barrow-upon-Soar United Kingdom rent houses, and rental homes Barrow-upon-Soar
Homes for rent by owner West Lulworth, condos for rent in West Lulworth, rental homes in West Lulworth United Kingdom, and for rent by owner homes West Lulworth United Kingdom
Real estate rentals and St Margaret s Bay short term rentals
Vacation rental Perth United Kingdom, Perth United Kingdom apartment rentals, and rent houses
Perth United Kingdom real estate rentals, Perth house rentals, rental properties in Perth United Kingdom, and Perth United Kingdom homes for rent
For rent by owner homes in Hythe United Kingdom and Hythe house rentals
Home rentals, rental apartment in Perth, and short term rentals in Perth
Homes for rent in Exeter United Kingdom, Exeter United Kingdom rental homes, short term rentals in Exeter United Kingdom, and rent houses
Real estate rentals in Bath United Kingdom and rental houses
For rent by owner homes in Oddington, rent houses in Oddington United Kingdom, and rental properties in Oddington
Bed and breakfast rentals in Dunning United Kingdom, Dunning United Kingdom vacation rentals, home rentals, and Dunning United Kingdom vacation homes
Short term rentals Stratford-upon-Avon United Kingdom and apartments for rent in Stratford-upon-Avon
Rental properties Hythe United Kingdom, vacation homes for rent by owner, and Hythe United Kingdom condo rentals
Holiday rentals in Seaview United Kingdom, houses for rent in Seaview, Seaview home rentals, and vacation rentals Seaview
Dunning houses for rent and Dunning United Kingdom holiday rentals
St Andrews condo rentals, rent houses St Andrews, and rental homes
Stirling vacation rentals, Stirling United Kingdom short term rentals, Stirling United Kingdom rental home, and rent houses Stirling
Condo rentals Stratford-upon-Avon United Kingdom and vacation rental in Stratford-upon-Avon
Home rentals, houses for rent in Sandwich United Kingdom, and vacation rentals in Sandwich
Rental homes Stratford-upon-Avon, vacation rentals in Stratford-upon-Avon, rent houses in Stratford-upon-Avon, and Stratford-upon-Avon United Kingdom rental houses
Rent houses in St Margaret s Bay United Kingdom and St Margaret s Bay United Kingdom home rentals
Apartments for rent in Sandwich United Kingdom, Sandwich United Kingdom rental apartment, and Sandwich United Kingdom for rent by owner homes
For rent by owner homes in Crail United Kingdom, Crail rental home, Crail United Kingdom real estate rentals, and Crail United Kingdom vacation rental
Bed and breakfast rentals and Stratford-upon-Avon holiday rentals
Join our well appointed listed properties, hillside indexes, convenient directories, and penthouse ads mailing list for vacation homes for rent by owner, Llandeilo United Kingdom rental homes, and house rentals in Llandeilo United Kingdom.
Invent and hear Machynlleth United Kingdom rental home and homes for rent Machynlleth.
Find out, espy, and move real estate rentals, holiday rentals, and rental apartment Cheltenham.
Using For Rent By Owner, property brokers peg villa, ranch, and townhouse ads.
Rental apartment Cooraclare, condos for rent in Cooraclare, and rental properties Cooraclare Ireland
Amandola Italy bed and breakfast rentals, Amandola Italy holiday rentals, house rentals in Amandola Italy, and vacation homes for rent by owner
Almost ready to be occupied loft duplex, beach apartment, beach hacienda, and exotic timeshare are approaching in the handy stretch of Llandeilo United Kingdom.
The Llandeilo United Kingdom mountain advertisements, lakeside listed properties, and penthouse advertisements for these can be mapped.
Originate your perquisition online this week, on Monday, tomorrow afternoon, or on Friday for your house rentals Llandeilo United Kingdom, Llandeilo bed and breakfast rentals, and vacation homes for rent by owner Llandeilo.
Come across and originate vacation homes in Harlow United Kingdom and homes for rent by owner in Harlow.
Invent, notice, and find apartments for rent Church Stretton, Church Stretton homes for rent by owner, and rental home in Church Stretton United Kingdom.
Come upon, explore, and determine home rentals in Cladich United Kingdom, Cladich United Kingdom vacation homes, and vacation homes in Cladich.
Homes for rent by owner in Como Italy and real estate rentals in Como
Find, glimpse, and uncover Stockport United Kingdom rental properties, Stockport United Kingdom condo rentals, and rental apartment.
Disclose and notice Haverfordwest United Kingdom home rentals and vacation homes Haverfordwest United Kingdom.
Find out and espy homes for rent in Romford and Romford United Kingdom vacation homes.
Llandeilo facts could support, sustain, and assist your inspection.
Condos for rent in Lavagna Italy and homes for rent Lavagna
Penedo Portugal rent house, Penedo Portugal rental houses, rental properties in Penedo, and rent houses in Penedo Portugal
Hear and come upon Birmingham United Kingdom apartments for rent and bed and breakfast rentals in Birmingham United Kingdom.
See rustic classified advertisements and hidden lists of marked properties that rental owners and landlords post on our website, FRBO.com.
Send pretty, stunning, graceful, and appealing notes regarding apartments for rent in Llandeilo United Kingdom, rent houses in Llandeilo United Kingdom, Llandeilo United Kingdom rental properties, and homes for rent by owner Llandeilo found on this website, FRBO.com.
Engage, enroll, and procure in the next few days to launch, lead off, get cracking, and get cracking on this trek.
Move, detect, and locate Glastonbury vacation rental, homes for rent by owner Glastonbury United Kingdom, and Glastonbury United Kingdom short term rentals.
Locate and light upon Staines condo rentals and rental homes Staines.
|
|
