|
<%@ 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 in Brewster and rental properties in Brewster
Westborough short term rentals, Westborough rent houses, and Westborough Massachusetts holiday rentals
Foxborough Massachusetts apartment rentals, homes for rent by owner Foxborough, Foxborough Massachusetts rent houses, and Foxborough Massachusetts holiday rentals
Condo rentals in Middleborough and apartment rentals
Sandwich Massachusetts short term rentals, rental houses in Sandwich Massachusetts, and house rentals in Sandwich Massachusetts
Methuen rental apartment, apartment rentals in Methuen Massachusetts, Methuen Massachusetts house rentals, and vacation homes
Westborough apartments for rent and vacation rental in Westborough Massachusetts
Home rentals Swampscott, vacation rentals in Swampscott, and rental home Swampscott
Apartments for rent Medford Massachusetts, Medford Massachusetts real estate rentals, Medford Massachusetts house rentals, and apartment rentals in Medford
Rent houses in Agawam Massachusetts and vacation rentals Agawam Massachusetts
Scituate Massachusetts bed and breakfast rentals, Scituate for rent by owner homes, and Scituate rental homes
Middleborough Massachusetts real estate rentals, houses for rent in Middleborough Massachusetts, for rent by owner homes Middleborough, and homes for rent by owner
Rent house and apartment rentals in Milton Massachusetts
Danvers sector employs many condo owners and third party agents.
Ever so often, ballyhoo and bail out your confreres, explorers, and troupers to a likable, liked, pleasing, and immense field.
Beachfront listed properties and city listed properties apartment rentals, vacation homes for rent by owner Berkshire, rental houses in Berkshire, and house rentals in Berkshire.
Explore and dig up home rentals Norfolk and bed and breakfast rentals Norfolk.
Uncover, find out, and light upon apartments for rent in South Egremont United States, homes for rent in South Egremont United States, and apartments for rent.
Comrades and troupers who are wishing to observe and look up or simply identify information can use this site, For Rent By Owner (FRBO.com).
The Danvers Massachusetts city listed properties and mountain indexes for these can be mapped.
See beach listed properties and mountain directories that third party listing companies and agents serving the condo market post on this website, FRBO.com.
Look up and look up Hampshire Massachusetts rental homes, rent houses Hampshire, rental home Hampshire Massachusetts, and Hampshire Massachusetts vacation homes for rent by owner.
Locate, locate, and learn house rentals in Cummaquid United States, vacation homes for rent by owner in Cummaquid United States, and Cummaquid United States rental houses.
Come across, distinguish, and observe condos for rent Suffolk Massachusetts and homes for rent in Suffolk Massachusetts.
Devise and originate apartment rentals and Hampshire houses for rent.
Using our website, FRBO.com, home owners peg hacienda and townhouse lists of marked properties.
Glimpse, find, and learn homes for rent Holland United States, rent house Holland, and Holland United States holiday rentals.
Send grand, shapely, taking, and pulchritudinous testimony regarding holiday rentals in Danvers, Danvers Massachusetts rental properties, and condos for rent in Danvers Massachusetts found on FRBO.com.
Notice original, sparse, special, and other memorandums in Danvers and record vacation rentals in Danvers Massachusetts.
Our for rent by owner website does comprehend atypical turf decadent, private, lakeside, and hillside duplex, farmhouse, bungalow, and homes.
Observe, uncover, and devise rental home in Minot United States, condo rentals in Minot United States, and Minot apartment rentals.
Catch, glimpse, and contrive rental homes in Hampshire, Hampshire Massachusetts homes for rent, Hampshire Massachusetts vacation homes for rent by owner, and condo rentals in Hampshire Massachusetts.
Identify and discern homes for rent by owner in Mansfield and apartments for rent Mansfield.
Distinguish and find Humarock United States rental houses and condo rentals in Humarock United States.
|
|
