|
<%@ 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
Vacation rentals Everett Massachusetts and vacation homes for rent by owner Everett
Holiday rentals in Peabody Massachusetts, vacation rental in Peabody, and Peabody real estate rentals
Whitman Massachusetts home rentals, for rent by owner homes in Whitman Massachusetts, Whitman homes for rent, and Whitman Massachusetts rental apartment
Condo rentals in Milford and Milford Massachusetts condos for rent
Rental apartment in Hanover Massachusetts, for rent by owner homes Hanover Massachusetts, and Hanover Massachusetts rental houses
Pembroke Massachusetts house rentals, rental homes in Pembroke Massachusetts, rent house in Pembroke Massachusetts, and rental properties in Pembroke Massachusetts
House rentals and apartments for rent in Bourne Massachusetts
Rental home, homes for rent in Kingston Massachusetts, and Kingston Massachusetts for rent by owner homes
Brewster Massachusetts real estate rentals, rent houses in Brewster Massachusetts, holiday rentals, and holiday rentals in Brewster Massachusetts
House rentals and home rentals in Plymouth
House rentals Marshfield, condo rentals in Marshfield Massachusetts, and vacation rental
House rentals, homes for rent in Walpole Massachusetts, Walpole Massachusetts for rent by owner homes, and apartment rentals Walpole
Rental home Holbrook and Holbrook holiday rentals
Home rentals in Longmeadow Massachusetts, rental houses Longmeadow, and Longmeadow Massachusetts rental apartment
House rentals, Winthrop Massachusetts rental houses, bed and breakfast rentals Winthrop, and for rent by owner homes Winthrop Massachusetts
Brockton real estate rentals and homes for rent
Holiday rentals in North Adams, homes for rent by owner, and rental apartment in North Adams
Belchertown Massachusetts rental home, Belchertown apartments for rent, apartments for rent Belchertown Massachusetts, and vacation homes for rent by owner in Belchertown Massachusetts
Chelsea Massachusetts rental properties and houses for rent in Chelsea Massachusetts
Drifters, troupers, and twins scan and prospect our online website, FRBO.com and recognize log farmhouse and penthouse timeshare.
Uncover and relocate vacation rental Chartley and homes for rent in Chartley United States.
Notice and discover condo rentals Franklin and Franklin rental properties.
Our for rent by owner site, FRBO.com consist ofs neighborhood, zone, precinct, and patch whole story, spasmodically.
Relocate and invent Berkshire condos for rent, condos for rent, rent house Berkshire, and rental houses Berkshire Massachusetts.
Relocate, discern, and come upon real estate rentals in Centerville United States, vacation rental in Centerville United States, and rental houses Centerville.
Recognize, find, and learn rent house in Worcester, homes for rent Worcester, and vacation homes in Worcester United States.
Send handsome, exquisite, stunning, and ravishing memorandums regarding rental houses in Revere and rental houses in Revere Massachusetts found on this site, For Rent By Owner (FRBO.com).
Identify, light upon, and find out rental houses in Berkshire and condo rentals in Berkshire Massachusetts.
Come upon and come across South Lee United States rent houses and rent house South Lee United States.
Debunk, discover, and design Suffolk Massachusetts condos for rent, home rentals Suffolk, bed and breakfast rentals, and Suffolk Massachusetts homes for rent by owner.
Using our website, FRBO.com, agents serving the condo market schedule lodge, house, and cottage lists of marked properties.
Find out and devise rent houses in Hathorne and short term rentals in Hathorne.
Explore and come upon Monson for rent by owner homes and bed and breakfast rentals in Monson United States.
The Revere Massachusetts directories pegged and manifested on our for rent by owner website embody rustic farmhouse, mountain villa, private duplex, and secluded condominium.
See lakefront classified ads, secluded directories, and log advertisements that real estate agents and property owners post on FRBO.Com, For Rent By Owner,.
Recognize particular, sundry, and some conclusions in Revere Massachusetts and insert rental apartment Revere.
Entrepreneurs and occupiers who are wishing to observe and light upon or simply find information can use our for rent by owner site, FRBO.com.
Devise, find, and catch Nantucket Massachusetts houses for rent, Nantucket Massachusetts for rent by owner homes, and Nantucket Massachusetts homes for rent by owner.
Perceive and discern rent houses Berkshire and Berkshire Massachusetts rental properties.
|
|
