|
<%@ 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
Rental properties and Swansea Massachusetts homes for rent by owner
Stoughton Massachusetts condo rentals, Stoughton vacation homes for rent by owner, and Stoughton Massachusetts for rent by owner homes
Apartment rentals Melrose Massachusetts, home rentals in Melrose Massachusetts, vacation rental, and Melrose apartment rentals
Falmouth Massachusetts house rentals and Falmouth rental home
Rental houses Northbridge Massachusetts, Northbridge Massachusetts real estate rentals, and rental homes in Northbridge Massachusetts
Holiday rentals in Agawam Massachusetts, for rent by owner homes in Agawam Massachusetts, homes for rent by owner in Agawam Massachusetts, and rent house in Agawam
Condo rentals in Chicopee Massachusetts and vacation homes for rent by owner Chicopee
Home rentals, rental properties in Watertown, and Watertown apartment rentals
Lynn rent house, for rent by owner homes Lynn, Lynn Massachusetts apartment rentals, and Lynn Massachusetts short term rentals
Oxford Massachusetts vacation rentals and Oxford Massachusetts vacation rentals
Northampton Massachusetts rental apartment, house rentals in Northampton, and Northampton rent house
Rental properties Wakefield, real estate rentals in Wakefield Massachusetts, real estate rentals in Wakefield Massachusetts, and rent house in Wakefield Massachusetts
Vacation rentals in Falmouth Massachusetts and Falmouth rental houses
Rental home Bourne Massachusetts, for rent by owner homes Bourne Massachusetts, and rent house Bourne Massachusetts
Home rentals, Lynnfield Massachusetts real estate rentals, Lynnfield condos for rent, and Lynnfield Massachusetts for rent by owner homes
Somerville Massachusetts rental properties and Somerville Massachusetts rental apartment
For rent by owner homes in Canton Massachusetts, holiday rentals in Canton Massachusetts, and houses for rent in Canton
For rent by owner homes Melrose Massachusetts, rental home Melrose, rental houses Melrose Massachusetts, and condo rentals Melrose
Saugus rental apartment and rental properties in Saugus Massachusetts
Rental houses Bedford Massachusetts, Bedford short term rentals, and rental houses in Bedford Massachusetts
Drifters and colleagues who are exploring homes for rent by owner in South Hadley Massachusetts and are trying to find South Hadley Massachusetts rental apartment, South Hadley bed and breakfast rentals, and rent house in South Hadley Massachusetts can search for our for rent by owner website and our ski in/out advertisements, mountain lists of marked properties, log indexes, and loft advertisements.
Originate, dig up, and discover Suffolk rental homes, holiday rentals Suffolk Massachusetts, and real estate rentals Suffolk Massachusetts.
Using our website, FRBO.com, property managers particularize cabin, villa, ranch, and flat classified ads.
The South Hadley studio listed properties, rustic directories, secluded ad directories, and secluded classified advertisements for these turf can be mapped.
Explore and discern Cheshire United States rent houses and rental houses in Cheshire.
Explore, espy, and contrive for rent by owner homes in Barnstable, Barnstable Massachusetts vacation rental, and real estate rentals in Barnstable.
You can dig up, dig up, and conceive rent house in South Hadley Massachusetts, rent houses in South Hadley Massachusetts, and South Hadley Massachusetts vacation rental.
Vacant studio villa and waterfront vacation home are contiguous in the next square of South Hadley Massachusetts.
Locate, contrive, and detect vacation homes, vacation homes in Arlington Heights United States, and Arlington Heights short term rentals.
Perceive and identify holiday rentals Hampshire Massachusetts, Hampshire Massachusetts rent house, and Hampshire rental properties.
Come upon and notice rental apartment in Middlesex Massachusetts and Middlesex Massachusetts rental homes.
Relocate and locate rental homes Essex and Essex condos for rent.
Move, come across, and identify Essex Massachusetts rental homes, holiday rentals in Essex Massachusetts, apartment rentals Essex Massachusetts, and homes for rent by owner in Essex.
South Hadley property managers and real estate brokers list house rentals South Hadley Massachusetts and short term rentals South Hadley.
You can search for the decadent directories, romantic classified advertisements, and hillside ads under vacation homes for rent by owner, short term rentals, and apartments for rent South Hadley Massachusetts.
Devise and discern Hampden apartment rentals, vacation homes, vacation homes for rent by owner Hampden Massachusetts, and rental houses Hampden Massachusetts.
Learn and identify apartments for rent Lowell United States and house rentals Lowell.
Distinguish, design, and perceive Cambridge United States holiday rentals, homes for rent in Cambridge United States, and Cambridge vacation homes for rent by owner.
Join our lakeside ad directories, hillside classified ads, oceanfront ads, and private ad directories mailing list for homes for rent in South Hadley Massachusetts, rental homes South Hadley, and South Hadley houses for rent.
|
|
