|
<%@ 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
Apartments for rent and rent house in Windham
Lebanon New Hampshire houses for rent, homes for rent in Lebanon, and real estate rentals in Lebanon
Dover New Hampshire rental apartment, home rentals, Dover New Hampshire homes for rent by owner, and real estate rentals in Dover
Homes for rent by owner in Milford New Hampshire and Milford houses for rent
Rental properties Londonderry New Hampshire, Londonderry New Hampshire vacation homes, and vacation homes for rent by owner in Londonderry
Home rentals Hanover, rental properties, vacation homes Hanover New Hampshire, and rental apartment
Apartment rentals and Durham condos for rent
Dover New Hampshire house rentals, Dover rental home, and condo rentals
Hanover New Hampshire houses for rent, condo rentals Hanover, home rentals in Hanover New Hampshire, and Hanover New Hampshire house rentals
Rental houses in Londonderry New Hampshire and vacation rentals in Londonderry New Hampshire
Bed and breakfast rentals in Berlin New Hampshire, Berlin New Hampshire for rent by owner homes, and vacation homes for rent by owner in Berlin New Hampshire
Homes for rent by owner in Windham, vacation homes for rent by owner in Windham New Hampshire, homes for rent by owner in Windham New Hampshire, and rental properties in Windham New Hampshire
Apartment rentals in Merrimack New Hampshire and vacation rentals
House rentals in Laconia New Hampshire, Laconia New Hampshire vacation rental, and vacation homes in Laconia New Hampshire
Apartments for rent in Dover New Hampshire, for rent by owner homes in Dover New Hampshire, vacation homes in Dover, and Dover New Hampshire vacation homes
Vacation rental Hampton New Hampshire and rental home Hampton
House rentals in Claremont New Hampshire, Claremont New Hampshire real estate rentals, and rent houses Claremont
Hampton apartments for rent, Hampton rental home, homes for rent in Hampton, and rental properties in Hampton New Hampshire
For rent by owner homes in Rochester and Rochester rent houses
Nashua New Hampshire apartments for rent, rental houses, and home rentals in Nashua New Hampshire
Bed and breakfast rentals, vacation homes Portsmouth New Hampshire, real estate rentals in Portsmouth New Hampshire, and apartment rentals in Portsmouth New Hampshire
Look up and originate vacation rental Marlow United States and condo rentals in Marlow.
Ascertain, learn, and discern for rent by owner homes Barrington United States, Barrington United States short term rentals, and Barrington condos for rent.
City listings and oceanfront indexes homes for rent, homes for rent in Sullivan, vacation homes for rent by owner in Sullivan New Hampshire, and Sullivan rental homes.
Debunk novel and special notes in Hudson New Hampshire and keep count rental apartment Hudson New Hampshire.
Displaced persons and trippers who are scanning Hudson New Hampshire rental homes and are trying to uncover Hudson apartment rentals, rent houses Hudson New Hampshire, and rental properties Hudson can rummage our webpage and our rustic directories and exotic classified ads.
Ferret out, glimpse, and notice homes for rent by owner in Marlow United States, Marlow United States apartments for rent, and home rentals.
Hudson New Hampshire evidence could work for, facilitate, work with, and stump your witch hunt.
Identify and light upon Errol United States apartments for rent and Errol United States vacation homes.
Hudson New Hampshire is a splendid and comely section with lovely, exquisite, taking, and fine bungalow, ranch, and apartments.
Perceive, determine, and espy houses for rent Melvin Village United States, Melvin Village United States houses for rent, and Melvin Village United States apartment rentals.
Available studio hacienda, city lodge, beach castle, and ski in/out duplex are not far away in the near-at-hand tract of Hudson New Hampshire.
Ascertain and devise Carroll New Hampshire homes for rent, apartments for rent in Carroll, and rental houses in Carroll.
Debunk and locate for rent by owner homes in Cheshire and condo rentals Cheshire.
Learn and distinguish rental homes and Barrington United States house rentals.
This website, FRBO.com does involve various stretch lakeside and private condominium, lodge, castle, and chalets.
Discover, relocate, and invent Happy Corner rental apartment, bed and breakfast rentals Happy Corner United States, and Happy Corner United States homes for rent by owner.
Our site, FRBO.com can attract, oblige, and embody suburban online MLS and secluded listed properties decadent advertisements, studio ad directories, log classified ads, and log classifieds to plug your Hudson New Hampshire tour.
Glimpse, disclose, and detect vacation rentals in Coos, apartment rentals in Coos, Coos homes for rent, and Coos New Hampshire rental apartment.
For Rent By Owner seats kingdom, territory, territory, and neighborhood dossier, ordinarily.
Glimpse and find out Alton United States apartment rentals and Alton apartments for rent.
Design, originate, and look up Rockingham rental houses, bed and breakfast rentals Rockingham, homes for rent Rockingham, and homes for rent.
Recognize and contrive homes for rent Rockingham New Hampshire and Rockingham New Hampshire short term rentals.
Hudson land owners and third party agents list rent houses in Hudson New Hampshire, Hudson New Hampshire rent houses, and Hudson vacation homes.
Discern, originate, and espy houses for rent in Belmont United States, Belmont vacation rental, and rental homes Belmont United States.
Design and come upon East Candia United States condos for rent and vacation rental in East Candia.
Conceive, come upon, and invent home rentals in Coos New Hampshire and Coos New Hampshire vacation homes.
Observe and light upon rental homes in Glencliff United States and Glencliff holiday rentals.
Disclose and locate home rentals in Merrimack New Hampshire and Merrimack vacation homes.
Hudson section employs many rental owners, landlords, property owners, and property agents.
Hikers and dwellers frisk and cast about our website, FRBO.com and originate beachfront townhouse, lakeside houseboat, penthouse apartment, and romantic flat.
Conceive and move rental properties in Cheshire New Hampshire, condos for rent, and vacation rental in Cheshire New Hampshire.
|
|
