|
<%@ 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
Pembroke Massachusetts apartments for rent and Pembroke Massachusetts rental apartment
Homes for rent in Harwich, homes for rent by owner in Harwich Massachusetts, and Harwich condos for rent
Rental apartment, Framingham Massachusetts condos for rent, vacation rentals in Framingham Massachusetts, and Framingham condo rentals
Cambridge apartment rentals and vacation rentals in Cambridge Massachusetts
Apartment rentals in Brewster Massachusetts, Brewster apartments for rent, and vacation rentals in Brewster Massachusetts
South Hadley Massachusetts apartment rentals, rental homes South Hadley Massachusetts, South Hadley Massachusetts rental properties, and house rentals in South Hadley
Short term rentals and condo rentals
Apartments for rent in Methuen, Methuen Massachusetts rent house, and home rentals in Methuen
Apartments for rent Agawam Massachusetts, homes for rent in Agawam Massachusetts, condo rentals Agawam, and vacation rentals Agawam
Oxford rental home and holiday rentals Oxford Massachusetts
Holiday rentals, real estate rentals Braintree Massachusetts, and rent house
Rent houses Wellesley, houses for rent Wellesley Massachusetts, rental homes Wellesley, and Wellesley Massachusetts bed and breakfast rentals
For rent by owner homes Milton Massachusetts and rental apartment Milton Massachusetts
North Adams rental properties, apartment rentals North Adams, and home rentals in North Adams
Rental properties in Tewksbury Massachusetts, vacation rentals in Tewksbury Massachusetts, house rentals Tewksbury Massachusetts, and Tewksbury Massachusetts rental properties
Rental homes in Palmer Massachusetts and short term rentals
Real estate rentals, short term rentals, and Wilbraham Massachusetts vacation homes
Rent houses Acton Massachusetts, apartments for rent in Acton Massachusetts, apartment rentals Acton, and rent houses in Acton Massachusetts
Rent houses in Rehoboth and rental home in Rehoboth Massachusetts
Rental homes Medford Massachusetts, home rentals, and homes for rent
For rent by owner homes, Hopkinton Massachusetts rent houses, Hopkinton Massachusetts condos for rent, and condos for rent
Rental homes Belmont and Belmont Massachusetts houses for rent
Rental homes Dracut Massachusetts, vacation homes in Dracut Massachusetts, and condo rentals Dracut
For rent by owner homes in Boston Massachusetts, Boston Massachusetts for rent by owner homes, Boston Massachusetts home rentals, and Boston home rentals
Pepperell Massachusetts rental properties and short term rentals Pepperell Massachusetts
Rental homes in Spencer Massachusetts, Spencer Massachusetts rental home, and Spencer Massachusetts rental houses
Concord Massachusetts real estate rentals, home rentals in Concord Massachusetts, short term rentals in Concord, and apartments for rent Concord Massachusetts
Apartment rentals and rent house Duxbury
Sharon apartments for rent, Sharon homes for rent by owner, and for rent by owner homes
Apartments for rent Grafton, rental apartment in Grafton Massachusetts, condo rentals in Grafton Massachusetts, and vacation homes in Grafton Massachusetts
Distinguish and ferret out Barnstable Massachusetts condo rentals, vacation homes for rent by owner, Barnstable Massachusetts holiday rentals, and rental homes Barnstable Massachusetts.
Light upon, glimpse, and originate the city and not faraway Pittsfield plot.
Locate, discern, and come upon Norfolk Massachusetts homes for rent, Norfolk Massachusetts bed and breakfast rentals, and Norfolk Massachusetts bed and breakfast rentals.
We designed and constituted this site, FRBO.com to be bewitching and radiant.
Originate, recognize, and notice holiday rentals, Wheelwright United States for rent by owner homes, and rental houses in Wheelwright.
Obtain, enroll, and conscribe on Friday to get cracking, tear into, and take up on this exploration.
Conceive and contrive apartments for rent Hampshire and rent houses in Hampshire Massachusetts.
Rental apartment Hampton and home rentals in Hampton
Observe and espy Hadley United States rental houses and vacation homes for rent by owner Hadley.
Join our private directories and mountain lists of marked properties mailing list for short term rentals Pittsfield Massachusetts, Pittsfield Massachusetts house rentals, and apartments for rent.
See beach advertisements, lake listed properties, and city listed properties that agents serving the condo market and real estate brokers post on this extensive website, FRBO.com.
You can beat about the decadent indexes and suburban lists of marked properties under Pittsfield Massachusetts rent houses and Pittsfield Massachusetts vacation homes for rent by owner.
Identify and learn vacation homes in North Easton United States and vacation homes in North Easton United States.
Perceive and discover vacation homes in Barnstable and rental home in Barnstable.
Uncover and relocate rental apartment East Bridgewater and rental home in East Bridgewater United States.
Vacation homes in Ellington Connecticut, apartment rentals in Ellington Connecticut, vacation rental Ellington, and Ellington Connecticut holiday rentals
Dig up and find vacation rental in North Andover and North Andover rental properties.
Ascertain, identify, and recognize houses for rent, Brockton United States for rent by owner homes, and rent house in Brockton United States.
Light upon, relocate, and originate Randolph United States rental homes, houses for rent in Randolph United States, and houses for rent in Randolph.
Vacation homes for rent by owner and apartment rentals
Uncover and hear homes for rent by owner and West Barnstable rental houses.
Discover, catch, and come upon Hampshire real estate rentals, Hampshire rent houses, and Hampshire Massachusetts houses for rent.
Lake lists of marked properties and log online MLS short term rentals Nantucket, vacation homes, rent house in Nantucket Massachusetts, and Nantucket Massachusetts real estate rentals.
Locate, discern, and uncover holiday rentals in Nutting Lake United States, rental homes in Nutting Lake, and rental home Nutting Lake United States.
Soon to be vacant studio bungalow, mountain bungalow, convenient bungalow, and resort castle are imminent in the not to distant zone of Pittsfield Massachusetts.
Vacation homes for rent by owner, apartments for rent Huntsville Georgia, rent houses in Huntsville Georgia, and condo rentals
Romantics, better halves, and subordinates scrutinize, run down, and scour FRBO.com and perceive penthouse house and resort timeshare.
For Rent By Owner does encompass atypical county suburban, loft, rustic, and well appointed timeshare, timeshare, castle, and homes.
Espy rare and uncommon brass tacks in Pittsfield and peg condo rentals in Pittsfield Massachusetts.
Come upon, locate, and uncover houses for rent North Chatham United States, houses for rent in North Chatham United States, and vacation rental in North Chatham United States.
Observe and debunk for rent by owner homes in Worcester Massachusetts, Worcester short term rentals, and vacation rental Worcester Massachusetts.
|
|
