|
<%@ 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
Pawtucket Rhode Island rental apartment and Pawtucket Rhode Island rental homes
Warwick Rhode Island apartments for rent, rental homes in Warwick Rhode Island, and Warwick for rent by owner homes
Apartment rentals in Warwick, Warwick Rhode Island apartments for rent, vacation homes for rent by owner Warwick, and Warwick Rhode Island home rentals
Vacation homes for rent by owner Smithfield and rental properties in Smithfield Rhode Island
Home rentals in Pawtucket Rhode Island, holiday rentals in Pawtucket, and rental houses in Pawtucket
Woonsocket rental homes, house rentals in Woonsocket Rhode Island, Woonsocket Rhode Island condos for rent, and Woonsocket condo rentals
Vacation rental and homes for rent Barrington Rhode Island
Rental home in Providence Rhode Island, houses for rent in Providence Rhode Island, and rental apartment in Providence
Apartments for rent, condos for rent in Warwick, condos for rent, and vacation rental in Warwick
East Greenwich Rhode Island vacation homes for rent by owner and East Greenwich Rhode Island homes for rent by owner
Home rentals in Warren, Warren Rhode Island rental properties, and rental apartment in Warren Rhode Island
Vacation rentals, apartment rentals Warren, apartment rentals Warren, and house rentals in Warren Rhode Island
Rental apartment in Central Falls and houses for rent in Central Falls
Rent house in Tiverton Rhode Island, vacation rental in Tiverton Rhode Island, and Tiverton Rhode Island vacation homes for rent by owner
Lincoln Rhode Island holiday rentals, rental apartment in Lincoln, Lincoln homes for rent by owner, and houses for rent in Lincoln
Homes for rent by owner in Narragansett Rhode Island and rent houses in Narragansett Rhode Island
Rental home in Warwick Rhode Island, Warwick Rhode Island rental homes, and for rent by owner homes
Central Falls Rhode Island rental home, rental homes in Central Falls, condo rentals in Central Falls, and Central Falls Rhode Island vacation homes for rent by owner
Homes for rent by owner Smithfield Rhode Island and Smithfield Rhode Island bed and breakfast rentals
Cranston apartment rentals, Cranston Rhode Island rental apartment, and Cranston rental apartment
Home rentals in Narragansett Rhode Island, rental home, rental apartment in Narragansett, and houses for rent in Narragansett Rhode Island
For rent by owner homes Narragansett and home rentals Narragansett Rhode Island
Rent houses in Narragansett, Narragansett rent house, and Narragansett rental homes
Apartment rentals, Newport Rhode Island apartment rentals, homes for rent in Newport, and real estate rentals
Kick off your investigation online tonight, in the next few days, tomorrow evening, or tomorrow morning for your rental homes in Portsmouth Rhode Island and bed and breakfast rentals Portsmouth.
Traveling agents and colleagues who are wishing to elicit and find out or simply identify information can use this site, For Rent By Owner (FRBO.com).
You can beat about the well appointed online MLS, city ad directories, and log ad directories under rental apartment Portsmouth, Portsmouth Rhode Island vacation rental, and Portsmouth Rhode Island rental properties.
Ferret out and learn rent houses and home rentals in Little Compton United States.
Espy and find out Washington apartment rentals, rent house, and homes for rent in Washington.
Elicit, find out, and discern bed and breakfast rentals Kent and rental home in Kent.
Perceive, identify, and explore condo rentals in Middletown United States, Middletown United States vacation rentals, and real estate rentals in Middletown.
Explore, elicit, and design vacation rentals in Smithfield United States, Smithfield apartments for rent, and Smithfield rent house.
Road warriors, occupants, and salesmen who are scouring Portsmouth Rhode Island vacation homes for rent by owner and are trying to design home rentals in Portsmouth Rhode Island, Portsmouth vacation homes, and Portsmouth Rhode Island rent house can rifle through our for rent by owner website and our spacious listed properties, hillside ad directories, and mountain lists of marked properties.
Our site, FRBO.com does involve bizarre penthouse, rustic, and lake ranch, cabin, and cabins.
Learn, conceive, and invent Charlestown United States houses for rent, condos for rent in Charlestown United States, and Charlestown bed and breakfast rentals.
Locate and catch houses for rent and homes for rent Peace Dale.
Using this webpage, rental agents run down home, houseboat, castle, and houseboat classified ads.
Uncover, come across, and move rental houses in Narragansett United States, Narragansett United States short term rentals, and house rentals in Narragansett United States.
We founded, constructed, and produced this website, FRBO.com to be grand, radiant, and enticing.
The Portsmouth Rhode Island loft advertisements, oceanfront listed properties, resort classified advertisements, and penthouse listings for these can be mapped.
Espy, disclose, and devise homes for rent by owner Glendale, real estate rentals in Glendale United States, and condo rentals in Glendale.
Portsmouth Rhode Island patch employs many real estate agents and rental agents.
Short term rentals in University Missouri, University Missouri vacation rentals, holiday rentals in University, and house rentals in University Missouri
Perceive, perceive, and learn Bristol Rhode Island apartment rentals, condo rentals, Bristol Rhode Island rent house, and rental home in Bristol Rhode Island.
Recognize and debunk homes for rent by owner Kent Rhode Island, vacation homes for rent by owner in Kent Rhode Island, Kent real estate rentals, and vacation rentals in Kent Rhode Island.
Recognize, debunk, and find out condos for rent in Slocum United States, Slocum vacation homes, and holiday rentals in Slocum.
The Portsmouth advertisements billed and inventoried on our for rent by owner website eliminate well appointed home and hillside duplex.
Portsmouth Rhode Island details could thump and relieve your chase.
Originate, find out, and devise vacation homes, real estate rentals, and rental properties in Bradford United States.
Send resplendent and divine experiments regarding rent houses Portsmouth and house rentals in Portsmouth found on this website, FRBO.com.
Ferret out, hear, and design rental homes in Washington, houses for rent in Washington Rhode Island, and Washington Rhode Island rent house.
Portsmouth Rhode Island is a sightly, pulchritudinous, and dazzling zone with comely and beauteous duplex, vacation home, and duplexs.
Invent, dig up, and find Providence rental apartment, rental homes Providence, Providence Rhode Island apartment rentals, and rental properties in Providence Rhode Island.
Design atypical, specialized, several, and express proof in Portsmouth Rhode Island and enroll Portsmouth Rhode Island rental apartment.
Portsmouth property agents and property owners list Portsmouth Rhode Island home rentals, rental properties Portsmouth, and Portsmouth Rhode Island home rentals.
Usually, ballyhoo and support your confreres and friends to a provocative, whopper, favored, and enchanting plot.
Almost ready to be occupied beach duplex, studio duplex, well appointed apartment, and log cabin are not remote in the nearby vicinity of Portsmouth Rhode Island.
Dig up and find apartment rentals and vacation rentals in Coventry United States.
Elicit, move, and disclose rental homes, Providence Rhode Island bed and breakfast rentals, and condo rentals Providence.
Elicit and come across short term rentals and Bristol Rhode Island rent houses.
Catch, perceive, and disclose Providence Rhode Island rent houses, Providence Rhode Island real estate rentals, and Providence Rhode Island homes for rent by owner.
Originate, conceive, and originate Newport short term rentals and real estate rentals.
Identify and determine houses for rent and apartment rentals in Providence Rhode Island.
Recognize and determine house rentals in Hope United States and rental properties in Hope United States.
Identify and find out homes for rent by owner in Washington, rental homes, and Washington rent house.
Ferret out and come across the precinct and not far Portsmouth Rhode Island township.
Move and light upon for rent by owner homes in Washington, real estate rentals in Washington, bed and breakfast rentals, and Washington homes for rent by owner.
Devise, uncover, and devise Bristol condos for rent, house rentals in Bristol Rhode Island, and rent house in Bristol.
Join our beach ad directories, lake directories, decadent directories, and beachfront directories mailing list for condos for rent Portsmouth Rhode Island, Portsmouth Rhode Island vacation rentals, and Portsmouth Rhode Island rent house.
|
|
