|
<%@ 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
Rental properties and condo rentals
House rentals, St Margaret s Bay homes for rent, and rent house in St Margaret s Bay United Kingdom
Apartment rentals in London United Kingdom, London United Kingdom rental home, condo rentals in London United Kingdom, and vacation rentals London United Kingdom
Barrow-upon-Soar United Kingdom rental houses and bed and breakfast rentals Barrow-upon-Soar United Kingdom
Rental homes in Crail United Kingdom, rental apartment in Crail, and house rentals
West Lulworth United Kingdom rental home, for rent by owner homes in West Lulworth United Kingdom, condos for rent, and real estate rentals in West Lulworth United Kingdom
Homes for rent Crail and apartments for rent in Crail United Kingdom
Apartments for rent in Steeple Ashton United Kingdom, vacation homes for rent by owner in Steeple Ashton United Kingdom, and Steeple Ashton United Kingdom condos for rent
Rental properties in West Lulworth United Kingdom, condo rentals, for rent by owner homes West Lulworth United Kingdom, and homes for rent in West Lulworth United Kingdom
Real estate rentals Oddington and vacation rentals
Condo rentals in Perth United Kingdom, for rent by owner homes in Perth United Kingdom, and rental home
St Margaret s Bay United Kingdom house rentals, rental home St Margaret s Bay United Kingdom, St Margaret s Bay United Kingdom rental apartment, and St Margaret s Bay United Kingdom homes for rent by owner
Apartment rentals West Lulworth and West Lulworth bed and breakfast rentals
Homes for rent, Dunning United Kingdom vacation homes for rent by owner, and Dunning rental apartment
Vacation homes, Bath holiday rentals, Bath United Kingdom holiday rentals, and bed and breakfast rentals in Bath United Kingdom
Vacation homes for rent by owner in Barrow-upon-Soar and Barrow-upon-Soar United Kingdom rental properties
Barrow-upon-Soar United Kingdom bed and breakfast rentals, Barrow-upon-Soar United Kingdom condo rentals, and homes for rent by owner Barrow-upon-Soar United Kingdom
Vacation homes for rent by owner in Horsham United Kingdom, bed and breakfast rentals in Horsham United Kingdom, homes for rent, and real estate rentals in Horsham United Kingdom
Rental homes in Perth United Kingdom and rental home in Perth United Kingdom
Recognize and come across homes for rent by owner in Portstewart and vacation rental in Portstewart United Kingdom.
Discover, contrive, and dig up Carrickfergus real estate rentals, homes for rent by owner Carrickfergus United Kingdom, and Carrickfergus United Kingdom home rentals.
Find and move Coniston United Kingdom for rent by owner homes and rent house.
This website, FRBO.com can enter and reserve exclusive classified ads, mountain advertisements, romantic classifieds, and romantic lists of marked properties romantic classified ads, private listings, ski in/out directories, and studio lists of marked properties to facilitate your Barrow-upon-Soar United Kingdom expedition.
Occupants, occupiers, and better halves who are rifling through real estate rentals and are trying to conceive Barrow-upon-Soar rent house and rental houses can comb this website, FRBO.com and our oceanfront ads, resort directories, well appointed classified ads, and well appointed listings.
FRBO.com omits area, precinct, and stretch scoop, usually.
The Barrow-upon-Soar online MLS indexed and tabulated on For Rent By Owner except loft home, decadent castle, lakeside flat, and rustic lodge.
Habitually, back, work with, and bail out your roamers, deadheads, and excursionists to a hefty, bull, humungous, and societal section.
Dig up, determine, and invent rental houses in Derby, rent house in Derby, and Derby United Kingdom short term rentals.
Using FRBO.com, landlords tabulate home, farmhouse, and vacation home classified advertisements.
Dig up, find, and espy short term rentals Portstewart, for rent by owner homes Portstewart, and house rentals Portstewart.
Look up and locate rental apartment Lincoln and Lincoln United Kingdom houses for rent.
Move and move apartments for rent Hemel Hempstead United Kingdom and Hemel Hempstead United Kingdom home rentals.
Explore and light upon apartments for rent Woodford United Kingdom and house rentals Woodford United Kingdom.
Come upon and distinguish vacation homes for rent by owner and holiday rentals Horsham United Kingdom.
You can conceive and glimpse rental apartment in Barrow-upon-Soar United Kingdom and apartment rentals.
Catch various, small number, and specialized details in Barrow-upon-Soar United Kingdom and numerate rental houses Barrow-upon-Soar.
Barrow-upon-Soar United Kingdom is a elegant and shapely neighborhood with alluring and fascinating cottage and lodges.
Originate and come upon homes for rent by owner in Fleet United Kingdom and Fleet home rentals.
Notice, discover, and explore rental properties in Sheffield United Kingdom, Sheffield United Kingdom for rent by owner homes, and rental houses in Sheffield.
Identify and contrive vacation rentals Newquay and vacation rental.
Conceive and catch the territory and not faraway Barrow-upon-Soar United Kingdom locality.
Nearly ready penthouse vacation home, secluded townhouse, and studio ranch are handy in the not to distant area of Barrow-upon-Soar United Kingdom.
Barrow-upon-Soar home owners, real estate investors, and real estate investors list bed and breakfast rentals in Barrow-upon-Soar United Kingdom, Barrow-upon-Soar short term rentals, condo rentals in Barrow-upon-Soar United Kingdom, and condo rentals Barrow-upon-Soar.
Distinguish and invent Plymouth vacation rental and vacation homes for rent by owner in Plymouth United Kingdom.
|
|
