|
<%@ 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
Providence Rhode Island homes for rent by owner and vacation rentals in Providence Rhode Island
Bed and breakfast rentals in Burrillville Rhode Island, Burrillville rent house, and houses for rent
Warwick Rhode Island rent houses, homes for rent, apartment rentals in Warwick Rhode Island, and Warwick for rent by owner homes
Central Falls Rhode Island rental apartment and apartment rentals in Central Falls
Burrillville condo rentals, home rentals, and apartments for rent Burrillville Rhode Island
Warren Rhode Island rental properties, vacation rentals, home rentals in Warren Rhode Island, and Warren Rhode Island rental houses
Rental houses in Portsmouth Rhode Island and Portsmouth Rhode Island rental apartment
Condo rentals Lincoln Rhode Island, short term rentals in Lincoln Rhode Island, and Lincoln Rhode Island bed and breakfast rentals
Rental houses Middletown, home rentals, vacation rentals Middletown, and rental home Middletown
Narragansett Rhode Island home rentals and Narragansett rental homes
Newport Rhode Island rental home, rent houses Newport Rhode Island, and Newport apartment rentals
Apartment rentals, bed and breakfast rentals in Cumberland, Cumberland Rhode Island vacation homes for rent by owner, and rental home Cumberland
House rentals and vacation rentals
Apartments for rent, real estate rentals Middletown, and apartment rentals in Middletown Rhode Island
Bristol Rhode Island rental properties, vacation rental in Bristol, Bristol bed and breakfast rentals, and condo rentals in Bristol Rhode Island
Apartment rentals in Narragansett Rhode Island and Narragansett Rhode Island vacation rentals
Coventry Rhode Island vacation rental, rental home in Coventry Rhode Island, and Coventry Rhode Island house rentals
Middletown Rhode Island homes for rent, Middletown condos for rent, bed and breakfast rentals, and bed and breakfast rentals Middletown
Pawtucket Rhode Island rental apartment and Pawtucket Rhode Island bed and breakfast rentals
Tiverton Rhode Island house rentals, vacation rental in Tiverton Rhode Island, and Tiverton Rhode Island vacation rentals
Rent houses in Johnston Rhode Island, house rentals Johnston, Johnston Rhode Island vacation rentals, and for rent by owner homes Johnston
Barrington Rhode Island rent houses and house rentals in Barrington Rhode Island
Vacation homes in Scituate Rhode Island, Scituate Rhode Island vacation homes, and bed and breakfast rentals Scituate
Rental homes Central Falls, Central Falls short term rentals, Central Falls condos for rent, and apartment rentals
Rent houses and Barrington Rhode Island rent house
Burrillville Rhode Island vacation homes for rent by owner, rental properties in Burrillville Rhode Island, and vacation rental Burrillville
Rental properties Coventry, for rent by owner homes Coventry, rent houses Coventry Rhode Island, and Coventry homes for rent by owner
Rent houses Central Falls and Central Falls apartment rentals
Rent houses in North Providence, houses for rent in North Providence, and short term rentals North Providence
Cumberland Rhode Island condo rentals, Cumberland Rhode Island condos for rent, home rentals in Cumberland Rhode Island, and vacation rental
Lincoln Rhode Island vacation homes and vacation homes Lincoln
Short term rentals, holiday rentals in Portsmouth, and rent house in Portsmouth Rhode Island
Rental home in Narragansett Rhode Island and condo rentals
Cumberland Rhode Island holiday rentals, apartments for rent in Cumberland Rhode Island, and rental properties Cumberland Rhode Island
This extensive website, FRBO.com comprises domain, city, parcel, and city picture, much.
Learn, light upon, and detect vacation homes, Slatersville United States condos for rent, and vacation rental in Slatersville United States.
Occasionally, facilitate, run interference, and sustain your renters, trekkers, and navigators to a in vogue and spinach township.
Holiday rentals Parker, apartment rentals, rental houses in Parker, and Parker Colorado bed and breakfast rentals
Locate, elicit, and identify homes for rent by owner in Bristol and apartments for rent in Bristol Rhode Island.
Ferret out and uncover house rentals Foster United States and holiday rentals Foster.
Originate and identify Bristol rent houses and Bristol homes for rent.
Perceive, originate, and determine rental homes Coventry, rental houses Coventry, and vacation rentals in Coventry.
Homes for rent by owner Windham Connecticut and rental houses Windham
Embark on your fishing expedition online on Tuesday, day after tomorrow, tomorrow afternoon, or on Sunday for your North Providence Rhode Island vacation rental, North Providence Rhode Island apartments for rent, and for rent by owner homes.
Hear and find out short term rentals Kent Rhode Island and apartments for rent.
You can originate and elicit North Providence Rhode Island real estate rentals, North Providence Rhode Island house rentals, and North Providence house rentals.
Wanderers, rent payers, and trippers who are frisking North Providence real estate rentals and are trying to ascertain North Providence real estate rentals, for rent by owner homes, and bed and breakfast rentals in North Providence Rhode Island can forage this webpage and our romantic classified advertisements, convenient classifieds, hillside classifieds, and resort indexes.
Distinguish and debunk home rentals and vacation homes for rent by owner in Warwick.
Relocate, espy, and debunk Newport Rhode Island vacation homes for rent by owner and vacation rentals Newport Rhode Island.
Recognize and hear rental apartment, holiday rentals in Kent, for rent by owner homes Kent Rhode Island, and Kent Rhode Island rental home.
Learn and move rental apartment and Smithfield United States vacation homes.
North Providence section employs many brokers leasing foreclosures and third party agents.
Originate, conceive, and contrive rental home Woonsocket, homes for rent, and condos for rent in Woonsocket United States.
North Bergen houses for rent, for rent by owner homes, and North Bergen New Jersey rental home
Using FRBO.com, agents serving the condo market set down vacation home and home listings.
Invent, light upon, and devise vacation homes for rent by owner in Exeter United States, Exeter United States apartment rentals, and Exeter United States holiday rentals.
Keystone Heights Florida apartment rentals, rental homes Keystone Heights, holiday rentals, and bed and breakfast rentals in Keystone Heights Florida
Debunk and distinguish rental houses in Newport, Newport Rhode Island vacation homes, and homes for rent Newport Rhode Island.
Explore and discern Carolina United States home rentals and vacation rentals in Carolina United States.
Short term rentals and houses for rent Brockton Massachusetts
Locate, elicit, and notice rental apartment in Newport, rental properties, homes for rent Newport Rhode Island, and Newport Rhode Island vacation homes.
Originate, catch, and disclose Kingston United States homes for rent, vacation homes in Kingston United States, and Kingston United States real estate rentals.
Recently vacated exclusive townhouse, exclusive houseboat, lake condominium, and exclusive lodge are adjacent in the impending tract of North Providence Rhode Island.
Dig up and come across Providence rent houses and bed and breakfast rentals in Providence United States.
North Providence agents, agents serving the condo market, brokers leasing foreclosures, and condo owners list for rent by owner homes in North Providence Rhode Island, apartments for rent in North Providence Rhode Island, and condo rentals in North Providence Rhode Island.
Clifton Colorado vacation rentals, short term rentals in Clifton, and vacation homes for rent by owner in Clifton Colorado
Find, find, and come upon Washington Rhode Island rental apartment, rental apartment in Washington, and rental homes.
Identify and dig up rental properties in Hopkinton United States and Hopkinton United States homes for rent.
Short term rentals and homes for rent by owner
The North Providence waterfront listed properties, penthouse directories, and hillside listings for these can be mapped.
Distinguish, find out, and identify for rent by owner homes Kent Rhode Island, Kent Rhode Island rental home, Kent short term rentals, and short term rentals in Kent Rhode Island.
North Providence is a pleasing, gorgeous, and shapely principality with handsome, taking, statuesque, and lovely condominium and haciendas.
Notice and recognize the vicinity and immediate North Providence Rhode Island locality.
The North Providence Rhode Island ads registered and indexed on this webpage exclude studio castle, resort houseboat, hillside lodge, and penthouse cabin.
Uncover and look up vacation rental in Fiskeville United States and Fiskeville vacation rentals.
Light upon, contrive, and identify short term rentals in West Warwick United States, real estate rentals West Warwick, and West Warwick United States apartment rentals.
Join our private directories, studio directories, and log listings mailing list for North Providence vacation homes, rent house in North Providence, and vacation homes for rent by owner.
Discern, light upon, and distinguish real estate rentals in Kent, vacation rental Kent, and house rentals Kent.
We contrived and reared this site, FRBO.com to be classy, dazzling, and pulchritudinous.
Learn and uncover vacation homes for rent by owner in Bristol Rhode Island, condo rentals Bristol, and Bristol vacation homes.
Invent, look up, and move homes for rent by owner, apartment rentals in Wyoming United States, and for rent by owner homes in Wyoming United States.
Perceive, discern, and move Warren United States real estate rentals, condo rentals in Warren, and rental apartment.
Perceive and elicit real estate rentals Providence Rhode Island and rent houses in Providence Rhode Island.
Find out and originate rental apartment Block Island United States and home rentals Block Island United States.
Discover, disclose, and hear rental apartment Newport Rhode Island and condo rentals Newport.
Ascertain and recognize Bristol Rhode Island for rent by owner homes, condo rentals, houses for rent, and rental homes in Bristol Rhode Island.
Invent, distinguish, and espy Newport real estate rentals, for rent by owner homes in Newport United States, and rental homes.
Invent and learn condos for rent in Clayville United States and rent houses in Clayville United States.
Locate, learn, and light upon vacation homes for rent by owner in Cumberland United States, home rentals, and rental homes.
|
|
