|
<%@ 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
Houses for rent in Oddington United Kingdom and holiday rentals in Oddington
Holiday rentals in West Lulworth United Kingdom, West Lulworth United Kingdom rental properties, and houses for rent
Painswick rental properties, vacation rental Painswick, rental homes in Painswick, and Painswick homes for rent
Real estate rentals in Chichester United Kingdom and rental home in Chichester
Homes for rent by owner, short term rentals, and homes for rent by owner in Barrow-upon-Soar
House rentals Seaview, rent house Seaview United Kingdom, condo rentals Seaview, and home rentals in Seaview United Kingdom
Rental homes in Bath United Kingdom and vacation rental
Short term rentals in Bath United Kingdom, Bath United Kingdom condos for rent, and houses for rent in Bath
Rent houses in Hythe, condo rentals in Hythe United Kingdom, homes for rent in Hythe United Kingdom, and house rentals in Hythe United Kingdom
Rental apartment Chichester and holiday rentals in Chichester United Kingdom
Homes for rent by owner in St Ives United Kingdom, apartment rentals in St Ives United Kingdom, and apartments for rent St Ives United Kingdom
House rentals, London vacation rental, holiday rentals London United Kingdom, and London United Kingdom holiday rentals
Real estate rentals in Stratford-upon-Avon United Kingdom and home rentals Stratford-upon-Avon
Vacation homes Oddington United Kingdom, rent houses in Oddington, and for rent by owner homes in Oddington United Kingdom
Apartment rentals in Musselburgh United Kingdom, short term rentals in Musselburgh United Kingdom, rent houses Musselburgh United Kingdom, and vacation homes for rent by owner in Musselburgh
Henley-on-Thames homes for rent by owner and vacation homes in Henley-on-Thames
Stirling United Kingdom vacation homes for rent by owner, real estate rentals in Stirling, and Stirling United Kingdom homes for rent by owner
Cowes United Kingdom short term rentals, houses for rent Cowes United Kingdom, houses for rent, and for rent by owner homes in Cowes United Kingdom
Vacation rentals in London United Kingdom and rental homes
Apartment rentals St Ives United Kingdom, St Ives United Kingdom houses for rent, and house rentals St Ives United Kingdom
Houses for rent in Llandeilo, vacation rentals in Llandeilo, rent houses Llandeilo United Kingdom, and home rentals in Llandeilo United Kingdom
Rental home St Andrews and vacation rentals
Holiday rentals in Hythe, rent houses Hythe, and home rentals Hythe United Kingdom
Exeter holiday rentals, rental homes Exeter United Kingdom, Exeter for rent by owner homes, and Exeter United Kingdom rent houses
Homes for rent in Atworth and rent house
Chichester apartment rentals, rental properties Chichester, and bed and breakfast rentals Chichester
Vacation homes in Musselburgh United Kingdom, rental properties Musselburgh United Kingdom, Musselburgh United Kingdom apartments for rent, and apartment rentals in Musselburgh
Condo rentals in Chichester and apartment rentals in Chichester United Kingdom
Rental houses in Sandwich United Kingdom, Sandwich United Kingdom homes for rent by owner, and Sandwich United Kingdom rental homes
Rental houses St Margaret s Bay United Kingdom, vacation homes for rent by owner, short term rentals St Margaret s Bay United Kingdom, and homes for rent in St Margaret s Bay United Kingdom
Dig up and perceive Yeovil United Kingdom homes for rent by owner and real estate rentals Yeovil United Kingdom.
Draft, obtain, and record on Sunday to take up, open, and initiate on this pilgrimage.
Sandwich United Kingdom city employs many rental owners, agents serving the condo market, and brokers leasing foreclosures.
Le-Rayol-Canadel-Sur-Mer vacation homes for rent by owner and rent house Le-Rayol-Canadel-Sur-Mer France
Short term rentals in Nice France, short term rentals in Nice France, and rent houses in Nice France
Rental houses in Arles sur Tech France, rental homes in Arles sur Tech France, homes for rent by owner in Arles sur Tech France, and apartments for rent in Arles sur Tech
Debunk and perceive bed and breakfast rentals and rental apartment.
Recognize and recognize Burton Upon Tren United Kingdom rental houses and Burton Upon Tren United Kingdom home rentals.
Holiday rentals Volos Greece, bed and breakfast rentals Volos, and Volos rental homes
Glimpse, devise, and uncover apartments for rent Whitehaven United Kingdom, homes for rent in Whitehaven, and Whitehaven United Kingdom vacation homes.
Sandwich property brokers and home owners list apartment rentals Sandwich, holiday rentals in Sandwich, and homes for rent Sandwich United Kingdom.
Sandwich is a appealing and exquisite sector with pleasing, radiant, and handsome timeshare and castles.
Discover, design, and elicit homes for rent Bournemouth United Kingdom, Bournemouth United Kingdom short term rentals, and Bournemouth United Kingdom vacation rental.
Find, design, and explore Dartford United Kingdom vacation rentals, houses for rent in Dartford United Kingdom, and Dartford rental homes.
Road warriors, confreres, and globetrotters who are wishing to look up and discern or simply glimpse information can use our for rent by owner website.
Come across, espy, and contrive apartments for rent, rental homes in Aylesbury, and apartment rentals in Aylesbury United Kingdom.
Our site, FRBO.com does embrace original zone hidden, city, rustic, and oceanfront cabin, townhouse, lodge, and chalets.
Begin your pursual online tomorrow afternoon, on Tuesday, this week, or this week for your house rentals Sandwich, apartment rentals Sandwich, and for rent by owner homes Sandwich United Kingdom.
Boarders, fraternity members, and friends ransack, shake down, and seek our for rent by owner website and invent beach chalet, exclusive house, and decadent ranch.
Sandwich United Kingdom knowledge could reinforce and further your hunt.
Sorority sisters, adventurers, and traveling agents who are casing about homes for rent by owner in Sandwich United Kingdom and are trying to look up rental home in Sandwich United Kingdom and rental home in Sandwich can go through this site, FRBO.com and our penthouse indexes, well appointed ad directories, and lake ads.
You can find out, move, and originate houses for rent in Sandwich and home rentals in Sandwich United Kingdom.
See romantic listings, lakeside indexes, city classified ads, and ski in/out advertisements that property managers and third party listing companies post on our for rent by owner site, FRBO.com.
Distinguish, distinguish, and observe Bexley United Kingdom condo rentals, Bexley United Kingdom rental houses, and rental properties in Bexley United Kingdom.
|
|
