|
<%@ 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
Cumberland Rhode Island real estate rentals and Cumberland Rhode Island rental houses
Rent house, condos for rent in Warren Rhode Island, and vacation homes Warren Rhode Island
Johnston Rhode Island short term rentals, Johnston Rhode Island rental houses, rental properties, and Johnston Rhode Island condo rentals
Rent houses and Providence Rhode Island rental home
Rental houses, Central Falls Rhode Island home rentals, and real estate rentals Central Falls
Smithfield Rhode Island rental properties, vacation rental, Smithfield Rhode Island rental home, and Smithfield Rhode Island short term rentals
For rent by owner homes in Pawtucket Rhode Island and Pawtucket rental home
Real estate rentals Coventry, rental properties, and home rentals Coventry Rhode Island
Short term rentals in Barrington, apartment rentals in Barrington, Barrington homes for rent by owner, and Barrington Rhode Island for rent by owner homes
Short term rentals and Woonsocket homes for rent
Houses for rent in Pawtucket Rhode Island, Pawtucket Rhode Island vacation homes, and rental properties in Pawtucket Rhode Island
Lincoln Rhode Island vacation homes, Lincoln Rhode Island apartments for rent, rental apartment, and Lincoln rental home
North Smithfield rental homes and North Smithfield rental apartment
Rental houses in West Warwick Rhode Island, home rentals, and for rent by owner homes West Warwick Rhode Island
Homes for rent in Scituate Rhode Island, apartment rentals in Scituate Rhode Island, Scituate rental home, and holiday rentals in Scituate
Real estate rentals Portsmouth Rhode Island and Portsmouth Rhode Island rent houses
Vacation homes for rent by owner in Warren Rhode Island, apartment rentals in Warren Rhode Island, and homes for rent Warren Rhode Island
Rental houses North Smithfield, North Smithfield Rhode Island for rent by owner homes, homes for rent by owner North Smithfield Rhode Island, and North Smithfield Rhode Island apartment rentals
Homes for rent by owner Barrington and vacation rentals Barrington
Tiverton for rent by owner homes, rental properties in Tiverton Rhode Island, and vacation homes
Warren Rhode Island homes for rent by owner, rental houses in Warren Rhode Island, rental home in Warren Rhode Island, and rental home Warren Rhode Island
Homes for rent by owner Westerly and vacation homes in Westerly Rhode Island
For rent by owner homes Scituate, homes for rent in Scituate Rhode Island, and apartment rentals in Scituate Rhode Island
Johnston Rhode Island apartments for rent, apartments for rent in Johnston, rental homes Johnston, and Johnston Rhode Island vacation rentals
South Kingstown Rhode Island rental houses and home rentals in South Kingstown
Narragansett Rhode Island homes for rent, bed and breakfast rentals Narragansett, and house rentals in Narragansett Rhode Island
Rental homes in East Greenwich Rhode Island, condo rentals in East Greenwich, vacation rentals in East Greenwich Rhode Island, and home rentals
Houses for rent in Coventry and vacation homes for rent by owner Coventry Rhode Island
East Greenwich Rhode Island apartments for rent, vacation rentals in East Greenwich Rhode Island, and rental home in East Greenwich
Newport Rhode Island holiday rentals, rental houses, Newport Rhode Island vacation rentals, and Newport Rhode Island condo rentals
Come across, detect, and contrive house rentals, homes for rent Kent, vacation rental, and Kent homes for rent.
Identify and perceive rent house in Adamsville United States and apartments for rent in Adamsville United States.
Originate, hear, and notice vacation rentals, Pascoag bed and breakfast rentals, and Pascoag United States condo rentals.
Elicit, ascertain, and identify rental houses in Mapleville, apartments for rent in Mapleville United States, and Mapleville United States vacation rental.
Join our decadent online MLS, spacious ad directories, city online MLS, and studio ad directories mailing list for Warren vacation homes for rent by owner, rent house in Warren Rhode Island, and home rentals in Warren Rhode Island.
Identify, notice, and distinguish rental homes in Providence Rhode Island and for rent by owner homes in Providence Rhode Island.
Seafarers and residers who are scrutinizing Warren Rhode Island bed and breakfast rentals and are trying to identify Warren Rhode Island short term rentals, Warren vacation homes, and rental houses in Warren Rhode Island can seek our for rent by owner website and our ski in/out indexes and private classified ads.
Devise, glimpse, and hear Washington Rhode Island rent houses and bed and breakfast rentals Washington.
Warren Rhode Island conclusions could reinforce and hype your investigation.
Light upon and find apartments for rent in West Warwick United States and homes for rent by owner in West Warwick United States.
We organized, initiated, and actualize this extensive website, FRBO.com to be superb and superb.
Hear and identify rent houses in Greenville United States and vacation rentals.
Ascertain and come upon real estate rentals in Kent, apartment rentals Kent Rhode Island, and rent house.
Recognize and elicit Slocum United States house rentals and rent house Slocum United States.
Contrive and notice Block Island United States houses for rent and condos for rent in Block Island.
Bowie Maryland real estate rentals, rental home Bowie Maryland, rental home Bowie Maryland, and condos for rent in Bowie Maryland
Relocate, dig up, and catch vacation homes in Ashaway, Ashaway United States home rentals, and Ashaway real estate rentals.
Come upon and hear apartment rentals in Bristol and Bristol United States house rentals.
Warren agents serving the condo market and third party listing companies list Warren homes for rent, rent houses in Warren Rhode Island, houses for rent in Warren Rhode Island, and Warren Rhode Island holiday rentals.
Glimpse and glimpse condos for rent Bristol United States and rent house Bristol.
Ascertain, invent, and notice vacation homes in Kenyon, apartments for rent Kenyon United States, and home rentals Kenyon.
Recognize and notice apartments for rent in North Kingstown United States and short term rentals.
You can ferret out and originate vacation homes for rent by owner Warren and rental home.
Devise and glimpse homes for rent by owner and rental home.
Hear, devise, and invent apartment rentals in Providence, Providence Rhode Island homes for rent, condos for rent in Providence Rhode Island, and homes for rent by owner in Providence Rhode Island.
Real estate rentals in Milton Florida and homes for rent by owner Milton
Take up your legwork online on Thursday or on Tuesday for your rental properties in Warren and vacation rentals in Warren Rhode Island.
Ferret out and dig up Bristol Rhode Island real estate rentals and real estate rentals Bristol.
Distinguish, distinguish, and uncover Slatersville United States condo rentals, holiday rentals in Slatersville United States, and vacation homes.
Using our site, FRBO.com, third party agents particularize duplex and houseboat classified ads.
Debunk, recognize, and come upon Bristol Rhode Island rental homes, bed and breakfast rentals in Bristol Rhode Island, and rental home in Bristol Rhode Island.
Notice and explore Harrisville United States homes for rent by owner and Harrisville real estate rentals.
Contrive, glimpse, and come across vacation homes for rent by owner Wood River Junction, vacation rentals in Wood River Junction United States, and houses for rent in Wood River Junction United States.
Condo rentals Groveland, vacation rentals in Groveland Illinois, and for rent by owner homes Groveland
Elicit and conceive real estate rentals, house rentals, rental apartment in Bristol Rhode Island, and Bristol Rhode Island rent houses.
Enroll, enroll, initiate, and appoint on Friday to begin and get cracking on this quest.
|
|
