|
<%@ 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" %>
|
Rhode Island Rental Links
Vacation rental Barrington Rhode Island and rental apartment
Rental homes in Cumberland, rent houses in Cumberland, and apartment rentals Cumberland Rhode Island
West Warwick Rhode Island rent houses, vacation rental West Warwick, real estate rentals West Warwick Rhode Island, and rent houses West Warwick
Short term rentals in Warwick and rent house in Warwick Rhode Island
East Greenwich house rentals, rental home East Greenwich Rhode Island, and rental homes in East Greenwich Rhode Island
Rent houses Pawtucket Rhode Island, real estate rentals Pawtucket, rental homes Pawtucket Rhode Island, and vacation homes for rent by owner Pawtucket Rhode Island
Rental home East Providence and rental houses East Providence Rhode Island
Bristol Rhode Island holiday rentals, condo rentals Bristol Rhode Island, and Bristol rental apartment
For rent by owner homes in Pawtucket Rhode Island, Pawtucket Rhode Island holiday rentals, home rentals in Pawtucket Rhode Island, and Pawtucket apartment rentals
Condos for rent in North Providence Rhode Island and for rent by owner homes in North Providence Rhode Island
Apartment rentals, East Greenwich Rhode Island vacation rentals, and vacation homes in East Greenwich Rhode Island
South Kingstown rent houses, houses for rent in South Kingstown, home rentals, and South Kingstown Rhode Island short term rentals
Warren Rhode Island holiday rentals and vacation homes Warren Rhode Island
Condos for rent in Barrington Rhode Island, holiday rentals Barrington Rhode Island, and apartments for rent in Barrington Rhode Island
Woonsocket homes for rent by owner, house rentals, rental home in Woonsocket, and short term rentals in Woonsocket Rhode Island
Apartment rentals in Tiverton and house rentals in Tiverton Rhode Island
Middletown Rhode Island rental homes, condos for rent, and house rentals in Middletown
Apartment rentals in Cranston Rhode Island, Cranston Rhode Island rental houses, home rentals Cranston, and short term rentals Cranston
Bristol Rhode Island for rent by owner homes and Bristol Rhode Island rental homes
Rental apartment Warwick Rhode Island, real estate rentals Warwick, and rental houses Warwick
Rental properties in Newport, Newport Rhode Island vacation rental, rent houses Newport Rhode Island, and home rentals Newport
Rental properties and home rentals Cranston Rhode Island
Providence Rhode Island rent houses, Providence rental homes, and short term rentals Providence
Vacation homes for rent by owner in North Kingstown Rhode Island, North Kingstown Rhode Island real estate rentals, homes for rent by owner, and rental homes North Kingstown
Vacation rental in Barrington Rhode Island and rental houses in Barrington
Rental houses Newport Rhode Island, Newport bed and breakfast rentals, and houses for rent in Newport Rhode Island
Bed and breakfast rentals Cranston Rhode Island, houses for rent Cranston Rhode Island, Cranston Rhode Island bed and breakfast rentals, and vacation homes for rent by owner Cranston Rhode Island
North Kingstown Rhode Island condos for rent and North Kingstown short term rentals
For rent by owner homes in Cranston Rhode Island, Cranston Rhode Island for rent by owner homes, and rental houses Cranston Rhode Island
Short term rentals, Narragansett vacation rentals, rent house Narragansett Rhode Island, and Narragansett Rhode Island homes for rent
Portsmouth rental properties and Portsmouth Rhode Island rental home
Rental properties Johnston, homes for rent by owner, and Johnston Rhode Island rental home
Come upon, perceive, and find out Washington Rhode Island vacation homes, Washington homes for rent by owner, Washington Rhode Island vacation homes for rent by owner, and house rentals in Washington Rhode Island.
Identify, find, and dig up holiday rentals in Oakland, house rentals, and for rent by owner homes.
Devise, detect, and uncover rental properties in Providence Rhode Island, Providence rental home, vacation rental, and Providence Rhode Island house rentals.
The Barrington Rhode Island advertisements written down and numerated on our site, FRBO.com seat exotic vacation home and exotic castle.
Relocate, dig up, and ferret out rent houses Rumford United States, Rumford United States vacation rentals, and Rumford United States apartment rentals.
Find out, catch, and find Ashaway rental home, Ashaway United States vacation homes, and rental apartment in Ashaway.
Come across, ascertain, and notice rental properties, Pawtucket rent house, and Pawtucket United States rental apartment.
Ascertain, dig up, and debunk home rentals in Newport and vacation homes for rent by owner Newport Rhode Island.
See loft directories and resort directories that third party listing companies and home owners post on this site, For Rent By Owner (FRBO.com).
This webpage can incorporate, enter into, and enter beach lists of marked properties, waterfront ad directories, secluded online MLS, and exclusive lists of marked properties ski in/out classified advertisements and log indexes to support your Barrington Rhode Island drive.
Originate and dig up condo rentals Bristol Rhode Island and Bristol Rhode Island condos for rent.
Homes for rent in Bedford New Hampshire, Bedford New Hampshire rental homes, Bedford New Hampshire rental apartment, and rental properties Bedford
Our site, FRBO.com incorporates sector and neighborhood brass tacks, recurrently.
Vacation rental in Pelham and vacation homes in Pelham
Fort Oglethorpe-Lakeview Georgia bed and breakfast rentals, for rent by owner homes in Fort Oglethorpe-Lakeview Georgia, and house rentals in Fort Oglethorpe-Lakeview Georgia
Contrive and invent short term rentals in Kent Rhode Island, house rentals in Kent Rhode Island, and condo rentals in Kent Rhode Island.
Dig up, discern, and learn rent house in Exeter, Exeter United States rental home, and Exeter United States for rent by owner homes.
Dig up, find, and ascertain home rentals in Bristol Rhode Island, houses for rent, apartment rentals, and Bristol Rhode Island short term rentals.
You can scan the log lists of marked properties and private listings under apartments for rent in Barrington and apartments for rent.
Using FRBO.com, brokers leasing foreclosures tally hacienda, houseboat, and apartment lists of marked properties.
Move, come across, and perceive Bristol bed and breakfast rentals, condo rentals Bristol Rhode Island, and Bristol condos for rent.
Houses for rent Prairie Missouri, rent house in Prairie Missouri, and homes for rent
Lakefront advertisements and oceanfront classified ads Bristol condos for rent, rental home Bristol Rhode Island, Bristol Rhode Island rental apartment, and Bristol vacation homes for rent by owner.
Ferret out, recognize, and light upon holiday rentals in Kent Rhode Island and rental houses in Kent Rhode Island.
Notice and explore rental home in Narragansett United States and Narragansett real estate rentals.
Recognize and find Washington Rhode Island rental homes, bed and breakfast rentals, and homes for rent in Washington Rhode Island.
Debunk and elicit Foster rent house and Foster United States vacation homes.
Barrington parcel employs many home owners, third party listing companies, agents, and real estate investors.
Wanderers, residents, and comrades who are chasing after for rent by owner homes Barrington and are trying to dig up vacation rentals Barrington and for rent by owner homes Barrington can forage our webpage and our beach listings, beach classified ads, and oceanfront indexes.
Homes for rent by owner New Ulm Minnesota, houses for rent New Ulm Minnesota, for rent by owner homes in New Ulm Minnesota, and New Ulm Minnesota home rentals
FRBO.com does except various kingdom waterfront, hillside, penthouse, and exclusive ranch, home, chalet, and duplexs.
Glimpse and come upon rental homes Kent and vacation homes for rent by owner Kent Rhode Island.
You can light upon and hear Barrington Rhode Island real estate rentals, Barrington Rhode Island condo rentals, and vacation rentals in Barrington Rhode Island.
Elicit, light upon, and come across Coventry rental properties, vacation homes for rent by owner Coventry United States, and condos for rent.
Ascertain, uncover, and discover Providence Rhode Island condos for rent, Providence Rhode Island homes for rent, and rental apartment.
Come upon and catch vacation rental Albion United States and Albion United States houses for rent.
Determine and glimpse condos for rent in Kent, Kent Rhode Island rent house, and homes for rent by owner in Kent Rhode Island.
Distinguish, hear, and look up rental properties in Bristol Rhode Island, Bristol Rhode Island holiday rentals, and rental homes in Bristol Rhode Island.
Homes for rent in Sarasota Florida, homes for rent by owner in Sarasota Florida, vacation rental in Sarasota Florida, and house rentals in Sarasota Florida
Barrington Rhode Island abstracts could relieve, serve, reinforce, and push your shakedown.
Ferret out specific and startling brass tacks in Barrington Rhode Island and specialize homes for rent by owner in Barrington Rhode Island.
Sailors and adventurers who are wishing to come upon, dig up, and perceive or simply observe information can use For Rent By Owner.
Apartments for rent in Mount Sterling Kentucky, vacation homes for rent by owner Mount Sterling Kentucky, and vacation rental in Mount Sterling
Barrington third party listing companies, third party agents, town home owners, and rental property owners list condos for rent in Barrington Rhode Island and holiday rentals Barrington Rhode Island.
Perceive and conceive Mapleville United States homes for rent and Mapleville United States rental houses.
Determine and disclose condos for rent in West Greenwich and apartment rentals West Greenwich.
Send statuesque and admirable results regarding Barrington Rhode Island rental apartment and Barrington rental properties found on this website, FRBO.com.
|
|
