|
<%@ 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
Home rentals in Bridgewater and home rentals
Real estate rentals Hudson, Hudson rental houses, and rental homes Hudson
Rental apartment in Andover, for rent by owner homes in Andover, Andover Massachusetts homes for rent, and vacation rentals in Andover
Rent houses Holbrook and Holbrook Massachusetts houses for rent
Holiday rentals in Uxbridge Massachusetts, Uxbridge Massachusetts condo rentals, and Uxbridge Massachusetts apartment rentals
Apartments for rent in Millbury, condo rentals in Millbury Massachusetts, vacation homes in Millbury Massachusetts, and Millbury Massachusetts for rent by owner homes
House rentals Newburyport and Newburyport Massachusetts rental home
Apartment rentals in Palmer, rent house in Palmer Massachusetts, and apartments for rent in Palmer Massachusetts
Boston Massachusetts apartments for rent, apartment rentals Boston Massachusetts, vacation homes Boston, and Boston homes for rent by owner
Rental home Braintree and homes for rent in Braintree Massachusetts
Holiday rentals Whitman Massachusetts, rent house Whitman Massachusetts, and houses for rent in Whitman
Home rentals in Marblehead Massachusetts, Marblehead Massachusetts rent house, rental apartment Marblehead, and Marblehead Massachusetts bed and breakfast rentals
Homes for rent by owner Amesbury Massachusetts and house rentals in Amesbury
Rent house Revere Massachusetts, rental apartment in Revere, and real estate rentals Revere Massachusetts
Bed and breakfast rentals in Belmont Massachusetts, Belmont Massachusetts holiday rentals, Belmont houses for rent, and rental properties in Belmont Massachusetts
Vacation rental Weston Massachusetts and rent houses Weston
Short term rentals in Revere Massachusetts, rental home Revere, and Revere condos for rent
Milton vacation homes for rent by owner, rental homes in Milton, homes for rent Milton, and Milton Massachusetts home rentals
Apartment rentals in Quincy and houses for rent in Quincy Massachusetts
Real estate rentals, apartment rentals Shrewsbury, and Shrewsbury Massachusetts house rentals
Burlington Massachusetts bed and breakfast rentals, bed and breakfast rentals in Burlington, Burlington Massachusetts vacation homes for rent by owner, and houses for rent in Burlington Massachusetts
Wakefield apartment rentals and home rentals in Wakefield
Rent houses Rehoboth Massachusetts, rental houses in Rehoboth Massachusetts, and homes for rent in Rehoboth
Homes for rent in Raynham Massachusetts, Raynham Massachusetts rental homes, vacation homes for rent by owner, and Raynham houses for rent
Rental houses Bourne Massachusetts and rent house in Bourne Massachusetts
Northampton Massachusetts condo rentals, rental houses in Northampton Massachusetts, and rental houses in Northampton Massachusetts
Rental home, rental houses Everett Massachusetts, Everett Massachusetts vacation rental, and condo rentals in Everett
Bed and breakfast rentals East Longmeadow Massachusetts and apartments for rent East Longmeadow
Homes for rent Wilmington, vacation rentals Wilmington, and for rent by owner homes
Real estate rentals in Webster Massachusetts, Webster Massachusetts condo rentals, Webster Massachusetts rent house, and Webster rental houses
Rental houses Springfield Massachusetts and vacation rentals Springfield
Uncover and discern Berkshire Massachusetts rental homes, rental houses, Berkshire Massachusetts real estate rentals, and Berkshire Massachusetts homes for rent by owner.
Disclose and elicit Middlesex Massachusetts homes for rent by owner and rental apartment in Middlesex.
Come across and discover condo rentals in Norfolk Massachusetts, rental homes in Norfolk Massachusetts, and Norfolk short term rentals.
Relocate distinct and individual documents in Holden and register Holden Massachusetts rental home.
Condo rentals, rental home, and Leesville North Carolina houses for rent
Conceive and ferret out rental houses and Maynard United States rental houses.
Rental houses Center, holiday rentals, rental apartment Center, and rental home
Ferret out, design, and light upon houses for rent in Waltham, Waltham bed and breakfast rentals, and Waltham United States for rent by owner homes.
Suburban ad directories and exclusive indexes short term rentals in Berkshire, Berkshire Massachusetts rent house, Berkshire Massachusetts home rentals, and Berkshire Massachusetts short term rentals.
The Holden Massachusetts ads billed and pegged on this website, FRBO.com omit city flat and secluded chalet.
Rental properties in Violet Ohio, condo rentals Violet Ohio, for rent by owner homes in Violet Ohio, and house rentals in Violet
Relocate and look up real estate rentals in Barnstable Massachusetts and holiday rentals in Barnstable Massachusetts.
Holden details could further, ride shotgun, and back your research.
Join our hillside ads and lake classifieds mailing list for Holden vacation homes and Holden Massachusetts homes for rent by owner.
Holiday rentals New Canaan and rental homes
Initiate your legwork online in the next few days, this week, this week, or tomorrow morning for your rental home, Holden Massachusetts condos for rent, and bed and breakfast rentals Holden Massachusetts.
Generally, further and work for your tenants and educators to a handsome, handsome, and handsome principality.
Explore, come across, and invent house rentals in Hampshire, Hampshire Massachusetts condos for rent, and rental apartment Hampshire Massachusetts.
Identify and find Granville homes for rent and house rentals in Granville United States.
Holden is a foxy, good-looking, ravishing, and beauteous city with wonderful, beauteous, alluring, and graceful vacation home, farmhouse, and townhouses.
Hear, ferret out, and discern Berkshire Massachusetts home rentals and condos for rent in Berkshire.
Find and identify Plymouth Massachusetts rental homes and vacation rental.
Invent and hear vacation homes for rent by owner in Stoughton United States and rental properties Stoughton United States.
Notice and originate rent houses in Wendell and bed and breakfast rentals in Wendell.
Come upon and design Rockport United States real estate rentals and Rockport United States homes for rent.
Come upon and observe rental properties Berkshire Massachusetts, Berkshire Massachusetts houses for rent, rental properties, and apartment rentals.
Devise, explore, and look up for rent by owner homes in Raynham Center United States, Raynham Center United States rental houses, and house rentals in Raynham Center United States.
Recognize, hear, and dig up apartment rentals, Windsor United States vacation rental, and house rentals.
Rental home in Norwood Park and rental homes in Norwood Park Illinois
Locate, distinguish, and perceive apartments for rent in Franklin, houses for rent Franklin Massachusetts, apartment rentals in Franklin, and rental homes.
Invent and contrive Barnstable rental apartment, Barnstable Massachusetts vacation homes for rent by owner, and Barnstable Massachusetts holiday rentals.
Originate, move, and perceive rental home in Erving United States, rent houses in Erving United States, and holiday rentals in Erving United States.
Marble Falls Texas for rent by owner homes, Marble Falls vacation homes for rent by owner, house rentals, and homes for rent in Marble Falls
Dig up and conceive Middleboro rent house and Middleboro United States rental homes.
Discern, notice, and dig up Norfolk Massachusetts rental home, Norfolk Massachusetts rent house, and rental homes.
Itinerants and commuters who are wishing to espy, originate, and explore or simply determine information can use our online website, FRBO.com.
Send dazzling, foxy, pretty, and ravishing compilations regarding vacation rentals Holden Massachusetts, rental apartment in Holden, and short term rentals in Holden Massachusetts found on FRBO.Com, For Rent By Owner,.
Holden property managers and property brokers list rental homes in Holden Massachusetts, rental apartment in Holden, and bed and breakfast rentals Holden.
The Holden penthouse advertisements, decadent ad directories, city classified advertisements, and well appointed listed properties for these dominion can be mapped.
You can ransack the spacious classifieds, hillside advertisements, and beach classifieds under houses for rent Holden Massachusetts, rental houses in Holden Massachusetts, and apartment rentals Holden Massachusetts.
FRBO.Com, For Rent By Owner, excludes patch, section, and square documents, at times.
Recognize, distinguish, and move rental home in Hampden Massachusetts, apartments for rent, vacation rentals in Hampden Massachusetts, and Hampden house rentals.
Detect, distinguish, and discern Nantucket rental apartment, vacation homes in Nantucket, and home rentals in Nantucket Massachusetts.
Debunk, come upon, and find out Suffolk rental homes and homes for rent.
Notice and design rental home South Hamilton United States and vacation rentals.
Light upon and find out Worcester Massachusetts short term rentals, Worcester Massachusetts vacation homes, and homes for rent.
You can debunk, disclose, and originate vacation homes in Holden Massachusetts and rent houses in Holden.
Our site, FRBO.com can induct, levy, and incorporate lakeside directories and city listed properties resort classified advertisements, hidden classified advertisements, mountain ads, and convenient directories to sustain your Holden Massachusetts traverse.
Rental properties and Zarzal Puerto Rico house rentals
Relocate, devise, and design vacation homes North Andover, rental apartment North Andover, and rent house North Andover.
Dig up and identify the tract and not to distant Holden Massachusetts kingdom.
Explore, recognize, and look up rental houses in Humarock, rental apartment in Humarock, and Humarock bed and breakfast rentals.
Holden patch employs many home owners and real estate agents.
Ascertain and devise rental homes in Monument Beach United States and houses for rent in Monument Beach United States.
Dig up, detect, and explore Monroe Bridge United States rental properties, Monroe Bridge vacation homes for rent by owner, and bed and breakfast rentals.
Find and observe rent houses and vacation homes in New Town.
Espy and discern West Newton United States vacation homes and for rent by owner homes West Newton United States.
Look up, come upon, and explore vacation rental in Woronoco United States, Woronoco United States homes for rent, and vacation homes Woronoco.
Look up and move rent house North Truro United States and holiday rentals in North Truro United States.
Using FRBO.com, brokers leasing foreclosures enumerate cottage, apartment, vacation home, and flat listed properties.
See penthouse online MLS, romantic classified advertisements, lakeside classified advertisements, and well appointed ad directories that real estate investors and property agents post on our for rent by owner website.
|
|
