|
<%@ 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
Home rentals and holiday rentals in Burrillville Rhode Island
Central Falls rent houses, vacation homes in Central Falls Rhode Island, and Central Falls vacation homes for rent by owner
Coventry Rhode Island apartments for rent, rental home, Coventry Rhode Island vacation rental, and condos for rent Coventry Rhode Island
House rentals in Scituate Rhode Island and Scituate rental home
North Smithfield Rhode Island condo rentals, rental houses in North Smithfield, and rental apartment in North Smithfield
Barrington Rhode Island rent houses, Barrington Rhode Island rent houses, bed and breakfast rentals Barrington Rhode Island, and rental home in Barrington
Bed and breakfast rentals North Providence and for rent by owner homes in North Providence
West Warwick Rhode Island bed and breakfast rentals, West Warwick Rhode Island rental houses, and homes for rent in West Warwick Rhode Island
Apartment rentals North Kingstown, vacation homes for rent by owner North Kingstown Rhode Island, North Kingstown Rhode Island house rentals, and houses for rent in North Kingstown
Rental homes in East Greenwich and East Greenwich condo rentals
Rental apartment in North Providence Rhode Island, rental homes North Providence, and condos for rent in North Providence
For rent by owner homes in North Kingstown Rhode Island, rental homes in North Kingstown Rhode Island, North Kingstown Rhode Island rent houses, and holiday rentals in North Kingstown Rhode Island
Condo rentals and Tiverton rental houses
Rental properties, Warwick Rhode Island homes for rent, and rent house in Warwick Rhode Island
Cranston apartments for rent, vacation rental, rental homes Cranston Rhode Island, and Cranston rent house
North Providence Rhode Island homes for rent and North Providence vacation rental
Central Falls Rhode Island vacation homes for rent by owner, rental homes Central Falls Rhode Island, and rental properties in Central Falls Rhode Island
Vacation homes for rent by owner in North Smithfield Rhode Island, North Smithfield Rhode Island rental properties, rental home in North Smithfield, and rental properties in North Smithfield Rhode Island
Rental home in Providence and rent house Providence Rhode Island
North Providence Rhode Island vacation rentals, rent houses in North Providence Rhode Island, and real estate rentals in North Providence
Warwick Rhode Island rental properties, condo rentals Warwick Rhode Island, rent houses in Warwick Rhode Island, and homes for rent in Warwick
Home rentals Portsmouth Rhode Island and holiday rentals Portsmouth Rhode Island
Westerly Rhode Island condo rentals, Westerly condo rentals, and Westerly Rhode Island vacation rentals
Holiday rentals Providence, Providence house rentals, vacation homes for rent by owner in Providence, and short term rentals Providence Rhode Island
Rent house Barrington Rhode Island and houses for rent in Barrington Rhode Island
House rentals in Woonsocket Rhode Island, vacation homes in Woonsocket Rhode Island, and Woonsocket Rhode Island vacation rental
Send pretty, lovely, and nice dossier regarding home rentals in East Providence Rhode Island, home rentals in East Providence, and rental properties East Providence Rhode Island found on FRBO.com.
Romantics and sorority sisters who are wishing to espy, uncover, and devise or simply discern information can use our site, FRBO.com.
East Providence input could do for and further your going-over.
Espy, ferret out, and distinguish Newport United States bed and breakfast rentals, apartments for rent, and real estate rentals in Newport.
Relocate, discover, and find Adamsville United States home rentals, bed and breakfast rentals Adamsville, and rent house Adamsville United States.
You can learn and conceive vacation rentals East Providence Rhode Island, condo rentals in East Providence, and homes for rent by owner in East Providence Rhode Island.
The East Providence Rhode Island waterfront ad directories, exclusive classifieds, penthouse ads, and exclusive ads for these can be mapped.
East Providence is a angelic, pulchritudinous, and pretty zone with pleasing, fascinating, and shapely houseboat, castle, castle, and vacation homes.
Locate and notice rental apartment in Bristol Rhode Island, Bristol vacation rental, and condo rentals Bristol Rhode Island.
Glimpse, come upon, and discover Newport Rhode Island vacation homes for rent by owner, Newport Rhode Island holiday rentals, rental homes in Newport, and Newport apartments for rent.
Look up, catch, and determine rent houses in Washington Rhode Island, Washington Rhode Island houses for rent, and home rentals Washington Rhode Island.
Light upon and relocate condo rentals Newport, Newport rental home, and vacation rentals.
Catch and identify rent houses Newport, bed and breakfast rentals Newport, home rentals in Newport Rhode Island, and rental houses in Newport Rhode Island.
Discern and catch Rumford United States home rentals and for rent by owner homes in Rumford.
Explore and move apartment rentals in Newport United States and Newport United States for rent by owner homes.
Rental properties in Daleville and bed and breakfast rentals in Daleville
Distinguish, detect, and explore Narragansett United States vacation homes for rent by owner, apartment rentals Narragansett United States, and short term rentals Narragansett.
You can poke into the studio listings, beach listings, lake indexes, and studio online MLS under vacation homes in East Providence Rhode Island, rental apartment in East Providence Rhode Island, and rental apartment East Providence Rhode Island.
Our online website, FRBO.com does enclose especial resort, exclusive, and private castle, lodge, cottage, and haciendas.
Come across and ferret out real estate rentals in Warwick United States and home rentals in Warwick United States.
Identify and distinguish short term rentals in West Kingston United States and houses for rent in West Kingston United States.
Disclose, find out, and glimpse vacation homes for rent by owner Wakefield, apartments for rent in Wakefield, and vacation homes for rent by owner.
Conceive and ascertain Newport Rhode Island vacation rentals and Newport homes for rent by owner.
Originate your frisking online tomorrow, next week, this weekend, or on Thursday for your East Providence home rentals and rental home in East Providence Rhode Island.
Espy and dig up homes for rent in Bristol, Bristol Rhode Island rental properties, and holiday rentals.
Identify, look up, and glimpse Little Compton United States rental home, Little Compton United States apartment rentals, and rental properties.
Unused studio castle, well appointed lodge, exclusive houseboat, and rustic ranch are nearly in the adjoining vicinity of East Providence.
See suburban directories and resort indexes that real estate brokers and condo owners post on this extensive website, FRBO.com.
|
|
