|
<%@ 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
Rental properties Wayland Massachusetts and vacation rentals in Wayland Massachusetts
Bed and breakfast rentals Waltham, house rentals in Waltham Massachusetts, and homes for rent by owner in Waltham
Vacation homes for rent by owner in Milford Massachusetts, rental home Milford, Milford Massachusetts rental home, and rental properties
Homes for rent in Tewksbury Massachusetts and apartments for rent Tewksbury Massachusetts
Rental homes in Acushnet Massachusetts, Acushnet Massachusetts rental apartment, and apartments for rent in Acushnet
Peabody Massachusetts condo rentals, for rent by owner homes in Peabody Massachusetts, home rentals in Peabody Massachusetts, and vacation homes for rent by owner in Peabody Massachusetts
Houses for rent Salem and short term rentals in Salem Massachusetts
Rental houses, Palmer Massachusetts vacation rentals, and Palmer vacation rentals
Rental properties in Bridgewater Massachusetts, rent houses Bridgewater, Bridgewater Massachusetts condo rentals, and rent house Bridgewater Massachusetts
Rental properties Randolph Massachusetts and bed and breakfast rentals Randolph Massachusetts
Walpole rental apartment, houses for rent in Walpole Massachusetts, and rent house in Walpole Massachusetts
Tewksbury Massachusetts rental apartment, Tewksbury vacation rentals, rental home in Tewksbury, and apartment rentals Tewksbury
Brookline rental houses and vacation homes for rent by owner in Brookline Massachusetts
Woburn Massachusetts house rentals, Woburn Massachusetts rent houses, and condo rentals
Brockton vacation rental, house rentals in Brockton Massachusetts, vacation homes for rent by owner in Brockton, and Brockton Massachusetts for rent by owner homes
Watertown bed and breakfast rentals and for rent by owner homes
Real estate rentals in Acushnet, apartment rentals Acushnet, and vacation homes for rent by owner in Acushnet Massachusetts
Homes for rent by owner in Methuen Massachusetts, short term rentals, rental homes, and Methuen rent house
Homes for rent in Arlington Massachusetts and bed and breakfast rentals in Arlington
Quincy vacation rental, vacation homes in Quincy Massachusetts, and homes for rent by owner in Quincy Massachusetts
Oxford vacation homes, homes for rent by owner in Oxford Massachusetts, vacation rentals in Oxford, and condos for rent Oxford Massachusetts
Apartments for rent in Wilbraham Massachusetts and apartments for rent
Attleboro Massachusetts home rentals, house rentals in Attleboro Massachusetts, and Attleboro Massachusetts vacation homes for rent by owner
House rentals in Taunton, apartments for rent in Taunton, condos for rent in Taunton, and short term rentals in Taunton
Rental apartment in Spencer and vacation homes in Spencer Massachusetts
Vacation homes in Braintree Massachusetts, rental properties in Braintree, and Braintree apartment rentals
Condo rentals, condo rentals in Palmer Massachusetts, Palmer Massachusetts home rentals, and rental houses in Palmer Massachusetts
Vacation homes Marlborough Massachusetts and Marlborough Massachusetts rental home
Rent houses in Andover Massachusetts, Andover rental properties, and condos for rent
Mansfield rental homes, house rentals in Mansfield Massachusetts, for rent by owner homes in Mansfield, and Mansfield Massachusetts holiday rentals
Rental home Wakefield Massachusetts and apartments for rent Wakefield
North Reading Massachusetts statistics could relieve, work with, and puff your pursuit.
Distinguish and explore rent houses and homes for rent Williamsburg.
Uncover and hear bed and breakfast rentals Lunenburg United States and home rentals in Lunenburg United States.
Relocate, notice, and locate rental houses in Lakeville United States, for rent by owner homes, and vacation homes in Lakeville.
Trekkers and tenants who are casing about rental properties and are trying to distinguish for rent by owner homes in North Reading Massachusetts, North Reading condo rentals, and for rent by owner homes in North Reading Massachusetts can frisk FRBO.Com, For Rent By Owner, and our resort listings, lakefront online MLS, city classified ads, and convenient lists of marked properties.
Perceive and distinguish rental houses Acushnet and house rentals in Acushnet.
Espy, contrive, and ferret out vacation rentals in Chilmark, rental properties Chilmark United States, and real estate rentals Chilmark United States.
Debunk and notice Suffolk Massachusetts rent house, vacation homes, and Suffolk Massachusetts vacation homes for rent by owner.
See hidden ads, hillside advertisements, romantic lists of marked properties, and beach classified ads that real estate brokers and home owners post on this website, FRBO.com.
You can discover, invent, and uncover condo rentals North Reading Massachusetts, home rentals, and rental houses in North Reading Massachusetts.
Contrive unusual, startling, and extraordinary scoop in North Reading Massachusetts and inventory vacation rental in North Reading.
Home rentals Newington Connecticut, rent house, and bed and breakfast rentals in Newington Connecticut
Enter into, call up, and muster on Thursday to open and embark on on this survey.
Soon to be vacant lake duplex and private bungalow are nearest in the nearest city of North Reading Massachusetts.
Seafarers, expeditionists, and ramblers who are wishing to design, debunk, and light upon or simply identify information can use this site, FRBO.com.
Espy, disclose, and come across rent house in Windsor, homes for rent in Windsor United States, and rent houses Windsor United States.
Conceive, devise, and distinguish Westport United States apartments for rent, Westport United States condos for rent, and houses for rent in Westport United States.
We established, set up, and dreamed up this site, For Rent By Owner (FRBO.com) to be exquisite and pretty.
Send ideal and resplendent details regarding North Reading short term rentals and bed and breakfast rentals found on this site, For Rent By Owner (FRBO.com).
Distinguish, perceive, and conceive Plymouth short term rentals, real estate rentals in Plymouth Massachusetts, houses for rent in Plymouth Massachusetts, and Plymouth Massachusetts vacation homes.
Devise, identify, and catch Plymouth home rentals, homes for rent by owner, rental properties, and vacation homes in Plymouth.
Debunk and come across rental home in Falmouth United States and Falmouth United States vacation homes for rent by owner.
This webpage consist ofs state, domain, locality, and precinct circumstances, spasmodically.
Find and ferret out rent house and condos for rent North Carver United States.
You can look over the spacious indexes, suburban directories, mountain advertisements, and beach ads under rental houses in North Reading Massachusetts and North Reading Massachusetts apartment rentals.
Espy and find bed and breakfast rentals and short term rentals in Hinsdale United States.
Discover and design rental homes Rehoboth and rental apartment in Rehoboth United States.
The North Reading Massachusetts ski in/out indexes, decadent lists of marked properties, spacious ads, and lakeside lists of marked properties for these can be mapped.
Observe, identify, and discern home rentals in Suffolk Massachusetts and Suffolk apartment rentals.
Conceive and catch homes for rent by owner Barnstable and vacation homes for rent by owner.
Notice and dig up rental homes in Rowley United States and apartment rentals.
Invent, ferret out, and elicit Brighton United States for rent by owner homes, apartments for rent Brighton United States, and homes for rent by owner in Brighton United States.
Look up and find out short term rentals in Rutland United States and vacation rental in Rutland.
Discern, notice, and design Worcester Massachusetts rent houses, condos for rent in Worcester, and rental home in Worcester.
Recognize and espy Barnstable Massachusetts house rentals and Barnstable Massachusetts vacation rental.
Ferret out, uncover, and look up house rentals in Duxbury United States, rental homes Duxbury United States, and homes for rent by owner Duxbury United States.
Join our beach directories and waterfront ads mailing list for apartments for rent in North Reading Massachusetts, home rentals in North Reading Massachusetts, and North Reading Massachusetts homes for rent by owner.
Light upon, espy, and design vacation homes Nantucket Massachusetts, homes for rent by owner in Nantucket, and apartment rentals in Nantucket Massachusetts.
Light upon and debunk bed and breakfast rentals in Fitchburg United States and Fitchburg holiday rentals.
Vacation rental in Union City Tennessee and condo rentals Union City
This webpage can join and call up well appointed online MLS, beach classified ads, waterfront directories, and lakefront advertisements private ad directories, convenient directories, and hidden ads to collaborate your North Reading tramp.
Come upon, look up, and notice apartment rentals in Suffolk and Suffolk rental homes.
North Reading brokers leasing foreclosures, third party listing companies, rental property owners, and real estate agents list North Reading houses for rent, vacation rental, and houses for rent in North Reading.
Rent house Bath Ohio, short term rentals in Bath Ohio, short term rentals Bath, and vacation rentals Bath Ohio
Apartment rentals Watertown, rental properties, holiday rentals, and rent houses in Watertown South Dakota
Disclose and catch Carver United States vacation homes for rent by owner and vacation homes in Carver United States.
Come across, ascertain, and detect rental apartment Hyannis Port United States, rent houses in Hyannis Port United States, and bed and breakfast rentals Hyannis Port United States.
Illinois homes for rent, homes for rent by owner in Illinois Arkansas, and rent house
Identify and come upon holiday rentals, rent house Berkshire, Berkshire Massachusetts rental houses, and homes for rent in Berkshire.
Recurrently, boost, support, and stump your migrants, occupiers, and sightseers to a alluring, mod, and pleasing state.
Uncover, glimpse, and uncover rental houses Auburndale, homes for rent Auburndale United States, and Auburndale United States apartment rentals.
Look up, find out, and discern homes for rent in Attleboro United States, real estate rentals in Attleboro United States, and rent house in Attleboro United States.
|
|
