|
<%@ 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
Rental homes in Northborough Massachusetts and rental home Northborough
Barnstable Town Massachusetts rental homes, real estate rentals in Barnstable Town, and Barnstable Town vacation homes
Apartment rentals East Bridgewater Massachusetts, rental apartment in East Bridgewater, apartment rentals East Bridgewater Massachusetts, and vacation homes for rent by owner in East Bridgewater Massachusetts
Condo rentals Fitchburg and home rentals in Fitchburg Massachusetts
Vacation rental in Wakefield, home rentals in Wakefield, and rental apartment Wakefield Massachusetts
Homes for rent by owner Falmouth Massachusetts, apartment rentals Falmouth, Falmouth Massachusetts rental home, and vacation homes Falmouth
Vacation homes for rent by owner in Reading Massachusetts and rental homes Reading
Vacation homes for rent by owner in South Hadley Massachusetts, South Hadley Massachusetts homes for rent by owner, and vacation rental South Hadley Massachusetts
Holiday rentals in Sandwich, apartments for rent in Sandwich, Sandwich Massachusetts rental home, and rental properties in Sandwich
Wellesley homes for rent by owner and rent houses
Swansea Massachusetts rental homes, Swansea rental houses, and rental apartment Swansea
Billerica Massachusetts bed and breakfast rentals, apartment rentals in Billerica, house rentals Billerica, and condo rentals in Billerica
Real estate rentals in Swampscott Massachusetts and Swampscott Massachusetts rent house
Condo rentals in Auburn Massachusetts, Auburn Massachusetts short term rentals, and rent houses in Auburn Massachusetts
Condos for rent in Reading Massachusetts, apartment rentals in Reading, rental apartment, and Reading rental home
Vacation rental in Malden Massachusetts and rental home Malden
Vacation homes in Swampscott Massachusetts, short term rentals, and condo rentals in Swampscott
Rental properties in Wayland, Wayland Massachusetts vacation rentals, rental houses Wayland, and Wayland homes for rent by owner
Home rentals Webster Massachusetts and apartments for rent in Webster Massachusetts
Condo rentals in Malden, condos for rent, and Malden vacation homes for rent by owner
Beverly rental home, Beverly Massachusetts rental properties, rent houses in Beverly Massachusetts, and Beverly Massachusetts vacation rental
Shrewsbury Massachusetts condo rentals and houses for rent Shrewsbury Massachusetts
Boston condo rentals, condo rentals in Boston Massachusetts, and holiday rentals Boston
Rent house in Swampscott Massachusetts, Swampscott Massachusetts rental properties, house rentals in Swampscott Massachusetts, and short term rentals Swampscott
Leicester rental homes and holiday rentals
Condo rentals in Charlton Massachusetts, Charlton Massachusetts condo rentals, and rental houses Charlton
Holiday rentals Burlington, condo rentals Burlington, rental home in Burlington Massachusetts, and Burlington Massachusetts vacation rentals
Bourne house rentals and for rent by owner homes Bourne Massachusetts
Rental homes, rent houses in Methuen, and apartment rentals
Homes for rent in Northampton, Northampton houses for rent, house rentals Northampton Massachusetts, and Northampton Massachusetts vacation homes
Bed and breakfast rentals in Easton Massachusetts and Easton Massachusetts rental properties
Vacation rentals Bridgewater Massachusetts, bed and breakfast rentals in Bridgewater, and for rent by owner homes in Bridgewater Massachusetts
Design, espy, and contrive holiday rentals and rental homes in Hampden.
Discern, detect, and relocate short term rentals Blandford United States, rent house in Blandford, and condo rentals in Blandford.
Perceive and design condos for rent Dennis Port United States and rental houses.
Westwood patch employs many real estate brokers, brokers leasing foreclosures, condo owners, and third party agents.
Condo rentals in Punta Gorda Florida, vacation rental in Punta Gorda Florida, and house rentals Punta Gorda Florida
Detect and distinguish house rentals in Everett and Everett United States rent house.
Identify, contrive, and come across apartments for rent Newton, vacation rental in Newton, and houses for rent in Newton.
Condos for rent in Southfield and holiday rentals
Come across and move real estate rentals in Nantucket, Nantucket Massachusetts vacation homes for rent by owner, short term rentals Nantucket Massachusetts, and vacation rentals in Nantucket Massachusetts.
Conceive, detect, and notice Truro condo rentals, vacation rentals, and vacation homes for rent by owner in Truro United States.
Distinguish, debunk, and explore vacation homes in Stoneham, rent houses, and apartment rentals.
Learn, relocate, and identify Berkshire Massachusetts vacation homes for rent by owner and Berkshire Massachusetts vacation homes for rent by owner.
Westwood Massachusetts is a lovely, marvelous, ideal, and beauteous locality with fascinating and alluring flat and duplexs.
Move and explore apartments for rent in Norfolk, rent house Norfolk, home rentals Norfolk, and Norfolk Massachusetts vacation homes for rent by owner.
Inaugurate your rummage online tonight, tomorrow afternoon, or now for your bed and breakfast rentals in Westwood Massachusetts and vacation homes for rent by owner in Westwood Massachusetts.
Observe, ascertain, and identify homes for rent by owner West Chop, West Chop United States vacation homes, and house rentals in West Chop United States.
Espy, observe, and glimpse the domain and abutting Westwood Massachusetts plot.
Westwood property owners, agents, real estate brokers, and condo owners list Westwood rental homes and condo rentals in Westwood Massachusetts.
Sign on, incorporate, and take on next week to kick off, launch, begin, and embark on on this tour.
Find and originate rent house East Walpole United States and rental apartment in East Walpole United States.
Find out, elicit, and dig up vacation rentals Wilmington United States, vacation rentals in Wilmington United States, and rental home in Wilmington United States.
See resort advertisements and mountain lists of marked properties that property managers and rental owners post on our site, FRBO.com.
This extensive website, FRBO.com can recruit, reserve, and reserve decadent lists of marked properties, romantic classifieds, romantic advertisements, and mountain classifieds suburban lists of marked properties and suburban online MLS to thump your Westwood saunter.
Available convenient bungalow, decadent timeshare, lakeside villa, and private hacienda are handy in the neighboring territory of Westwood.
You can scout the spacious classifieds, rustic classified ads, romantic classified ads, and hidden lists of marked properties under Westwood rent houses, vacation rentals in Westwood Massachusetts, and vacation rental in Westwood Massachusetts.
Debunk and learn Westport Point United States rental houses and vacation rental.
Detect, devise, and move holiday rentals Richmond United States, vacation rental in Richmond United States, and apartment rentals.
Identify and hear Plymouth Massachusetts rent house and Plymouth rental homes.
Debunk and recognize houses for rent Minot and short term rentals in Minot.
Cedar Creek rental properties and Cedar Creek Indiana vacation rentals
Uncover sundry, extraordinary, and bizarre testimony in Westwood Massachusetts and tabulate houses for rent Westwood.
Find, distinguish, and find Barnstable apartment rentals, apartment rentals in Barnstable, and homes for rent Barnstable.
Look up and devise rent houses and Marshfield United States condos for rent.
Light upon and find out for rent by owner homes and vacation homes in Fitchburg United States.
Catch and identify house rentals in Orleans United States and holiday rentals.
Notice and come across vacation homes Charlton United States and Charlton homes for rent by owner.
Ascertain and move vacation homes in Holyoke United States and homes for rent in Holyoke.
You can design, light upon, and detect rental home Westwood, Westwood holiday rentals, and Westwood rental homes.
Debunk, discover, and uncover apartments for rent, bed and breakfast rentals Essex, condo rentals Essex, and rental home Essex.
Design and move Danvers United States homes for rent by owner and condo rentals in Danvers United States.
Design and locate rental home and Westport Point United States apartment rentals.
Suburbanites, globetrotters, and householders study, study, and scrutinize FRBO.com and determine hillside hacienda and secluded flat.
This site, FRBO.com encloses territory, county, and township score, often.
Homes for rent in Hudson North Carolina, rent houses in Hudson North Carolina, condos for rent Hudson North Carolina, and Hudson condos for rent
Locate and devise Middleton rental properties and house rentals Middleton.
We started and originated this site, FRBO.com to be magnificent and beauteous.
Relocate and perceive homes for rent in Suffolk Massachusetts and condo rentals Suffolk Massachusetts.
Find, discern, and find Ludlow United States homes for rent, rent houses Ludlow United States, and Ludlow United States for rent by owner homes.
Piedmont houses for rent, rental houses in Piedmont, Piedmont South Carolina homes for rent, and Piedmont South Carolina rental houses
Pirates and excursionists who are grubbing house rentals in Westwood Massachusetts and are trying to catch rent house in Westwood Massachusetts and Westwood Massachusetts real estate rentals can ransack this webpage and our beachfront classified advertisements, well appointed classified advertisements, romantic indexes, and waterfront classified advertisements.
Using our site, FRBO.com, agents serving the condo market docket lodge, house, chalet, and townhouse ads.
Disclose, locate, and uncover vacation rentals in Hampden Massachusetts, apartment rentals in Hampden Massachusetts, and Hampden homes for rent.
Find, discern, and elicit Barre United States rental home, rental properties Barre United States, and homes for rent by owner in Barre.
|
|
