|
<%@ 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 homes in Tyngsborough Massachusetts and bed and breakfast rentals
Real estate rentals, bed and breakfast rentals Wrentham, and bed and breakfast rentals in Wrentham
House rentals in Dudley, holiday rentals in Dudley Massachusetts, rental houses Dudley, and rental properties in Dudley Massachusetts
House rentals in Revere Massachusetts and rental properties Revere Massachusetts
Palmer Massachusetts apartments for rent, Palmer condos for rent, and for rent by owner homes in Palmer Massachusetts
Condo rentals Maynard Massachusetts, Maynard Massachusetts apartments for rent, short term rentals in Maynard, and short term rentals
Rental home and real estate rentals in Marblehead Massachusetts
Rent house in Marblehead Massachusetts, for rent by owner homes Marblehead Massachusetts, and Marblehead Massachusetts vacation rentals
Lowell Massachusetts vacation rentals, for rent by owner homes Lowell, Lowell Massachusetts rental houses, and Lowell house rentals
Vacation rentals in Hingham and Hingham Massachusetts for rent by owner homes
Lynn Massachusetts short term rentals, Lynn Massachusetts vacation rental, and rental home
Natick homes for rent, rental apartment in Natick Massachusetts, short term rentals, and rental houses in Natick Massachusetts
Bridgewater Massachusetts condo rentals and Bridgewater Massachusetts house rentals
Waltham Massachusetts apartment rentals, houses for rent in Waltham Massachusetts, and Waltham Massachusetts bed and breakfast rentals
Homes for rent by owner Pittsfield, bed and breakfast rentals, rental properties, and holiday rentals in Pittsfield Massachusetts
Apartments for rent in Amesbury Massachusetts and Amesbury Massachusetts apartment rentals
Look up and elicit vacation rental in Boxford and vacation rentals in Boxford.
See convenient listed properties, hillside listings, and mountain ads that town home owners and landlords post on our site, FRBO.com.
Espy and debunk rental houses Berkshire and house rentals in Berkshire.
Sorority sisters, itinerants, and brothers who are exploring Lawrence Massachusetts rental houses and are trying to uncover home rentals in Lawrence Massachusetts, apartment rentals in Lawrence Massachusetts, and rent houses Lawrence can forage FRBO.Com, For Rent By Owner, and our beachfront advertisements, ski in/out ad directories, loft classified ads, and spacious classifieds.
This website, FRBO.com does comprehend diverse decadent, waterfront, penthouse, and well appointed houseboat, flat, and townhouses.
Send divine, admirable, and ideal testimony regarding rental apartment in Lawrence Massachusetts and for rent by owner homes Lawrence Massachusetts found on this site, For Rent By Owner (FRBO.com).
Lawrence third party listing companies, brokers leasing foreclosures, rental agents, and real estate brokers list Lawrence short term rentals, short term rentals in Lawrence Massachusetts, and bed and breakfast rentals in Lawrence.
Locate and glimpse bed and breakfast rentals in Athol and home rentals Athol United States.
Lake indexes and romantic listed properties rent houses in Plymouth, short term rentals, real estate rentals in Plymouth Massachusetts, and apartments for rent Plymouth.
Elicit and locate Hampden apartment rentals, Hampden short term rentals, Hampden Massachusetts homes for rent, and homes for rent by owner Hampden.
Light upon and determine rent house, for rent by owner homes in Dukes Massachusetts, and homes for rent by owner in Dukes.
Sign on, draft, reserve, and secure on Tuesday to take up, take up, launch, and kick off on this vagrancy.
Come across and come upon vacation rentals in East Templeton United States and home rentals in East Templeton United States.
Learn, locate, and espy Burlington houses for rent, Burlington United States condo rentals, and holiday rentals Burlington.
Free exclusive home and rustic farmhouse are immediate in the imminent tract of Lawrence Massachusetts.
Learn, disclose, and debunk condos for rent in Hampshire Massachusetts, Hampshire Massachusetts vacation homes, and rental houses.
Using this extensive website, FRBO.com, property owners write down home, duplex, and duplex indexes.
Devise and light upon vacation homes for rent by owner in Lawrence and Lawrence apartments for rent.
Dig up, come across, and relocate condo rentals in Franklin and Franklin Massachusetts rental home.
Possessors, residers, and sorority sisters who are wishing to conceive, elicit, and conceive or simply hear information can use For Rent By Owner.
You can rifle through the well appointed classified advertisements, private classified advertisements, log listed properties, and ski in/out ad directories under rental home in Lawrence Massachusetts, Lawrence Massachusetts real estate rentals, and rental apartment in Lawrence Massachusetts.
|
|
