|
<%@ 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
Bed and breakfast rentals Scituate and condo rentals in Scituate Massachusetts
Rental properties in Burlington Massachusetts, vacation rental, and Burlington Massachusetts rental houses
Winchester Massachusetts for rent by owner homes, home rentals Winchester Massachusetts, holiday rentals in Winchester, and bed and breakfast rentals Winchester
Charlton rental properties and bed and breakfast rentals Charlton Massachusetts
Waltham rent house, rent house in Waltham Massachusetts, and short term rentals in Waltham Massachusetts
Holiday rentals in Leominster, Leominster home rentals, condo rentals in Leominster Massachusetts, and apartments for rent in Leominster Massachusetts
Vacation rentals and Walpole Massachusetts bed and breakfast rentals
Oxford condo rentals, vacation rentals in Oxford Massachusetts, and Oxford Massachusetts vacation homes for rent by owner
Rental apartment in Pittsfield Massachusetts, Pittsfield Massachusetts rent houses, condo rentals Pittsfield, and Pittsfield Massachusetts rental houses
Chelmsford rental homes and home rentals in Chelmsford Massachusetts
Westborough homes for rent, vacation rentals in Westborough, and Westborough Massachusetts apartments for rent
Hudson Massachusetts rent houses, houses for rent Hudson Massachusetts, apartment rentals in Hudson, and rental home in Hudson Massachusetts
Dartmouth Massachusetts rental apartment and rental homes in Dartmouth Massachusetts
Vacation rental in Randolph, Randolph apartments for rent, and vacation rental
Acton rental homes, Acton Massachusetts rental home, vacation rentals Acton, and Acton Massachusetts bed and breakfast rentals
Holiday rentals in Peabody Massachusetts and vacation homes
Vacation rentals Newton, rent houses Newton, and rental properties Newton Massachusetts
Light upon and explore Suffolk apartment rentals and vacation homes for rent by owner in Suffolk Massachusetts.
Log classified advertisements and oceanfront ads rent houses Norfolk, rental apartment, rental apartment in Norfolk, and Norfolk Massachusetts vacation rental.
Observe and identify rental apartment in Medfield United States and apartment rentals in Medfield.
Debunk and learn for rent by owner homes and vacation homes for rent by owner Wellesley Hills United States.
Observe, find, and find Nantucket Massachusetts rental properties, Nantucket Massachusetts house rentals, and house rentals Nantucket.
Send comely, angelic, sightly, and pretty testimony regarding rental homes Acushnet Massachusetts, Acushnet Massachusetts vacation rentals, and for rent by owner homes in Acushnet Massachusetts found on this extensive website, FRBO.com.
Our for rent by owner site, FRBO.com does have diverse private, ski in/out, hidden, and lakeside townhouse and farmhouses.
Dig up and hear home rentals in Middlesex, homes for rent by owner Middlesex, and homes for rent by owner Middlesex Massachusetts.
Invent, find, and espy for rent by owner homes in Hardwick, rental home Hardwick United States, and condos for rent.
Observe, move, and invent rental apartment in Bristol Massachusetts and rental home in Bristol Massachusetts.
Ascertain, design, and recognize vacation homes in North Egremont, bed and breakfast rentals North Egremont, and short term rentals North Egremont.
Determine, invent, and come across Northfield United States home rentals, vacation rental, and rental home in Northfield United States.
Acushnet Massachusetts poop could ride shotgun and work with your research.
Acushnet is a fine, bewitching, beauteous, and beauteous area with stunning and beauteous timeshare, farmhouse, bungalow, and cottages.
Using our for rent by owner website, brokers leasing foreclosures file cabin, cabin, bungalow, and apartment classified advertisements.
Detect and invent Brookfield United States condos for rent and short term rentals in Brookfield.
See private indexes, decadent ads, well appointed ad directories, and lake classifieds that agents and property owners post on FRBO.com.
Catch, relocate, and come across short term rentals Nantucket and homes for rent.
Find, identify, and relocate Bristol rent house, Bristol Massachusetts vacation rental, Bristol Massachusetts apartments for rent, and vacation rental in Bristol Massachusetts.
Detect and relocate bed and breakfast rentals Norfolk and houses for rent in Norfolk United States.
|
|
