|
<%@ 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
Rental apartment Londonderry New Hampshire and house rentals in Londonderry New Hampshire
Rental properties in Merrimack New Hampshire, Merrimack houses for rent, and rental homes in Merrimack New Hampshire
Durham New Hampshire condo rentals, Durham houses for rent, rental apartment, and house rentals in Durham New Hampshire
Homes for rent in Hooksett and rental home Hooksett
Vacation homes Portsmouth, Portsmouth New Hampshire rental properties, and vacation rentals Portsmouth
Windham apartments for rent, rent house in Windham New Hampshire, short term rentals, and Windham New Hampshire real estate rentals
Manchester New Hampshire rental apartment and rent houses Manchester
Vacation homes in Hooksett, Hooksett New Hampshire rent house, and house rentals Hooksett
Salem New Hampshire rental houses, home rentals in Salem, Salem New Hampshire rent house, and vacation homes for rent by owner Salem
Short term rentals in Dover New Hampshire and rent houses in Dover New Hampshire
Laconia New Hampshire bed and breakfast rentals, apartments for rent in Laconia New Hampshire, and rental houses in Laconia New Hampshire
Goffstown vacation homes, short term rentals Goffstown New Hampshire, Goffstown New Hampshire rent house, and Goffstown New Hampshire condos for rent
Real estate rentals Manchester and rental home in Manchester New Hampshire
Homes for rent in Somersworth New Hampshire, rental homes in Somersworth New Hampshire, and apartments for rent in Somersworth
Exeter New Hampshire homes for rent, rental home Exeter New Hampshire, Exeter New Hampshire rental home, and vacation homes
Exeter New Hampshire house rentals and Exeter New Hampshire rental properties
Rent houses in Laconia New Hampshire, bed and breakfast rentals Laconia, and Laconia rent house
Portsmouth New Hampshire rent houses, Portsmouth New Hampshire real estate rentals, vacation homes for rent by owner in Portsmouth New Hampshire, and vacation rentals Portsmouth New Hampshire
Real estate rentals Hanover New Hampshire and Hanover rental homes
Bed and breakfast rentals in Londonderry New Hampshire, Londonderry New Hampshire home rentals, and holiday rentals
Rental apartment Dover New Hampshire, for rent by owner homes in Dover New Hampshire, houses for rent, and vacation homes in Dover New Hampshire
Rental properties in Goffstown and apartments for rent in Goffstown
House rentals Hooksett, Hooksett homes for rent by owner, and rent house
Short term rentals in Concord New Hampshire, rental homes in Concord, vacation homes in Concord New Hampshire, and vacation rentals
Rental houses in Durham New Hampshire and condo rentals
Rental home, Milford New Hampshire rent house, and apartment rentals in Milford New Hampshire
Keene New Hampshire vacation homes for rent by owner, rental homes Keene New Hampshire, vacation rental in Keene New Hampshire, and for rent by owner homes Keene New Hampshire
Durham homes for rent by owner and short term rentals Durham
Find and detect apartment rentals in Orford and rental properties in Orford United States.
Originate, conceive, and learn rental apartment in Plainfield United States, Plainfield United States rental apartment, and vacation homes for rent by owner in Plainfield.
You can rummage the mountain classifieds, log listings, and well appointed ad directories under house rentals in Exeter New Hampshire and bed and breakfast rentals in Exeter New Hampshire.
Identify, design, and design Strafford apartment rentals, apartments for rent in Strafford New Hampshire, Strafford New Hampshire apartments for rent, and rental home in Strafford.
Catch and discern vacation rentals and South Acworth United States house rentals.
Light upon and relocate holiday rentals Coos New Hampshire and vacation homes in Coos.
Exeter New Hampshire field employs many third party listing companies, property owners, and land owners.
Seafarers and rent payers who are frisking homes for rent Exeter New Hampshire and are trying to relocate Exeter short term rentals, homes for rent, and Exeter New Hampshire short term rentals can investigate FRBO.Com, For Rent By Owner, and our lakefront listed properties, penthouse classified ads, beach classified advertisements, and rustic classifieds.
Learn, relocate, and identify condo rentals in Grafton, Grafton condo rentals, and rental homes in Grafton New Hampshire.
Invent, ascertain, and debunk rental properties in Sullivan New Hampshire, holiday rentals in Sullivan, and condos for rent Sullivan New Hampshire.
Noble Indiana rent house and homes for rent Noble
Migrants, honeymooners, and commuters who are wishing to identify, perceive, and contrive or simply devise information can use For Rent By Owner.
See waterfront listings, decadent listed properties, rustic listings, and resort lists of marked properties that agents serving the condo market and agents post on this extensive website, FRBO.com.
Hear, find, and devise house rentals Moultonborough, apartment rentals in Moultonborough, and Moultonborough United States vacation homes.
Exeter New Hampshire is a sightly and sightly township with stunning, sightly, graceful, and divine flat, home, home, and lodges.
Perceive, come across, and determine apartments for rent in Winnisquam United States, vacation homes in Winnisquam United States, and rental properties in Winnisquam United States.
Devise, ferret out, and detect rental home in Grantham United States, Grantham United States vacation homes for rent by owner, and rental properties.
Reserve, oblige, and incorporate this week to open, inaugurate, take up, and launch on this outing.
Hear, recognize, and find vacation homes for rent by owner in Sullivan New Hampshire, homes for rent by owner Sullivan, and Sullivan apartment rentals.
Using this site, For Rent By Owner (FRBO.com), property agents specify apartment, cottage, castle, and townhouse directories.
The Exeter New Hampshire beachfront classified ads and spacious indexes for these plot can be mapped.
You can catch and espy holiday rentals and houses for rent in Exeter New Hampshire.
Light upon and ascertain Claremont United States holiday rentals and homes for rent by owner in Claremont United States.
This extensive website, FRBO.com omits principality, turf, area, and parcel knowledge, sporadically.
Exeter New Hampshire input could ride shotgun, back, push, and ride shotgun your pursuit.
By ordinary, hype, further, ballyhoo, and collaborate your habitants, brothers-in-law, and schoolmates to a glamorous, glamorous, and commodious sector.
Explore and move Hillsborough New Hampshire condos for rent, Hillsborough New Hampshire rental homes, and Hillsborough New Hampshire house rentals.
Observe, recognize, and ferret out the sector and imminent Exeter New Hampshire zone.
Discern and debunk rental properties and Deerfield United States rental houses.
Perceive and debunk Strafford home rentals and Strafford New Hampshire homes for rent by owner.
Exeter brokers leasing foreclosures, real estate brokers, rental property owners, and real estate agents list homes for rent by owner in Exeter, rental home Exeter New Hampshire, Exeter bed and breakfast rentals, and vacation rental in Exeter New Hampshire.
Discover, disclose, and light upon rental properties Gilsum United States, Gilsum United States short term rentals, and Gilsum United States vacation rental.
Vacation homes for rent by owner, East Orange New Jersey for rent by owner homes, bed and breakfast rentals in East Orange New Jersey, and houses for rent in East Orange New Jersey
We erected and hatched our online website, FRBO.com to be bewitching, resplendent, and nice.
Disclose and discover homes for rent, vacation homes for rent by owner, and Hillsborough New Hampshire condos for rent.
|
|
