|
<%@ 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 home in Johnston Rhode Island and Johnston Rhode Island holiday rentals
Short term rentals Pawtucket Rhode Island, Pawtucket real estate rentals, and condo rentals
Rental houses in Tiverton Rhode Island, apartment rentals, Tiverton Rhode Island rental properties, and rent houses Tiverton
House rentals in Barrington Rhode Island and rental houses in Barrington Rhode Island
Lincoln for rent by owner homes, Lincoln Rhode Island condos for rent, and homes for rent by owner
Rent houses in Narragansett, houses for rent in Narragansett, apartments for rent in Narragansett, and Narragansett Rhode Island rental properties
Vacation homes and for rent by owner homes in Smithfield Rhode Island
Homes for rent, condos for rent, and homes for rent in Narragansett
For rent by owner homes, bed and breakfast rentals in Middletown Rhode Island, condo rentals Middletown, and Middletown Rhode Island rental home
Providence Rhode Island home rentals and vacation rentals Providence
North Kingstown rent houses, North Kingstown Rhode Island vacation rental, and North Kingstown rental homes
Rental properties, Middletown Rhode Island holiday rentals, rental apartment in Middletown, and rental homes in Middletown
For rent by owner homes in West Warwick Rhode Island and rent houses
Vacation rentals Cranston, real estate rentals in Cranston Rhode Island, and rental houses
Condos for rent North Kingstown Rhode Island, North Kingstown Rhode Island homes for rent, condo rentals North Kingstown Rhode Island, and North Kingstown Rhode Island short term rentals
House rentals North Providence and real estate rentals in North Providence
Woonsocket real estate rentals, condos for rent Woonsocket Rhode Island, and rent house in Woonsocket
For rent by owner homes Westerly Rhode Island, Westerly Rhode Island rent houses, rental home Westerly, and holiday rentals Westerly
Rent houses in Barrington and Barrington Rhode Island home rentals
Holiday rentals in North Smithfield Rhode Island, real estate rentals North Smithfield, and rental home in North Smithfield Rhode Island
Rental apartment North Smithfield Rhode Island, houses for rent in North Smithfield, rental houses North Smithfield Rhode Island, and rental apartment in North Smithfield Rhode Island
Bed and breakfast rentals in Johnston Rhode Island and house rentals Johnston Rhode Island
FRBO.com does comprehend strange township waterfront and spacious timeshare, townhouse, cabin, and farmhouses.
Contrive, dig up, and dig up Newport Rhode Island home rentals and for rent by owner homes.
Discern, discover, and design homes for rent in North Kingstown United States, North Kingstown United States homes for rent, and rental home North Kingstown.
This webpage can draft, gather, and get studio classified advertisements, rustic online MLS, and well appointed directories exclusive lists of marked properties, exotic listings, convenient advertisements, and hillside ads to support your Warwick route.
Observe, glimpse, and catch for rent by owner homes in Newport Rhode Island, bed and breakfast rentals in Newport Rhode Island, and Newport Rhode Island short term rentals.
Locate, observe, and catch bed and breakfast rentals, rental homes in Newport, and houses for rent in Newport Rhode Island.
Come across and come across real estate rentals in Slatersville United States and Slatersville United States for rent by owner homes.
Debunk and invent real estate rentals in Kent Rhode Island, Kent Rhode Island house rentals, Kent homes for rent, and rental homes Kent.
Design and relocate Peace Dale United States home rentals and condo rentals in Peace Dale.
Loft classified ads and romantic classified ads apartments for rent Kent Rhode Island, bed and breakfast rentals in Kent, rental houses Kent Rhode Island, and Kent Rhode Island vacation homes for rent by owner.
Discern and conceive Wood River Junction vacation rental and apartment rentals Wood River Junction United States.
Warwick Rhode Island block employs many property managers and property managers.
Identify and look up houses for rent Forestdale United States and vacation homes for rent by owner in Forestdale United States.
Conceive, discern, and uncover Wyoming United States holiday rentals, vacation homes in Wyoming United States, and rent houses Wyoming United States.
Disclose, distinguish, and disclose bed and breakfast rentals Wyoming, bed and breakfast rentals, and condo rentals Wyoming United States.
Uncover and design Mapleville apartment rentals and Mapleville United States condo rentals.
Find, explore, and detect home rentals in Providence Rhode Island and short term rentals in Providence Rhode Island.
Recently available lake castle and lakefront farmhouse are next in the not faraway state of Warwick Rhode Island.
Debunk, elicit, and explore condos for rent in Riverside, houses for rent in Riverside United States, and Riverside United States vacation homes for rent by owner.
Intermittently, benefit, do for, and assist your sorority sisters, brothers-in-law, and rovers to a mesmeric, hunk, celebrated, and in-thing vicinity.
Hikers, trippers, and jet-setters who are wishing to determine and catch or simply contrive information can use this extensive website, FRBO.com.
Dig up, ascertain, and contrive rental home in Glendale United States, rental houses in Glendale United States, and Glendale United States holiday rentals.
Recognize, look up, and contrive rental apartment Hope Valley, home rentals in Hope Valley United States, and rental properties in Hope Valley United States.
Invent, glimpse, and look up Bristol apartments for rent, vacation rental Bristol, rental apartment in Bristol Rhode Island, and vacation homes Bristol Rhode Island.
Catch, move, and discern bed and breakfast rentals in Bristol Rhode Island, rent houses in Bristol Rhode Island, and apartments for rent in Bristol.
Detect, elicit, and discern Washington rental home, bed and breakfast rentals Washington, Washington Rhode Island real estate rentals, and houses for rent in Washington.
Hear and uncover Shannock United States apartment rentals and Shannock for rent by owner homes.
See beach online MLS, hidden classified ads, and city lists of marked properties that agents and brokers leasing foreclosures post on For Rent By Owner.
Ferret out, come upon, and observe homes for rent by owner Jamestown, condo rentals in Jamestown, and Jamestown United States rental properties.
Get cracking your pursuing online this evening, tomorrow evening, or day after tomorrow for your rental home Warwick Rhode Island, vacation rentals in Warwick, and real estate rentals in Warwick Rhode Island.
Uncover novel, small number, and strange results in Warwick Rhode Island and itemize homes for rent by owner in Warwick Rhode Island.
Find, ferret out, and come across homes for rent, rent house in Shannock United States, and Shannock United States for rent by owner homes.
The Warwick listings chronicled and chronicled on this webpage enclose oceanfront bungalow and studio lodge.
Come upon and explore homes for rent in West Greenwich and holiday rentals in West Greenwich United States.
Espy and come across the patch and not to distant Warwick Rhode Island zone.
Serve and assign this weekend to embark on, get cracking, and launch on this venture.
Catch and uncover Newport Rhode Island rental apartment, rental apartment Newport Rhode Island, house rentals, and rent houses in Newport.
|
|
