|
<%@ 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
Vacation homes Woonsocket Rhode Island and Woonsocket real estate rentals
Apartment rentals, rental apartment, and vacation homes in Burrillville Rhode Island
Rental houses Woonsocket, rental properties Woonsocket, holiday rentals Woonsocket, and Woonsocket Rhode Island rental houses
Rental properties Bristol Rhode Island and for rent by owner homes Bristol Rhode Island
North Smithfield home rentals, houses for rent in North Smithfield Rhode Island, and rental home in North Smithfield Rhode Island
Holiday rentals in Barrington Rhode Island, Barrington Rhode Island vacation homes, rental home in Barrington Rhode Island, and houses for rent Barrington
Home rentals in East Providence and condo rentals East Providence Rhode Island
Middletown homes for rent by owner, short term rentals in Middletown, and short term rentals in Middletown Rhode Island
Pawtucket vacation homes, for rent by owner homes in Pawtucket Rhode Island, short term rentals in Pawtucket Rhode Island, and Pawtucket Rhode Island condos for rent
Coventry Rhode Island vacation homes for rent by owner and rent houses in Coventry Rhode Island
Rent houses in Lincoln Rhode Island, condos for rent in Lincoln Rhode Island, and Lincoln Rhode Island vacation rentals
Scituate Rhode Island rental apartment, rental houses in Scituate Rhode Island, rental apartment Scituate, and rental home in Scituate
Vacation homes for rent by owner North Kingstown Rhode Island and rent house North Kingstown
Bed and breakfast rentals, Narragansett apartment rentals, and vacation rentals Narragansett Rhode Island
Rental homes in Coventry Rhode Island, condo rentals Coventry Rhode Island, apartments for rent, and vacation homes for rent by owner Coventry Rhode Island
Disclose, design, and discern rental apartment, home rentals, and rent houses in Kingston.
Hear, perceive, and dig up Bristol Rhode Island vacation homes and Bristol Rhode Island for rent by owner homes.
Glimpse, light upon, and determine rental apartment in Bristol Rhode Island and homes for rent by owner Bristol.
Lakefront advertisements and city listed properties Washington condo rentals, Washington real estate rentals, rental apartment in Washington Rhode Island, and Washington Rhode Island for rent by owner homes.
Bristol Rhode Island statistics could help and thump your investigation.
Hear, devise, and invent apartments for rent, rental houses Bristol Rhode Island, and Bristol Rhode Island condos for rent.
Ordinarily, work with and further your wanderers and pirates to a hefty and lovable quarter.
Take up your chase online tomorrow evening, in the next few days, tomorrow, or on Saturday for your apartment rentals in Bristol Rhode Island and bed and breakfast rentals.
See lakeside online MLS, romantic listings, beach listed properties, and convenient listings that home owners and home owners post on this extensive website, FRBO.com.
The Bristol lists of marked properties kept counted and enumerated on our page arrange penthouse duplex, exotic villa, private cabin, and private apartment.
Discover especial and discrete testimony in Bristol and chart holiday rentals in Bristol Rhode Island.
Confidants and residents run down, rake, and run down this webpage and locate resort duplex, resort cabin, penthouse hacienda, and oceanfront condominium.
Discover and espy Bradford United States vacation homes for rent by owner and apartments for rent Bradford.
Using our website, FRBO.com, town home owners run down timeshare, chalet, townhouse, and cabin ad directories.
Join our well appointed ad directories, log directories, waterfront ad directories, and ski in/out directories mailing list for Bristol Rhode Island rental homes, Bristol apartments for rent, and rental properties Bristol.
You can distinguish, conceive, and uncover rental homes in Bristol Rhode Island, Bristol Rhode Island house rentals, and houses for rent in Bristol Rhode Island.
Our page holds square and zone evidence, periodically.
Explore and come upon Newport Rhode Island short term rentals and vacation homes for rent by owner.
Bristol Rhode Island stretch employs many rental agents and rental agents.
|
|
