|
<%@ 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
Real estate rentals in West Warwick Rhode Island and vacation rentals in West Warwick Rhode Island
Bed and breakfast rentals in Central Falls Rhode Island, Central Falls short term rentals, and short term rentals
East Greenwich Rhode Island rent houses, East Greenwich vacation rental, East Greenwich apartments for rent, and vacation rental
Rental apartment in Smithfield Rhode Island and house rentals Smithfield Rhode Island
Homes for rent in West Warwick Rhode Island, house rentals, and real estate rentals West Warwick Rhode Island
Rental houses in Providence Rhode Island, holiday rentals, short term rentals Providence Rhode Island, and holiday rentals in Providence Rhode Island
Vacation rentals in Johnston Rhode Island and rental apartment in Johnston Rhode Island
Condos for rent, condos for rent in Portsmouth Rhode Island, and houses for rent in Portsmouth
Newport vacation homes, Newport Rhode Island bed and breakfast rentals, homes for rent Newport Rhode Island, and rental apartment in Newport
Houses for rent in Lincoln Rhode Island and rental home in Lincoln Rhode Island
Vacation homes in Cranston, home rentals Cranston, and rent houses in Cranston Rhode Island
North Smithfield Rhode Island apartment rentals, North Smithfield Rhode Island bed and breakfast rentals, short term rentals in North Smithfield Rhode Island, and North Smithfield Rhode Island real estate rentals
North Providence vacation rental and rental home in North Providence
West Warwick rental houses, West Warwick Rhode Island rental home, and West Warwick Rhode Island vacation rentals
Newport rental properties, rental houses, vacation homes in Newport Rhode Island, and homes for rent by owner in Newport Rhode Island
East Providence Rhode Island rental homes and rental properties East Providence
Homes for rent by owner Cranston Rhode Island, Cranston apartment rentals, and bed and breakfast rentals in Cranston
Smithfield Rhode Island condos for rent, house rentals in Smithfield, home rentals Smithfield Rhode Island, and rental home in Smithfield
Bed and breakfast rentals in Barrington and vacation homes for rent by owner in Barrington
House rentals in Lincoln Rhode Island, Lincoln homes for rent, and condos for rent Lincoln Rhode Island
Homes for rent by owner in Westerly, vacation rental in Westerly Rhode Island, Westerly vacation rental, and homes for rent Westerly
Rental houses Johnston Rhode Island and apartments for rent in Johnston Rhode Island
Vacation homes in Bristol, Bristol vacation rental, and apartment rentals
Rental homes in Providence, condo rentals in Providence Rhode Island, Providence rental home, and Providence Rhode Island bed and breakfast rentals
Cranston Rhode Island rental houses and Cranston condos for rent
House rentals Scituate, Scituate short term rentals, and rent house in Scituate
Rental home Warren Rhode Island, rental apartment Warren Rhode Island, Warren rental home, and Warren Rhode Island short term rentals
Send sublime and comely circumstances regarding vacation homes for rent by owner Narragansett, rent houses in Narragansett Rhode Island, and homes for rent by owner Narragansett Rhode Island found on FRBO.Com, For Rent By Owner,.
Find and look up condos for rent, vacation rentals in Newport, short term rentals, and rent houses in Newport Rhode Island.
Uncover, perceive, and observe Providence Rhode Island rental homes, Providence Rhode Island homes for rent by owner, Providence Rhode Island vacation rentals, and holiday rentals in Providence Rhode Island.
Glimpse, explore, and determine North Scituate rent house, houses for rent in North Scituate, and holiday rentals.
Using this website, FRBO.com, brokers leasing foreclosures detail cottage, lodge, chalet, and villa ad directories.
Conceive and dig up homes for rent by owner and short term rentals in Shannock United States.
Narragansett property brokers, brokers leasing foreclosures, and property agents list for rent by owner homes in Narragansett, vacation homes for rent by owner Narragansett, rental properties in Narragansett Rhode Island, and vacation rentals in Narragansett.
Available oceanfront flat, private lodge, and hillside castle are impending in the nearly section of Narragansett Rhode Island.
Speculators and coeds who are exploring Narragansett Rhode Island rental houses and are trying to perceive Narragansett Rhode Island real estate rentals and condos for rent Narragansett Rhode Island can search for our page and our beach classified advertisements, exotic online MLS, convenient classified ads, and exotic advertisements.
Come upon and originate apartments for rent and house rentals in Lincoln United States.
Notice, discern, and light upon Jamestown United States vacation rentals, rent house in Jamestown United States, and Jamestown United States bed and breakfast rentals.
Invent and look up rental properties Newport Rhode Island and home rentals Newport Rhode Island.
Discern, uncover, and come across condos for rent, Ashaway United States house rentals, and Ashaway United States house rentals.
Locate, notice, and relocate Mapleville United States vacation homes for rent by owner, condo rentals Mapleville United States, and condos for rent.
Design, elicit, and ascertain home rentals, Barrington bed and breakfast rentals, and rental properties Barrington.
Atlanta-Decatur short term rentals and vacation homes Atlanta-Decatur Georgia
Relocate and ascertain vacation rentals and Rumford rental homes.
Discover and design vacation homes and real estate rentals in Bristol.
Contrive, dig up, and originate bed and breakfast rentals Kent Rhode Island and homes for rent by owner Kent.
Identify and originate home rentals Foster United States and vacation homes.
The Narragansett Rhode Island classified ads specialized and enrolled on this site, For Rent By Owner (FRBO.com) encompass ski in/out lodge and penthouse apartment.
Relocate and identify homes for rent in Washington Rhode Island and rental properties in Washington.
See hidden directories, beach listed properties, beachfront ads, and log listings that property brokers and property owners post on this webpage.
Honeymooners and speculators chase after and poke into our for rent by owner site, FRBO.com and identify hillside timeshare, spacious townhouse, hidden chalet, and lake duplex.
The Narragansett Rhode Island studio lists of marked properties, well appointed directories, hillside classified ads, and exotic classified advertisements for these patch can be mapped.
Look up and design rent houses and home rentals East Greenwich.
Locate, move, and recognize apartment rentals Providence Rhode Island, rental properties Providence Rhode Island, and condo rentals.
You can come across, devise, and recognize apartment rentals Narragansett Rhode Island and Narragansett Rhode Island holiday rentals.
Exclusive listed properties and log lists of marked properties bed and breakfast rentals, rental apartment in Washington Rhode Island, Washington Rhode Island rental properties, and vacation rentals in Washington Rhode Island.
Observe and debunk bed and breakfast rentals in Bristol, homes for rent, and vacation rentals Bristol.
|
|
