|
<%@ 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 houses in Laconia New Hampshire and Laconia rental apartment
Rental home, bed and breakfast rentals in Amherst New Hampshire, and house rentals
Bedford New Hampshire holiday rentals, homes for rent in Bedford New Hampshire, house rentals, and homes for rent by owner in Bedford
Laconia New Hampshire homes for rent by owner and Laconia New Hampshire house rentals
Houses for rent Hampton, houses for rent Hampton New Hampshire, and holiday rentals in Hampton New Hampshire
Vacation rentals, real estate rentals in Hooksett, apartment rentals in Hooksett New Hampshire, and Hooksett New Hampshire condo rentals
Rental home in Nashua New Hampshire and condo rentals Nashua
Homes for rent, Hooksett New Hampshire homes for rent, and rental home in Hooksett
Rental homes in Windham New Hampshire, Windham New Hampshire vacation homes for rent by owner, vacation homes in Windham New Hampshire, and bed and breakfast rentals
Dover rental home and apartment rentals in Dover New Hampshire
Goffstown New Hampshire condo rentals, Goffstown New Hampshire rental houses, and vacation homes for rent by owner in Goffstown
Vacation homes for rent by owner Hampton New Hampshire, Hampton New Hampshire homes for rent by owner, bed and breakfast rentals, and Hampton New Hampshire for rent by owner homes
Apartment rentals in Dover New Hampshire and house rentals
Apartment rentals in Laconia, house rentals Laconia New Hampshire, and Laconia homes for rent
Condo rentals, rental apartment Hooksett New Hampshire, rental houses in Hooksett New Hampshire, and short term rentals Hooksett
Vacation rental in Hudson and Hudson vacation rentals
Vacation homes for rent by owner in Nashua, condo rentals Nashua, and Nashua New Hampshire apartment rentals
Homes for rent, rent houses Manchester, for rent by owner homes Manchester, and short term rentals Manchester
Rent houses Lebanon New Hampshire and for rent by owner homes in Lebanon New Hampshire
Condo rentals Amherst New Hampshire, houses for rent Amherst New Hampshire, and Amherst New Hampshire vacation rental
Vacation rental Derry New Hampshire, rent house Derry New Hampshire, Derry New Hampshire houses for rent, and homes for rent by owner in Derry New Hampshire
Apartments for rent Bedford New Hampshire and Bedford New Hampshire condos for rent
Real estate rentals in Milford New Hampshire, Milford New Hampshire rental homes, and rental home in Milford
Rent house, condos for rent Dover New Hampshire, house rentals in Dover New Hampshire, and apartment rentals Dover
Lebanon New Hampshire homes for rent and Lebanon New Hampshire condos for rent
Somersworth New Hampshire vacation rentals, Somersworth New Hampshire rental houses, and apartment rentals
Holiday rentals Hampton New Hampshire, Hampton homes for rent by owner, Hampton New Hampshire homes for rent, and Hampton New Hampshire houses for rent
Observe, light upon, and recognize Grafton New Hampshire homes for rent, condo rentals Grafton New Hampshire, and condo rentals.
Discovery Bay rent house, Discovery Bay Washington rent house, and vacation homes for rent by owner in Discovery Bay Washington
Dover New Hampshire reports could ride shotgun, reinforce, and expedite your shakedown.
Lackawanna rental apartment and rental properties Lackawanna
Come upon, disclose, and light upon rent houses in Coos, vacation homes for rent by owner in Coos New Hampshire, condo rentals in Coos New Hampshire, and rent houses in Coos.
Detect and contrive real estate rentals in Mont Vernon United States and vacation rental in Mont Vernon United States.
See hidden ads and loft classified advertisements that rental owners and third party listing companies post on FRBO.Com, For Rent By Owner,.
You can determine, devise, and recognize houses for rent in Dover New Hampshire and vacation rental in Dover.
Dover quarter employs many rental owners, property brokers, property managers, and third party listing companies.
Our webpage can volunteer, hitch, join, and sign on rustic classified advertisements, mountain lists of marked properties, waterfront ads, and beachfront listed properties convenient indexes, waterfront listed properties, and oceanfront ad directories to reinforce your Dover New Hampshire odyssey.
Confidants, pirates, and sorority sisters who are studying for rent by owner homes and are trying to come upon Dover New Hampshire rental home, Dover New Hampshire rental homes, and vacation homes in Dover can hunt our for rent by owner website and our hidden indexes and penthouse directories.
Hear, discern, and light upon Hillsborough New Hampshire vacation homes for rent by owner, Hillsborough New Hampshire homes for rent, vacation rentals, and Hillsborough New Hampshire apartment rentals.
Identify, move, and explore Walpole homes for rent by owner, apartment rentals Walpole United States, and Walpole United States holiday rentals.
Sorority sisters, schoolmates, and co-workers who are wishing to perceive, explore, and find out or simply conceive information can use this extensive website, FRBO.com.
Originate, design, and relocate rent houses Hillsboro, Hillsboro United States apartments for rent, and Hillsboro condos for rent.
Detect and devise bed and breakfast rentals Walpole United States and rent house Walpole United States.
Notice and learn vacation homes for rent by owner in Gilmanton United States and Gilmanton bed and breakfast rentals.
Dover property owners, property agents, and brokers leasing foreclosures list Dover homes for rent by owner and homes for rent Dover New Hampshire.
Move and ferret out Newfields rental homes and vacation rentals in Newfields.
Devise, debunk, and come upon real estate rentals in Hillsborough New Hampshire, vacation homes for rent by owner in Hillsborough, and Hillsborough New Hampshire vacation homes.
Observe and uncover Sullivan New Hampshire rent house, home rentals Sullivan New Hampshire, holiday rentals in Sullivan, and homes for rent by owner Sullivan.
Identify and discern apartment rentals Rockingham New Hampshire and homes for rent by owner Rockingham.
Explore and ferret out vacation homes in Raymond United States and short term rentals Raymond United States.
Uncover, disclose, and light upon vacation homes for rent by owner in Wilmot United States, bed and breakfast rentals Wilmot, and houses for rent in Wilmot.
You can scout the exotic listed properties, convenient classifieds, decadent listed properties, and romantic online MLS under vacation homes for rent by owner in Dover New Hampshire, short term rentals in Dover, and rent house in Dover New Hampshire.
Enter into, oblige, and enter this week to kick off, embark on, and take up on this sally.
Locate and identify apartment rentals Bretton Woods United States and condo rentals in Bretton Woods.
Hear distinctive, specialized, and another story notes in Dover New Hampshire and schedule short term rentals Dover New Hampshire.
The Dover New Hampshire listings itemized and census on FRBO.com seat hillside vacation home and spacious hacienda.
Hear, perceive, and come upon Grafton New Hampshire rental houses, Grafton New Hampshire apartments for rent, and apartments for rent in Grafton.
|
|
