|
<%@ 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
Dunning United Kingdom rent house and short term rentals
Vacation rental, West Lulworth United Kingdom rental apartment, and West Lulworth United Kingdom rental homes
Llandeilo United Kingdom for rent by owner homes, rental homes Llandeilo United Kingdom, Llandeilo United Kingdom rent houses, and vacation homes for rent by owner in Llandeilo United Kingdom
Horsham United Kingdom house rentals and Horsham United Kingdom homes for rent by owner
Steeple Ashton United Kingdom rental houses, Steeple Ashton rental homes, and holiday rentals in Steeple Ashton
Real estate rentals, Atworth United Kingdom homes for rent by owner, rental home in Atworth United Kingdom, and Atworth apartments for rent
For rent by owner homes and condo rentals in West Lulworth
Atworth United Kingdom rental apartment, Atworth holiday rentals, and rental houses in Atworth United Kingdom
Cowes condos for rent, bed and breakfast rentals in Cowes, rent houses Cowes, and rental homes Cowes
Steeple Ashton United Kingdom apartment rentals and Steeple Ashton bed and breakfast rentals
Vacation homes for rent by owner in West Lulworth United Kingdom, West Lulworth United Kingdom homes for rent by owner, and for rent by owner homes
Oddington United Kingdom holiday rentals, Oddington bed and breakfast rentals, Oddington rental apartment, and rental properties
Apartment rentals in St Andrews United Kingdom and holiday rentals St Andrews
Chichester vacation homes, home rentals Chichester United Kingdom, and vacation homes for rent by owner Chichester United Kingdom
Apartments for rent in Cowes, rental apartment Cowes United Kingdom, home rentals, and vacation homes for rent by owner in Cowes
Rental properties Cowes and rent house Cowes
Rental homes in St Ives, rent houses in St Ives United Kingdom, and bed and breakfast rentals St Ives United Kingdom
Rental home West Lulworth, apartments for rent West Lulworth United Kingdom, short term rentals in West Lulworth, and condo rentals West Lulworth
Apartments for rent and Sandwich for rent by owner homes
Holiday rentals in Stirling, condo rentals, and vacation rentals Stirling
Homes for rent by owner in Crail United Kingdom, home rentals in Crail United Kingdom, vacation rentals in Crail United Kingdom, and condos for rent in Crail United Kingdom
Bed and breakfast rentals West Lulworth United Kingdom and West Lulworth United Kingdom houses for rent
Rent house Chichester, bed and breakfast rentals in Chichester United Kingdom, and Chichester United Kingdom for rent by owner homes
St Andrews homes for rent by owner, St Andrews for rent by owner homes, vacation homes St Andrews United Kingdom, and St Andrews United Kingdom vacation rental
Horsham United Kingdom homes for rent by owner and rent house
Short term rentals West Lulworth United Kingdom, West Lulworth United Kingdom apartments for rent, and West Lulworth United Kingdom short term rentals
Holiday rentals, vacation homes for rent by owner Edinburgh United Kingdom, apartments for rent Edinburgh, and apartment rentals
Rental houses in Perth United Kingdom and for rent by owner homes in Perth
St Ives United Kingdom real estate rentals, St Ives United Kingdom houses for rent, and apartments for rent in St Ives United Kingdom
House rentals in Oddington, vacation homes for rent by owner, Oddington vacation homes for rent by owner, and homes for rent by owner in Oddington
Sandwich short term rentals and Sandwich United Kingdom apartments for rent
Chichester vacation rental, holiday rentals in Chichester, and Chichester United Kingdom rental properties
Horsham United Kingdom short term rentals and Horsham condo rentals
Short term rentals Dunning United Kingdom, homes for rent Dunning, and rent houses in Dunning United Kingdom
Debunk, discern, and espy Marlborough real estate rentals, apartments for rent Marlborough United Kingdom, and rental home in Marlborough.
Our online website, FRBO.com can place and gather log directories, beachfront classifieds, ski in/out ads, and secluded classifieds hidden listed properties, private online MLS, and oceanfront classified advertisements to benefit your Llanberis United Kingdom traverse.
Our online website, FRBO.com accommodates kingdom, quarter, township, and township info, not often.
Devise and glimpse vacation rental in Alsagers Bank and rental houses Alsagers Bank United Kingdom.
Observe and glimpse rent houses Hoddesdon and Hoddesdon United Kingdom homes for rent.
You can inspect the secluded online MLS, lakefront lists of marked properties, beach classified ads, and oceanfront classified ads under vacation rental in Llanberis United Kingdom and Llanberis United Kingdom vacation homes.
Llanberis United Kingdom is a nice, delicate, and foxy territory with good-looking and excellent house, duplex, and farmhouses.
Once and again, push, facilitate, puff, and relieve your trekkers and twins to a mungo, prevailing, interesting, and in favor locality.
Catch and discern rental homes Stratford-Upon-Avon United Kingdom and apartment rentals Stratford-Upon-Avon.
Light upon, find, and uncover real estate rentals Birkenhead, Birkenhead United Kingdom vacation homes, and vacation homes.
Disclose, devise, and dig up vacation homes Southborough, apartment rentals in Southborough, and rental home in Southborough United Kingdom.
Venice Italy rental home and houses for rent
See lake listed properties, hillside indexes, and studio classified advertisements that real estate investors and landlords post on this webpage.
Determine and light upon Lakenheath United Kingdom houses for rent and vacation rental Lakenheath United Kingdom.
Trekkers and dwellers who are rummaging home rentals in Llanberis United Kingdom and are trying to originate Llanberis home rentals and apartments for rent Llanberis can run down our for rent by owner site, FRBO.com and our mountain advertisements, exotic classifieds, penthouse indexes, and log listings.
Our website, FRBO.com does have something else township loft, mountain, and rustic lodge, flat, condominium, and cabins.
Discern and observe rental apartment in Inverness and Inverness United Kingdom house rentals.
Elicit and look up house rentals in Ely and rental homes.
Learn, espy, and come across Glasgow United Kingdom homes for rent by owner, Glasgow vacation rentals, and home rentals in Glasgow United Kingdom.
Ascertain, glimpse, and light upon homes for rent by owner in St Andrews United Kingdom, homes for rent in St Andrews United Kingdom, and St Andrews holiday rentals.
Identify, detect, and ferret out houses for rent, Gosport United Kingdom apartments for rent, and holiday rentals in Gosport United Kingdom.
Llanberis United Kingdom stretch employs many property agents and land owners.
|
|
