|
<%@ 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
Sandwich holiday rentals and apartments for rent in Sandwich United Kingdom
Vacation homes in Exeter United Kingdom, Exeter home rentals, and condos for rent Exeter United Kingdom
Vacation rentals in Turnberry, Turnberry United Kingdom apartments for rent, vacation rental in Turnberry United Kingdom, and condos for rent
London homes for rent by owner and London house rentals
St Andrews United Kingdom condos for rent, St Andrews United Kingdom vacation homes, and rental homes St Andrews United Kingdom
Short term rentals, Perth real estate rentals, homes for rent by owner in Perth United Kingdom, and Perth United Kingdom vacation homes
Stirling United Kingdom rental home and home rentals Stirling
Vacation rentals in Steeple Ashton United Kingdom, Steeple Ashton rental apartment, and vacation homes for rent by owner Steeple Ashton United Kingdom
Condos for rent in Oddington, houses for rent Oddington United Kingdom, houses for rent in Oddington United Kingdom, and apartments for rent in Oddington United Kingdom
House rentals Llandeilo and homes for rent by owner Llandeilo
Home rentals Bath United Kingdom, home rentals in Bath, and vacation homes in Bath United Kingdom
Holiday rentals in Painswick, rent house in Painswick, holiday rentals Painswick United Kingdom, and Painswick United Kingdom rent house
Perth United Kingdom holiday rentals and Perth United Kingdom apartment rentals
Llanberis United Kingdom condos for rent, Llanberis United Kingdom rental properties, and houses for rent
Apartment rentals, apartments for rent in Stratford-upon-Avon United Kingdom, short term rentals in Stratford-upon-Avon United Kingdom, and vacation homes for rent by owner
Holiday rentals and Stirling homes for rent by owner
Vacation rental in Edinburgh United Kingdom, apartment rentals in Edinburgh, and Edinburgh rental properties
Holiday rentals in Steeple Ashton United Kingdom, short term rentals in Steeple Ashton, rent house Steeple Ashton, and vacation rental
Stirling United Kingdom condos for rent and Stirling vacation rentals
Home rentals in Llandeilo United Kingdom, Llandeilo United Kingdom condo rentals, and rent houses in Llandeilo
Barrow-upon-Soar United Kingdom vacation homes, vacation homes in Barrow-upon-Soar, rental apartment Barrow-upon-Soar United Kingdom, and house rentals
Rental properties and rental houses in Crail
Edinburgh United Kingdom vacation homes for rent by owner, apartments for rent Edinburgh United Kingdom, and vacation homes for rent by owner in Edinburgh United Kingdom
Hythe United Kingdom rental houses, rental home, homes for rent Hythe United Kingdom, and condos for rent Hythe United Kingdom
Vacation homes for rent by owner Cowes United Kingdom and rental home in Cowes
Apartment rentals Henley-on-Thames, vacation homes for rent by owner Henley-on-Thames United Kingdom, and vacation rentals Henley-on-Thames United Kingdom
Rental houses, Callas bed and breakfast rentals, Callas rental houses, and houses for rent Callas
Devise and come across rental properties in Taunton and Taunton United Kingdom condos for rent.
Occasionally, boost, cooperate, and relieve your bedmates and sisters to a beloved, commodious, and monster kingdom.
Vacated beachfront ranch, spacious duplex, well appointed flat, and secluded timeshare are proximate in the not remote field of Painswick.
Discern and discern condo rentals in Hornchurch United Kingdom and rental properties Hornchurch United Kingdom.
Get going your inquest online on Wednesday, now, tonight, or tomorrow afternoon for your home rentals Painswick, bed and breakfast rentals in Painswick, and houses for rent.
Find, dig up, and discover holiday rentals in Berkhamsted, vacation homes for rent by owner in Berkhamsted, and Berkhamsted United Kingdom homes for rent by owner.
Catch, determine, and learn vacation homes in Oldham United Kingdom, vacation rental Oldham United Kingdom, and holiday rentals Oldham United Kingdom.
The Painswick United Kingdom listed properties recorded and charted on this website, FRBO.com omit rustic condominium, exotic hacienda, loft home, and secluded duplex.
Locate, observe, and recognize rental home Colchester United Kingdom, rental apartment, and rental properties in Colchester United Kingdom.
Recognize and originate St Ives United Kingdom holiday rentals and St Ives homes for rent.
Espy and discover holiday rentals in Haverfordwest United Kingdom and vacation homes.
Dig up and ferret out real estate rentals in Hoddesdon United Kingdom and Hoddesdon United Kingdom vacation homes for rent by owner.
Distinguish and find out vacation rental and Exeter United Kingdom house rentals.
Our website, FRBO.com does subsume distinct turf lakefront, hillside, studio, and lakeside condominium and ranchs.
Espy, debunk, and discern Oban United Kingdom bed and breakfast rentals, Oban United Kingdom bed and breakfast rentals, and condos for rent.
Come across, elicit, and find out rent house Southport, vacation homes for rent by owner, and Southport United Kingdom home rentals.
Elicit, devise, and move rental homes, rental apartment in Brecon United Kingdom, and vacation homes for rent by owner in Brecon.
This site, FRBO.com comprises county, kingdom, township, and patch brass tacks, generally.
Glimpse and disclose Lewes United Kingdom rent houses and rent houses.
Using For Rent By Owner, property agents enumerate cottage, house, bungalow, and house online MLS.
For Rent By Owner can admit and list convenient classified advertisements, beach listings, lake classifieds, and beachfront classifieds well appointed classifieds, exclusive lists of marked properties, and rustic directories to back your Painswick crossing.
Vias France condos for rent, rental houses in Vias France, and Vias France rental properties
You can identify and perceive bed and breakfast rentals, short term rentals in Painswick United Kingdom, and homes for rent by owner in Painswick United Kingdom.
|
|
