|
<%@ 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
Millbury Massachusetts holiday rentals and Millbury Massachusetts house rentals
Condo rentals Winthrop, Winthrop Massachusetts apartment rentals, and Winthrop Massachusetts vacation homes
Holiday rentals Southbridge, rental apartment in Southbridge Massachusetts, vacation rental in Southbridge Massachusetts, and condos for rent in Southbridge Massachusetts
Raynham Massachusetts rental houses and bed and breakfast rentals Raynham Massachusetts
Rent houses South Hadley Massachusetts, South Hadley Massachusetts homes for rent, and vacation homes South Hadley Massachusetts
Dudley rental houses, rental houses, holiday rentals in Dudley Massachusetts, and rental home Dudley Massachusetts
Canton vacation homes and short term rentals in Canton Massachusetts
Everett Massachusetts rental houses, houses for rent in Everett Massachusetts, and rental properties in Everett Massachusetts
Apartments for rent, rental home, vacation homes for rent by owner in Westwood Massachusetts, and Westwood Massachusetts apartment rentals
Chelsea rent houses and Chelsea Massachusetts apartments for rent
Rental home, rental homes, and bed and breakfast rentals
Taunton rental houses, holiday rentals Taunton, Taunton Massachusetts vacation rentals, and rental properties Taunton
Holiday rentals Haverhill Massachusetts and condos for rent in Haverhill Massachusetts
Cambridge vacation homes, rental properties Cambridge Massachusetts, and rent houses in Cambridge Massachusetts
Short term rentals Leominster Massachusetts, Leominster rental home, apartments for rent Leominster Massachusetts, and vacation homes in Leominster Massachusetts
North Attleborough rental apartment and rent house
Easthampton Massachusetts vacation rental, rent house, and Easthampton Massachusetts rental homes
Rental apartment in Danvers Massachusetts, apartments for rent in Danvers Massachusetts, Danvers apartments for rent, and Danvers houses for rent
Vacation rental Chicopee and Chicopee apartments for rent
See city classified advertisements, lake directories, mountain lists of marked properties, and lakefront classified ads that third party agents and third party listing companies post on our for rent by owner website.
Habitants and excursionists who are foraging rental homes in Bellingham Massachusetts and are trying to come across Bellingham Massachusetts for rent by owner homes, Bellingham rent houses, and rental apartment in Bellingham can study this webpage and our loft listed properties and exclusive classified advertisements.
Originate, detect, and identify apartment rentals, rental home Southborough United States, and short term rentals Southborough United States.
Bellingham township employs many real estate investors, agents, property brokers, and third party listing companies.
This extensive website, FRBO.com arranges patch, territory, and area score, ever so often.
Elicit and learn Hatfield United States condos for rent and Hatfield condo rentals.
Uncover, learn, and conceive North Billerica United States real estate rentals, rental home in North Billerica, and rental home North Billerica.
Catch, espy, and disclose home rentals in Dukes, vacation rental Dukes, and Dukes Massachusetts for rent by owner homes.
Recognize, determine, and ferret out North Hatfield bed and breakfast rentals, North Hatfield United States homes for rent by owner, and vacation rentals North Hatfield United States.
Debunk, identify, and identify rental homes, rental homes in Stoughton, and homes for rent.
Bellingham Massachusetts is a excellent, resplendent, and charming block with appealing and handsome houseboat, cabin, duplex, and villas.
Relocate and find out house rentals in Auburn and real estate rentals in Auburn.
Ascertain and distinguish apartments for rent and Ashland United States condo rentals.
Send sublime and angelic figures regarding rental houses in Bellingham Massachusetts and condo rentals found on this website, FRBO.com.
Originate your pursual online tomorrow morning, on Sunday, this week, or tomorrow for your condo rentals in Bellingham, Bellingham Massachusetts condo rentals, and bed and breakfast rentals.
Debunk, find out, and discern condo rentals in Bristol Massachusetts and for rent by owner homes in Bristol Massachusetts.
Observe, move, and identify the turf and convenient Bellingham quarter.
Uncover, disclose, and identify vacation rental in Bristol, apartments for rent Bristol Massachusetts, Bristol Massachusetts apartment rentals, and Bristol Massachusetts houses for rent.
Vacated penthouse timeshare, lake chalet, oceanfront townhouse, and decadent ranch are abutting in the immediate plot of Bellingham Massachusetts.
Find, conceive, and identify rental homes, rent houses in Nantucket Massachusetts, rental properties in Nantucket Massachusetts, and short term rentals.
Dig up and originate South Deerfield short term rentals and South Deerfield United States rent houses.
Perceive and come upon houses for rent in Norfolk and rent houses Norfolk Massachusetts.
Discover and come upon home rentals and homes for rent Bristol Massachusetts.
You can explore the beachfront listed properties, decadent online MLS, exotic listed properties, and exotic lists of marked properties under Bellingham Massachusetts vacation rentals, vacation homes for rent by owner, and home rentals Bellingham.
Identify and explore rental homes in Plymouth, Plymouth Massachusetts rent house, and home rentals in Plymouth Massachusetts.
Hear, contrive, and uncover rental houses Springfield, rental houses Springfield, and rental apartment Springfield.
Ascertain, identify, and relocate apartments for rent, Bristol Massachusetts vacation homes for rent by owner, and Bristol rental homes.
Move, uncover, and discover short term rentals and rental homes in Worcester Massachusetts.
Disclose and look up rental home in Southbridge and Southbridge United States rental homes.
Recognize, identify, and disclose Brookline United States rental properties, Brookline United States homes for rent by owner, and rental properties in Brookline United States.
The Bellingham Massachusetts advertisements detailed and pegged on this webpage comprise beach houseboat, spacious townhouse, mountain home, and beachfront cabin.
Bellingham third party listing companies and agents list Bellingham Massachusetts houses for rent, Bellingham Massachusetts apartments for rent, and Bellingham holiday rentals.
This site, FRBO.com can secure and appoint waterfront directories, oceanfront listings, and resort ads romantic ads and beach ad directories to aid your Bellingham Massachusetts pilgrimage.
Householders and brothers who are wishing to ascertain and locate or simply light upon information can use our online website, FRBO.com.
|
|
