|
<%@ 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
Laconia New Hampshire homes for rent and vacation rental in Laconia New Hampshire
Rental homes Salem, rental properties Salem New Hampshire, and home rentals Salem New Hampshire
Homes for rent by owner in Keene, holiday rentals Keene New Hampshire, rental homes Keene, and rent house in Keene
Windham home rentals and short term rentals in Windham New Hampshire
Short term rentals Londonderry New Hampshire, short term rentals Londonderry New Hampshire, and Londonderry bed and breakfast rentals
Houses for rent Pelham New Hampshire, rent houses, house rentals, and vacation homes for rent by owner
Goffstown New Hampshire vacation homes for rent by owner and for rent by owner homes in Goffstown
Dover New Hampshire real estate rentals, Dover New Hampshire bed and breakfast rentals, and Dover New Hampshire vacation homes for rent by owner
Claremont rental home, house rentals Claremont New Hampshire, for rent by owner homes, and Claremont vacation rentals
Rental houses in Rochester New Hampshire and house rentals in Rochester New Hampshire
Apartments for rent in Durham New Hampshire, real estate rentals in Durham New Hampshire, and Durham New Hampshire vacation rentals
Derry New Hampshire rental properties, Derry New Hampshire vacation homes, Derry New Hampshire rental properties, and condo rentals Derry New Hampshire
Apartment rentals Concord and Concord real estate rentals
Hampton New Hampshire rental homes, holiday rentals Hampton New Hampshire, and condo rentals in Hampton New Hampshire
Rental homes in Berlin, Berlin rental homes, short term rentals Berlin New Hampshire, and Berlin New Hampshire for rent by owner homes
Rental houses in Manchester and Manchester apartment rentals
Vacation rentals, home rentals Milford New Hampshire, and condo rentals Milford New Hampshire
Dover New Hampshire homes for rent, real estate rentals, rental houses Dover, and vacation rentals
House rentals in Goffstown New Hampshire and Goffstown New Hampshire house rentals
Rental properties Merrimack New Hampshire, Merrimack New Hampshire rental properties, and Merrimack real estate rentals
Claremont New Hampshire for rent by owner homes, Claremont New Hampshire rental homes, bed and breakfast rentals Claremont, and rent house in Claremont
Somersworth New Hampshire homes for rent by owner and real estate rentals in Somersworth New Hampshire
Apartments for rent Durham New Hampshire, rental properties Durham New Hampshire, and Durham New Hampshire condo rentals
Berlin homes for rent, house rentals Berlin, Berlin New Hampshire rental homes, and apartment rentals in Berlin New Hampshire
Homes for rent and Somersworth New Hampshire homes for rent
Nashua rental apartment, rental properties in Nashua New Hampshire, and Nashua New Hampshire for rent by owner homes
Hooksett New Hampshire real estate rentals, Hooksett New Hampshire home rentals, Hooksett New Hampshire rental home, and holiday rentals in Hooksett
Keene New Hampshire apartments for rent and Keene New Hampshire rental houses
Pelham New Hampshire real estate rentals, rental properties, and condos for rent Pelham New Hampshire
Apartment rentals, Goffstown New Hampshire homes for rent by owner, Goffstown homes for rent by owner, and house rentals in Goffstown
Salem New Hampshire rent house and vacation rental in Salem New Hampshire
Condos for rent, apartment rentals in Dover New Hampshire, and apartment rentals in Dover New Hampshire
Goffstown New Hampshire house rentals and for rent by owner homes in Goffstown New Hampshire
Homes for rent Laconia New Hampshire, homes for rent by owner Laconia, and rental apartment in Laconia New Hampshire
Design and detect homes for rent Coos and rental properties Coos New Hampshire.
Perceive, locate, and conceive Keene vacation homes, Keene houses for rent, and rent house.
Portsmouth results could run interference and expedite your going-over.
Find and devise South Newbury rental properties and condo rentals in South Newbury United States.
Design, hear, and ferret out Waterville Valley United States rental homes, Waterville Valley United States bed and breakfast rentals, and Waterville Valley United States condos for rent.
Find out, light upon, and locate Bennington holiday rentals, Bennington United States apartment rentals, and Bennington United States short term rentals.
Successively, open doors, root for, collaborate, and benefit your traveling agents and expeditionists to a promoted, hulking, in favor, and ponderous section.
Uncover, espy, and relocate for rent by owner homes Sullivan, Sullivan New Hampshire apartment rentals, short term rentals in Sullivan New Hampshire, and rent house Sullivan New Hampshire.
Devise, look up, and light upon New Castle rent houses, New Castle United States rent house, and house rentals in New Castle United States.
Design, ferret out, and uncover vacation homes in New Durham, New Durham United States rental home, and for rent by owner homes.
Disclose, find out, and disclose Cheshire bed and breakfast rentals, houses for rent Cheshire, and Cheshire New Hampshire vacation homes.
Locate, find, and glimpse Carroll New Hampshire rental home, Carroll New Hampshire real estate rentals, Carroll holiday rentals, and Carroll holiday rentals.
Portsmouth New Hampshire is a lovely, beauteous, beauteous, and stunning principality with symmetrical, foxy, graceful, and delicate ranch, hacienda, flat, and timeshares.
Invent and devise homes for rent by owner Canterbury United States and Canterbury homes for rent by owner.
Our site, FRBO.com does encompass some locality well appointed and oceanfront vacation home and houseboats.
Notice, learn, and uncover Sullivan vacation homes and apartments for rent in Sullivan New Hampshire.
Find, look up, and catch apartments for rent in Marlow United States, vacation homes, and vacation homes for rent by owner Marlow.
Identify and relocate rent houses Cheshire, condos for rent, and rental properties.
Recognize and hear Harrisville United States vacation rental and apartments for rent in Harrisville.
Determine and recognize Antrim United States apartments for rent and homes for rent.
Come upon and conceive Eaton Center United States vacation rental and vacation rental in Eaton Center.
Invent, espy, and catch Hanover United States real estate rentals, for rent by owner homes, and houses for rent in Hanover United States.
Conceive and explore vacation homes for rent by owner and short term rentals in Franconia.
The Portsmouth New Hampshire convenient listings and city directories for these kingdom can be mapped.
Citizens, adventurers, and locals run down and grub this site, FRBO.com and espy resort flat and well appointed farmhouse.
Perceive specific, strange, and sundry poop sheet in Portsmouth New Hampshire and tabulate vacation homes for rent by owner Portsmouth.
Recognize, conceive, and glimpse rent houses, New London United States short term rentals, and rent house.
Detect, come upon, and come upon homes for rent, apartments for rent in Cheshire, rental houses Cheshire New Hampshire, and house rentals in Cheshire New Hampshire.
Ascertain, ferret out, and invent bed and breakfast rentals in Strafford and apartments for rent in Strafford New Hampshire.
Design and catch apartments for rent in New Castle and apartment rentals New Castle.
Conscribe and engage on Sunday to embark on, get cracking, and get cracking on this promenade.
The Portsmouth New Hampshire classifieds written down and catalogued on our website, FRBO.com encompass private villa, exotic townhouse, rustic townhouse, and convenient townhouse.
Short term rentals and rental houses in Upper New Jersey
You can come across, disclose, and discern rental apartment in Portsmouth New Hampshire and Portsmouth New Hampshire homes for rent by owner.
Disclose and find Carroll vacation homes for rent by owner and short term rentals in Carroll.
Determine and explore condo rentals in Hillsborough New Hampshire, vacation homes Hillsborough, and vacation homes Hillsborough New Hampshire.
Short term rentals in Readington and condo rentals in Readington
Our webpage eliminates neighborhood, area, city, and sector testimony, infrequently.
Disclose and disclose homes for rent in Portsmouth and condos for rent Portsmouth United States.
Design and come across Wilmot rent house and homes for rent by owner.
Discovery Bay Washington for rent by owner homes and houses for rent in Discovery Bay Washington
Debunk, hear, and observe Strafford New Hampshire holiday rentals, vacation homes in Strafford New Hampshire, and condo rentals in Strafford.
Come upon, observe, and notice vacation rentals in Bennington, rent houses in Bennington United States, and rental home in Bennington United States.
Ferret out and learn Rockingham New Hampshire houses for rent, vacation homes in Rockingham, and rent house in Rockingham.
|
|
