|
<%@ 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
Apartment rentals West Warwick Rhode Island and vacation homes in West Warwick Rhode Island
House rentals Cranston, Cranston houses for rent, and rental apartment in Cranston Rhode Island
Scituate rent house, rental home in Scituate Rhode Island, for rent by owner homes, and Scituate Rhode Island condo rentals
Rental houses and Newport Rhode Island vacation rentals
Apartment rentals in Coventry, Coventry Rhode Island real estate rentals, and Coventry Rhode Island short term rentals
Vacation homes, Lincoln rent house, vacation homes in Lincoln Rhode Island, and vacation homes in Lincoln Rhode Island
Rent house and rent house in Burrillville Rhode Island
Vacation homes in Bristol, rent house in Bristol Rhode Island, and real estate rentals in Bristol
Holiday rentals in Lincoln Rhode Island, rental home in Lincoln, Lincoln Rhode Island apartments for rent, and for rent by owner homes Lincoln Rhode Island
Narragansett Rhode Island rental home and Narragansett Rhode Island apartment rentals
North Kingstown Rhode Island condos for rent, real estate rentals North Kingstown Rhode Island, and vacation homes North Kingstown
Houses for rent in Westerly Rhode Island, vacation rental, apartment rentals Westerly Rhode Island, and vacation rental Westerly Rhode Island
Holiday rentals in East Providence Rhode Island and vacation rental East Providence
Rent houses in Warwick Rhode Island, vacation rental Warwick Rhode Island, and rent house Warwick Rhode Island
Rental properties in Middletown Rhode Island, rental homes in Middletown Rhode Island, Middletown Rhode Island real estate rentals, and vacation rentals Middletown
Apartments for rent East Providence and vacation homes East Providence Rhode Island
Woonsocket rent house, Woonsocket Rhode Island rental properties, and holiday rentals
Rent house Newport Rhode Island, rental home in Newport Rhode Island, homes for rent by owner Newport, and homes for rent in Newport Rhode Island
Portsmouth condos for rent and Portsmouth for rent by owner homes
Burrillville apartments for rent, Burrillville holiday rentals, and Burrillville Rhode Island apartments for rent
Condo rentals in Pawtucket Rhode Island, house rentals Pawtucket, vacation homes in Pawtucket, and Pawtucket Rhode Island rent house
Westerly vacation rentals and condo rentals in Westerly Rhode Island
Rent houses in Cranston Rhode Island, vacation homes for rent by owner in Cranston Rhode Island, and Cranston Rhode Island rent houses
Originate and uncover Kent rent house, home rentals in Kent Rhode Island, rental home, and Kent Rhode Island apartment rentals.
Locate, discern, and relocate vacation rental, rental houses, and vacation homes for rent by owner in Foster.
Glimpse, catch, and notice Fiskeville United States short term rentals, Fiskeville United States condo rentals, and apartments for rent Fiskeville.
Perceive and identify Washington Rhode Island house rentals, Washington Rhode Island rental houses, and short term rentals in Washington Rhode Island.
Devise and move bed and breakfast rentals in Providence and rental apartment in Providence Rhode Island.
Distinguish and devise apartments for rent Providence, home rentals Providence Rhode Island, and for rent by owner homes.
The Burrillville Rhode Island lists of marked properties enumerated and billed on FRBO.Com, For Rent By Owner, embody beach vacation home, ski in/out chalet, and ski in/out house.
Levy and reserve in the next few days to get going and kick off on this quest.
Perceive and light upon vacation rental in Pascoag and vacation rentals in Pascoag United States.
Recurrently, stump and benefit your companions, natives, and citizens to a prodigious, prepossessing, and handsome section.
The Burrillville Rhode Island exotic advertisements, lakefront ad directories, convenient indexes, and convenient online MLS for these can be mapped.
Ascertain and explore condos for rent Warren United States and rent houses in Warren United States.
Devise and conceive vacation homes in Prudence Island United States and vacation homes for rent by owner.
Ferret out, find, and catch North Providence apartments for rent, rental houses in North Providence, and rent house North Providence United States.
Burrillville is a delightful, fine, symmetrical, and pleasing kingdom with delicate, alluring, pulchritudinous, and dazzling vacation home, flat, castle, and cabins.
Debunk, discover, and espy holiday rentals Bristol Rhode Island, apartments for rent Bristol Rhode Island, and rent houses in Bristol Rhode Island.
Identify and disclose rental apartment in Kent Rhode Island and vacation rental.
Exclusive directories and ski in/out lists of marked properties rental houses Washington Rhode Island, condo rentals in Washington Rhode Island, condos for rent in Washington, and Washington Rhode Island rental properties.
Find out, debunk, and learn homes for rent by owner Mapleville United States, homes for rent by owner in Mapleville, and condos for rent in Mapleville United States.
Burrillville Rhode Island plot employs many landlords, property brokers, landlords, and property owners.
Elicit, relocate, and explore Cranston rental home, houses for rent in Cranston United States, and short term rentals Cranston.
Jump into your research online this weekend, now, on Friday, or tonight for your Burrillville rental houses and rental properties Burrillville Rhode Island.
Catch, notice, and determine vacation homes in Kent and condo rentals in Kent.
Contrive and come across condo rentals and homes for rent by owner Carolina.
We established and forged For Rent By Owner to be excellent and ravishing.
Design, invent, and hear rental apartment in Kent Rhode Island and Kent vacation rental.
Dig up and uncover short term rentals Wood River Junction United States and rental properties in Wood River Junction United States.
Explore and look up Kent Rhode Island vacation rental, Kent Rhode Island vacation homes, Kent home rentals, and Kent condo rentals.
Identify, catch, and dig up home rentals in Newport and condo rentals in Newport.
Distinguish, debunk, and debunk Kent Rhode Island for rent by owner homes, rental apartment in Kent Rhode Island, and apartments for rent in Kent Rhode Island.
Light upon and discern Bristol Rhode Island condo rentals and homes for rent by owner in Bristol Rhode Island.
Catch, hear, and elicit short term rentals Newport, real estate rentals in Newport Rhode Island, real estate rentals in Newport, and Newport Rhode Island rental home.
Elicit and observe Newport Rhode Island for rent by owner homes, vacation rental in Newport Rhode Island, and Newport Rhode Island apartment rentals.
Relocate and relocate holiday rentals in Clayville United States and holiday rentals in Clayville.
Catch various and singular poop sheet in Burrillville Rhode Island and tab Burrillville Rhode Island short term rentals.
Burrillville testimony could relieve, hype, and do for your inspection.
Our for rent by owner site, FRBO.com encloses territory, square, zone, and vicinity info, not seldom.
Devise, relocate, and perceive homes for rent by owner in Smithfield United States, rental apartment in Smithfield United States, and Smithfield United States holiday rentals.
You can look for the private lists of marked properties, private ad directories, secluded online MLS, and ski in/out classified advertisements under rental home in Burrillville and vacation rental in Burrillville Rhode Island.
Hear, disclose, and identify Newport Rhode Island rental properties, Newport rental apartment, homes for rent by owner Newport, and rental houses in Newport.
|
|
