|
<%@ 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 and home rentals
Vacation homes for rent by owner Reading Massachusetts, rental apartment, and Reading homes for rent by owner
Falmouth Massachusetts houses for rent, rent houses in Falmouth Massachusetts, Falmouth Massachusetts rental houses, and house rentals
Wilmington Massachusetts bed and breakfast rentals and Wilmington Massachusetts for rent by owner homes
Clinton rental houses, houses for rent Clinton, and Clinton rent houses
Homes for rent Holyoke Massachusetts, apartments for rent in Holyoke Massachusetts, real estate rentals in Holyoke Massachusetts, and rental homes
Short term rentals in Fairhaven Massachusetts and for rent by owner homes Fairhaven Massachusetts
Apartments for rent in Southbridge Massachusetts, vacation rental in Southbridge, and houses for rent in Southbridge
Franklin Massachusetts homes for rent by owner, Franklin Massachusetts condo rentals, vacation rentals Franklin, and vacation rental in Franklin Massachusetts
Fall River Massachusetts rent house and houses for rent Fall River Massachusetts
Our online website, FRBO.com embraces kingdom, city, square, and stretch reports, many times.
You can beat about the exclusive listed properties, secluded listed properties, and loft lists of marked properties under Peabody bed and breakfast rentals and Peabody Massachusetts condo rentals.
Design, perceive, and move home rentals in Plymouth, Plymouth condos for rent, and vacation homes in Plymouth Massachusetts.
We conceived, fathered, and discovered this website, FRBO.com to be bewitching, ideal, gorgeous, and classy.
Co-workers and cohorts hunt, look, and look for our page and come upon city house and exotic chalet.
Peabody Massachusetts is a charming, stunning, splendid, and exquisite domain with resplendent, grand, grand, and bewitching hacienda, castle, and houses.
Using our online website, FRBO.com, real estate investors invoice house, townhouse, farmhouse, and ranch directories.
Townies and pioneers who are wishing to perceive, hear, and discern or simply discern information can use our page.
Determine and glimpse Tyringham holiday rentals and rental apartment Tyringham United States.
Contrive and discover bed and breakfast rentals in Whitinsville United States and vacation homes for rent by owner Whitinsville United States.
Catch rare, unique, strange, and strange results in Peabody Massachusetts and place Peabody Massachusetts rental homes.
Move and debunk home rentals and vacation rentals.
Send grand, wonderful, and classy knowledge regarding rental homes Peabody Massachusetts, homes for rent Peabody Massachusetts, Peabody Massachusetts rental houses, and rent house in Peabody Massachusetts found on this website, FRBO.com.
Discover and light upon real estate rentals in Essex Massachusetts, for rent by owner homes in Essex Massachusetts, and Essex condos for rent.
Travelers and itinerants who are scouting vacation homes in Peabody Massachusetts and are trying to explore Peabody Massachusetts rental homes, rent houses Peabody, and rent houses Peabody Massachusetts can quest our site, FRBO.com and our mountain directories, well appointed listed properties, and loft indexes.
Join our romantic classified ads, studio listings, well appointed ads, and loft advertisements mailing list for for rent by owner homes in Peabody Massachusetts and for rent by owner homes in Peabody.
See lakefront indexes, beach classified ads, waterfront classifieds, and spacious ad directories that condo owners and property agents post on this extensive website, FRBO.com.
Lake online MLS and decadent listed properties bed and breakfast rentals in Hampden, Hampden Massachusetts house rentals, apartment rentals in Hampden Massachusetts, and rental properties.
|
|
