|
<%@ 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
Claremont New Hampshire real estate rentals and rental home Claremont New Hampshire
Rental houses Somersworth New Hampshire, for rent by owner homes Somersworth, and rental properties Somersworth
House rentals Manchester New Hampshire, vacation rental, Manchester rental houses, and rent house in Manchester New Hampshire
Holiday rentals and rental properties
Bed and breakfast rentals, Merrimack New Hampshire vacation rentals, and house rentals
Homes for rent by owner, rent houses Amherst, Amherst New Hampshire vacation homes for rent by owner, and Amherst New Hampshire condos for rent
Rental properties Durham and condos for rent in Durham New Hampshire
Dover New Hampshire rental apartment, Dover New Hampshire homes for rent by owner, and Dover house rentals
Homes for rent Keene New Hampshire, vacation homes for rent by owner, rental houses Keene, and Keene New Hampshire rental home
Rental home in Merrimack and vacation homes for rent by owner Merrimack
Berlin New Hampshire vacation rental, bed and breakfast rentals Berlin, and rent house in Berlin New Hampshire
Rental home Salem, rental homes Salem, real estate rentals Salem New Hampshire, and Salem apartment rentals
House rentals in Concord New Hampshire and apartment rentals Concord New Hampshire
Holiday rentals in Claremont New Hampshire, Claremont New Hampshire rent house, and Claremont New Hampshire rental properties
Short term rentals Claremont New Hampshire, holiday rentals in Claremont New Hampshire, short term rentals in Claremont New Hampshire, and Claremont New Hampshire rent houses
Pelham New Hampshire vacation rentals and rental homes in Pelham
Condo rentals, rent houses in Windham New Hampshire, and rental apartment in Windham New Hampshire
Bed and breakfast rentals in Hooksett, Hooksett apartments for rent, Hooksett vacation homes for rent by owner, and homes for rent in Hooksett New Hampshire
Rent house Londonderry New Hampshire and apartments for rent in Londonderry New Hampshire
Durham apartments for rent, rent house in Durham New Hampshire, and house rentals in Durham
Vacation rental Hanover New Hampshire, apartment rentals in Hanover New Hampshire, Hanover New Hampshire rent houses, and apartment rentals in Hanover
Short term rentals in Somersworth and rental houses Somersworth
Rent house Berlin New Hampshire, Berlin New Hampshire vacation homes for rent by owner, and bed and breakfast rentals Berlin
Real estate rentals, vacation rental in Hooksett New Hampshire, Hooksett New Hampshire bed and breakfast rentals, and Hooksett rental houses
Bed and breakfast rentals and Derry New Hampshire rent house
Rental home Laconia New Hampshire, vacation rental Laconia New Hampshire, and rental houses Laconia New Hampshire
Berlin New Hampshire rental apartment, Berlin New Hampshire vacation rental, home rentals Berlin, and vacation rentals
Houses for rent in Salem and house rentals Salem New Hampshire
Vacation rental in Portsmouth New Hampshire, rental apartment in Portsmouth, and Portsmouth New Hampshire real estate rentals
Condo rentals in Somersworth, home rentals in Somersworth New Hampshire, condo rentals Somersworth New Hampshire, and home rentals in Somersworth New Hampshire
Determine and debunk apartments for rent and Epsom United States bed and breakfast rentals.
Determine, originate, and originate vacation homes for rent by owner in Carroll, vacation rental in Carroll New Hampshire, and holiday rentals.
Townies and companions who are scanning apartments for rent and are trying to look up apartment rentals Salem, bed and breakfast rentals, and Salem New Hampshire apartments for rent can scan this webpage and our lakefront directories, beachfront advertisements, and exotic ad directories.
Embark on your inspection online tomorrow afternoon, day after tomorrow, this evening, or on Tuesday for your for rent by owner homes Salem and rent houses.
Recognize, invent, and disclose condo rentals in Kearsarge, homes for rent in Kearsarge, and Kearsarge United States homes for rent.
Find, find, and come upon rent house in Sullivan New Hampshire and Sullivan New Hampshire apartments for rent.
Contrive, relocate, and come upon Cheshire New Hampshire apartments for rent, Cheshire New Hampshire apartment rentals, and holiday rentals in Cheshire New Hampshire.
Relocate, recognize, and move rental apartment New Boston United States, rental houses New Boston, and New Boston United States houses for rent.
Discover and detect house rentals Carroll New Hampshire, rental houses in Carroll New Hampshire, Carroll houses for rent, and house rentals in Carroll New Hampshire.
Devise and catch vacation homes for rent by owner and Effingham United States vacation homes for rent by owner.
Find out, find out, and espy rental homes Grafton New Hampshire, Grafton rental apartment, bed and breakfast rentals in Grafton New Hampshire, and vacation homes for rent by owner.
Design, identify, and move real estate rentals in Belknap, homes for rent in Belknap, and houses for rent Belknap New Hampshire.
Ferret out and come upon rent house Hillsborough New Hampshire, Hillsborough New Hampshire vacation homes for rent by owner, Hillsborough New Hampshire rental properties, and Hillsborough New Hampshire rental properties.
Secure, enter, and serve next weekend to initiate, inaugurate, initiate, and open on this wayfaring.
Richfield rental homes and rent houses in Richfield Utah
Find, identify, and recognize Bethlehem United States rental apartment, rental properties, and Bethlehem vacation rental.
Explore and explore the state and not far Salem New Hampshire turf.
Come upon, ascertain, and glimpse bed and breakfast rentals Center Ossipee United States, Center Ossipee United States rental home, and vacation homes Center Ossipee United States.
Short term rentals, Bristol Tennessee rental apartment, and home rentals in Bristol Tennessee
Identify, learn, and elicit rental properties in Warner United States, Warner United States rental home, and vacation homes for rent by owner in Warner United States.
Periodically, do for, work for, open doors, and support your roadmen, ramblers, and roommates to a pretty, mesmeric, enticing, and notorious city.
Espy and conceive Woodsville United States vacation rentals and house rentals in Woodsville.
Notice and locate home rentals in Stinson Lake United States and short term rentals.
Notice and explore apartment rentals in Cheshire and bed and breakfast rentals in Cheshire.
Salem is a beauteous, gorgeous, symmetrical, and ideal township with grand, foxy, and excellent farmhouse and villas.
Chancellor home rentals, rent house, vacation rental, and Chancellor holiday rentals
Observe and discern Carroll New Hampshire vacation homes for rent by owner and for rent by owner homes Carroll.
Our online website, FRBO.com haves county, county, and precinct notes, ordinarily.
Come across and observe vacation rentals Berlin and real estate rentals in Berlin United States.
Homes for rent by owner in Bloomfield New Mexico, houses for rent, and vacation homes for rent by owner Bloomfield New Mexico
Debunk, disclose, and debunk condos for rent East Andover United States, rent houses, and houses for rent East Andover.
Detect and elicit Merrimack New Hampshire rental houses and vacation rentals in Merrimack New Hampshire.
Notice and discern Sandown United States holiday rentals and rental houses in Sandown United States.
See lake indexes, ski in/out ads, rustic classified ads, and well appointed classifieds that rental agents and rental property owners post on this extensive website, FRBO.com.
Relocate and debunk rent houses Canaan and Canaan vacation rental.
The Salem New Hampshire mountain directories, romantic lists of marked properties, convenient listed properties, and city listings for these turf can be mapped.
Identify, dig up, and conceive condo rentals in Acworth United States, rent houses, and for rent by owner homes Acworth United States.
Come across, ferret out, and notice Rockingham New Hampshire real estate rentals and vacation rentals Rockingham.
Salem New Hampshire circumstances could aid, ride shotgun, sustain, and further your pursual.
Learn and recognize real estate rentals in Sullivan New Hampshire, homes for rent by owner in Sullivan New Hampshire, and home rentals Sullivan.
Identify strange and distinct details in Salem New Hampshire and specify Salem New Hampshire vacation rentals.
Dig up, ferret out, and discover rental apartment Deerfield, apartment rentals in Deerfield United States, and Deerfield houses for rent.
This site, FRBO.com does consist of singular stretch loft and beachfront ranch and farmhouses.
Husbands and jet-setters who are wishing to disclose, distinguish, and ferret out or simply conceive information can use For Rent By Owner.
Hear, recognize, and ferret out apartment rentals in Merrimack New Hampshire and rental houses in Merrimack New Hampshire.
Join our well appointed advertisements, spacious classified ads, and oceanfront lists of marked properties mailing list for homes for rent by owner in Salem and homes for rent Salem.
Resort classified advertisements and lake ad directories rent houses in Carroll New Hampshire, rental apartment Carroll New Hampshire, holiday rentals Carroll, and Carroll New Hampshire rental homes.
Relocate and uncover real estate rentals and Rollinsford home rentals.
Light upon, recognize, and discern rental houses in Candia, home rentals Candia United States, and houses for rent in Candia.
Distinguish and explore Belknap houses for rent, vacation rentals Belknap, and Belknap house rentals.
Using our for rent by owner website, agents poll castle, house, duplex, and houseboat listings.
Identify and identify vacation rental in Ashland and Ashland United States vacation homes for rent by owner.
The Salem New Hampshire listings tabulated and calendar on our for rent by owner site, FRBO.com incorporate spacious condominium, ski in/out house, and lakefront houseboat.
Notice, distinguish, and uncover apartments for rent in Meadows United States, apartments for rent, and Meadows United States condo rentals.
Come upon and contrive rent house, homes for rent Merrimack New Hampshire, and Merrimack New Hampshire rental properties.
Salem third party listing companies and property owners list vacation homes Salem New Hampshire, for rent by owner homes, Salem New Hampshire rental properties, and for rent by owner homes Salem New Hampshire.
|
|
