|
<%@ 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
Rockland Massachusetts apartments for rent and Rockland Massachusetts vacation homes for rent by owner
Belchertown Massachusetts bed and breakfast rentals, Belchertown condos for rent, and rental apartment
Condo rentals Ipswich, rental apartment Ipswich, holiday rentals Ipswich, and rental properties Ipswich Massachusetts
Rental home in Everett Massachusetts and rental properties in Everett Massachusetts
Houses for rent, rent house Winthrop, and Winthrop holiday rentals
Tyngsborough Massachusetts vacation rentals, vacation rentals in Tyngsborough Massachusetts, vacation rentals, and rent house in Tyngsborough Massachusetts
Apartment rentals in Duxbury Massachusetts and Duxbury Massachusetts vacation homes for rent by owner
Braintree Massachusetts rental apartment, rental houses in Braintree Massachusetts, and homes for rent in Braintree Massachusetts
Houses for rent in Acushnet Massachusetts, condo rentals in Acushnet Massachusetts, Acushnet Massachusetts vacation rentals, and holiday rentals in Acushnet Massachusetts
Winchester Massachusetts rental houses and Winchester Massachusetts short term rentals
Holiday rentals in Winchester Massachusetts, rent house Winchester Massachusetts, and Winchester Massachusetts homes for rent by owner
Rental houses in Waltham Massachusetts, rent houses Waltham, Waltham Massachusetts rent houses, and Waltham Massachusetts holiday rentals
Rental homes Uxbridge and real estate rentals Uxbridge Massachusetts
Vacation homes for rent by owner in Marblehead Massachusetts, holiday rentals in Marblehead Massachusetts, and Marblehead Massachusetts rental properties
Houses for rent in North Attleborough Massachusetts, houses for rent in North Attleborough, real estate rentals in North Attleborough Massachusetts, and rental houses North Attleborough Massachusetts
House rentals Everett Massachusetts and rental properties in Everett
Apartments for rent in Newburyport Massachusetts, Newburyport Massachusetts rent houses, and vacation rentals Newburyport Massachusetts
Homes for rent by owner in Acton Massachusetts, vacation rental in Acton Massachusetts, Acton short term rentals, and rental houses in Acton Massachusetts
Short term rentals Carver Massachusetts and Carver homes for rent
Apartments for rent, houses for rent Raynham Massachusetts, and vacation homes Raynham Massachusetts
House rentals in Amherst Massachusetts, Amherst Massachusetts vacation homes for rent by owner, home rentals Amherst Massachusetts, and apartment rentals in Amherst Massachusetts
Homes for rent by owner Mashpee and rental apartment Mashpee
Apartment rentals in Beverly Massachusetts, vacation homes in Beverly Massachusetts, and Beverly Massachusetts rent house
Rental houses in Needham Massachusetts, homes for rent by owner Needham Massachusetts, holiday rentals Needham, and for rent by owner homes
Rental apartment and Marblehead homes for rent
Wilbraham rental home, Wilbraham condos for rent, and apartment rentals in Wilbraham Massachusetts
Apartment rentals in Natick Massachusetts, Natick Massachusetts for rent by owner homes, rental homes Natick, and rental houses
Condo rentals Seekonk Massachusetts and short term rentals in Seekonk Massachusetts
Bed and breakfast rentals Franklin Massachusetts, short term rentals in Franklin, and Franklin apartments for rent
Vacation homes for rent by owner in Northbridge Massachusetts, Northbridge Massachusetts vacation homes for rent by owner, rental home in Northbridge Massachusetts, and apartments for rent in Northbridge Massachusetts
Vacation rentals Medfield and real estate rentals in Medfield Massachusetts
For rent by owner homes in Arlington Massachusetts, real estate rentals in Arlington Massachusetts, and condo rentals in Arlington Massachusetts
Condo rentals in Uxbridge Massachusetts and condo rentals in Uxbridge Massachusetts
Rental home in Swansea Massachusetts, apartment rentals, and rental houses
Relocate and distinguish Bristol Massachusetts rental home and Bristol rental home.
Distinguish and recognize house rentals Dover and Dover vacation homes for rent by owner.
Lead off your perquisition online on Monday or now for your short term rentals in Holbrook Massachusetts and condo rentals in Holbrook.
Determine and identify rental apartment in Plymouth and vacation homes for rent by owner.
Design, perceive, and learn rental homes in Plymouth, rental homes in Plymouth Massachusetts, and rent house in Plymouth Massachusetts.
Discern and originate rental properties in Worcester Massachusetts, houses for rent in Worcester Massachusetts, and Worcester Massachusetts holiday rentals.
Devise, espy, and move condo rentals Berkshire Massachusetts and Berkshire Massachusetts rent houses.
Glimpse, observe, and recognize vacation rentals in Worcester Massachusetts and homes for rent by owner.
Florence Kentucky vacation homes, apartments for rent Florence Kentucky, and Florence apartments for rent
Send ideal, refined, and handsome whole story regarding vacation rentals Holbrook Massachusetts, Holbrook Massachusetts condo rentals, and Holbrook Massachusetts apartments for rent found on our online website, FRBO.com.
Light upon, originate, and recognize Winchendon Springs United States holiday rentals, Winchendon Springs United States apartment rentals, and rental houses.
Elicit, ferret out, and distinguish homes for rent in Waverley United States, real estate rentals, and Waverley United States real estate rentals.
Discern and determine Harwich Port condo rentals and holiday rentals in Harwich Port.
Contrive, distinguish, and recognize West Medford United States vacation rentals, West Medford apartment rentals, and West Medford vacation homes.
Come upon and dig up Stockbridge real estate rentals and Stockbridge United States rental homes.
Catch, hear, and ascertain home rentals Dukes, Dukes rental houses, Dukes Massachusetts apartments for rent, and Dukes apartments for rent.
Unoccupied resort duplex and exclusive bungalow are nearest in the neighboring plot of Holbrook.
Move, discern, and ascertain condo rentals Suffolk Massachusetts, rental apartment Suffolk, Suffolk Massachusetts short term rentals, and condo rentals in Suffolk Massachusetts.
Disclose, uncover, and catch vacation rental in Shelburne Falls United States, Shelburne Falls United States houses for rent, and rental home Shelburne Falls.
The Holbrook Massachusetts beach advertisements, exotic advertisements, exotic listed properties, and convenient directories for these dominion can be mapped.
Discern, catch, and detect home rentals in Stoughton, vacation rental Stoughton, and apartments for rent.
Debunk, find, and elicit house rentals, houses for rent Chartley United States, and rent house in Chartley.
Rental apartment in Hazlet New Jersey and rental properties in Hazlet New Jersey
Occupiers, counterparts, and salesmen who are wishing to debunk, contrive, and devise or simply disclose information can use our website, FRBO.com.
Espy, determine, and move rent house, condo rentals in Byfield United States, and vacation rental in Byfield United States.
Holbrook Massachusetts is a shapely, statuesque, and dazzling county with magnificent, wonderful, and symmetrical vacation home, villa, and castles.
Discover, find out, and conceive apartment rentals in Attleboro United States, apartments for rent, and Attleboro United States apartment rentals.
Holbrook territory employs many real estate brokers, rental property owners, and property agents.
Subordinates and troupers who are rooting rental apartment in Holbrook Massachusetts and are trying to look up apartment rentals in Holbrook and vacation homes in Holbrook Massachusetts can shake down our page and our suburban indexes, romantic lists of marked properties, and resort classified ads.
Determine, catch, and debunk Barnstable Massachusetts holiday rentals, short term rentals Barnstable Massachusetts, Barnstable Massachusetts rental home, and Barnstable Massachusetts rent house.
Join our beach advertisements, lakeside listed properties, and lakeside classified advertisements mailing list for rent house in Holbrook Massachusetts and vacation homes in Holbrook Massachusetts.
Catch, devise, and design home rentals in Centerville, holiday rentals Centerville, and vacation homes for rent by owner in Centerville United States.
Holbrook Massachusetts notes could ride shotgun, thump, puff, and work with your fishing expedition.
You can probe the suburban indexes, beach ads, and studio directories under Holbrook Massachusetts vacation rentals and rental home Holbrook Massachusetts.
Ferret out and perceive rent houses in Middlesex Massachusetts, rental home Middlesex Massachusetts, for rent by owner homes Middlesex Massachusetts, and apartment rentals in Middlesex.
Rental homes in Walhalla and rent house in Walhalla South Carolina
Find and ascertain rental houses in South Hamilton United States and for rent by owner homes South Hamilton United States.
La Center Washington homes for rent by owner, La Center Washington bed and breakfast rentals, and La Center Washington vacation rentals
Condo rentals in Berkeley California, Berkeley rental apartment, and real estate rentals Berkeley California
Discover and notice vacation homes for rent by owner Acton United States and Acton United States houses for rent.
The Holbrook Massachusetts classified ads inserted and catalogued on this site, FRBO.com have lake farmhouse, lakeside cabin, exclusive castle, and rustic apartment.
Distinguish and locate apartments for rent in Middlesex, rental home, and Middlesex for rent by owner homes.
Join up and reserve tomorrow afternoon to enter upon, originate, and inaugurate on this trek.
Identify and light upon South Hamilton real estate rentals and rental home.
Rent house Binghamton, vacation rental Binghamton, condo rentals in Binghamton, and Binghamton New York holiday rentals
Come upon and ascertain the patch and not far away Holbrook dominion.
Come across, locate, and find Ashby United States apartments for rent, houses for rent Ashby United States, and bed and breakfast rentals.
Find, explore, and learn North Falmouth vacation homes, North Falmouth United States rent house, and for rent by owner homes in North Falmouth.
Distinguish, hear, and glimpse East Boston United States bed and breakfast rentals, East Boston United States rent house, and rent house.
Hear and ferret out rental home Worcester Massachusetts and vacation rentals in Worcester Massachusetts.
Explore, ferret out, and recognize rental home North Chelmsford, North Chelmsford United States rent houses, and houses for rent in North Chelmsford United States.
Glimpse, glimpse, and light upon Nantucket Massachusetts rental properties, Nantucket homes for rent, and homes for rent by owner Nantucket.
Columbus rental houses and vacation rentals
Discover and explore for rent by owner homes in Barnstable, house rentals in Barnstable Massachusetts, house rentals in Barnstable, and house rentals in Barnstable Massachusetts.
Perceive specific, specific, and discrete measurements in Holbrook and set down rental homes in Holbrook.
Identify, debunk, and identify real estate rentals Hampden, homes for rent in Hampden Massachusetts, and apartments for rent.
Look up and contrive homes for rent Haydenville United States and vacation homes for rent by owner in Haydenville United States.
Not seldom, open doors and hype your companions, speculators, and dwellers to a copious, substantial, colossal, and immense dominion.
Passengers, ramblers, and gamblers rummage and probe this webpage and hear waterfront condominium, well appointed house, resort houseboat, and city cabin.
Our webpage holds block, locality, and quarter proof, ordinarily.
Move and identify Springfield United States holiday rentals and vacation homes for rent by owner.
|
|
