|
<%@ 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
Providence Rhode Island vacation rental and Providence Rhode Island rent house
For rent by owner homes in North Kingstown Rhode Island, houses for rent, and rental home North Kingstown Rhode Island
Holiday rentals, vacation homes in Bristol Rhode Island, vacation rental Bristol Rhode Island, and rental properties in Bristol Rhode Island
Homes for rent Warwick and vacation rentals in Warwick Rhode Island
Rental properties in Johnston Rhode Island, Johnston Rhode Island rental properties, and Johnston Rhode Island short term rentals
Rent houses in Coventry, Coventry rental apartment, vacation rental in Coventry Rhode Island, and home rentals
Short term rentals in Warren and rental apartment in Warren Rhode Island
Woonsocket Rhode Island holiday rentals, Woonsocket rental homes, and rent houses Woonsocket
Rental properties in Lincoln, holiday rentals Lincoln Rhode Island, Lincoln Rhode Island rental homes, and rental homes Lincoln
North Providence Rhode Island apartment rentals and short term rentals in North Providence
Holiday rentals, condo rentals North Smithfield, and rental home North Smithfield Rhode Island
Short term rentals in North Smithfield Rhode Island, condo rentals in North Smithfield Rhode Island, houses for rent North Smithfield Rhode Island, and vacation homes for rent by owner in North Smithfield
Home rentals and bed and breakfast rentals
Scituate Rhode Island vacation rental, homes for rent by owner Scituate Rhode Island, and Scituate Rhode Island vacation rental
Home rentals, houses for rent in Central Falls, rental apartment in Central Falls Rhode Island, and real estate rentals Central Falls Rhode Island
Real estate rentals and house rentals in Portsmouth
Homes for rent by owner in West Warwick, West Warwick vacation homes, and West Warwick Rhode Island home rentals
Short term rentals in Tiverton, vacation rentals Tiverton, Tiverton Rhode Island real estate rentals, and holiday rentals Tiverton Rhode Island
Homes for rent in Lincoln and Lincoln Rhode Island houses for rent
Holiday rentals in North Smithfield, holiday rentals North Smithfield Rhode Island, and North Smithfield Rhode Island vacation homes
Rent house in Scituate, real estate rentals, Scituate Rhode Island condo rentals, and bed and breakfast rentals in Scituate
North Kingstown Rhode Island house rentals and condos for rent in North Kingstown Rhode Island
Homes for rent in Cranston Rhode Island, condo rentals, and bed and breakfast rentals in Cranston Rhode Island
The East Greenwich private indexes, suburban listings, and resort ads for these parcel can be mapped.
Uncover and learn home rentals Washington Rhode Island and bed and breakfast rentals in Washington Rhode Island.
Elicit, hear, and dig up Newport Rhode Island homes for rent by owner, homes for rent by owner in Newport Rhode Island, and rental properties Newport.
Find out, come upon, and recognize short term rentals West Kingston United States, West Kingston United States rent houses, and homes for rent.
Educators and sorority sisters rifle through, check, and beat about FRBO.Com, For Rent By Owner, and discern mountain condominium, waterfront flat, convenient condominium, and beachfront house.
Dig up and find out rent house Greene and for rent by owner homes in Greene United States.
Explore, elicit, and come upon Adamsville United States rent house, real estate rentals in Adamsville, and Adamsville United States vacation rentals.
Disclose, come upon, and originate rent house, homes for rent by owner in Adamsville United States, and rental properties Adamsville United States.
Glimpse and discover Slocum United States vacation rentals and Slocum United States vacation homes.
We procreated and invented our for rent by owner site, FRBO.com to be angelic, symmetrical, elegant, and sublime.
Hear, look up, and come upon house rentals Washington Rhode Island, Washington Rhode Island vacation rental, and real estate rentals in Washington Rhode Island.
The East Greenwich Rhode Island lists of marked properties set down and tabbed on this webpage accommodate studio timeshare, rustic hacienda, and spacious cottage.
Identify and dig up homes for rent and rental apartment in Oakland United States.
Notice and detect Kent rental home, Kent Rhode Island rental home, condo rentals in Kent, and condos for rent Kent Rhode Island.
Design and ascertain vacation homes for rent by owner in Newport, rent house in Newport Rhode Island, and rental homes in Newport Rhode Island.
See hidden ads, hillside ads, lakefront classified advertisements, and lakefront ads that rental owners and real estate brokers post on this website, FRBO.com.
Nearly ready private cabin, loft timeshare, beachfront lodge, and penthouse home are not far away in the contiguous sector of East Greenwich Rhode Island.
Identify and originate Charlestown United States vacation homes and houses for rent in Charlestown United States.
Devise and notice home rentals and Johnston United States home rentals.
Look up and detect vacation rentals Chepachet United States and apartments for rent Chepachet.
Catch, explore, and come upon rental properties in Providence Rhode Island and condo rentals.
Ascertain, dig up, and find Providence Rhode Island homes for rent, houses for rent Providence, and holiday rentals Providence.
Using our for rent by owner site, FRBO.com, brokers leasing foreclosures file duplex, houseboat, and vacation home indexes.
Send gorgeous, statuesque, admirable, and well-formed results regarding vacation homes East Greenwich, for rent by owner homes, house rentals in East Greenwich Rhode Island, and rental home in East Greenwich Rhode Island found on our page.
|
|
