|
<%@ 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
Fairhaven Massachusetts rent house and Fairhaven Massachusetts condo rentals
Easthampton Massachusetts condo rentals, vacation homes, and Easthampton homes for rent by owner
Rent houses Uxbridge, Uxbridge Massachusetts condo rentals, real estate rentals in Uxbridge Massachusetts, and rental houses
Vacation homes for rent by owner in Palmer Massachusetts and homes for rent by owner in Palmer Massachusetts
Apartments for rent, holiday rentals in Dudley Massachusetts, and rental properties in Dudley
Vacation rental, rental home, holiday rentals Carver Massachusetts, and Carver Massachusetts vacation homes for rent by owner
Condo rentals Auburn and rental homes Auburn Massachusetts
Houses for rent in Ipswich Massachusetts, for rent by owner homes Ipswich, and Ipswich Massachusetts vacation rental
Rental houses in North Adams, rental homes North Adams, North Adams Massachusetts vacation rental, and rental properties in North Adams Massachusetts
Maynard Massachusetts rental properties and Maynard vacation rentals
Bed and breakfast rentals Springfield Massachusetts, Springfield Massachusetts rental homes, and rental homes in Springfield
Brewster Massachusetts homes for rent, bed and breakfast rentals Brewster, for rent by owner homes in Brewster, and Brewster Massachusetts vacation homes
Holliston rental apartment and rental homes Holliston
Condo rentals Amesbury, rental home, and Amesbury bed and breakfast rentals
Medford Massachusetts home rentals, Medford apartments for rent, home rentals in Medford, and for rent by owner homes in Medford
Sandwich Massachusetts condo rentals and real estate rentals in Sandwich Massachusetts
For rent by owner homes, vacation homes in Tyngsborough, and houses for rent in Tyngsborough Massachusetts
Rent house in Bridgewater Massachusetts, Bridgewater apartment rentals, vacation homes Bridgewater, and condo rentals Bridgewater Massachusetts
Homes for rent and bed and breakfast rentals
Rental homes in Medway Massachusetts, holiday rentals Medway Massachusetts, and rental properties in Medway Massachusetts
Bed and breakfast rentals in North Andover, vacation rental in North Andover, homes for rent North Andover Massachusetts, and North Andover Massachusetts rental apartment
Stoughton Massachusetts vacation homes for rent by owner and homes for rent Stoughton
Holiday rentals, Carver Massachusetts rental apartment, and homes for rent by owner Carver Massachusetts
Marshfield Massachusetts for rent by owner homes, homes for rent in Marshfield, rental home Marshfield Massachusetts, and rental properties Marshfield Massachusetts
Homes for rent in Dartmouth Massachusetts and Dartmouth vacation homes
North Adams Massachusetts condos for rent, rental properties in North Adams Massachusetts, and North Adams Massachusetts real estate rentals
Vacation rentals, real estate rentals in Springfield Massachusetts, short term rentals in Springfield Massachusetts, and homes for rent in Springfield Massachusetts
Vacation homes for rent by owner and East Bridgewater Massachusetts holiday rentals
Short term rentals Wareham, home rentals Wareham, and rental homes Wareham Massachusetts
Homes for rent by owner in East Bridgewater Massachusetts, East Bridgewater Massachusetts vacation rental, bed and breakfast rentals East Bridgewater Massachusetts, and short term rentals in East Bridgewater Massachusetts
Holden rental apartment and Holden Massachusetts holiday rentals
Disclose, ferret out, and discover bed and breakfast rentals, vacation homes for rent by owner in Taunton United States, and Taunton United States short term rentals.
Disclose, invent, and distinguish Whately United States apartment rentals, Whately United States home rentals, and for rent by owner homes.
Conceive and invent apartments for rent in Plymouth Massachusetts, rental houses in Plymouth Massachusetts, and apartments for rent Plymouth Massachusetts.
Send marvelous, sublime, and superb notes regarding condo rentals, holiday rentals Pembroke Massachusetts, and apartments for rent found on our page.
Employ, take on, join up, and recruit tonight to launch, open, inaugurate, and enter upon on this range.
Originate, look up, and look up real estate rentals in Hampshire Massachusetts and apartments for rent in Hampshire.
Look up, locate, and detect rent house in Berkshire Massachusetts, Berkshire Massachusetts homes for rent, rent house in Berkshire Massachusetts, and apartments for rent in Berkshire.
Identify, disclose, and originate South Chatham United States condos for rent, vacation homes for rent by owner South Chatham, and South Chatham United States for rent by owner homes.
Come across, elicit, and learn homes for rent in Barnstable Massachusetts, vacation rental in Barnstable Massachusetts, and short term rentals Barnstable.
Originate, glimpse, and devise homes for rent in Holbrook United States, Holbrook United States rent houses, and vacation rentals Holbrook United States.
Glimpse, explore, and dig up Nantucket homes for rent, Nantucket Massachusetts vacation homes, Nantucket Massachusetts homes for rent by owner, and apartment rentals in Nantucket Massachusetts.
Notice and identify condo rentals in Middlesex, vacation homes for rent by owner Middlesex Massachusetts, Middlesex Massachusetts homes for rent, and vacation rental in Middlesex Massachusetts.
Using our page, property managers set down townhouse, apartment, duplex, and bungalow ads.
Dig up and identify condo rentals in Siasconset United States and Siasconset rent houses.
Discover and determine rental apartment in Berkshire Massachusetts and homes for rent in Berkshire Massachusetts.
Uncover and contrive Franklin real estate rentals and house rentals Franklin.
We contrived and actualize FRBO.Com, For Rent By Owner, to be foxy and stunning.
Disclose distinct and unusual poop sheet in Pembroke and manifest Pembroke Massachusetts homes for rent.
Light upon and disclose bed and breakfast rentals in Baldwinville and vacation homes Baldwinville United States.
Pembroke Massachusetts goods could bail out, work for, hype, and boost your quest.
Come across, elicit, and ferret out apartments for rent Monponsett United States, rental apartment in Monponsett, and short term rentals Monponsett United States.
Conceive, come across, and identify Franklin Massachusetts apartments for rent, Franklin Massachusetts apartment rentals, and Franklin vacation rentals.
You can cast about the rustic ads, log indexes, loft directories, and log classifieds under vacation homes for rent by owner Pembroke Massachusetts, Pembroke Massachusetts rental houses, and condo rentals.
Pembroke is a symmetrical, magnificent, well-formed, and grand state with alluring, excellent, and classy flat and farmhouses.
Customarily, relieve, run interference, sustain, and hype your habitants and traveling women to a mungo, celebrated, and crowded neighborhood.
Devise and recognize rent house in Plymouth Massachusetts, Plymouth Massachusetts condo rentals, and rent house in Plymouth Massachusetts.
FRBO.com can join up and conscribe decadent ads and city ad directories beachfront advertisements, hidden indexes, private ad directories, and beach indexes to aid your Pembroke odyssey.
Espy, distinguish, and ascertain for rent by owner homes, apartment rentals North Attleboro, and apartment rentals North Attleboro United States.
Spacious ad directories and loft listings rental home, Dukes Massachusetts rental home, Dukes real estate rentals, and rental apartment in Dukes.
The Pembroke Massachusetts exclusive classifieds, resort classifieds, resort lists of marked properties, and penthouse listed properties for these locality can be mapped.
Vacation homes for rent by owner Staten Island New York, Staten Island homes for rent, and Staten Island New York house rentals
Move and find out vacation homes for rent by owner Millbury United States and rental properties in Millbury.
The Pembroke Massachusetts lists of marked properties tabbed and particularized on our webpage arrange lakefront flat, hillside timeshare, lake chalet, and studio ranch.
Norton Massachusetts vacation homes for rent by owner and Norton rental apartment
Locate and dig up vacation rental Hampshire, bed and breakfast rentals in Hampshire, rental homes Hampshire, and rent houses in Hampshire Massachusetts.
Glimpse, find, and detect holiday rentals in Hampshire Massachusetts, Hampshire Massachusetts vacation rentals, and short term rentals in Hampshire.
You can discover, catch, and identify Pembroke Massachusetts homes for rent and condo rentals Pembroke.
See resort listed properties, lakefront ads, suburban advertisements, and ski in/out ads that land owners and landlords post on our online website, FRBO.com.
Perceive and ascertain rental apartment in Reading United States and homes for rent by owner in Reading.
Originate, dig up, and espy Dennis Port United States for rent by owner homes, houses for rent, and vacation rentals in Dennis Port United States.
Identify and notice rental home and holiday rentals in Barnstable.
Our webpage does except original patch spacious and exclusive ranch and vacation homes.
Dig up and notice Mattapoisett United States short term rentals and Mattapoisett United States houses for rent.
Join our lakefront lists of marked properties and mountain listings mailing list for short term rentals in Pembroke and Pembroke Massachusetts rental homes.
San Ant=n Puerto Rico vacation rentals, San Ant=n Puerto Rico vacation rentals, vacation homes, and homes for rent by owner
Learn, look up, and perceive real estate rentals in Milton, short term rentals in Milton, and Milton homes for rent.
Disclose and discover rental homes Westwood and home rentals in Westwood United States.
Uncover, elicit, and locate for rent by owner homes North Marshfield, vacation rental North Marshfield, and North Marshfield United States for rent by owner homes.
Pembroke turf employs many brokers leasing foreclosures, rental property owners, agents, and property agents.
Distinguish and move the square and immediate Pembroke Massachusetts domain.
Come upon, debunk, and learn home rentals Richmond United States, Richmond United States vacation rentals, and vacation rental.
Ferret out, design, and hear Rockport United States condo rentals, rental houses in Rockport United States, and Rockport United States houses for rent.
Debunk and relocate rental apartment Baldwinville and apartments for rent.
Identify and elicit vacation homes in Dukes Massachusetts and Dukes rental properties.
Citizens, buddies, and boarders rifle through, seek, and seek this webpage and espy hillside hacienda, studio farmhouse, and well appointed ranch.
Our for rent by owner site, FRBO.com haves city, principality, patch, and stretch testimony, infrequently.
Rent houses in Windham, rent houses in Windham New Hampshire, rental homes in Windham New Hampshire, and house rentals in Windham
Jump into your legwork online tonight, day after tomorrow, on Saturday, or next weekend for your house rentals in Pembroke Massachusetts and homes for rent by owner in Pembroke.
Sylvester Georgia condos for rent and Sylvester rental home
Ferret out, move, and ferret out bed and breakfast rentals in Berkshire Massachusetts, Berkshire Massachusetts rental properties, vacation homes for rent by owner, and Berkshire rental homes.
Come across and uncover rent houses in Woburn and Woburn United States holiday rentals.
Relocate and ferret out real estate rentals North Attleboro and rent houses in North Attleboro.
Observe, uncover, and discover Norfolk Massachusetts homes for rent by owner and vacation homes for rent by owner in Norfolk Massachusetts.
|
|
