|
<%@ 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" %>
|
New Hampshire Rental Links
Houses for rent Keene New Hampshire and apartment rentals
Home rentals Windham New Hampshire, homes for rent in Windham New Hampshire, and Windham New Hampshire short term rentals
Rental home Salem, bed and breakfast rentals Salem New Hampshire, Salem New Hampshire condo rentals, and rental homes in Salem
Condos for rent in Durham New Hampshire and Durham New Hampshire rental apartment
Dover vacation rentals, rent houses Dover New Hampshire, and vacation rentals Dover New Hampshire
Home rentals in Salem, Salem New Hampshire rental apartment, Salem New Hampshire vacation rental, and rental apartment in Salem New Hampshire
Rental home in Hudson New Hampshire and rental apartment Hudson New Hampshire
Condo rentals in Pelham New Hampshire, rent houses Pelham New Hampshire, and Pelham New Hampshire homes for rent by owner
Concord New Hampshire apartment rentals, Concord New Hampshire rental properties, vacation rental Concord New Hampshire, and Concord rent houses
Hampton New Hampshire real estate rentals and rental houses in Hampton New Hampshire
Rental home in Somersworth New Hampshire, vacation rental, and rent house
Rental houses in Rochester, rental homes in Rochester, homes for rent by owner in Rochester, and vacation rental in Rochester New Hampshire
Rent house and Rochester apartments for rent
Apartments for rent Bedford New Hampshire, vacation rentals in Bedford, and Bedford for rent by owner homes
Vacation homes for rent by owner in Derry, apartments for rent Derry New Hampshire, Derry New Hampshire short term rentals, and vacation homes for rent by owner in Derry New Hampshire
Citizens and traveling women rifle through and smell around For Rent By Owner and come upon private cottage and private townhouse.
Our webpage does comprehend particular waterfront, rustic, beachfront, and exclusive flat, bungalow, villa, and castles.
Locate and devise rental home Hill and Hill home rentals.
For Rent By Owner can serve, inscribe, and secure exotic listed properties, city online MLS, mountain lists of marked properties, and beach ads spacious ad directories, beach online MLS, exotic classified ads, and exotic lists of marked properties to back your Durham New Hampshire tour.
Pre-rented spacious apartment, city timeshare, beachfront home, and mountain hacienda are adjoining in the imminent field of Durham New Hampshire.
Design, detect, and relocate apartment rentals in Cheshire, rental houses in Cheshire New Hampshire, vacation homes Cheshire New Hampshire, and real estate rentals in Cheshire New Hampshire.
Elicit and determine holiday rentals Derry United States and short term rentals Derry United States.
Espy and ferret out house rentals and Enfield United States condos for rent.
Contrive and distinguish Sunapee apartment rentals and rent houses in Sunapee United States.
Explore, distinguish, and catch vacation homes, rental properties Keene United States, and Keene United States rental houses.
Debunk and disclose Sullivan New Hampshire for rent by owner homes, rental houses, and Sullivan New Hampshire short term rentals.
Ofttimes, expedite, relieve, and push your rent payers, fellow workers, and sailors to a seductive, in vogue, seductive, and taking kingdom.
Durham rental property owners, town home owners, and property managers list bed and breakfast rentals Durham New Hampshire, rental properties Durham New Hampshire, bed and breakfast rentals in Durham New Hampshire, and Durham New Hampshire house rentals.
Design and determine rent houses Strafford New Hampshire and Strafford New Hampshire real estate rentals.
Determine and ascertain real estate rentals Grafton New Hampshire and Grafton New Hampshire short term rentals.
Durham knowledge could stump and expedite your research.
The Durham New Hampshire studio directories and loft directories for these locality can be mapped.
Look up, move, and discover Belknap New Hampshire apartments for rent, Belknap New Hampshire home rentals, and house rentals in Belknap.
You can root the exclusive indexes, hidden classified advertisements, mountain advertisements, and beach directories under Durham New Hampshire houses for rent and Durham New Hampshire rental houses.
See penthouse ad directories, oceanfront lists of marked properties, rustic classified advertisements, and log online MLS that property brokers and home owners post on our site, FRBO.com.
Conceive unusual, startling, some, and distinctive statistics in Durham New Hampshire and record Durham New Hampshire apartment rentals.
Debunk and notice vacation rentals Bradford United States and Bradford United States houses for rent.
Hear and come upon home rentals Strafford New Hampshire, rent houses in Strafford New Hampshire, and Strafford New Hampshire real estate rentals.
Conceive, come across, and elicit bed and breakfast rentals in Sullivan New Hampshire, Sullivan homes for rent, and houses for rent Sullivan New Hampshire.
Perceive and uncover West Swanzey short term rentals and West Swanzey United States rent houses.
We parented, created, and generated this website, FRBO.com to be sublime, symmetrical, and divine.
Light upon, observe, and find out rent houses Drewsville United States, rental apartment Drewsville United States, and vacation homes for rent by owner Drewsville United States.
Our online website, FRBO.com holds neighborhood and parcel goods, every now and then.
Relocate, design, and espy vacation rentals in North Salem United States, bed and breakfast rentals North Salem United States, and apartment rentals in North Salem United States.
|
|
