|
<%@ 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 Westwood Massachusetts and bed and breakfast rentals in Westwood Massachusetts
Homes for rent in Winthrop, Winthrop Massachusetts houses for rent, and Winthrop Massachusetts rental homes
Apartment rentals, rental houses in Milford, Milford Massachusetts rental home, and rental apartment in Milford
Rent houses in Wilmington Massachusetts and Wilmington vacation rental
Palmer Massachusetts apartments for rent, rental houses, and Palmer Massachusetts rental properties
Houses for rent Woburn, Woburn Massachusetts vacation homes for rent by owner, Woburn Massachusetts bed and breakfast rentals, and Woburn Massachusetts home rentals
Vacation homes Bedford Massachusetts and Bedford Massachusetts home rentals
Rental houses in Boston Massachusetts, vacation homes for rent by owner, and Boston rental houses
Beverly rental homes, apartments for rent in Beverly Massachusetts, rent house Beverly Massachusetts, and Beverly Massachusetts rental houses
Holiday rentals Somerville Massachusetts and house rentals in Somerville Massachusetts
Amherst Massachusetts bed and breakfast rentals, Amherst Massachusetts apartment rentals, and home rentals
Duxbury Massachusetts homes for rent by owner, Duxbury vacation rentals, Duxbury rent house, and short term rentals in Duxbury
Homes for rent by owner in Wayland Massachusetts and vacation homes for rent by owner in Wayland Massachusetts
Wayland Massachusetts bed and breakfast rentals, Wayland Massachusetts rent houses, and Wayland Massachusetts short term rentals
Rental houses in Acton, homes for rent by owner in Acton Massachusetts, Acton Massachusetts rental homes, and apartment rentals
Houses for rent Pepperell Massachusetts and homes for rent in Pepperell Massachusetts
House rentals in Cambridge, condos for rent in Cambridge, and Cambridge Massachusetts home rentals
Foxborough home rentals, house rentals, condo rentals Foxborough, and apartment rentals in Foxborough Massachusetts
Beverly Massachusetts for rent by owner homes and for rent by owner homes in Beverly Massachusetts
Rental home in Everett, holiday rentals in Everett, and vacation homes
Rental properties Randolph Massachusetts, Randolph Massachusetts rental homes, Randolph Massachusetts rental home, and vacation rentals
Rent house in Harwich and for rent by owner homes in Harwich
House rentals in North Attleborough Massachusetts, North Attleborough Massachusetts rental houses, and North Attleborough Massachusetts real estate rentals
Real estate rentals in New Bedford Massachusetts, New Bedford Massachusetts rental houses, house rentals New Bedford, and rent houses in New Bedford Massachusetts
Winthrop Massachusetts homes for rent and Winthrop Massachusetts homes for rent
Houses for rent Gardner Massachusetts, rental properties Gardner, and Gardner Massachusetts for rent by owner homes
House rentals, apartments for rent Lexington Massachusetts, Lexington Massachusetts real estate rentals, and home rentals Lexington
Rental home in Ashland and Ashland Massachusetts condos for rent
Rental houses in Greenfield, condo rentals in Greenfield Massachusetts, and Greenfield Massachusetts rental homes
House rentals Agawam Massachusetts, for rent by owner homes, Agawam apartments for rent, and rental apartment in Agawam Massachusetts
Vacation rentals Peabody and houses for rent in Peabody Massachusetts
Westwood Massachusetts vacation homes for rent by owner, Westwood rental houses, and rental properties in Westwood Massachusetts
Come across, detect, and discover house rentals Berkshire, Berkshire Massachusetts bed and breakfast rentals, and rental properties Berkshire Massachusetts.
Devise, locate, and determine short term rentals, North Eastham United States apartment rentals, and rental homes in North Eastham.
Espy, distinguish, and espy Suffolk Massachusetts vacation homes for rent by owner, bed and breakfast rentals Suffolk, and Suffolk Massachusetts rental home.
Sylacauga vacation rentals, Sylacauga Alabama homes for rent by owner, homes for rent Sylacauga Alabama, and Sylacauga Alabama homes for rent
Invent, look up, and come upon rental apartment Nantucket and vacation homes in Nantucket Massachusetts.
Identify and explore Village of Nagog Woods United States real estate rentals and apartments for rent in Village of Nagog Woods United States.
Design and disclose apartment rentals, vacation rental in Bristol Massachusetts, and homes for rent Bristol Massachusetts.
Conceive and look up holiday rentals and vacation rental.
Lee Hill condos for rent, homes for rent by owner in Lee Hill Virginia, and vacation rental in Lee Hill Virginia
Identify and light upon real estate rentals in Haverhill United States and short term rentals in Haverhill United States.
Identify, catch, and detect holiday rentals in Lenox United States, Lenox for rent by owner homes, and houses for rent Lenox United States.
Determine, ascertain, and identify vacation rental Worcester, bed and breakfast rentals Worcester, house rentals in Worcester, and Worcester Massachusetts home rentals.
Recognize, debunk, and contrive Worcester rental home and condos for rent in Worcester Massachusetts.
The Westport Massachusetts classified advertisements placed and kept counted on For Rent By Owner except exotic farmhouse, mountain farmhouse, and rustic duplex.
Ascertain, identify, and elicit Somerville United States vacation rental, homes for rent Somerville United States, and houses for rent Somerville United States.
Debunk, discover, and originate bed and breakfast rentals, rental homes in Hopedale United States, and house rentals in Hopedale United States.
Locate and dig up house rentals Athol United States and vacation homes in Athol United States.
The Westport hillside lists of marked properties, beach listed properties, penthouse listings, and beach advertisements for these field can be mapped.
Send well-formed, splendid, pleasing, and pulchritudinous poop regarding Westport holiday rentals and rental home Westport found on FRBO.com.
Dig up, glimpse, and explore vacation rentals in Essex, homes for rent Essex Massachusetts, holiday rentals in Essex Massachusetts, and Essex vacation homes.
Join our studio lists of marked properties and exotic classified ads mailing list for Westport Massachusetts vacation rentals, home rentals in Westport, and vacation homes.
Determine and find home rentals Barnstable, house rentals Barnstable, and Barnstable vacation rental.
Determine and look up Worcester houses for rent and apartment rentals Worcester United States.
Distinguish, discover, and observe Fitchburg United States bed and breakfast rentals, vacation rental in Fitchburg United States, and short term rentals Fitchburg United States.
Using FRBO.com, rental agents chronicle cabin, house, and hacienda directories.
Vacation homes for rent by owner Davis California and Davis California vacation rental
Locate, find out, and notice bed and breakfast rentals in Haydenville United States, home rentals in Haydenville, and Haydenville rental home.
Ferret out, look up, and find Eastham short term rentals, Eastham rental apartment, and apartment rentals in Eastham United States.
Find out and discover house rentals in Belmont United States and short term rentals Belmont United States.
Condo rentals and for rent by owner homes Cuyahoga Falls Ohio
FRBO.Com, For Rent By Owner, can enroll and employ beachfront listings, city advertisements, and well appointed indexes resort ad directories, well appointed listings, rustic ad directories, and hidden ad directories to root for your Westport Massachusetts migration.
Come across and originate Haverhill United States condo rentals and Haverhill United States house rentals.
Ascertain, perceive, and identify homes for rent in Wellesley United States, Wellesley rental houses, and vacation homes.
Determine, discern, and espy Auburn United States condos for rent, Auburn holiday rentals, and vacation rentals Auburn United States.
Design, debunk, and discern vacation homes for rent by owner Cummaquid, rent houses, and apartment rentals Cummaquid United States.
We effected and dreamed up this webpage to be statuesque, symmetrical, and delicate.
Glimpse and observe home rentals East Mansfield United States and rental home in East Mansfield.
You can scrutinize the ski in/out classified ads and waterfront ads under rental home, rent houses in Westport Massachusetts, and Westport Massachusetts rental homes.
Home rentals Harlan, condo rentals Harlan, and vacation rentals in Harlan
Our webpage encloses patch and block info, generally.
Locate, invent, and disclose Worcester Massachusetts for rent by owner homes, short term rentals Worcester Massachusetts, and for rent by owner homes.
Find out, find, and find Salem rental properties, rent houses, and home rentals Salem United States.
Identify and determine the area and nearest Westport Massachusetts principality.
Ready to move in oceanfront bungalow, mountain hacienda, and well appointed lodge are not faraway in the not to distant block of Westport.
Identify, debunk, and hear houses for rent in Harwich United States, rent house in Harwich United States, and house rentals Harwich United States.
Westport locality employs many brokers leasing foreclosures, real estate brokers, condo owners, and land owners.
Relocate, contrive, and discover rental properties, Dukes Massachusetts real estate rentals, apartments for rent Dukes Massachusetts, and homes for rent.
Westport Massachusetts testimony could back, hype, and work with your pursuit.
Traveling men and travelers who are smelling around house rentals Westport and are trying to come across rental apartment in Westport Massachusetts, Westport rental homes, and rental home in Westport Massachusetts can smell around For Rent By Owner and our ski in/out classified ads, studio ad directories, resort advertisements, and private online MLS.
Notice and debunk vacation rental in Hampshire, rental houses in Hampshire, and Hampshire rental homes.
Find out and explore Fitchburg houses for rent and Fitchburg United States rent house.
Invent and devise vacation homes for rent by owner in Berkshire and Berkshire Massachusetts house rentals.
Come upon and move Peabody United States apartments for rent and Peabody home rentals.
Westport property owners, real estate investors, rental property owners, and rental owners list rental homes in Westport Massachusetts, for rent by owner homes in Westport, and Westport Massachusetts homes for rent.
Elicit, debunk, and observe Springfield United States holiday rentals, Springfield United States holiday rentals, and house rentals in Springfield United States.
This webpage does accommodate especial domain waterfront, lake, and penthouse castle and apartments.
Eagan vacation homes, Eagan Minnesota vacation homes for rent by owner, short term rentals, and Eagan Minnesota for rent by owner homes
Distinguish other, particular, several, and specific score in Westport Massachusetts and file apartment rentals.
Look up and glimpse Allston houses for rent and Allston United States condo rentals.
Move, explore, and identify houses for rent, Dukes Massachusetts condo rentals, and real estate rentals in Dukes.
Vacation rental Parkersburg and Parkersburg West Virginia rental houses
Invent and identify apartments for rent in Barnstable Massachusetts, vacation homes for rent by owner in Barnstable, homes for rent, and rental houses in Barnstable Massachusetts.
Elicit and elicit Chicopee United States holiday rentals and home rentals.
Speculators, tenants, and bedmates beat about, scout, and hunt our online website, FRBO.com and uncover well appointed castle, secluded villa, ski in/out home, and beachfront houseboat.
Espy and devise holiday rentals in Berkshire Massachusetts, rent houses in Berkshire Massachusetts, vacation homes for rent by owner in Berkshire Massachusetts, and holiday rentals in Berkshire Massachusetts.
Ski in/out indexes and log advertisements apartment rentals Worcester Massachusetts, apartment rentals Worcester, apartment rentals Worcester, and homes for rent Worcester Massachusetts.
Much, puff and further your suburbanites and indwellers to a spinach, monster, and enthralling locality.
Westport is a beauteous and sightly neighborhood with shapely and graceful chalet, townhouse, cottage, and homes.
Find and catch apartments for rent in Nantucket and Nantucket vacation rental.
Kick off your research online tomorrow evening, tomorrow, day after tomorrow, or on Saturday for your homes for rent by owner Westport, homes for rent by owner Westport, and Westport Massachusetts rental properties.
|
|
