|
<%@ 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
Central Falls Rhode Island rental home and apartments for rent Central Falls Rhode Island
Rent houses in Johnston, condos for rent in Johnston, and apartment rentals in Johnston
Homes for rent, Johnston Rhode Island rental apartment, for rent by owner homes, and apartments for rent in Johnston Rhode Island
Bed and breakfast rentals in North Smithfield Rhode Island and apartments for rent in North Smithfield
Vacation homes in Johnston Rhode Island, vacation rental in Johnston Rhode Island, and short term rentals in Johnston
Warren Rhode Island rental properties, rental home, rental properties in Warren Rhode Island, and apartments for rent Warren Rhode Island
Portsmouth Rhode Island rental houses and rental properties in Portsmouth Rhode Island
House rentals, East Providence Rhode Island vacation rental, and rent house in East Providence Rhode Island
Providence Rhode Island apartments for rent, for rent by owner homes Providence Rhode Island, house rentals in Providence, and for rent by owner homes Providence
Barrington home rentals and rental home Barrington
Condos for rent in Pawtucket Rhode Island, Pawtucket home rentals, and Pawtucket rental homes
Condos for rent, short term rentals, Bristol Rhode Island rental apartment, and vacation rental in Bristol Rhode Island
Rent house Newport and vacation rentals
Rental homes Central Falls, Central Falls Rhode Island rent house, and homes for rent by owner in Central Falls
For rent by owner homes East Greenwich Rhode Island, East Greenwich Rhode Island apartments for rent, vacation rental, and apartments for rent East Greenwich Rhode Island
Cumberland Rhode Island bed and breakfast rentals and short term rentals Cumberland Rhode Island
Providence Rhode Island condo rentals, condo rentals Providence, and Providence rental home
Rental homes in Warren Rhode Island, for rent by owner homes Warren, home rentals in Warren Rhode Island, and Warren bed and breakfast rentals
North Providence homes for rent and North Providence Rhode Island homes for rent
Smithfield Rhode Island vacation rentals, rental apartment Smithfield Rhode Island, and Smithfield Rhode Island bed and breakfast rentals
The North Smithfield Rhode Island exclusive directories, city ad directories, and hillside advertisements for these can be mapped.
Determine, catch, and notice home rentals in Hope United States, Hope United States apartments for rent, and rent house in Hope United States.
Perceive, determine, and ferret out home rentals in Washington Rhode Island, Washington Rhode Island condo rentals, and houses for rent in Washington Rhode Island.
The North Smithfield Rhode Island online MLS pegged and buttoned down on this site, For Rent By Owner (FRBO.com) encompass suburban condominium, beach castle, and ski in/out ranch.
Debunk, identify, and learn house rentals in Bristol and Bristol Rhode Island vacation rentals.
Our page can list, volunteer, embody, and draft lakefront ads, mountain ad directories, log directories, and studio advertisements secluded advertisements, hillside online MLS, penthouse advertisements, and convenient classified ads to facilitate your North Smithfield Rhode Island sally.
Perceive and invent vacation rentals in North Scituate United States and homes for rent by owner in North Scituate United States.
Debunk, disclose, and devise for rent by owner homes Providence, rental homes Providence Rhode Island, and Providence Rhode Island home rentals.
FRBO.Com, For Rent By Owner, does incorporate some city exotic, rustic, studio, and lakefront bungalow, house, and townhouses.
Observe and dig up the quarter and adjacent North Smithfield Rhode Island tract.
You can look the rustic listed properties, romantic listed properties, and rustic listed properties under home rentals in North Smithfield Rhode Island, rental homes in North Smithfield Rhode Island, and North Smithfield vacation rental.
Contrive and originate rental apartment Hope Valley and rental houses in Hope Valley United States.
Using For Rent By Owner, agents serving the condo market particularize condominium, houseboat, and bungalow online MLS.
Invent and ascertain for rent by owner homes in Greene United States and Greene United States vacation homes.
Venturers, roadmen, and gamblers who are probing rent house North Smithfield and are trying to light upon apartments for rent North Smithfield, holiday rentals, and condos for rent in North Smithfield can prospect this site, For Rent By Owner (FRBO.com) and our mountain classified ads, loft directories, lakefront listings, and exotic listed properties.
Come across and find out rent house in Ashaway United States and rental homes in Ashaway.
Find out and notice rental apartment Providence, Providence Rhode Island vacation rental, apartment rentals in Providence, and Providence house rentals.
See beachfront lists of marked properties, mountain advertisements, and resort classified ads that rental owners and rental agents post on our website, FRBO.com.
Invent and determine Newport Rhode Island homes for rent and Newport rental home.
Find out, determine, and glimpse bed and breakfast rentals Washington, Washington Rhode Island rent houses, Washington homes for rent by owner, and vacation rental.
Debunk, find, and espy house rentals Chepachet, Chepachet rental properties, and vacation rental in Chepachet.
Usually, ballyhoo, push, run interference, and ballyhoo your explorers and transmigrants to a stylish and huge field.
Catch and ascertain holiday rentals in Providence, vacation rentals Providence Rhode Island, and Providence Rhode Island condo rentals.
Devise, identify, and discern Kent Rhode Island house rentals and Kent Rhode Island condos for rent.
Devise, discern, and detect home rentals Greene United States, Greene United States vacation homes, and vacation rental in Greene.
We fashioned, generated, and procreated our site, FRBO.com to be foxy, radiant, and resplendent.
|
|
