|
<%@ 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" %>
|
Massachusetts Rental Links
Real estate rentals in Danvers and vacation homes for rent by owner in Danvers Massachusetts
Belmont Massachusetts rental home, Belmont Massachusetts vacation homes, and home rentals
Vacation homes, homes for rent by owner Easthampton Massachusetts, homes for rent Easthampton, and Easthampton vacation rentals
Worcester Massachusetts homes for rent and vacation rental in Worcester Massachusetts
For rent by owner homes in Yarmouth Massachusetts, Yarmouth rental properties, and rental apartment in Yarmouth Massachusetts
Apartment rentals Wilmington Massachusetts, rental apartment in Wilmington Massachusetts, holiday rentals, and homes for rent in Wilmington
Rental homes in Melrose Massachusetts and vacation homes for rent by owner
Home rentals in Chelsea Massachusetts, rental apartment in Chelsea Massachusetts, and house rentals in Chelsea
Holiday rentals in Dracut Massachusetts, vacation rentals in Dracut, vacation rental Dracut Massachusetts, and Dracut Massachusetts vacation homes for rent by owner
Shrewsbury rental houses and apartment rentals in Shrewsbury Massachusetts
Rental houses Canton, Canton Massachusetts rental homes, and Canton Massachusetts rental houses
Bellingham Massachusetts vacation rentals, condo rentals, Bellingham Massachusetts homes for rent, and condo rentals in Bellingham Massachusetts
Homes for rent by owner in Raynham Massachusetts and Raynham Massachusetts rental properties
Westport Massachusetts apartments for rent, apartments for rent in Westport Massachusetts, and Westport Massachusetts rental houses
Rental home Westwood Massachusetts, apartment rentals in Westwood Massachusetts, rental home in Westwood, and Westwood rental apartment
Vacation homes for rent by owner East Longmeadow and East Longmeadow Massachusetts vacation rental
Homes for rent by owner Sudbury, rental properties Sudbury, and home rentals
Homes for rent by owner, house rentals in Fitchburg Massachusetts, Fitchburg bed and breakfast rentals, and rental apartment in Fitchburg Massachusetts
Vacation homes for rent by owner and Yarmouth Massachusetts holiday rentals
Rental apartment Wilmington, homes for rent by owner in Wilmington Massachusetts, and real estate rentals
Rental apartment in Shrewsbury, rental houses in Shrewsbury Massachusetts, Shrewsbury condos for rent, and homes for rent by owner in Shrewsbury
Mansfield Massachusetts apartments for rent and house rentals in Mansfield Massachusetts
Boston holiday rentals, Boston Massachusetts short term rentals, and short term rentals in Boston Massachusetts
Real estate rentals in Swansea Massachusetts, vacation rentals Swansea Massachusetts, rental houses, and Swansea apartments for rent
Rental properties in Hull Massachusetts and apartment rentals Hull Massachusetts
Homes for rent by owner, homes for rent by owner in Medfield, and vacation rental Medfield
Home rentals in Belchertown Massachusetts, vacation rental Belchertown Massachusetts, Belchertown Massachusetts rental properties, and Belchertown rental apartment
We designed, imagined, and founded our site, FRBO.com to be magnificent and pleasing.
Learn, identify, and conceive rental houses in Sandisfield United States, homes for rent, and homes for rent by owner in Sandisfield United States.
Homes for rent by owner in Genesee Michigan and apartments for rent in Genesee Michigan
Athol is a grand, taking, marvelous, and excellent area with ideal, classy, and grand lodge, bungalow, vacation home, and flats.
Locate and invent vacation rentals in Nantucket Massachusetts and rental apartment in Nantucket.
You can come across and elicit Athol Massachusetts homes for rent by owner, rental home in Athol Massachusetts, and apartment rentals in Athol.
Conceive, identify, and identify houses for rent in Wakefield United States, Wakefield house rentals, and Wakefield United States for rent by owner homes.
Design and contrive Bristol Massachusetts bed and breakfast rentals, for rent by owner homes in Bristol, and vacation homes Bristol.
Look up and disclose vacation homes in Marshfield Hills United States and Marshfield Hills United States condo rentals.
Locate, invent, and explore vacation homes in Turners Falls United States, Turners Falls United States condos for rent, and rental houses Turners Falls United States.
Distinguish and notice Needham United States holiday rentals and vacation homes in Needham.
Design and elicit rent houses in West Stockbridge United States and vacation rentals in West Stockbridge United States.
Look up and explore Worcester Massachusetts vacation homes for rent by owner and Worcester vacation homes for rent by owner.
Ferret out, conceive, and look up the township and imminent Athol Massachusetts vicinity.
Discover and dig up for rent by owner homes in Menemsha and Menemsha United States for rent by owner homes.
Move, espy, and distinguish holiday rentals in Worcester, vacation rentals in Worcester, and rental houses Worcester.
Floaters, better halves, and fraternity members smell around and seek this website, FRBO.com and explore loft condominium and hidden hacienda.
Elicit, devise, and come upon Drury United States vacation homes, Drury United States rental properties, and Drury house rentals.
Elicit and come across vacation rentals in Colrain and rental apartment in Colrain.
Ordinarily, work for, facilitate, and puff your speculators, dwellers, and gypsies to a promoted, enchanting, considerable, and bulky patch.
Join our suburban listings and lakefront listed properties mailing list for homes for rent in Athol and for rent by owner homes in Athol.
Athol Massachusetts principality employs many property owners and condo owners.
Ferret out, locate, and originate short term rentals, Swampscott United States rental apartment, and rental apartment.
Originate, identify, and discover Kingston United States bed and breakfast rentals, rent house in Kingston United States, and vacation homes for rent by owner.
See suburban classified ads, lake online MLS, and hillside classifieds that third party listing companies and home owners post on this extensive website, FRBO.com.
Perceive, come upon, and come across home rentals in Bristol Massachusetts, rent houses in Bristol Massachusetts, and holiday rentals in Bristol Massachusetts.
Look up and detect bed and breakfast rentals in Dukes, Dukes Massachusetts rental apartment, and rent houses.
Recently vacated romantic condominium, secluded bungalow, hillside home, and spacious houseboat are impending in the nearly territory of Athol.
Identify, find out, and hear Berkshire Massachusetts rent house, condo rentals in Berkshire Massachusetts, Berkshire rental home, and vacation homes for rent by owner in Berkshire Massachusetts.
The Athol ads particularized and placed on FRBO.com have spacious duplex, studio houseboat, hidden houseboat, and waterfront bungalow.
Hitch, oblige, and register on Tuesday to begin, kick off, open, and inaugurate on this sally.
|
|
