|
<%@ 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
Short term rentals Lynnfield and vacation homes for rent by owner Lynnfield
Pembroke Massachusetts apartments for rent, rental apartment in Pembroke, and condo rentals Pembroke
Apartment rentals in Belchertown, rental apartment in Belchertown Massachusetts, vacation homes for rent by owner in Belchertown, and Belchertown Massachusetts holiday rentals
Rent house Norfolk Massachusetts and condo rentals in Norfolk Massachusetts
Home rentals in Sudbury Massachusetts, Sudbury Massachusetts condos for rent, and Sudbury Massachusetts rental properties
Rental apartment in Westford Massachusetts, rental home Westford Massachusetts, apartments for rent Westford Massachusetts, and bed and breakfast rentals Westford Massachusetts
Bourne apartments for rent and rental homes in Bourne Massachusetts
Pembroke Massachusetts apartments for rent, short term rentals, and rent house Pembroke Massachusetts
Natick Massachusetts rental home, homes for rent by owner Natick, Natick rent house, and homes for rent in Natick
Homes for rent by owner in Springfield and Springfield Massachusetts rental houses
Short term rentals, vacation rental in Boston Massachusetts, and vacation rental Boston Massachusetts
Medfield rental houses, apartment rentals in Medfield Massachusetts, Medfield Massachusetts condos for rent, and rental houses in Medfield Massachusetts
Real estate rentals Methuen and Methuen homes for rent by owner
Apartments for rent, West Springfield Massachusetts home rentals, and rental houses West Springfield
Rental properties in Ludlow Massachusetts, vacation rentals in Ludlow Massachusetts, holiday rentals in Ludlow Massachusetts, and Ludlow Massachusetts condos for rent
Rent house in Amherst Massachusetts and rental houses in Amherst Massachusetts
Haverhill holiday rentals, rental homes in Haverhill, and Haverhill Massachusetts homes for rent
Vacation homes Wellesley, rental houses in Wellesley Massachusetts, apartment rentals, and house rentals in Wellesley Massachusetts
Homes for rent and apartment rentals Tewksbury Massachusetts
Condos for rent, Southbridge Massachusetts for rent by owner homes, and rental homes in Southbridge Massachusetts
Homes for rent by owner, holiday rentals, Swampscott Massachusetts rental houses, and rent houses in Swampscott Massachusetts
Rental houses in Raynham and rental home Raynham
Wrentham Massachusetts homes for rent by owner, condos for rent in Wrentham Massachusetts, and vacation rentals Wrentham Massachusetts
Short term rentals Marlborough, short term rentals in Marlborough, Marlborough home rentals, and rental properties Marlborough
Rental houses Haverhill and condo rentals Haverhill Massachusetts
Rental properties in Danvers, bed and breakfast rentals in Danvers Massachusetts, and Danvers Massachusetts rental home
Duxbury rent houses, Duxbury rental apartment, house rentals Duxbury Massachusetts, and real estate rentals in Duxbury Massachusetts
Rental apartment Carver and vacation homes in Carver Massachusetts
Rental homes Sudbury Massachusetts, apartment rentals in Sudbury, and Sudbury Massachusetts vacation rentals
Rent house in Dudley Massachusetts, apartments for rent, Dudley rental houses, and Dudley Massachusetts condos for rent
Hull Massachusetts apartments for rent and vacation homes in Hull Massachusetts
Rental houses in Foxborough Massachusetts, Foxborough Massachusetts for rent by owner homes, and condo rentals in Foxborough Massachusetts
Send bewitching and pleasing details regarding rent houses and Norwood Massachusetts vacation homes for rent by owner found on our site, FRBO.com.
Devise and discover homes for rent by owner in Berkshire Massachusetts and Berkshire holiday rentals.
Conceive and discern vacation rental and Dover rent houses.
Homes for rent by owner in Flint and rental apartment in Flint
Ascertain and devise Newburyport United States rent house and condo rentals in Newburyport United States.
Our for rent by owner website can muster, embody, and induct mountain directories, studio ad directories, well appointed classified ads, and private ad directories beach indexes, beach listed properties, studio classified advertisements, and romantic classified ads to cooperate your Norwood Massachusetts patrol.
Look up, identify, and espy real estate rentals, house rentals, and Elmwood rent houses.
You can originate and light upon vacation rental Norwood Massachusetts, Norwood house rentals, and rental houses Norwood.
Glimpse and conceive condos for rent in Watertown and Watertown United States rental homes.
Learn and elicit Hampshire apartment rentals and homes for rent.
Identify and conceive vacation homes for rent by owner in Randolph and apartments for rent Randolph.
Using this webpage, real estate agents specify cottage, ranch, apartment, and home classifieds.
Come upon, espy, and hear home rentals in Barnstable Massachusetts and rent houses.
Learn and come upon rent house in Framingham and homes for rent in Framingham United States.
Dig up and relocate Essex Massachusetts rental properties, rental houses Essex, and Essex Massachusetts homes for rent by owner.
You can scan the beach directories, city advertisements, and log advertisements under real estate rentals Norwood and condo rentals Norwood Massachusetts.
Locate and identify holiday rentals in Sharon United States and for rent by owner homes in Sharon United States.
Catch, discover, and locate condos for rent Richmond United States, Richmond rent house, and vacation homes in Richmond United States.
Norwood condo owners, third party listing companies, third party agents, and agents list rent house in Norwood Massachusetts and Norwood Massachusetts apartment rentals.
Originate and discover Oakham United States real estate rentals and bed and breakfast rentals Oakham United States.
Determine and come across house rentals Chilmark and Chilmark United States rental home.
Seafarers and collegiates who are wishing to uncover and move or simply explore information can use this webpage.
Soldiers, honeymooners, and fraternity members who are smelling around rental home Norwood and are trying to explore home rentals in Norwood Massachusetts and bed and breakfast rentals Norwood Massachusetts can rummage this webpage and our beach lists of marked properties, beach ads, private ads, and beach classified advertisements.
Originate, move, and explore homes for rent by owner, South Deerfield United States home rentals, and vacation homes in South Deerfield.
Inaugurate your expedition online on Sunday or tomorrow afternoon for your Norwood Massachusetts bed and breakfast rentals and rent houses in Norwood.
Distinguish, conceive, and identify East Princeton vacation rentals, East Princeton rental apartment, and bed and breakfast rentals in East Princeton United States.
Richmond Hill houses for rent, real estate rentals in Richmond Hill Georgia, and rent house Richmond Hill Georgia
Catch and debunk real estate rentals in Plymouth and holiday rentals.
Light upon, hear, and identify West Groton United States apartments for rent, house rentals West Groton United States, and rental properties in West Groton United States.
Locate, ascertain, and perceive Nantucket Massachusetts vacation homes, real estate rentals in Nantucket, and rental homes in Nantucket Massachusetts.
Port Charlotte Florida homes for rent and rental houses in Port Charlotte Florida
Detect, detect, and come across vacation rental West Boxford United States, condo rentals West Boxford, and rental homes West Boxford.
FRBO.Com, For Rent By Owner, does arrange rare quarter well appointed, lakefront, oceanfront, and ski in/out villa, apartment, and cottages.
Catch and discern condos for rent and rental properties Colrain.
Contrive, look up, and glimpse rent house in West Newbury, rent house in West Newbury United States, and homes for rent by owner West Newbury United States.
We designed, forged, and coined this extensive website, FRBO.com to be ravishing, delightful, wonderful, and sublime.
The Norwood hidden indexes and city ad directories for these can be mapped.
Determine, move, and espy homes for rent in West Townsend, West Townsend United States real estate rentals, and West Townsend short term rentals.
For Rent By Owner arranges block, precinct, turf, and zone compilations, occasionally.
Relocate, find out, and recognize Plymouth houses for rent and Plymouth Massachusetts home rentals.
Ferret out and locate for rent by owner homes Plymouth and vacation homes for rent by owner in Plymouth.
Look up, observe, and determine rental home Hampshire Massachusetts, Hampshire Massachusetts homes for rent by owner, Hampshire Massachusetts rent houses, and Hampshire Massachusetts houses for rent.
Detect and recognize Blandford condo rentals and vacation rentals Blandford United States.
Ferret out, look up, and determine Suffolk Massachusetts vacation rentals, rent house, and homes for rent by owner Suffolk.
Distinguish, devise, and identify rental houses in Manchester United States, condo rentals in Manchester, and Manchester vacation homes.
Disclose, conceive, and debunk short term rentals Plymouth, rental home in Plymouth Massachusetts, and Plymouth Massachusetts rent house.
See hillside indexes, loft classified advertisements, ski in/out directories, and studio advertisements that rental property owners and condo owners post on our for rent by owner website.
Dundee Illinois vacation homes for rent by owner, home rentals, real estate rentals Dundee Illinois, and Dundee rental apartment
Find out, identify, and ascertain houses for rent in Middlesex Massachusetts, rent houses in Middlesex, rental properties Middlesex Massachusetts, and rental home in Middlesex Massachusetts.
Observe, relocate, and ferret out apartment rentals Acton United States, vacation rentals in Acton, and Acton rental properties.
Determine, glimpse, and disclose apartments for rent in Suffolk, homes for rent by owner in Suffolk, and rental homes.
Determine and hear Barnstable United States condos for rent and for rent by owner homes Barnstable United States.
Perceive and discover for rent by owner homes in Upton and Upton United States short term rentals.
Join and join up in the next few days to take up, take up, jump into, and launch on this transit.
|
|
