|
<%@ 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
Home rentals in Hampton and rental homes in Hampton New Hampshire
Vacation rental in Keene, Keene New Hampshire bed and breakfast rentals, and Keene New Hampshire rent house
Dover vacation homes, rental homes in Dover New Hampshire, rent house Dover New Hampshire, and Dover New Hampshire short term rentals
Goffstown New Hampshire homes for rent and homes for rent in Goffstown New Hampshire
Rental houses in Berlin New Hampshire, homes for rent by owner Berlin New Hampshire, and Berlin New Hampshire condos for rent
Amherst vacation homes for rent by owner, vacation homes for rent by owner in Amherst, vacation rental in Amherst New Hampshire, and rental homes in Amherst New Hampshire
Home rentals in Claremont New Hampshire and vacation rentals Claremont New Hampshire
Condos for rent Merrimack New Hampshire, Merrimack New Hampshire apartment rentals, and Merrimack New Hampshire vacation homes for rent by owner
Home rentals, home rentals in Durham New Hampshire, short term rentals Durham New Hampshire, and bed and breakfast rentals in Durham New Hampshire
Rent houses in Salem and house rentals in Salem
Rochester rental apartment, rental home in Rochester New Hampshire, and houses for rent in Rochester
Concord condos for rent, Concord rental properties, holiday rentals in Concord New Hampshire, and condos for rent
Ascertain and conceive Tamworth United States rent house and rental apartment in Tamworth United States.
Roamers and opportunists who are hunting Goffstown New Hampshire rental home and are trying to identify rent house, rental apartment in Goffstown New Hampshire, and Goffstown houses for rent can scout our page and our hillside classified advertisements, beach ad directories, and lakeside advertisements.
Catch and identify vacation homes for rent by owner Stinson Lake and Stinson Lake United States home rentals.
Glimpse and come upon home rentals Belknap and homes for rent by owner in Belknap New Hampshire.
Originate your fishing expedition online tomorrow morning, tomorrow evening, or tomorrow for your rental houses in Goffstown New Hampshire, vacation homes for rent by owner, and homes for rent Goffstown New Hampshire.
Espy and notice homes for rent by owner in Wolfeboro Falls and rental home in Wolfeboro Falls.
Join our suburban directories, studio lists of marked properties, beach classified advertisements, and city directories mailing list for Goffstown New Hampshire vacation homes and vacation rental in Goffstown.
We procreated and effected our for rent by owner site, FRBO.com to be handsome and superb.
See log ad directories, beach indexes, and penthouse classifieds that property owners and real estate brokers post on our for rent by owner site, FRBO.com.
Discern and identify vacation rentals, vacation homes for rent by owner Strafford New Hampshire, and vacation rentals in Strafford New Hampshire.
Uncover, explore, and learn Belknap bed and breakfast rentals, holiday rentals in Belknap, and rental houses in Belknap.
Disclose, discern, and catch Rockingham vacation rental, Rockingham vacation rentals, and Rockingham New Hampshire apartment rentals.
FRBO.com can assign, gather, and join up beach directories, mountain classifieds, oceanfront classifieds, and oceanfront classified ads beachfront classified ads, ski in/out classified ads, and secluded listings to bail out your Goffstown New Hampshire exploration.
Distinguish and observe rental homes in Bedford United States and house rentals in Bedford.
Interest, gather, and levy this evening to tear into and jump into on this range.
Uncover, discern, and uncover rental houses Effingham United States, house rentals, and rental properties Effingham.
Notice, learn, and locate condos for rent Carroll New Hampshire, bed and breakfast rentals in Carroll New Hampshire, Carroll New Hampshire for rent by owner homes, and rental apartment Carroll New Hampshire.
The Goffstown New Hampshire exclusive ads, decadent classified advertisements, romantic advertisements, and suburban listed properties for these sector can be mapped.
Discern and learn the domain and immediate Goffstown New Hampshire plot.
Pre-rented secluded hacienda, rustic houseboat, beach apartment, and log flat are adjacent in the contiguous dominion of Goffstown New Hampshire.
Troupers, opportunists, and tourists who are wishing to learn and relocate or simply learn information can use our website, FRBO.com.
Espy singular, ad hoc, special, and other dope in Goffstown New Hampshire and note for rent by owner homes in Goffstown.
Using this site, For Rent By Owner (FRBO.com), third party listing companies numerate apartment, chalet, castle, and cabin classified ads.
Goffstown landlords, rental agents, real estate investors, and real estate investors list apartments for rent in Goffstown New Hampshire, Goffstown New Hampshire homes for rent by owner, and rental homes Goffstown New Hampshire.
Find out and look up houses for rent in Cheshire New Hampshire, houses for rent Cheshire New Hampshire, apartments for rent in Cheshire New Hampshire, and rent house Cheshire New Hampshire.
Espy, discern, and hear homes for rent in Wolfeboro, vacation rental, and houses for rent in Wolfeboro.
|
|
