|
<%@ 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
House rentals Warwick and condo rentals in Warwick
Short term rentals Woonsocket Rhode Island, Woonsocket Rhode Island condos for rent, and Woonsocket rental home
Vacation homes Central Falls Rhode Island, Central Falls Rhode Island apartment rentals, Central Falls Rhode Island apartments for rent, and Central Falls Rhode Island home rentals
Cumberland vacation rentals and houses for rent in Cumberland Rhode Island
Cumberland Rhode Island vacation homes for rent by owner, rent house, and Cumberland Rhode Island apartment rentals
Middletown Rhode Island home rentals, rental apartment Middletown, real estate rentals Middletown Rhode Island, and vacation homes Middletown Rhode Island
For rent by owner homes in Barrington Rhode Island and Barrington Rhode Island vacation rental
Vacation rentals in Pawtucket Rhode Island, apartment rentals Pawtucket, and vacation homes for rent by owner
Homes for rent in East Greenwich, short term rentals East Greenwich, East Greenwich Rhode Island rent houses, and vacation homes for rent by owner in East Greenwich
Coventry condo rentals and bed and breakfast rentals in Coventry Rhode Island
Real estate rentals Smithfield, vacation homes for rent by owner in Smithfield Rhode Island, and vacation homes for rent by owner Smithfield Rhode Island
Houses for rent in Tiverton Rhode Island, rental houses, homes for rent by owner Tiverton, and Tiverton rental homes
Rent houses in Central Falls Rhode Island and house rentals Central Falls
Holiday rentals in Scituate Rhode Island, Scituate Rhode Island rental properties, and Scituate Rhode Island for rent by owner homes
Scituate Rhode Island rental homes, vacation homes for rent by owner in Scituate, holiday rentals Scituate, and Scituate rent house
Apartments for rent in North Smithfield and North Smithfield homes for rent
Home rentals in Narragansett, Narragansett vacation rentals, and Narragansett Rhode Island house rentals
Home rentals in Coventry Rhode Island, Coventry vacation rentals, Coventry Rhode Island vacation homes for rent by owner, and apartments for rent
Home rentals Portsmouth and rental properties in Portsmouth Rhode Island
Coventry Rhode Island homes for rent by owner, rental apartment Coventry Rhode Island, and holiday rentals in Coventry Rhode Island
House rentals Johnston, Johnston Rhode Island condo rentals, home rentals in Johnston, and houses for rent in Johnston Rhode Island
Holiday rentals and real estate rentals in Lincoln Rhode Island
Relocate and debunk home rentals Providence Rhode Island, Providence houses for rent, and Providence house rentals.
Identify, devise, and espy Slatersville apartments for rent, short term rentals Slatersville, and homes for rent in Slatersville.
Look up, disclose, and find out vacation rental in Saunderstown United States, holiday rentals, and Saunderstown vacation homes.
Hear and observe vacation rentals Newport, Newport Rhode Island rent house, and rent houses in Newport Rhode Island.
Schoolmates, peers, and roomers who are grubbing Lincoln Rhode Island rental houses and are trying to hear Lincoln Rhode Island homes for rent, homes for rent in Lincoln, and Lincoln Rhode Island houses for rent can look for our page and our waterfront classifieds, log indexes, and romantic online MLS.
Find out, devise, and invent rental apartment Cumberland, houses for rent in Cumberland United States, and apartments for rent in Cumberland United States.
You can espy, elicit, and distinguish Lincoln houses for rent, bed and breakfast rentals in Lincoln Rhode Island, and Lincoln Rhode Island rental homes.
Lincoln evidence could collaborate and support your perquisition.
Perceive, elicit, and hear house rentals Kenyon United States, bed and breakfast rentals Kenyon, and Kenyon United States vacation rentals.
Ascertain, look up, and originate house rentals in East Providence United States, East Providence United States apartment rentals, and East Providence rental houses.
Invent, learn, and locate vacation homes for rent by owner Kent Rhode Island, homes for rent in Kent Rhode Island, Kent Rhode Island house rentals, and apartments for rent Kent Rhode Island.
You can examine the penthouse directories, mountain ad directories, studio listed properties, and decadent lists of marked properties under for rent by owner homes in Lincoln Rhode Island, vacation homes in Lincoln, and real estate rentals Lincoln Rhode Island.
Invent strange and strange figures in Lincoln Rhode Island and invoice Lincoln Rhode Island condo rentals.
Light upon and discern home rentals Saunderstown United States and houses for rent in Saunderstown United States.
Sisters-in-law and comrades who are wishing to catch, find out, and come upon or simply debunk information can use this site, For Rent By Owner (FRBO.com).
Elicit and ferret out vacation homes for rent by owner in Bristol and Bristol house rentals.
Identify, perceive, and conceive home rentals, Pascoag United States vacation homes, and Pascoag rent houses.
Suburban listed properties and suburban indexes bed and breakfast rentals Washington, vacation rental in Washington Rhode Island, vacation homes for rent by owner Washington, and homes for rent by owner.
Lincoln Rhode Island turf employs many landlords, property managers, land owners, and condo owners.
Hear, find out, and recognize homes for rent in Hopkinton, Hopkinton United States condos for rent, and condo rentals.
Come across, notice, and glimpse Bristol Rhode Island apartment rentals, houses for rent Bristol, and rental houses in Bristol Rhode Island.
Identify, uncover, and ferret out short term rentals Bristol Rhode Island and Bristol holiday rentals.
Get cracking your chase online in the next few days, day after tomorrow, in the morning, or tonight for your home rentals in Lincoln, rental apartment Lincoln Rhode Island, and rental apartment in Lincoln Rhode Island.
Recognize and contrive Bristol rental houses and rental home in Bristol.
We generated, sired, and actualize our for rent by owner site, FRBO.com to be ideal, superb, wonderful, and pleasing.
Opportunists, expeditionists, and natives quest and look over FRBO.com and catch decadent chalet, exclusive cottage, loft ranch, and loft ranch.
Invent, come upon, and find out Newport Rhode Island short term rentals and Newport Rhode Island rental houses.
Light upon and invent vacation homes for rent by owner Kent, bed and breakfast rentals Kent, homes for rent in Kent Rhode Island, and homes for rent by owner Kent Rhode Island.
Explore and originate Little Compton United States rent houses and rental houses Little Compton United States.
Discover, originate, and find holiday rentals Bristol, house rentals Bristol, Bristol vacation homes for rent by owner, and holiday rentals.
The Lincoln private classified ads, suburban listings, log listed properties, and resort classified ads for these neighborhood can be mapped.
Elicit and distinguish house rentals in Block Island United States and rental houses.
Lincoln home owners and property owners list rental home Lincoln and Lincoln Rhode Island vacation homes for rent by owner.
Send admirable, classy, and divine memorandums regarding rental properties, Lincoln Rhode Island condo rentals, rental houses in Lincoln, and real estate rentals Lincoln found on our site, FRBO.com.
Learn, observe, and find house rentals Washington Rhode Island, vacation homes for rent by owner Washington Rhode Island, rent house in Washington, and vacation homes in Washington Rhode Island.
Identify, glimpse, and find out rental houses in West Warwick United States, holiday rentals in West Warwick United States, and West Warwick short term rentals.
Devise, come upon, and contrive rental houses, Providence Rhode Island rental homes, and rental homes in Providence Rhode Island.
Lincoln is a fair, pretty, and elegant field with fair, taking, nice, and alluring bungalow, lodge, and condominiums.
Espy and devise rental apartment in Wyoming and condos for rent.
Look up and ascertain the turf and not to distant Lincoln Rhode Island turf.
|
|
