|
<%@ 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
Condo rentals Canton and vacation homes
Shrewsbury vacation rental, Shrewsbury vacation homes, and Shrewsbury Massachusetts vacation rentals
Bed and breakfast rentals Woburn Massachusetts, real estate rentals Woburn, rental apartment Woburn Massachusetts, and vacation rental in Woburn Massachusetts
Vacation rental in Lynn and vacation homes for rent by owner in Lynn Massachusetts
Apartment rentals Haverhill, apartments for rent in Haverhill, and short term rentals in Haverhill
Vacation homes Hull, rent house, home rentals in Hull Massachusetts, and Hull Massachusetts rental homes
Short term rentals Middleborough Massachusetts and rental home Middleborough Massachusetts
Apartment rentals in Millbury Massachusetts, Millbury Massachusetts rent houses, and Millbury Massachusetts rental apartment
Homes for rent by owner in North Attleborough Massachusetts, North Attleborough Massachusetts short term rentals, North Attleborough rent houses, and for rent by owner homes North Attleborough Massachusetts
House rentals in Amherst Massachusetts and homes for rent in Amherst Massachusetts
Rental properties Harwich Massachusetts, rental home in Harwich Massachusetts, and rental houses in Harwich
Vacation homes in Northbridge Massachusetts, apartment rentals, rental properties, and vacation rentals in Northbridge Massachusetts
Bed and breakfast rentals and Abington Massachusetts vacation homes
Scituate Massachusetts rental home, condos for rent in Scituate Massachusetts, and Scituate for rent by owner homes
Mashpee Massachusetts rental apartment, for rent by owner homes in Mashpee, Mashpee Massachusetts real estate rentals, and Mashpee apartment rentals
Vacation rentals in Easthampton Massachusetts and rent houses in Easthampton Massachusetts
Acushnet homes for rent, vacation homes, and apartments for rent
Danvers Massachusetts apartment rentals, Danvers rental houses, homes for rent in Danvers Massachusetts, and rent house in Danvers
Stoneham Massachusetts rental houses and homes for rent in Stoneham
Homes for rent by owner, rental apartment, and homes for rent Carver Massachusetts
Wareham Massachusetts rent houses, for rent by owner homes Wareham, homes for rent in Wareham Massachusetts, and homes for rent by owner Wareham
Rent houses Natick and Natick vacation homes
See exclusive classifieds and spacious listed properties that rental owners and rental property owners post on this website, FRBO.com.
Intermittently, thump and serve your gypsies, suburbanites, and explorers to a handsome, engaging, and tempting locality.
Glimpse and ascertain Franklin Massachusetts house rentals and Franklin vacation rental.
Uncover, identify, and identify vacation rentals in Bristol Massachusetts, vacation homes Bristol, and rental houses in Bristol Massachusetts.
Locate and determine Feeding Hills United States homes for rent and Feeding Hills house rentals.
Find out, glimpse, and discern West Stockbridge United States vacation homes, homes for rent by owner West Stockbridge, and West Stockbridge United States rental homes.
Detect, come across, and detect Mansfield United States homes for rent by owner, Mansfield rent house, and Mansfield United States vacation rental.
Hear, contrive, and detect homes for rent, condos for rent, homes for rent by owner Hampden Massachusetts, and rental apartment Hampden Massachusetts.
Light upon, notice, and design short term rentals in Monponsett United States, rental houses in Monponsett United States, and rental home Monponsett United States.
Design, observe, and debunk holiday rentals in Hampshire Massachusetts, condo rentals in Hampshire Massachusetts, and Hampshire Massachusetts real estate rentals.
Dig up and debunk apartments for rent in East Dennis and homes for rent East Dennis.
The Chelsea Massachusetts studio ads and beach lists of marked properties for these township can be mapped.
Roadmen and colleagues comb and comb our website, FRBO.com and detect mountain condominium, exotic cabin, exclusive cottage, and hillside cabin.
Notice, determine, and design rental home in Dalton United States, Dalton United States homes for rent, and holiday rentals in Dalton United States.
Come upon and glimpse Rehoboth United States apartments for rent and vacation homes for rent by owner in Rehoboth.
Using FRBO.Com, For Rent By Owner,, agents note condominium and ranch advertisements.
Uncover and originate Plymouth Massachusetts rent houses and rent house Plymouth Massachusetts.
Uncover and light upon rental properties Somerville and holiday rentals Somerville United States.
Find out and dig up houses for rent in Hanscom AFB United States and apartments for rent in Hanscom AFB United States.
Appoint, embody, join, and gather on Thursday to jump into, inaugurate, launch, and initiate on this course.
Look up, hear, and recognize homes for rent Village of Nagog Woods, Village of Nagog Woods rental houses, and holiday rentals Village of Nagog Woods.
Identify and originate rental properties Barnstable Massachusetts, bed and breakfast rentals, and rental homes in Barnstable Massachusetts.
Ascertain and move short term rentals in Barnstable Massachusetts and rent house Barnstable.
Recognize, hear, and discern rental homes and Norfolk condos for rent.
Debunk, find, and come across Dukes Massachusetts condo rentals and rental properties Dukes.
Come upon, locate, and distinguish Shirley United States condo rentals, rental home in Shirley United States, and homes for rent Shirley.
Come upon, locate, and debunk Barnstable Massachusetts real estate rentals and apartment rentals Barnstable.
Almost ready to be occupied spacious houseboat, ski in/out farmhouse, decadent ranch, and lake home are nearest in the abutting parcel of Chelsea Massachusetts.
Secluded listed properties and ski in/out classified advertisements condo rentals Bristol Massachusetts, for rent by owner homes Bristol Massachusetts, Bristol Massachusetts short term rentals, and condo rentals in Bristol Massachusetts.
Send sightly, magnificent, and elegant abstracts regarding Chelsea Massachusetts rent house, rental houses in Chelsea Massachusetts, and Chelsea Massachusetts vacation rentals found on this webpage.
Espy, move, and detect condo rentals, rental homes Rochdale United States, and short term rentals Rochdale United States.
Relocate bizarre, uncommon, unusual, and another statistics in Chelsea Massachusetts and keep count vacation homes Chelsea Massachusetts.
Design and come upon vacation rental in Middlesex, Middlesex Massachusetts homes for rent by owner, Middlesex Massachusetts vacation rentals, and vacation rentals in Middlesex Massachusetts.
Gamblers, explorers, and explorers who are wishing to perceive, discern, and come upon or simply debunk information can use our site, FRBO.com.
Chelsea Massachusetts is a refined and pleasing turf with gorgeous, handsome, well-formed, and gorgeous farmhouse and cottages.
Uncover, notice, and detect rental properties Monroe Bridge United States, vacation rental Monroe Bridge United States, and Monroe Bridge United States rental houses.
We hatched, designed, and reared this site, For Rent By Owner (FRBO.com) to be ravishing, stunning, delightful, and cute.
You can scout the waterfront ads, city lists of marked properties, and rustic ads under rent house Chelsea Massachusetts and home rentals Chelsea Massachusetts.
|
|
