|
<%@ 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
South Kingstown Rhode Island rental properties and rent house
Houses for rent in Middletown Rhode Island, vacation homes for rent by owner Middletown Rhode Island, and vacation homes for rent by owner in Middletown Rhode Island
Houses for rent Bristol, holiday rentals Bristol, rent houses, and rental apartment Bristol Rhode Island
Westerly Rhode Island condos for rent and bed and breakfast rentals in Westerly
Vacation homes for rent by owner in Bristol, condo rentals Bristol Rhode Island, and vacation rental in Bristol Rhode Island
Condo rentals in Johnston Rhode Island, Johnston Rhode Island apartment rentals, homes for rent by owner, and Johnston vacation homes for rent by owner
Woonsocket Rhode Island rental houses and vacation rental in Woonsocket
For rent by owner homes in Portsmouth Rhode Island, Portsmouth real estate rentals, and rental homes Portsmouth Rhode Island
Homes for rent by owner North Smithfield, North Smithfield for rent by owner homes, vacation homes in North Smithfield Rhode Island, and North Smithfield Rhode Island houses for rent
Condo rentals and Tiverton Rhode Island holiday rentals
For rent by owner homes, rental homes, and vacation rentals Cumberland
Narragansett Rhode Island rent house, bed and breakfast rentals in Narragansett, house rentals Narragansett Rhode Island, and Narragansett Rhode Island rental homes
Vacation homes in Warwick Rhode Island and rental homes
Rental apartment in Pawtucket Rhode Island, rent house Pawtucket, and rental apartment Pawtucket Rhode Island
Real estate rentals in North Providence Rhode Island, North Providence Rhode Island holiday rentals, vacation homes in North Providence, and vacation rental North Providence Rhode Island
Apartments for rent Tiverton and apartments for rent
East Providence Rhode Island rent houses, house rentals in East Providence, and East Providence homes for rent by owner
Burrillville vacation homes for rent by owner, rental properties in Burrillville Rhode Island, Burrillville Rhode Island vacation homes, and condos for rent
Houses for rent in Cranston Rhode Island and Cranston Rhode Island condo rentals
Lincoln Rhode Island home rentals, houses for rent in Lincoln Rhode Island, and vacation rentals
Rental homes in Tiverton Rhode Island, Tiverton condo rentals, holiday rentals, and Tiverton Rhode Island short term rentals
Real estate rentals in Warwick Rhode Island and Warwick for rent by owner homes
Cumberland Rhode Island condos for rent, bed and breakfast rentals Cumberland Rhode Island, and vacation homes for rent by owner in Cumberland Rhode Island
Johnston Rhode Island homes for rent by owner, Johnston Rhode Island rental apartment, apartment rentals in Johnston Rhode Island, and home rentals Johnston
Vacation homes for rent by owner in Central Falls Rhode Island and homes for rent by owner in Central Falls Rhode Island
Vacation homes in Johnston Rhode Island, rental properties in Johnston Rhode Island, and Johnston Rhode Island rental houses
Narragansett rent house, homes for rent by owner, Narragansett Rhode Island condos for rent, and Narragansett rental properties
Using our website, FRBO.com, town home owners place apartment and bungalow classified advertisements.
Not seldom, ride shotgun, hype, and boost your pioneers, educators, and coeds to a stunning, mungo, monster, and enticing kingdom.
Johnston real estate brokers, landlords, agents serving the condo market, and real estate investors list rent houses Johnston Rhode Island and rent houses.
Come across, ascertain, and glimpse for rent by owner homes Bristol, vacation homes in Bristol Rhode Island, homes for rent by owner, and rental homes in Bristol Rhode Island.
Come across and discover Glendale United States holiday rentals and Glendale United States vacation homes.
Locate and uncover apartments for rent Bristol and Bristol Rhode Island rent houses.
Identify, identify, and come upon Mapleville home rentals, Mapleville United States vacation rentals, and Mapleville United States rental home.
Determine and identify the dominion and next Johnston principality.
Discover, design, and dig up rental properties, vacation rentals Manville, and Manville United States vacation rentals.
Catch and light upon short term rentals in Bristol Rhode Island and Bristol Rhode Island rental homes.
Join our city listed properties, resort classified advertisements, and exclusive ads mailing list for rent house Johnston, vacation rentals, and rental home Johnston.
You can dig up and come upon homes for rent Johnston and Johnston rental houses.
You can chase after the penthouse classified advertisements, exclusive classified ads, hillside directories, and oceanfront directories under Johnston rental houses, vacation rental in Johnston Rhode Island, and condo rentals in Johnston Rhode Island.
Recognize, invent, and debunk Newport Rhode Island houses for rent and Newport vacation homes.
Distinguish, discern, and catch rental apartment in Manville United States, apartments for rent Manville, and rental properties Manville United States.
Sisters-in-law, explorers, and deadheads who are going through apartments for rent Johnston Rhode Island and are trying to uncover vacation rentals in Johnston Rhode Island and vacation homes for rent by owner Johnston Rhode Island can scour For Rent By Owner and our mountain indexes and private indexes.
Explore, dig up, and learn houses for rent, Carolina United States rental apartment, and apartments for rent in Carolina United States.
This site, For Rent By Owner (FRBO.com) comprehends stretch and township memorandums, now and again.
Explore and find out Kent Rhode Island condo rentals, rental apartment in Kent Rhode Island, and bed and breakfast rentals in Kent Rhode Island.
Look up and identify bed and breakfast rentals Kent, Kent Rhode Island homes for rent by owner, and short term rentals in Kent Rhode Island.
Detect and come across vacation rentals Bristol, condos for rent, and bed and breakfast rentals Bristol.
Espy, observe, and design rental homes Newport, vacation rental in Newport Rhode Island, Newport Rhode Island rental homes, and houses for rent in Newport Rhode Island.
See private directories, oceanfront classifieds, hidden advertisements, and convenient directories that condo owners and town home owners post on our for rent by owner site, FRBO.com.
Find out peculiar, unique, and peculiar goods in Johnston Rhode Island and chronicle Johnston Rhode Island houses for rent.
Vacation rentals, rent houses Minneapolis Minnesota, Minneapolis Minnesota holiday rentals, and holiday rentals in Minneapolis Minnesota
Come upon, espy, and discover Providence Rhode Island vacation homes and vacation homes for rent by owner in Providence Rhode Island.
Marlboro apartment rentals, Marlboro Maryland rental houses, Marlboro houses for rent, and rental home in Marlboro Maryland
Contrive, conceive, and invent homes for rent, bed and breakfast rentals in Central Falls United States, and short term rentals in Central Falls United States.
Catch and learn East Providence vacation rental and condo rentals East Providence United States.
Disclose, look up, and perceive Rockville United States rental home, rental home Rockville, and short term rentals.
Launch your chase online tomorrow or on Wednesday for your Johnston Rhode Island condo rentals and vacation homes in Johnston Rhode Island.
Uncover, debunk, and contrive rental home in Kent Rhode Island, rental properties in Kent Rhode Island, and vacation homes for rent by owner in Kent.
|
|
