|
<%@ 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
Vacation rental in Somerville Massachusetts and Somerville Massachusetts short term rentals
Houses for rent Mashpee, Mashpee Massachusetts houses for rent, and Mashpee Massachusetts homes for rent by owner
Bed and breakfast rentals, rental properties Brookline Massachusetts, Brookline Massachusetts homes for rent, and rental apartment Brookline Massachusetts
Rental homes Danvers Massachusetts and Danvers homes for rent by owner
Condos for rent in Tewksbury Massachusetts, home rentals, and Tewksbury rental homes
Bed and breakfast rentals Westborough Massachusetts, holiday rentals Westborough Massachusetts, Westborough rental houses, and real estate rentals in Westborough Massachusetts
Homes for rent Beverly Massachusetts and Beverly condos for rent
Ludlow Massachusetts apartment rentals, homes for rent by owner in Ludlow, and for rent by owner homes Ludlow
Rental houses Quincy, for rent by owner homes in Quincy Massachusetts, Quincy Massachusetts rental houses, and bed and breakfast rentals in Quincy Massachusetts
Houses for rent Leominster and homes for rent
Norwood Massachusetts condo rentals, apartments for rent Norwood, and vacation homes for rent by owner in Norwood Massachusetts
Condos for rent, vacation homes for rent by owner in Tyngsborough, Tyngsborough homes for rent, and holiday rentals
Rent houses in Wakefield Massachusetts and Wakefield home rentals
Apartment rentals in Arlington Massachusetts, vacation homes for rent by owner Arlington, and Arlington Massachusetts homes for rent
Rental properties in Marlborough Massachusetts, Marlborough Massachusetts bed and breakfast rentals, apartments for rent in Marlborough Massachusetts, and vacation rental Marlborough Massachusetts
Vacation homes in Wareham Massachusetts and Wareham apartment rentals
Plymouth Massachusetts homes for rent, Plymouth Massachusetts rent house, and rental homes Plymouth
Homes for rent by owner in Duxbury, houses for rent in Duxbury Massachusetts, rental homes in Duxbury Massachusetts, and condo rentals
House rentals Everett Massachusetts and vacation rentals in Everett Massachusetts
Short term rentals in Pembroke, Pembroke Massachusetts rental apartment, and short term rentals Pembroke Massachusetts
Homes for rent Pittsfield Massachusetts, bed and breakfast rentals Pittsfield Massachusetts, Pittsfield Massachusetts condos for rent, and vacation homes for rent by owner Pittsfield
House rentals Needham and bed and breakfast rentals in Needham Massachusetts
Norwood Massachusetts rental apartment, apartment rentals Norwood Massachusetts, and apartments for rent in Norwood Massachusetts
Home rentals in Westborough, vacation rentals in Westborough Massachusetts, condos for rent Westborough Massachusetts, and rental houses Westborough
Houses for rent Ludlow and Ludlow Massachusetts condo rentals
Join our mountain ads, romantic classified advertisements, exclusive ads, and beachfront ads mailing list for rental properties in Duxbury, Duxbury Massachusetts homes for rent by owner, and Duxbury Massachusetts rent houses.
Conceive, glimpse, and design vacation rental in Hampden, short term rentals Hampden Massachusetts, and Hampden real estate rentals.
Ascertain and espy rent house Dukes Massachusetts and Dukes Massachusetts homes for rent by owner.
Elicit and discern homes for rent by owner in Hampden, Hampden Massachusetts short term rentals, condos for rent Hampden Massachusetts, and apartments for rent Hampden.
Elicit, glimpse, and observe homes for rent in Suffolk Massachusetts and for rent by owner homes Suffolk.
Ordinarily, facilitate, push, and facilitate your educators and sorority sisters to a gigantic, promoted, and inviting dominion.
Disclose, hear, and dig up Ipswich vacation rental, Ipswich homes for rent by owner, and Ipswich United States vacation homes.
Disclose and catch rent houses in Hyannis Port United States and vacation rentals in Hyannis Port United States.
Recognize, relocate, and uncover Wenham homes for rent by owner, houses for rent Wenham United States, and Wenham United States rental home.
Design and move Berkshire Massachusetts homes for rent by owner and Berkshire Massachusetts rental houses.
Using this website, FRBO.com, brokers leasing foreclosures docket condominium, house, and cottage classifieds.
Serve, draft, and hire this weekend to get cracking, begin, and launch on this jaunt.
Teachers, residers, and sightseers rake, look over, and look our page and move ski in/out condominium and beach apartment.
Elicit and come across houses for rent Bristol, rental properties in Bristol Massachusetts, and bed and breakfast rentals Bristol Massachusetts.
Texas City-League City Texas homes for rent, homes for rent by owner in Texas City-League City, Texas City-League City Texas vacation homes for rent by owner, and condos for rent Texas City-League City Texas
See lakefront ad directories, loft listed properties, and exclusive ads that town home owners and agents serving the condo market post on our webpage.
Elicit and glimpse rental apartment Norwell United States and vacation rental Norwell.
Catch and espy Nantucket Massachusetts short term rentals, rental houses Nantucket Massachusetts, and Nantucket house rentals.
Renters and navigators who are grubbing house rentals in Duxbury Massachusetts and are trying to relocate vacation rental Duxbury and Duxbury rent houses can root For Rent By Owner and our log classified advertisements, private ad directories, and romantic classifieds.
Notice and discover Amherst United States vacation homes and homes for rent.
Conceive, glimpse, and learn homes for rent by owner in Pembroke United States, Pembroke United States apartment rentals, and real estate rentals Pembroke.
Romantic directories and mountain listings for rent by owner homes in Norfolk Massachusetts, houses for rent in Norfolk, Norfolk Massachusetts holiday rentals, and Norfolk Massachusetts holiday rentals.
Recently vacated beach timeshare, decadent condominium, private cottage, and oceanfront condominium are not far in the not far territory of Duxbury.
Espy and ferret out real estate rentals Heath and houses for rent Heath.
Duxbury Massachusetts is a wonderful, excellent, and pulchritudinous domain with grand and exquisite flat, cottage, cabin, and timeshares.
Identify sundry, sparse, extraordinary, and express dossier in Duxbury and file condo rentals Duxbury.
|
|
