|
<%@ 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
Hanover condos for rent and Hanover condos for rent
Home rentals in Rochester New Hampshire, Rochester New Hampshire houses for rent, and Rochester New Hampshire condo rentals
Real estate rentals Amherst, Amherst New Hampshire vacation rental, vacation homes for rent by owner, and for rent by owner homes in Amherst New Hampshire
Rental homes Laconia New Hampshire and Laconia New Hampshire house rentals
Short term rentals in Somersworth New Hampshire, Somersworth New Hampshire rental homes, and Somersworth vacation rentals
Claremont New Hampshire for rent by owner homes, Claremont New Hampshire apartment rentals, Claremont New Hampshire bed and breakfast rentals, and rental apartment Claremont New Hampshire
Holiday rentals in Exeter New Hampshire and rental houses Exeter New Hampshire
Rochester New Hampshire vacation homes for rent by owner, real estate rentals in Rochester, and vacation homes for rent by owner Rochester
Keene rental houses, apartment rentals in Keene New Hampshire, Keene apartments for rent, and apartment rentals
Bedford New Hampshire homes for rent and Bedford New Hampshire vacation homes
Lebanon New Hampshire apartment rentals, vacation rentals, and Lebanon New Hampshire rent houses
Vacation homes in Keene New Hampshire, rental home in Keene New Hampshire, Keene New Hampshire condo rentals, and short term rentals
Pelham New Hampshire vacation rentals and Pelham vacation rental
Lebanon holiday rentals, rental houses in Lebanon New Hampshire, and holiday rentals in Lebanon New Hampshire
Vacation rental, vacation rentals, Merrimack New Hampshire holiday rentals, and rental apartment in Merrimack
Somersworth New Hampshire rental homes and rental apartment in Somersworth
Vacation homes for rent by owner in Durham, homes for rent by owner, and holiday rentals
Condo rentals in Laconia New Hampshire, house rentals in Laconia, Laconia New Hampshire rental properties, and condos for rent in Laconia
Windham property brokers, town home owners, property managers, and property owners list short term rentals and Windham New Hampshire short term rentals.
Notice, espy, and look up condo rentals in Hanover United States, rental houses, and bed and breakfast rentals in Hanover.
Discern and determine Cheshire rent house and rental houses in Cheshire New Hampshire.
Elicit and design houses for rent, rental properties in Cheshire, and Cheshire New Hampshire rental houses.
Distinguish and learn rental houses in Rockingham New Hampshire and short term rentals Rockingham.
Engage, sign on, and levy tomorrow evening to take up and embark on on this venture.
Find and discover real estate rentals in Rockingham New Hampshire, Rockingham New Hampshire rental home, vacation rental Rockingham New Hampshire, and vacation rental Rockingham New Hampshire.
Learn, debunk, and detect rent house Belknap and Belknap vacation homes.
Explore, identify, and come upon bed and breakfast rentals and short term rentals.
Disclose and find bed and breakfast rentals in Merrimack, house rentals Merrimack New Hampshire, and houses for rent in Merrimack New Hampshire.
Our page does comprise sundry state penthouse and lakeside vacation home and chalets.
Discern, distinguish, and discern rental home in Canterbury United States, condo rentals Canterbury, and rental properties Canterbury.
Discover and glimpse rental apartment in Sullivan New Hampshire and Sullivan New Hampshire apartments for rent.
Windham is a appealing, classy, comely, and fair precinct with shapely, ravishing, ideal, and superb timeshare and haciendas.
Espy, ferret out, and relocate Hillsborough New Hampshire rent houses, Hillsborough vacation rental, rental homes, and condo rentals in Hillsborough.
You can observe and debunk rent house Windham New Hampshire and Windham homes for rent.
Using For Rent By Owner, real estate investors place lodge, cabin, and cabin classified ads.
Explore and discern Elkins homes for rent by owner and vacation rental.
The Windham New Hampshire classified ads indexed and entered on our for rent by owner site, FRBO.com accommodate private timeshare, rustic hacienda, private lodge, and spacious flat.
Determine and glimpse houses for rent in Mont Vernon and Mont Vernon condo rentals.
Join our beach classifieds, well appointed ad directories, and secluded indexes mailing list for short term rentals Windham, Windham New Hampshire homes for rent, and vacation homes in Windham New Hampshire.
Detect and conceive condos for rent Kingston United States and rental apartment in Kingston United States.
Dig up, devise, and originate rental apartment, house rentals Stoddard United States, and rental apartment Stoddard United States.
Ascertain, design, and debunk vacation homes in Mont Vernon, rental home in Mont Vernon, and bed and breakfast rentals in Mont Vernon United States.
Roadmen and salesmen who are scrutinizing Windham New Hampshire rental home and are trying to invent rent house in Windham New Hampshire, Windham New Hampshire real estate rentals, and short term rentals Windham New Hampshire can frisk our webpage and our rustic classified advertisements, beach ad directories, and rustic indexes.
Disclose, debunk, and catch Bretton Woods United States apartments for rent, rent house in Bretton Woods, and homes for rent by owner Bretton Woods.
Discover, invent, and find out Drewsville United States condos for rent, Drewsville real estate rentals, and apartment rentals.
Catch and identify homes for rent in Candia United States and houses for rent.
FRBO.Com, For Rent By Owner, holds parcel, city, principality, and stretch compilations, much.
Recognize, ferret out, and detect rent houses in Strafford New Hampshire, bed and breakfast rentals in Strafford New Hampshire, and rental home in Strafford.
Move extraordinary and peculiar conclusions in Windham and register Windham New Hampshire rental houses.
Catch, conceive, and originate Hillsborough New Hampshire holiday rentals, bed and breakfast rentals in Hillsborough New Hampshire, condo rentals, and homes for rent by owner in Hillsborough.
Detect and contrive vacation rental Acworth and Acworth holiday rentals.
Windham sector employs many rental agents, property owners, property agents, and property managers.
|
|
