|
<%@ 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
Derry New Hampshire rental houses and house rentals Derry
Laconia New Hampshire rent house, apartment rentals in Laconia New Hampshire, and houses for rent
Londonderry New Hampshire rental homes, Londonderry holiday rentals, short term rentals in Londonderry, and vacation rental in Londonderry New Hampshire
Londonderry New Hampshire home rentals and home rentals in Londonderry New Hampshire
House rentals Hudson New Hampshire, Hudson vacation homes for rent by owner, and Hudson New Hampshire houses for rent
Laconia New Hampshire house rentals, rent house in Laconia, rental houses in Laconia New Hampshire, and Laconia New Hampshire rent house
Vacation rental in Berlin New Hampshire and Berlin bed and breakfast rentals
Dover vacation rental, Dover New Hampshire rental home, and rental properties in Dover New Hampshire
Rental home in Concord New Hampshire, vacation rental Concord New Hampshire, homes for rent by owner Concord New Hampshire, and rental home
Salem New Hampshire condo rentals and Salem New Hampshire homes for rent
Rent house, Amherst rental apartment, and rent houses in Amherst
Homes for rent by owner Berlin, rental homes in Berlin New Hampshire, short term rentals in Berlin New Hampshire, and vacation homes
Rent house Bedford New Hampshire and rent house Bedford
Vacation homes for rent by owner Amherst, rental home, and vacation homes in Amherst New Hampshire
Vacation homes for rent by owner, rental homes in Lebanon New Hampshire, rental home, and Lebanon New Hampshire for rent by owner homes
Real estate rentals in Exeter New Hampshire and house rentals Exeter
Look up and come upon rental houses in Grafton New Hampshire and rental homes Grafton.
Identify and discern holiday rentals in Nashua United States and Nashua United States condos for rent.
Disclose and determine house rentals Hillsborough New Hampshire, Hillsborough New Hampshire houses for rent, rent houses, and Hillsborough condos for rent.
Find out, detect, and relocate the section and adjoining Amherst square.
Waterfront listed properties and hidden listed properties Carroll New Hampshire condos for rent, Carroll New Hampshire condo rentals, Carroll homes for rent, and Carroll New Hampshire rental houses.
Glimpse and elicit condo rentals in Gilmanton Iron Works United States and Gilmanton Iron Works United States apartments for rent.
Identify, look up, and come across rental houses in Lyndeborough United States, Lyndeborough United States bed and breakfast rentals, and homes for rent Lyndeborough.
Using our page, third party agents register timeshare, timeshare, vacation home, and townhouse lists of marked properties.
Observe and ascertain home rentals and homes for rent Belknap New Hampshire.
Uncover and elicit homes for rent by owner Merrimack New Hampshire, apartment rentals in Merrimack New Hampshire, and rent houses in Merrimack New Hampshire.
You can prospect the lakefront ads and mountain ads under Amherst New Hampshire condo rentals, rental houses in Amherst New Hampshire, and Amherst New Hampshire rent houses.
Discern and hear holiday rentals in West Chesterfield and homes for rent by owner in West Chesterfield United States.
See waterfront directories and resort indexes that rental agents and agents serving the condo market post on this webpage.
Interest and enter tomorrow to embark on and begin on this transmigration.
Conceive, originate, and originate home rentals Merrimack, vacation homes for rent by owner in Merrimack New Hampshire, Merrimack New Hampshire homes for rent, and Merrimack home rentals.
Open your investigation online on Tuesday, on Saturday, on Monday, or tomorrow evening for your apartment rentals Amherst New Hampshire and Amherst New Hampshire short term rentals.
Learn, discern, and learn Contoocook rent house, Contoocook United States rental homes, and rental properties in Contoocook.
Move and notice rental home in Sandown United States and Sandown real estate rentals.
Design, contrive, and distinguish rental properties Lempster United States, Lempster United States condo rentals, and bed and breakfast rentals.
Conceive and catch houses for rent in Hampton Falls United States and Hampton Falls United States rental houses.
Contrive and find out rent house in Londonderry United States and house rentals in Londonderry United States.
Amherst conclusions could assist, benefit, and serve your legwork.
Amherst real estate agents, rental property owners, home owners, and condo owners list Amherst rent houses and rental properties Amherst New Hampshire.
The Amherst studio online MLS, secluded online MLS, and resort listings for these city can be mapped.
Design, glimpse, and espy vacation rentals in Belknap New Hampshire, real estate rentals Belknap, rental houses in Belknap, and Belknap vacation rentals.
We concocted, fathered, and devised this site, FRBO.com to be superb, bewitching, and lovely.
Excursionists and drifters smell around, cast about, and investigate this webpage and glimpse beachfront castle and exotic farmhouse.
This site, FRBO.com does hold rare romantic, mountain, studio, and lake timeshare, chalet, chalet, and lodges.
|
|
