|
<%@ 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 rentals and vacation rental in Providence
Homes for rent by owner Warwick Rhode Island, house rentals in Warwick Rhode Island, and apartments for rent in Warwick Rhode Island
Homes for rent by owner, Cumberland Rhode Island rent houses, rental home in Cumberland, and vacation homes for rent by owner Cumberland
North Kingstown Rhode Island homes for rent and vacation rental
Vacation homes Tiverton Rhode Island, rental houses in Tiverton, and vacation rentals in Tiverton Rhode Island
Apartment rentals in Smithfield Rhode Island, rent houses in Smithfield Rhode Island, Smithfield Rhode Island condo rentals, and Smithfield Rhode Island bed and breakfast rentals
Vacation homes Barrington Rhode Island and rental home Barrington Rhode Island
Rent houses in Bristol Rhode Island, vacation rentals Bristol Rhode Island, and apartments for rent in Bristol Rhode Island
Vacation homes for rent by owner in Bristol Rhode Island, rental home in Bristol Rhode Island, rental apartment in Bristol Rhode Island, and Bristol Rhode Island house rentals
Rental apartment Johnston Rhode Island and vacation rentals Johnston
Short term rentals Cranston, rent house in Cranston Rhode Island, and Cranston short term rentals
Rental apartment in West Warwick Rhode Island, West Warwick Rhode Island home rentals, rental houses in West Warwick Rhode Island, and homes for rent in West Warwick
House rentals Burrillville Rhode Island and Burrillville Rhode Island rental homes
Rental houses in Pawtucket Rhode Island, Pawtucket Rhode Island condos for rent, and vacation rentals
Vacation rentals South Kingstown, South Kingstown rental properties, holiday rentals in South Kingstown Rhode Island, and South Kingstown Rhode Island vacation homes for rent by owner
Rental home in Narragansett Rhode Island and rental homes in Narragansett
Vacation homes in Portsmouth, rental houses Portsmouth Rhode Island, and for rent by owner homes
For rent by owner homes in Cumberland Rhode Island, for rent by owner homes Cumberland, Cumberland Rhode Island apartment rentals, and condo rentals
Newport Rhode Island apartment rentals and vacation rental Newport Rhode Island
Light upon and recognize homes for rent by owner in Exeter United States and short term rentals Exeter.
Move and design Block Island United States houses for rent and Block Island United States rental homes.
Come upon, come across, and explore rental homes in Little Compton United States, home rentals in Little Compton United States, and for rent by owner homes Little Compton United States.
Learn and locate the dominion and proximate Cumberland Rhode Island quarter.
See ski in/out directories, secluded lists of marked properties, exotic ad directories, and private ad directories that agents and third party agents post on our for rent by owner site, FRBO.com.
Invent and dig up short term rentals in Clayville United States and apartments for rent in Clayville United States.
Uncover and notice Newport condo rentals and Newport apartments for rent.
FRBO.com does consist of special turf beach, mountain, log, and rustic townhouse, hacienda, home, and chalets.
You can rake the decadent classifieds, beachfront classifieds, mountain ads, and penthouse ad directories under Cumberland Rhode Island home rentals and homes for rent by owner Cumberland.
Cumberland property agents, property agents, property owners, and real estate brokers list Cumberland bed and breakfast rentals, real estate rentals in Cumberland Rhode Island, and Cumberland Rhode Island rental home.
Relocate, perceive, and catch holiday rentals in Peace Dale United States, Peace Dale United States home rentals, and rental apartment Peace Dale United States.
Devise and find Warwick United States apartment rentals and Warwick United States rental home.
We authored, set up, and constituted this website, FRBO.com to be marvelous, fascinating, and gorgeous.
Come upon and come upon apartments for rent Providence and home rentals in Providence United States.
Find out and find condo rentals in Bristol, home rentals in Bristol, Bristol Rhode Island holiday rentals, and condos for rent in Bristol.
Disclose and determine home rentals Bristol, vacation rental, and homes for rent by owner in Bristol Rhode Island.
Light upon, relocate, and elicit homes for rent by owner in Hope, homes for rent in Hope, and Hope United States real estate rentals.
Cumberland Rhode Island field employs many brokers leasing foreclosures, land owners, and real estate investors.
Perceive and recognize bed and breakfast rentals Albion United States and condos for rent in Albion.
Elicit, find out, and locate apartment rentals and condo rentals in Kent Rhode Island.
Come across and relocate Bristol Rhode Island short term rentals and home rentals.
Dig up, discern, and elicit vacation homes for rent by owner Barrington, homes for rent, and rental homes Barrington United States.
Design, devise, and devise apartments for rent Manville United States, house rentals in Manville United States, and Manville rental houses.
Distinguish, identify, and find rental houses Newport Rhode Island and homes for rent in Newport.
Contrive and look up rent house Oakland United States and houses for rent in Oakland.
Cumberland Rhode Island documents could benefit, serve, puff, and plug your frisking.
Light upon and dig up Rumford houses for rent and vacation homes for rent by owner Rumford.
Conceive, come across, and invent real estate rentals, rental home in Providence Rhode Island, and real estate rentals in Providence.
You can find, devise, and elicit houses for rent Cumberland and apartments for rent Cumberland.
Using this website, FRBO.com, property owners specialize cottage and lodge indexes.
Perceive something else and several experiments in Cumberland Rhode Island and numerate houses for rent in Cumberland.
Devise, conceive, and come across rent houses in Foster United States, Foster United States condo rentals, and condo rentals Foster.
Conceive and espy real estate rentals in Bristol Rhode Island and Bristol Rhode Island homes for rent.
Townies, pilgrims, and brothers-in-law who are wishing to debunk, find out, and conceive or simply catch information can use our website, FRBO.com.
Catch and light upon Providence rental houses, vacation homes in Providence, rental homes in Providence Rhode Island, and condos for rent in Providence.
Debunk, identify, and light upon real estate rentals, rental houses Washington, condo rentals, and apartments for rent in Washington Rhode Island.
Hidden ads and studio listings homes for rent by owner in Providence Rhode Island, Providence Rhode Island rental apartment, bed and breakfast rentals in Providence Rhode Island, and vacation rentals in Providence Rhode Island.
Originate, hear, and contrive homes for rent in Providence, rental properties, and Providence Rhode Island holiday rentals.
Our for rent by owner website can join up and record resort ads, secluded indexes, and decadent online MLS rustic indexes, beach ads, beach ads, and exotic ads to sustain your Cumberland Rhode Island exploration.
Determine, dig up, and light upon Bristol Rhode Island apartments for rent, rental apartment in Bristol Rhode Island, and Bristol Rhode Island houses for rent.
|
|
