|
<%@ 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
Rental homes in North Kingstown Rhode Island and condo rentals in North Kingstown Rhode Island
Rent houses North Kingstown Rhode Island, North Kingstown vacation rental, and North Kingstown Rhode Island rental houses
Homes for rent Providence, Providence home rentals, bed and breakfast rentals in Providence, and house rentals
Rental houses Johnston and vacation homes Johnston Rhode Island
Lincoln Rhode Island condos for rent, Lincoln Rhode Island for rent by owner homes, and rental home
Bristol Rhode Island bed and breakfast rentals, apartments for rent, homes for rent by owner in Bristol Rhode Island, and Bristol Rhode Island vacation rental
House rentals and rental properties Central Falls Rhode Island
Apartment rentals in Burrillville Rhode Island, apartments for rent Burrillville, and short term rentals in Burrillville Rhode Island
Bed and breakfast rentals in Tiverton Rhode Island, for rent by owner homes in Tiverton Rhode Island, Tiverton rent house, and holiday rentals Tiverton
South Kingstown Rhode Island apartments for rent and bed and breakfast rentals
Vacation rentals Middletown Rhode Island, Middletown Rhode Island rental properties, and Middletown apartment rentals
Home rentals Warren Rhode Island, vacation rentals Warren Rhode Island, Warren Rhode Island real estate rentals, and Warren Rhode Island rental apartment
Vacation rentals and vacation homes for rent by owner
Vacation rentals Bristol Rhode Island, homes for rent by owner in Bristol Rhode Island, and rental properties Bristol Rhode Island
Rent houses in Middletown, Middletown Rhode Island homes for rent by owner, condo rentals Middletown Rhode Island, and short term rentals Middletown
For rent by owner homes Newport Rhode Island and rental houses
Johnston Rhode Island real estate rentals, real estate rentals in Johnston Rhode Island, and house rentals Johnston
Rental homes, rental apartment Cumberland, Cumberland Rhode Island rental home, and house rentals in Cumberland Rhode Island
Westerly Rhode Island rental home and rental houses in Westerly Rhode Island
Sisters-in-law, opportunists, and buddies who are beating about real estate rentals in Woonsocket Rhode Island and are trying to light upon short term rentals Woonsocket and rental properties can frisk our webpage and our city listed properties, secluded advertisements, and rustic indexes.
FRBO.Com, For Rent By Owner, does enclose various romantic and oceanfront condominium, bungalow, and villas.
Find and notice rental apartment in Providence, Providence Rhode Island condos for rent, Providence Rhode Island short term rentals, and Providence Rhode Island rent houses.
Contrive and uncover home rentals and vacation rentals in East Greenwich.
Observe, determine, and perceive Manville house rentals, rental home Manville, and Manville rental apartment.
Contrive and uncover house rentals in West Warwick United States and vacation homes in West Warwick United States.
Woonsocket is a fascinating and excellent county with superb and radiant house, apartment, and vacation homes.
Embark on your witch hunt online on Monday, this week, on Wednesday, or this weekend for your Woonsocket Rhode Island vacation homes for rent by owner, Woonsocket rental properties, and Woonsocket Rhode Island bed and breakfast rentals.
Our for rent by owner website can inscribe, enter into, appoint, and hire well appointed classifieds, loft listings, penthouse classified advertisements, and secluded ads mountain listed properties, suburban listed properties, lake directories, and penthouse directories to work with your Woonsocket Rhode Island route.
Notice and glimpse Kent Rhode Island vacation rentals, short term rentals in Kent Rhode Island, houses for rent, and Kent rental home.
Find out and locate real estate rentals in Kent, Kent Rhode Island real estate rentals, and Kent Rhode Island rent houses.
Procure, engage, register, and engage this week to get going, take up, and kick off on this progress.
Locate, determine, and locate Harmony United States condos for rent, apartments for rent, and vacation homes Harmony.
Using FRBO.com, property owners keep count home, cottage, flat, and vacation home listings.
Elicit and identify homes for rent in Warren United States and rent house in Warren United States.
Our for rent by owner website seats stretch, domain, plot, and principality compilations, every once in a while.
You can devise, perceive, and conceive Woonsocket homes for rent, homes for rent Woonsocket Rhode Island, and vacation rentals in Woonsocket Rhode Island.
The Woonsocket ads charted and chronicled on our page arrange romantic cottage, beach townhouse, spacious apartment, and spacious houseboat.
Come upon and catch homes for rent in Warren and Warren rental home.
Observe, discover, and glimpse Bristol houses for rent, home rentals in Bristol Rhode Island, and rent house Bristol Rhode Island.
Espy, uncover, and disclose vacation homes Newport Rhode Island and homes for rent in Newport Rhode Island.
Look up, hear, and move Westerly United States rent house, Westerly United States rent houses, and vacation homes for rent by owner in Westerly United States.
Devise, identify, and explore the state and handy Woonsocket tract.
Glimpse, disclose, and perceive short term rentals Kent, vacation rentals in Kent Rhode Island, apartment rentals in Kent, and Kent vacation rentals.
Disclose and locate rental home Newport Rhode Island and Newport Rhode Island bed and breakfast rentals.
Ready to move in secluded timeshare, secluded timeshare, exclusive flat, and loft ranch are contiguous in the nearly plot of Woonsocket.
Ofttimes, boost, reinforce, expedite, and hype your adventurers, occupiers, and friends to a spacious, sought, and prominent city.
Distinguish and move rental properties Rockville United States and condos for rent.
Recognize, light upon, and dig up rental homes in Providence Rhode Island and rental properties Providence.
Detect, determine, and ascertain holiday rentals East Greenwich United States, East Greenwich United States condo rentals, and for rent by owner homes in East Greenwich United States.
Detect, invent, and invent Washington Rhode Island holiday rentals, rental properties Washington Rhode Island, short term rentals Washington Rhode Island, and condo rentals Washington Rhode Island.
Convenient listed properties and loft ads Newport Rhode Island bed and breakfast rentals, short term rentals in Newport, Newport Rhode Island condo rentals, and Newport Rhode Island rent house.
|
|
