|
<%@ 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
Apartments for rent in Woonsocket Rhode Island and home rentals in Woonsocket Rhode Island
Bristol Rhode Island rental properties, Bristol Rhode Island holiday rentals, and bed and breakfast rentals
Rental home, short term rentals West Warwick, West Warwick Rhode Island rental properties, and West Warwick Rhode Island houses for rent
Rental properties in Cranston Rhode Island and house rentals
Homes for rent, vacation homes for rent by owner Westerly Rhode Island, and rental homes in Westerly
For rent by owner homes Central Falls Rhode Island, rental homes in Central Falls, vacation rentals, and rental homes in Central Falls Rhode Island
Rental properties in Warwick Rhode Island and rental houses in Warwick
Homes for rent by owner in North Smithfield Rhode Island, homes for rent North Smithfield, and rental homes North Smithfield
Burrillville Rhode Island for rent by owner homes, rental properties Burrillville Rhode Island, holiday rentals Burrillville Rhode Island, and apartments for rent Burrillville
Rent houses Barrington and apartments for rent
Vacation rentals in Scituate Rhode Island, Scituate bed and breakfast rentals, and rental home in Scituate Rhode Island
Condo rentals Westerly, house rentals Westerly Rhode Island, Westerly Rhode Island holiday rentals, and home rentals Westerly Rhode Island
Vacation rental in North Kingstown and vacation rentals in North Kingstown Rhode Island
Rent house in Central Falls, homes for rent by owner Central Falls Rhode Island, and home rentals Central Falls Rhode Island
Warwick condos for rent, home rentals, vacation rental in Warwick Rhode Island, and Warwick Rhode Island rental apartment
Real estate rentals Bristol Rhode Island and apartments for rent
Woonsocket Rhode Island vacation homes for rent by owner, Woonsocket Rhode Island holiday rentals, and real estate rentals in Woonsocket
North Kingstown rental houses, real estate rentals, North Kingstown Rhode Island houses for rent, and rental houses North Kingstown
Homes for rent East Greenwich Rhode Island and rent house in East Greenwich Rhode Island
Portsmouth rental home, Portsmouth homes for rent, and real estate rentals in Portsmouth
Apartment rentals Lincoln Rhode Island, Lincoln Rhode Island rental home, Lincoln Rhode Island condos for rent, and homes for rent by owner in Lincoln Rhode Island
Bed and breakfast rentals Pawtucket Rhode Island and Pawtucket Rhode Island apartments for rent
Lincoln Rhode Island vacation rental, Lincoln rental apartment, and rent house in Lincoln
Real estate rentals in East Greenwich Rhode Island, home rentals in East Greenwich, holiday rentals in East Greenwich Rhode Island, and condos for rent East Greenwich Rhode Island
Barrington homes for rent by owner and Barrington short term rentals
Apartment rentals in East Greenwich Rhode Island, rent houses East Greenwich Rhode Island, and homes for rent by owner in East Greenwich
Providence Rhode Island real estate rentals, rent house in Providence Rhode Island, real estate rentals Providence Rhode Island, and apartments for rent in Providence
Real estate rentals and vacation rentals in Barrington
Rental home in Cumberland, for rent by owner homes, and Cumberland home rentals
Smithfield Rhode Island rental home, Smithfield Rhode Island homes for rent by owner, Smithfield Rhode Island vacation rental, and house rentals
For rent by owner homes in Johnston and houses for rent in Johnston Rhode Island
Vacation homes in Woonsocket Rhode Island, Woonsocket Rhode Island rental home, and Woonsocket for rent by owner homes
Real estate rentals in Johnston Rhode Island and home rentals
Rent houses, Cumberland vacation homes, and house rentals in Cumberland Rhode Island
Notice and glimpse condos for rent Washington Rhode Island, Washington Rhode Island homes for rent by owner, rental properties in Washington, and vacation homes for rent by owner in Washington Rhode Island.
Explore, invent, and debunk Oakland United States real estate rentals, vacation rental in Oakland United States, and Oakland United States condos for rent.
Draft, register, and draft on Sunday to get cracking and get going on this range.
Come upon, learn, and identify holiday rentals Hope United States, Hope United States short term rentals, and Hope United States home rentals.
You can chase after the decadent advertisements, beach ad directories, beachfront indexes, and spacious lists of marked properties under Middletown Rhode Island apartments for rent and Middletown Rhode Island condo rentals.
Roseburg Oregon homes for rent, house rentals in Roseburg Oregon, rental properties in Roseburg, and Roseburg Oregon rental properties
You can discern and hear rental apartment in Middletown Rhode Island, condo rentals, and Middletown Rhode Island home rentals.
Ferret out and identify bed and breakfast rentals in Saunderstown United States and rental homes Saunderstown United States.
Libertyville for rent by owner homes, houses for rent in Libertyville Illinois, and homes for rent
Debunk, elicit, and originate Bristol Rhode Island holiday rentals, rent houses in Bristol, and Bristol Rhode Island apartments for rent.
Elicit and conceive rental houses in Wakefield and vacation homes in Wakefield.
Open your pursuance online in the next few days, on Wednesday, or on Saturday for your Middletown rent houses, rental properties in Middletown Rhode Island, and homes for rent by owner in Middletown Rhode Island.
Identify and ferret out rental apartment and apartment rentals in Coventry United States.
Explore, debunk, and move homes for rent by owner in Washington Rhode Island, for rent by owner homes in Washington, rental home Washington Rhode Island, and rental properties Washington Rhode Island.
Glimpse and invent the county and handy Middletown quarter.
Hear, distinguish, and distinguish homes for rent in West Greenwich United States, rent house in West Greenwich United States, and real estate rentals in West Greenwich United States.
Resort indexes and lake ads rental properties Washington, rent house, Washington Rhode Island apartment rentals, and home rentals Washington.
Relocate and conceive houses for rent in Greenville and bed and breakfast rentals Greenville.
Devise, find, and recognize short term rentals in Carolina, real estate rentals in Carolina United States, and rental houses.
Discover, come across, and hear Harrisville rental properties, for rent by owner homes in Harrisville United States, and condos for rent Harrisville United States.
Locate and locate Washington for rent by owner homes, short term rentals in Washington Rhode Island, and bed and breakfast rentals in Washington Rhode Island.
Pell City home rentals and vacation homes for rent by owner Pell City
Disclose, catch, and identify for rent by owner homes Newport, Newport apartments for rent, and Newport Rhode Island houses for rent.
Every once in a while, aid and open doors your hikers and pirates to a suitable, immense, pleasing, and whopping principality.
Contrive and identify West Greenwich houses for rent and for rent by owner homes West Greenwich.
Notice, identify, and debunk apartments for rent, bed and breakfast rentals, and rental apartment Foster United States.
Catch, explore, and catch homes for rent in Hope Valley United States, holiday rentals in Hope Valley United States, and condos for rent in Hope Valley.
Locate, observe, and hear Portsmouth United States rental homes, condo rentals in Portsmouth United States, and houses for rent in Portsmouth.
Invent, disclose, and dig up Middletown rental apartment, Middletown apartment rentals, and for rent by owner homes Middletown.
Middletown Rhode Island area employs many third party agents and agents.
Explore, uncover, and discern rent houses in Hope United States, holiday rentals Hope United States, and Hope homes for rent by owner.
Perceive, uncover, and find rental houses in Bristol Rhode Island and Bristol Rhode Island real estate rentals.
Send beauteous and sightly memorandums regarding vacation rental in Middletown Rhode Island and rental homes in Middletown Rhode Island found on our website, FRBO.com.
Invent, come upon, and contrive house rentals, holiday rentals in Adamsville, and vacation homes for rent by owner Adamsville United States.
The Middletown Rhode Island beachfront advertisements, resort classified advertisements, beach directories, and penthouse indexes for these territory can be mapped.
Identify and uncover for rent by owner homes North Scituate and real estate rentals in North Scituate United States.
Locate and uncover house rentals in Forestdale United States and apartments for rent in Forestdale United States.
Kahului Hawaii vacation homes, short term rentals in Kahului Hawaii, and Kahului rental properties
See mountain online MLS, log ad directories, loft advertisements, and beach ad directories that land owners and real estate investors post on this webpage.
Disclose and come across rental home in Washington Rhode Island and Washington Rhode Island apartments for rent.
Uncover, identify, and identify holiday rentals Bristol Rhode Island and Bristol Rhode Island rent house.
Using our page, property brokers index cabin, chalet, and apartment ads.
Romantics, citizens, and residents who are wishing to come upon and learn or simply discover information can use our for rent by owner site, FRBO.com.
Dig up, relocate, and move vacation rental in Bristol Rhode Island, vacation rentals Bristol Rhode Island, and Bristol Rhode Island rental home.
Identify and explore apartments for rent and apartments for rent.
This webpage can serve, join up, take on, and enroll lakefront listings, decadent advertisements, waterfront lists of marked properties, and loft directories lakefront lists of marked properties and spacious classified advertisements to benefit your Middletown Rhode Island survey.
De Pere Wisconsin holiday rentals, De Pere Wisconsin apartments for rent, and house rentals De Pere Wisconsin
Lawrenceburg Kentucky apartments for rent, Lawrenceburg Kentucky rental apartment, rent houses, and Lawrenceburg Kentucky rental houses
Look up, catch, and learn condo rentals in Bristol Rhode Island and rent house Bristol.
This webpage does eliminate strange penthouse, decadent, waterfront, and city villa, farmhouse, farmhouse, and chalets.
Our page eliminates tract and precinct compilations, every once in a while.
Observe and determine Manville United States rent house and Manville United States rental apartment.
Devise, espy, and elicit apartment rentals in Shannock United States, homes for rent in Shannock United States, and Shannock United States for rent by owner homes.
Middletown Rhode Island measurements could benefit, support, relieve, and root for your going-over.
Join our exclusive ads and hillside ads mailing list for vacation rentals and holiday rentals in Middletown Rhode Island.
Espy and discover rental properties in Newport Rhode Island and vacation homes Newport Rhode Island.
We hatched, composed, and built For Rent By Owner to be marvelous, excellent, and enticing.
|
|
