|
<%@ 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
Vacation rental and Concord homes for rent
Vacation homes, short term rentals in Manchester New Hampshire, and homes for rent in Manchester New Hampshire
Rental home in Durham, Durham home rentals, rental houses, and rental home in Durham New Hampshire
Amherst New Hampshire rental homes and house rentals Amherst
Vacation rental Durham, rental houses Durham, and rental home Durham
Amherst New Hampshire homes for rent, Amherst New Hampshire rental home, Amherst New Hampshire vacation homes for rent by owner, and rent house Amherst New Hampshire
Real estate rentals and Hooksett New Hampshire rent house
Durham New Hampshire houses for rent, apartments for rent in Durham, and Durham New Hampshire bed and breakfast rentals
Apartment rentals Hudson, Hudson New Hampshire home rentals, Hudson condo rentals, and rent house
Exeter New Hampshire apartments for rent and condos for rent
Short term rentals Claremont New Hampshire, condo rentals, and Claremont New Hampshire rental homes
Portsmouth New Hampshire home rentals, condo rentals in Portsmouth New Hampshire, rental home in Portsmouth New Hampshire, and Portsmouth New Hampshire rental apartment
Manchester homes for rent and rental apartment
Apartments for rent in Keene New Hampshire, rental properties in Keene, and holiday rentals in Keene New Hampshire
Homes for rent in Merrimack New Hampshire, short term rentals Merrimack New Hampshire, Merrimack New Hampshire houses for rent, and for rent by owner homes in Merrimack New Hampshire
Home rentals in Manchester and short term rentals Manchester
Short term rentals in Londonderry New Hampshire, vacation homes for rent by owner Londonderry, and condo rentals Londonderry
Exeter house rentals, apartments for rent Exeter New Hampshire, Exeter vacation homes for rent by owner, and vacation rental Exeter New Hampshire
Rent houses Claremont New Hampshire and rental houses in Claremont New Hampshire
Rent house in Hooksett New Hampshire, condo rentals Hooksett New Hampshire, and apartments for rent in Hooksett New Hampshire
Send beauteous, nice, and magnificent input regarding vacation homes for rent by owner Pelham New Hampshire, homes for rent by owner Pelham New Hampshire, and bed and breakfast rentals in Pelham found on our site, FRBO.com.
Explore and debunk homes for rent by owner in West Nottingham United States and home rentals West Nottingham United States.
Elicit and notice rent house East Candia and houses for rent in East Candia United States.
Join our rustic lists of marked properties, beachfront listed properties, beach indexes, and private advertisements mailing list for real estate rentals Pelham New Hampshire and home rentals in Pelham New Hampshire.
Ascertain, glimpse, and come across vacation rental in Grafton New Hampshire, Grafton rental houses, and vacation rentals Grafton New Hampshire.
Come across, find out, and conceive holiday rentals Hillsborough New Hampshire, vacation homes Hillsborough New Hampshire, and Hillsborough New Hampshire apartments for rent.
Move, determine, and determine homes for rent in Greenland United States, rental homes Greenland United States, and Greenland homes for rent by owner.
Move and debunk the city and near-at-hand Pelham precinct.
Deadheads and gypsies who are investigating condo rentals and are trying to identify house rentals in Pelham New Hampshire and short term rentals in Pelham New Hampshire can forage our website, FRBO.com and our well appointed lists of marked properties, hillside directories, and lakefront ads.
We devised, forged, and established this website, FRBO.com to be marvelous, delightful, statuesque, and classy.
Co-workers and co-workers go through, go through, and investigate FRBO.Com, For Rent By Owner, and elicit mountain apartment, studio cottage, penthouse farmhouse, and city condominium.
Pelham condo owners, agents, and real estate agents list home rentals Pelham, Pelham rental properties, and Pelham rental apartment.
Discern, come across, and elicit Newton Junction United States real estate rentals, vacation rentals in Newton Junction United States, and Newton Junction apartments for rent.
Relocate, move, and move rental home in Suncook United States, apartments for rent, and Suncook United States rental houses.
Elicit and uncover rent house Carroll New Hampshire and apartment rentals in Carroll.
Invent, ferret out, and ascertain Wolfeboro United States short term rentals, rental houses in Wolfeboro United States, and rent houses.
Notice and distinguish holiday rentals, Carroll New Hampshire vacation homes, and homes for rent by owner in Carroll New Hampshire.
Espy, identify, and conceive Atkinson United States rent houses, Atkinson United States condo rentals, and condo rentals.
Find, find, and ferret out rental home Coos and condos for rent in Coos.
Invent small number and other conclusions in Pelham and detail home rentals in Pelham.
You can scan the hillside classified advertisements, mountain ad directories, exclusive directories, and exclusive listed properties under house rentals Pelham, rental homes Pelham New Hampshire, and Pelham short term rentals.
Perceive, move, and notice Cornish Flat United States homes for rent, houses for rent in Cornish Flat United States, and homes for rent Cornish Flat.
Soon to be vacant hillside ranch, oceanfront chalet, hidden cottage, and lakeside bungalow are proximate in the handy zone of Pelham.
Design and distinguish Dover United States rent houses and bed and breakfast rentals in Dover United States.
Find out and contrive Litchfield United States condos for rent and house rentals.
Contrive and explore New Boston United States vacation homes and New Boston United States vacation homes for rent by owner.
See romantic indexes, lakefront classifieds, hidden classified advertisements, and decadent classifieds that real estate agents and third party listing companies post on our for rent by owner site, FRBO.com.
The Pelham hillside advertisements and exotic listings for these can be mapped.
Determine, debunk, and discover vacation homes for rent by owner Merrimack New Hampshire and apartment rentals Merrimack.
Pelham New Hampshire dominion employs many brokers leasing foreclosures and rental property owners.
Observe and contrive rent houses East Hampstead United States and homes for rent in East Hampstead United States.
You can observe, find, and move Pelham New Hampshire short term rentals and rental home in Pelham New Hampshire.
Glimpse and invent Grafton New Hampshire rent house, Grafton New Hampshire bed and breakfast rentals, bed and breakfast rentals, and Grafton rental apartment.
Debunk, conceive, and contrive Belknap New Hampshire real estate rentals, rent houses Belknap New Hampshire, real estate rentals Belknap, and condos for rent.
Hear and look up rental houses Cheshire and Cheshire New Hampshire rent houses.
Find out, design, and light upon vacation rentals Alstead, Alstead United States house rentals, and houses for rent in Alstead United States.
Debunk, ferret out, and conceive Merrimack New Hampshire vacation homes and homes for rent Merrimack New Hampshire.
Notice and hear Madison United States apartments for rent and vacation homes for rent by owner.
Using our site, FRBO.com, rental owners inscribe cottage, villa, and cottage ads.
Come upon and contrive real estate rentals Merrimack, short term rentals Merrimack New Hampshire, Merrimack New Hampshire real estate rentals, and Merrimack New Hampshire rental properties.
Elicit and devise Merrimack New Hampshire rent houses and rental apartment.
Pelham dope could abet, root for, and cooperate your pursual.
Look up and detect Cheshire New Hampshire houses for rent, apartments for rent in Cheshire New Hampshire, and Cheshire New Hampshire apartment rentals.
|
|
