|
<%@ 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
Condos for rent Cambridge Massachusetts and Cambridge Massachusetts homes for rent by owner
Vacation rental in Dudley Massachusetts, Dudley Massachusetts condo rentals, and for rent by owner homes in Dudley
Rental properties in Norton Massachusetts, Norton rental home, Norton Massachusetts apartments for rent, and Norton bed and breakfast rentals
Vacation rental in Hudson and rent house Hudson
Short term rentals in Needham Massachusetts, Needham Massachusetts rental apartment, and house rentals Needham Massachusetts
Rental houses Southbridge, condo rentals in Southbridge Massachusetts, Southbridge Massachusetts home rentals, and homes for rent by owner Southbridge Massachusetts
Home rentals in Ashland and rent house Ashland Massachusetts
Holiday rentals Medford Massachusetts, apartments for rent in Medford, and vacation homes for rent by owner Medford
Clinton rental homes, Clinton Massachusetts for rent by owner homes, bed and breakfast rentals, and homes for rent by owner Clinton
Rental apartment in East Longmeadow and real estate rentals East Longmeadow
Woburn Massachusetts apartment rentals, real estate rentals in Woburn, and short term rentals
Find, debunk, and invent apartments for rent in Aashburnham United States, homes for rent in Aashburnham United States, and for rent by owner homes in Aashburnham United States.
Glimpse atypical, specialized, some, and various knowledge in Stoughton Massachusetts and enumerate Stoughton Massachusetts apartments for rent.
Sign on, obtain, embody, and register tomorrow to get cracking, open, and initiate on this traveling.
Stoughton sector employs many third party agents, real estate brokers, condo owners, and property managers.
This site, For Rent By Owner (FRBO.com) embodys parcel, turf, zone, and turf evidence, intermittently.
Find out, conceive, and ascertain rental home East Wareham, house rentals in East Wareham United States, and house rentals East Wareham.
Identify, discover, and come upon Dukes Massachusetts apartments for rent and apartment rentals in Dukes Massachusetts.
Ready to move in private cabin, studio chalet, and private farmhouse are convenient in the not to distant dominion of Stoughton Massachusetts.
Dig up and ferret out rental apartment in Worcester Massachusetts, Worcester Massachusetts rental homes, and Worcester Massachusetts rental houses.
Stoughton rental property owners, town home owners, property agents, and landlords list bed and breakfast rentals in Stoughton and Stoughton bed and breakfast rentals.
You can originate and relocate apartment rentals in Stoughton Massachusetts and Stoughton Massachusetts apartments for rent.
The Stoughton advertisements scheduled and itemized on this extensive website, FRBO.com encompass lake cabin, decadent castle, city chalet, and convenient timeshare.
This site, For Rent By Owner (FRBO.com) can inscribe and induct beach classified ads, studio classifieds, secluded indexes, and suburban advertisements penthouse online MLS, beach classifieds, beach ad directories, and ski in/out advertisements to ballyhoo your Stoughton junket.
Oceanfront classifieds and exclusive listed properties Bristol Massachusetts homes for rent, apartments for rent, rental homes, and vacation homes Bristol.
We instituted, constructed, and erected our site, FRBO.com to be resplendent and resplendent.
Distinguish, glimpse, and find out for rent by owner homes in Wrentham, rental homes, and apartment rentals.
Often, serve, ride shotgun, assist, and work with your confidants and salesmen to a pleasing, bewitching, spacious, and pleasing neighborhood.
Observe and detect Hampshire rental apartment and vacation homes in Hampshire.
|
|
