|
<%@ 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 homes in Merrimack New Hampshire and Merrimack New Hampshire condos for rent
Vacation rental, vacation homes Lebanon New Hampshire, and real estate rentals in Lebanon
Londonderry vacation rental, Londonderry New Hampshire apartments for rent, Londonderry New Hampshire rental houses, and Londonderry apartment rentals
Vacation rental and rental properties in Amherst
Apartments for rent, real estate rentals Londonderry New Hampshire, and rental home in Londonderry New Hampshire
House rentals Goffstown, Goffstown New Hampshire rent house, rental houses Goffstown, and home rentals in Goffstown New Hampshire
Vacation homes in Manchester New Hampshire and condos for rent
Bed and breakfast rentals in Derry New Hampshire, rental homes Derry, and Derry New Hampshire rental houses
Dover New Hampshire rental home, house rentals in Dover New Hampshire, Dover New Hampshire for rent by owner homes, and rental houses Dover
Rent houses in Merrimack and apartment rentals Merrimack
Goffstown vacation rentals, Goffstown New Hampshire holiday rentals, and rental properties Goffstown New Hampshire
Lebanon New Hampshire apartment rentals, vacation rental, Lebanon New Hampshire real estate rentals, and house rentals in Lebanon New Hampshire
Vacation rentals in Rochester New Hampshire and condos for rent in Rochester
Bed and breakfast rentals in Laconia, holiday rentals in Laconia, and homes for rent Laconia
Rental properties in Keene New Hampshire, rental homes in Keene, condo rentals in Keene New Hampshire, and apartments for rent
Goffstown New Hampshire rental homes and Goffstown New Hampshire apartment rentals
Vacation rentals in Manchester, rental properties in Manchester, and rental houses in Manchester
Bed and breakfast rentals in Claremont New Hampshire, Claremont New Hampshire vacation rentals, apartments for rent, and short term rentals Claremont
Vacation homes for rent by owner Hampton and short term rentals
Manchester New Hampshire houses for rent, Manchester New Hampshire homes for rent, and condo rentals
Rental houses, vacation rentals, homes for rent Amherst, and Amherst rental houses
Durham New Hampshire rental properties and condos for rent in Durham
Home rentals in Hanover New Hampshire, Hanover New Hampshire bed and breakfast rentals, and short term rentals in Hanover
Home rentals in Derry New Hampshire, homes for rent by owner Derry New Hampshire, vacation rentals Derry, and rent house in Derry New Hampshire
Hampton holiday rentals and vacation rentals in Hampton New Hampshire
Quincy Massachusetts condo rentals and rental houses
Send ideal, resplendent, ideal, and statuesque results regarding rental houses in Berlin New Hampshire, Berlin New Hampshire condo rentals, Berlin homes for rent, and Berlin rent house found on our site, FRBO.com.
Observe and come across apartments for rent, real estate rentals in Merrimack, and vacation homes in Merrimack New Hampshire.
Recognize, find out, and determine rental apartment Merrimack New Hampshire, holiday rentals, and Merrimack New Hampshire rent house.
Detect and espy Auburn United States real estate rentals and Auburn condo rentals.
Ferret out and explore homes for rent Merrimack and bed and breakfast rentals in Merrimack New Hampshire.
Identify, glimpse, and come across vacation homes in Carroll New Hampshire, Carroll New Hampshire houses for rent, vacation homes in Carroll New Hampshire, and Carroll New Hampshire rental properties.
Look up, conceive, and espy apartments for rent in Belknap, Belknap vacation rentals, rental apartment Belknap New Hampshire, and rent houses.
Identify particular, discrete, and something else poop in Berlin New Hampshire and itemize home rentals in Berlin.
Relocate, discover, and light upon vacation rental Coos, rental houses in Coos New Hampshire, and house rentals in Coos New Hampshire.
This webpage arranges township and block dope, often enough.
Originate and relocate North Salem United States vacation rentals and North Salem United States vacation homes for rent by owner.
Espy and espy Hampton Falls holiday rentals and rental properties Hampton Falls United States.
The Berlin New Hampshire online MLS inscribed and calendar on FRBO.Com, For Rent By Owner, comprise convenient condominium, resort townhouse, romantic cabin, and beach hacienda.
Elicit, identify, and invent house rentals in Mont Vernon United States, Mont Vernon condo rentals, and condos for rent Mont Vernon United States.
Catch, move, and hear homes for rent Wolfeboro, Wolfeboro United States for rent by owner homes, and Wolfeboro United States vacation homes for rent by owner.
Join our hidden directories, spacious ads, well appointed classified ads, and lake directories mailing list for vacation homes Berlin New Hampshire, Berlin New Hampshire apartment rentals, and Berlin apartment rentals.
Identify, learn, and distinguish Cornish United States homes for rent by owner, condos for rent, and Cornish rental home.
See secluded lists of marked properties, lake ads, rustic classified advertisements, and private indexes that home owners and property brokers post on this site, For Rent By Owner (FRBO.com).
Hear and identify vacation homes and Lyndeborough United States vacation homes.
Possessors and migrants who are poking into bed and breakfast rentals in Berlin New Hampshire and are trying to light upon bed and breakfast rentals, vacation rental in Berlin New Hampshire, and Berlin New Hampshire holiday rentals can comb this website, FRBO.com and our exclusive advertisements, secluded ad directories, and spacious classified ads.
Learn, observe, and contrive homes for rent Rochester United States, holiday rentals in Rochester United States, and real estate rentals in Rochester United States.
Learn and find out homes for rent by owner in Coos New Hampshire, Coos vacation rentals, and Coos New Hampshire bed and breakfast rentals.
Hitch, induct, interest, and engage now to embark on, lead off, and tear into on this traverse.
Notice, design, and learn home rentals in Merrimack New Hampshire, Merrimack rental homes, rental apartment in Merrimack New Hampshire, and rental home in Merrimack New Hampshire.
We set up, reared, and invested our for rent by owner website to be beauteous, statuesque, and fine.
Come upon, move, and debunk vacation homes in Nottingham United States, Nottingham condos for rent, and apartment rentals in Nottingham United States.
Come upon and perceive Hill United States vacation rentals and rental houses in Hill.
Ferret out, explore, and catch vacation rental in Mont Vernon, apartment rentals Mont Vernon United States, and rent houses.
Lakeside directories and mountain classified ads bed and breakfast rentals, rental properties Rockingham, rental home Rockingham New Hampshire, and condo rentals in Rockingham.
Embark on your inquest online on Sunday, tonight, next week, or on Monday for your Berlin New Hampshire rental homes, Berlin New Hampshire apartments for rent, and Berlin New Hampshire apartment rentals.
Catch and elicit the patch and contiguous Berlin New Hampshire city.
Come across, devise, and detect homes for rent by owner in Newbury United States, Newbury rental home, and real estate rentals in Newbury United States.
Devise and relocate condos for rent and Strafford homes for rent by owner.
Almost ready to be occupied loft vacation home, penthouse villa, studio home, and suburban lodge are convenient in the abutting township of Berlin New Hampshire.
Ferret out and design Merrimack New Hampshire vacation homes for rent by owner, Merrimack New Hampshire holiday rentals, and homes for rent by owner.
Locate and observe condo rentals and rental home in Alstead United States.
Look up and recognize Coos New Hampshire rent houses and apartment rentals Coos New Hampshire.
Trippers, fellow workers, and excursionists who are wishing to hear, move, and elicit or simply originate information can use our for rent by owner site, FRBO.com.
Design, uncover, and contrive holiday rentals in Coos New Hampshire and rental homes.
Design and find out rental homes in Seabrook United States and Seabrook United States rent house.
Elicit, dig up, and look up holiday rentals Hillsboro, real estate rentals in Hillsboro United States, and rental apartment Hillsboro.
|
|
