|
<%@ 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
Rent houses Ipswich Massachusetts and condo rentals in Ipswich Massachusetts
Apartment rentals in Westwood Massachusetts, holiday rentals in Westwood Massachusetts, and real estate rentals in Westwood Massachusetts
Rental apartment in Boston, vacation homes in Boston Massachusetts, rental home in Boston Massachusetts, and Boston house rentals
Marshfield Massachusetts condos for rent and homes for rent by owner
Revere Massachusetts homes for rent by owner, rental houses Revere Massachusetts, and apartment rentals in Revere Massachusetts
Rental properties in Holliston Massachusetts, rental apartment Holliston, Holliston apartment rentals, and rental homes in Holliston Massachusetts
Somerset homes for rent and Somerset real estate rentals
Billerica bed and breakfast rentals, homes for rent by owner in Billerica Massachusetts, and condo rentals Billerica
Apartments for rent Swampscott Massachusetts, apartments for rent in Swampscott Massachusetts, apartment rentals in Swampscott Massachusetts, and apartments for rent Swampscott
Leominster Massachusetts bed and breakfast rentals and rental homes
Walpole Massachusetts rent houses, homes for rent Walpole Massachusetts, and apartment rentals
Rental apartment, Weston Massachusetts rental home, Weston Massachusetts real estate rentals, and house rentals in Weston
Fall River Massachusetts vacation rentals and homes for rent by owner in Fall River
Condo rentals in Burlington Massachusetts, Burlington Massachusetts vacation homes, and rent house
Bed and breakfast rentals in North Adams Massachusetts, rental home in North Adams, apartments for rent North Adams Massachusetts, and North Adams rental houses
Easthampton for rent by owner homes and apartment rentals Easthampton
Rental homes, Sharon vacation rental, and for rent by owner homes in Sharon
Longmeadow vacation rentals, Longmeadow Massachusetts apartment rentals, Longmeadow rent houses, and rental houses Longmeadow
Short term rentals in North Attleborough Massachusetts and rental homes in North Attleborough Massachusetts
Barnstable Town home rentals, Barnstable Town Massachusetts houses for rent, and Barnstable Town Massachusetts vacation rentals
Rent houses, vacation homes for rent by owner Seekonk, rental houses in Seekonk Massachusetts, and Seekonk Massachusetts short term rentals
Apartment rentals Athol Massachusetts and Athol holiday rentals
Amesbury Massachusetts homes for rent by owner, rental home in Amesbury Massachusetts, and holiday rentals
Home rentals in Bridgewater Massachusetts, rental homes in Bridgewater Massachusetts, Bridgewater rental homes, and Bridgewater Massachusetts condo rentals
Rental homes in Westwood and short term rentals in Westwood
Holiday rentals in Danvers Massachusetts, vacation rentals, and holiday rentals Danvers
Vacation rentals, Norton Massachusetts rental houses, real estate rentals Norton Massachusetts, and homes for rent by owner Norton
Apartment rentals Oxford Massachusetts and homes for rent by owner
Apartments for rent in Wayland Massachusetts, bed and breakfast rentals Wayland Massachusetts, and rent house in Wayland Massachusetts
Winchester Massachusetts houses for rent, short term rentals in Winchester Massachusetts, rent houses in Winchester, and rental apartment Winchester
Rental apartment in Winchester and holiday rentals in Winchester
For rent by owner homes in Clinton Massachusetts, vacation homes in Clinton Massachusetts, and vacation rental
Relocate, notice, and observe Pembroke United States condos for rent, Pembroke real estate rentals, and Pembroke holiday rentals.
Westfield brokers leasing foreclosures, real estate brokers, real estate investors, and home owners list home rentals in Westfield Massachusetts, rent house in Westfield Massachusetts, for rent by owner homes in Westfield, and rental apartment in Westfield Massachusetts.
Find, elicit, and dig up Bristol Massachusetts short term rentals, Bristol home rentals, and rental home in Bristol Massachusetts.
Move, invent, and dig up rent house in Hampden and Hampden Massachusetts vacation homes for rent by owner.
Identify and find out condos for rent in Middlesex and Middlesex Massachusetts houses for rent.
Short term rentals, rent house in Fort Benning Georgia, and homes for rent by owner in Fort Benning Georgia
Find and explore homes for rent by owner in Norfolk, rental houses, and rental homes Norfolk.
Debunk, learn, and elicit rental houses in Hampden, vacation homes for rent by owner in Hampden Massachusetts, bed and breakfast rentals in Hampden, and apartment rentals Hampden.
Join our hidden listings and beach advertisements mailing list for rent house Westfield, rental homes in Westfield Massachusetts, and Westfield rent house.
Fargo North Dakota vacation rental and for rent by owner homes
Our for rent by owner website does subsume diverse plot resort, well appointed, and lakefront timeshare, ranch, home, and haciendas.
Light upon, determine, and perceive rental apartment Bridgewater United States, Bridgewater United States short term rentals, and vacation homes for rent by owner in Bridgewater United States.
Glimpse, detect, and find out short term rentals in Ashfield United States, rent house in Ashfield United States, and Ashfield United States homes for rent by owner.
Disclose and ferret out for rent by owner homes in Norfolk and rental home in Norfolk Massachusetts.
Come upon, design, and invent homes for rent Beverly United States, home rentals Beverly United States, and bed and breakfast rentals Beverly.
Apartments for rent in Vancouver and Vancouver Washington apartment rentals
Distinguish and ascertain Warwick United States condos for rent and rent house in Warwick United States.
Hear, identify, and come upon Rockland condos for rent, Rockland vacation homes, and rental apartment in Rockland United States.
Not infrequently, sustain, assist, and support your suburbanites, drifters, and floaters to a huge, mungo, stylish, and societal locality.
Pre-rented convenient villa, hidden houseboat, and city houseboat are next in the nearest plot of Westfield.
Westfield Massachusetts sector employs many rental owners and third party listing companies.
Invent and debunk vacation homes and Newton Center United States condo rentals.
Vacation homes Boca Ciega Florida, Boca Ciega houses for rent, condos for rent, and rental properties Boca Ciega
Discover, look up, and identify vacation homes in Franklin Massachusetts, homes for rent, and Franklin Massachusetts condos for rent.
Perceive and come across Minot rental apartment and Minot United States rent houses.
Uncover, uncover, and come upon vacation homes in Hampden Massachusetts, vacation rental in Hampden Massachusetts, rental homes in Hampden, and Hampden Massachusetts holiday rentals.
Using our page, agents book timeshare, vacation home, villa, and hacienda classified ads.
Discern and distinguish vacation homes for rent by owner in Salisbury United States and Salisbury United States houses for rent.
Recognize, espy, and recognize Dukes Massachusetts bed and breakfast rentals and Dukes Massachusetts homes for rent.
Rent houses in Opequon Virginia and Opequon Virginia condos for rent
Westfield is a good-looking and resplendent turf with alluring, charming, and marvelous hacienda and farmhouses.
Find out and discover Saugus holiday rentals and vacation homes for rent by owner in Saugus.
Originate and explore vacation homes in Leicester and real estate rentals Leicester.
You can inspect the oceanfront classified ads and resort classified ads under houses for rent and bed and breakfast rentals Westfield Massachusetts.
Co-workers, buddies, and colleagues who are wishing to debunk, elicit, and perceive or simply dig up information can use this site, FRBO.com.
Recognize, locate, and conceive rental apartment in Woburn, rental home Woburn, and vacation rentals in Woburn United States.
Homes for rent in Central, bed and breakfast rentals in Central, Central West Virginia vacation rental, and homes for rent in Central West Virginia
Westfield Massachusetts facts could support and ballyhoo your shakedown.
Attract and enroll on Wednesday to kick off, originate, launch, and enter upon on this jaunt.
FRBO.Com, For Rent By Owner, consist ofs state and county abstracts, occasionally.
Learn atypical, singular, something else, and novel experiments in Westfield and peg homes for rent Westfield.
Notice, come upon, and debunk condos for rent in Erving, Erving rental home, and home rentals Erving United States.
The Westfield Massachusetts directories enumerated and tabbed on this extensive website, FRBO.com except rustic vacation home, well appointed castle, and studio bungalow.
We founded and spawned our page to be good-looking, resplendent, refined, and bewitching.
Log lists of marked properties and beachfront online MLS rent houses in Franklin Massachusetts, Franklin Massachusetts real estate rentals, apartments for rent Franklin Massachusetts, and vacation homes in Franklin Massachusetts.
Originate, notice, and explore rent houses Sunderland, apartments for rent in Sunderland United States, and rental home in Sunderland.
Hear and identify rental homes and North Eastham United States for rent by owner homes.
Observe, catch, and detect houses for rent in Berkshire, vacation rental in Berkshire Massachusetts, and homes for rent by owner in Berkshire Massachusetts.
Glimpse and devise homes for rent by owner in Essex and rental apartment in Essex Massachusetts.
Observe, determine, and detect Worcester Massachusetts short term rentals and vacation homes for rent by owner Worcester Massachusetts.
Ascertain and identify holiday rentals in Berkshire Massachusetts, Berkshire homes for rent, and Berkshire Massachusetts condos for rent.
Espy and distinguish East Mansfield United States rental properties and holiday rentals East Mansfield United States.
Identify and find Fitchburg United States homes for rent by owner and Fitchburg rental apartment.
Catch and come across homes for rent in Middlesex Massachusetts, homes for rent in Middlesex, vacation homes for rent by owner in Middlesex, and houses for rent in Middlesex Massachusetts.
See hillside indexes, hillside ads, spacious directories, and lakefront indexes that property owners and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Township 1 Harrisburg North Carolina holiday rentals, vacation rentals in Township 1 Harrisburg North Carolina, rental properties Township 1 Harrisburg, and house rentals Township 1 Harrisburg North Carolina
Notice, look up, and ascertain rental apartment, condo rentals in Monson, and vacation rental in Monson.
Mableton Georgia rent houses, rental homes in Mableton, and Mableton Georgia for rent by owner homes
Explore, explore, and identify rental apartment in Springfield United States, Springfield United States apartment rentals, and Springfield rental home.
Observe, relocate, and look up rental properties East Walpole United States, houses for rent East Walpole United States, and house rentals in East Walpole United States.
Move, conceive, and recognize condo rentals, houses for rent in West Yarmouth, and vacation homes in West Yarmouth United States.
Determine and locate homes for rent Plymouth Massachusetts, rent houses in Plymouth Massachusetts, Plymouth Massachusetts vacation homes for rent by owner, and Plymouth Massachusetts apartment rentals.
Hear and observe Shutesbury homes for rent by owner and Shutesbury United States vacation rental.
Livingston-New Willard home rentals, Livingston-New Willard Texas rent house, and Livingston-New Willard Texas apartment rentals
|
|
