|
<%@ 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
Taunton rent houses and holiday rentals in Taunton
Stoughton Massachusetts for rent by owner homes, rental homes, and house rentals in Stoughton Massachusetts
Milford Massachusetts houses for rent, Milford Massachusetts rent house, rent house Milford, and vacation homes Milford
Pepperell Massachusetts rental apartment and Pepperell Massachusetts rent houses
Hopkinton Massachusetts houses for rent, rental home in Hopkinton Massachusetts, and Hopkinton vacation rental
Home rentals in Millbury, Millbury real estate rentals, condo rentals, and real estate rentals Millbury
Homes for rent by owner in Dedham and real estate rentals Dedham
Vacation rentals in Seekonk, Seekonk Massachusetts rental homes, and rental houses Seekonk Massachusetts
Vacation rentals Agawam Massachusetts, rental properties Agawam Massachusetts, houses for rent in Agawam, and rental home in Agawam Massachusetts
Houses for rent East Bridgewater and houses for rent in East Bridgewater Massachusetts
East Longmeadow Massachusetts homes for rent, East Longmeadow Massachusetts homes for rent, and East Longmeadow Massachusetts holiday rentals
Longmeadow homes for rent by owner, rental properties Longmeadow Massachusetts, bed and breakfast rentals Longmeadow, and condo rentals in Longmeadow Massachusetts
Holiday rentals Whitman and condos for rent in Whitman
Watertown holiday rentals, Watertown Massachusetts apartment rentals, and apartment rentals in Watertown Massachusetts
Rent house, apartment rentals in Westport, vacation homes for rent by owner in Westport Massachusetts, and Westport Massachusetts rental homes
Homes for rent in Chicopee Massachusetts and rental properties
Vacation homes, apartment rentals, and rental homes Westford Massachusetts
Bedford condo rentals, vacation homes for rent by owner Bedford, short term rentals Bedford Massachusetts, and Bedford Massachusetts bed and breakfast rentals
Apartments for rent Holden Massachusetts and Holden Massachusetts rental houses
Vacation rentals, house rentals Somerville Massachusetts, and Somerville Massachusetts rental apartment
Rental houses in Sandwich Massachusetts, Sandwich Massachusetts rent houses, condo rentals in Sandwich Massachusetts, and rental apartment in Sandwich Massachusetts
Rental apartment in Chicopee Massachusetts and for rent by owner homes Chicopee Massachusetts
Vacation homes for rent by owner in East Longmeadow Massachusetts, homes for rent by owner East Longmeadow, and homes for rent in East Longmeadow Massachusetts
Vacation homes for rent by owner, Chelsea apartment rentals, Chelsea Massachusetts vacation rentals, and houses for rent in Chelsea Massachusetts
Vacation rental Wareham Massachusetts and Wareham Massachusetts vacation homes
Apartment rentals Braintree Massachusetts, rental properties Braintree Massachusetts, and condos for rent in Braintree Massachusetts
Bed and breakfast rentals New Bedford, New Bedford apartments for rent, New Bedford for rent by owner homes, and New Bedford Massachusetts rental apartment
Homes for rent in Wakefield Massachusetts and holiday rentals Wakefield Massachusetts
Rent house, rental home Waltham, and rental home in Waltham Massachusetts
Lynn vacation rentals, bed and breakfast rentals in Lynn Massachusetts, house rentals Lynn Massachusetts, and Lynn holiday rentals
Residents, adventurers, and indwellers root and cast about our for rent by owner website and come upon rustic duplex and mountain villa.
East Cameron Texas houses for rent and homes for rent in East Cameron Texas
FRBO.com can enter into and inscribe beach ads, secluded indexes, rustic ads, and oceanfront indexes spacious listed properties, lakefront ad directories, and studio advertisements to back your Wellesley route.
Bedmates and fortune-hunters who are wishing to debunk and glimpse or simply espy information can use our for rent by owner site, FRBO.com.
Locate, espy, and discover for rent by owner homes in Hyannis United States, short term rentals in Hyannis United States, and Hyannis United States vacation homes.
Dig up and determine houses for rent in Malden United States and vacation homes for rent by owner.
Invent and elicit Suffolk Massachusetts real estate rentals, for rent by owner homes Suffolk, and Suffolk Massachusetts home rentals.
Beach classified ads and romantic listed properties rental apartment Plymouth, rent house, rent house in Plymouth Massachusetts, and rent houses Plymouth.
Catch, move, and discern Chestnut Hill home rentals, rent house Chestnut Hill, and Chestnut Hill United States homes for rent by owner.
Locate and find out rental homes in Franklin Massachusetts and short term rentals in Franklin Massachusetts.
Home rentals Blairsville Georgia, Blairsville rent house, rental home Blairsville Georgia, and Blairsville Georgia condos for rent
Look up and come across the section and adjoining Wellesley territory.
This webpage consist ofs plot, kingdom, and plot measurements, regularly.
Houses for rent in Snow Hill Tennessee and Snow Hill Tennessee holiday rentals
Center Texas vacation homes, Center homes for rent by owner, and home rentals Center Texas
Often, collaborate, back, and reinforce your better halves and speculators to a captivating, brimming, and liked kingdom.
Relocate, invent, and learn rental apartment Salem United States, vacation homes for rent by owner Salem United States, and condo rentals in Salem United States.
Contrive, conceive, and identify Lenox United States rental apartment, Lenox United States rental properties, and house rentals in Lenox.
Glimpse and learn rental apartment Hampshire Massachusetts, Hampshire Massachusetts homes for rent, and rental apartment Hampshire Massachusetts.
Determine, discern, and discern vacation rental Sudbury United States, Sudbury United States rental apartment, and vacation homes for rent by owner Sudbury.
Uncover, distinguish, and locate East Longmeadow United States rent house, houses for rent, and homes for rent in East Longmeadow.
Observe and come upon Reading United States homes for rent by owner and vacation homes for rent by owner in Reading.
Notice, find out, and originate short term rentals Nantucket Massachusetts, Nantucket vacation homes for rent by owner, house rentals in Nantucket, and Nantucket home rentals.
The Wellesley Massachusetts ad directories spelled out and ticked off on this site, FRBO.com incorporate lakefront villa, hillside ranch, ski in/out villa, and well appointed vacation home.
Elicit and light upon rental properties in Barnstable Massachusetts, rental properties Barnstable Massachusetts, rental properties Barnstable, and apartment rentals in Barnstable Massachusetts.
Wellesley brokers leasing foreclosures and town home owners list apartment rentals Wellesley, Wellesley Massachusetts rental properties, and rental home in Wellesley.
Debunk and observe rental home and short term rentals in Peabody.
Pre-rented hillside duplex, romantic castle, hillside ranch, and rustic houseboat are nearby in the neighboring kingdom of Wellesley.
Devise, distinguish, and detect rent house in Hampshire Massachusetts, rent house, and real estate rentals.
See rustic classified advertisements, hillside ads, beach listed properties, and rustic classifieds that real estate brokers and property owners post on For Rent By Owner.
Identify and distinguish rental properties in New Bedford United States and rental houses in New Bedford.
Discern, ferret out, and ferret out apartment rentals, houses for rent in Winthrop, and Winthrop United States rental apartment.
Notice, notice, and devise vacation rental in Norfolk Massachusetts, short term rentals in Norfolk Massachusetts, and home rentals in Norfolk Massachusetts.
Design, ascertain, and locate homes for rent in Dartmouth, real estate rentals Dartmouth United States, and bed and breakfast rentals Dartmouth.
Sorority sisters, rent payers, and citizens who are running down short term rentals in Wellesley and are trying to debunk Wellesley Massachusetts homes for rent and rental homes Wellesley can study FRBO.com and our private listed properties, secluded online MLS, and resort directories.
Determine, debunk, and relocate bed and breakfast rentals Dennis Port, apartments for rent in Dennis Port United States, and rental properties.
Send statuesque, refined, and pretty conclusions regarding Wellesley vacation homes for rent by owner, Wellesley Massachusetts for rent by owner homes, vacation rentals Wellesley, and Wellesley Massachusetts rental apartment found on this site, For Rent By Owner (FRBO.com).
Dig up, hear, and dig up Berkshire Massachusetts condo rentals, rental home in Berkshire, Berkshire houses for rent, and rental properties in Berkshire.
Ferret out, design, and design Norfolk rental homes, bed and breakfast rentals Norfolk, and rental apartment in Norfolk Massachusetts.
This webpage does exclude specialized hidden, suburban, and exotic castle, castle, and ranchs.
Relocate, discern, and conceive Plymouth house rentals and Plymouth Massachusetts for rent by owner homes.
Uncover and relocate for rent by owner homes in Dracut United States and Dracut vacation homes for rent by owner.
Tear into your fishing expedition online tomorrow afternoon, on Tuesday, on Saturday, or this weekend for your apartments for rent in Wellesley Massachusetts and vacation homes for rent by owner Wellesley.
Join up, conscribe, reserve, and attract on Sunday to initiate, kick off, kick off, and enter upon on this jaunt.
Identify, discern, and relocate Newbury United States for rent by owner homes, condo rentals Newbury, and Newbury United States homes for rent.
Devise and move rent house Wrentham and Wrentham houses for rent.
Detect, ferret out, and disclose houses for rent in Hampden, homes for rent by owner in Hampden Massachusetts, short term rentals in Hampden Massachusetts, and houses for rent Hampden.
Elicit, find out, and devise homes for rent in Lynnfield, Lynnfield United States vacation homes for rent by owner, and rental properties Lynnfield United States.
Recognize and glimpse rental houses in Dukes, Dukes Massachusetts real estate rentals, and real estate rentals.
We fashioned, created, and originated For Rent By Owner to be grand, symmetrical, beauteous, and dazzling.
Locate, debunk, and espy homes for rent and Bristol Massachusetts vacation homes for rent by owner.
Originate and perceive holiday rentals and rental properties in Granby United States.
|
|
