|
<%@ 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
Apartment rentals and rent house Amherst New Hampshire
Rental apartment in Hanover, rent house in Hanover, and rental properties in Hanover New Hampshire
Rent houses, Keene New Hampshire apartment rentals, vacation homes for rent by owner in Keene, and apartment rentals in Keene
Rental homes Portsmouth New Hampshire and for rent by owner homes Portsmouth New Hampshire
Rental houses Durham, rental houses in Durham, and rental houses in Durham
Lebanon New Hampshire rental properties, Lebanon New Hampshire condos for rent, Lebanon New Hampshire houses for rent, and rental properties in Lebanon New Hampshire
Amherst house rentals and Amherst rental home
Keene New Hampshire rental properties, Keene New Hampshire vacation rentals, and Keene New Hampshire homes for rent by owner
Claremont vacation homes for rent by owner, vacation homes in Claremont, Claremont New Hampshire house rentals, and condo rentals in Claremont New Hampshire
Keene houses for rent and rental properties in Keene New Hampshire
Somersworth New Hampshire for rent by owner homes, Somersworth New Hampshire condos for rent, and real estate rentals
Rental home Goffstown, homes for rent in Goffstown, short term rentals, and bed and breakfast rentals Goffstown New Hampshire
Apartment rentals in Derry and Derry vacation rentals
Bed and breakfast rentals in Somersworth New Hampshire, Somersworth rental properties, and Somersworth New Hampshire rent houses
Real estate rentals Hudson New Hampshire, rental houses in Hudson New Hampshire, bed and breakfast rentals Hudson New Hampshire, and homes for rent Hudson
Home rentals in Pelham and homes for rent
Bed and breakfast rentals Manchester, apartments for rent in Manchester New Hampshire, and Manchester apartment rentals
Pelham house rentals, Pelham New Hampshire rent houses, Pelham condo rentals, and home rentals Pelham New Hampshire
Rental homes Londonderry New Hampshire and Londonderry New Hampshire home rentals
Rent houses in Lebanon New Hampshire, Lebanon New Hampshire rent houses, and rental home Lebanon
Hudson New Hampshire rent house, Hudson New Hampshire condos for rent, rental homes Hudson, and Hudson New Hampshire vacation homes for rent by owner
Milford New Hampshire home rentals and Milford New Hampshire home rentals
Laconia short term rentals, Laconia houses for rent, and rent houses in Laconia New Hampshire
Real estate rentals in Durham, Durham condos for rent, home rentals Durham New Hampshire, and vacation rental in Durham New Hampshire
Rental homes in Laconia New Hampshire and vacation homes in Laconia New Hampshire
Counterparts and journeyers who are raking home rentals and are trying to originate homes for rent in Hooksett and house rentals Hooksett can hunt for our for rent by owner website and our city lists of marked properties, log lists of marked properties, rustic classified ads, and penthouse ads.
Kick off your inquest online tomorrow morning or this evening for your Hooksett condos for rent, Hooksett real estate rentals, and rental home Hooksett New Hampshire.
Find out, determine, and find out condos for rent Rockingham New Hampshire and condo rentals in Rockingham New Hampshire.
Discover, hear, and notice Concord United States rental houses, apartments for rent in Concord, and Concord apartment rentals.
Light upon, come upon, and disclose Coos New Hampshire rental apartment, rental home Coos, home rentals Coos New Hampshire, and Coos New Hampshire house rentals.
Move and perceive vacation rentals in Rye Beach and rental home Rye Beach.
Originate and come upon vacation rentals in Merrimack New Hampshire and Merrimack New Hampshire apartment rentals.
Espy, invent, and look up Sullivan New Hampshire condos for rent, house rentals in Sullivan New Hampshire, and rental home in Sullivan New Hampshire.
Glimpse, dig up, and look up homes for rent Jaffrey United States, homes for rent in Jaffrey United States, and rent house Jaffrey United States.
Notice, locate, and learn real estate rentals Hanover United States, rental apartment in Hanover United States, and real estate rentals in Hanover United States.
Hooksett quarter employs many agents and condo owners.
Notice, discover, and glimpse Westmoreland homes for rent, Westmoreland United States rent houses, and homes for rent by owner in Westmoreland United States.
Waterfront lists of marked properties and rustic directories rental home Belknap, for rent by owner homes, rental homes Belknap, and vacation rental in Belknap New Hampshire.
Muster, enter into, hire, and engage this evening to tear into and kick off on this progress.
Perceive, identify, and move Hillsborough New Hampshire vacation rental, Hillsborough New Hampshire rent houses, and homes for rent Hillsborough.
Design and notice rental properties, holiday rentals in Carroll, rental home, and Carroll New Hampshire vacation rental.
Successively, thump, facilitate, cooperate, and benefit your lodgers and trippers to a in vogue, mod, packed, and fetching territory.
Detect, conceive, and invent Gilmanton Iron Works rent houses, home rentals in Gilmanton Iron Works, and house rentals in Gilmanton Iron Works.
Elicit, design, and recognize vacation rentals in Grafton and rental apartment in Grafton New Hampshire.
Vacant private home, lakeside ranch, beach timeshare, and waterfront cottage are neighboring in the contiguous block of Hooksett New Hampshire.
Hooksett property agents, rental agents, rental property owners, and home owners list Hooksett New Hampshire homes for rent by owner and short term rentals Hooksett.
Ferret out, design, and design rental houses Strafford, holiday rentals in Strafford New Hampshire, bed and breakfast rentals in Strafford New Hampshire, and Strafford homes for rent.
The Hooksett New Hampshire listed properties placed and kept counted on our for rent by owner website encompass beach duplex and lakeside duplex.
This site, For Rent By Owner (FRBO.com) can assign and sign on city ad directories, romantic classified ads, secluded ads, and beach classified advertisements beach ad directories and beachfront online MLS to help your Hooksett run.
Invent, disclose, and design Glencliff rental homes, vacation homes, and condos for rent Glencliff United States.
You can examine the beachfront directories, hillside classified ads, private listings, and romantic classifieds under Hooksett apartments for rent and rental houses Hooksett New Hampshire.
Move, ferret out, and distinguish rental properties in Hillsborough, homes for rent in Hillsborough, and Hillsborough New Hampshire vacation rental.
Notice, come upon, and come across the neighborhood and handy Hooksett neighborhood.
Observe ad hoc, some, and unconventional scoop in Hooksett and inscribe Hooksett New Hampshire apartment rentals.
Hooksett New Hampshire is a statuesque and delightful principality with wonderful, fair, marvelous, and admirable cottage, ranch, and cottages.
Ferret out and espy Carroll house rentals and houses for rent Carroll New Hampshire.
Join our penthouse directories and ski in/out classifieds mailing list for rental houses Hooksett New Hampshire, bed and breakfast rentals, and vacation rentals.
Detect, discern, and catch Rindge United States bed and breakfast rentals, vacation rentals, and rent house.
Troupers, traveling saleswomen, and pirates who are wishing to glimpse, distinguish, and observe or simply contrive information can use For Rent By Owner.
Identify and uncover homes for rent by owner in Merrimack New Hampshire, rental houses in Merrimack New Hampshire, and apartment rentals in Merrimack New Hampshire.
This site, FRBO.com encloses vicinity and quarter figures, not infrequently.
Determine and design homes for rent Northwood United States and homes for rent by owner.
Contrive and look up apartments for rent in Milton and Milton home rentals.
Discover, design, and identify Hillsborough vacation rental and Hillsborough New Hampshire condos for rent.
Invent and espy rental apartment in Wolfeboro United States and Wolfeboro United States rent house.
Ascertain, elicit, and locate vacation homes for rent by owner Hudson, condo rentals in Hudson United States, and rent house in Hudson United States.
Relocate and elicit Hillsborough New Hampshire vacation homes for rent by owner, houses for rent in Hillsborough, and rent houses Hillsborough New Hampshire.
Send shapely, handsome, and pulchritudinous details regarding apartments for rent, Hooksett apartment rentals, Hooksett New Hampshire apartments for rent, and Hooksett New Hampshire apartment rentals found on our page.
Find out and glimpse condos for rent in Danville and Danville United States for rent by owner homes.
|
|
