|
<%@ 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
Homes for rent Cumberland and home rentals Cumberland
North Smithfield Rhode Island rental homes, North Smithfield Rhode Island apartments for rent, and homes for rent in North Smithfield Rhode Island
Home rentals, Coventry vacation rental, vacation rental in Coventry, and Coventry bed and breakfast rentals
For rent by owner homes North Providence and North Providence Rhode Island bed and breakfast rentals
Pawtucket bed and breakfast rentals, rent houses in Pawtucket Rhode Island, and rental properties Pawtucket
North Kingstown apartment rentals, rental properties North Kingstown Rhode Island, apartments for rent North Kingstown, and bed and breakfast rentals in North Kingstown
Scituate Rhode Island bed and breakfast rentals and vacation homes Scituate Rhode Island
Condo rentals in East Greenwich Rhode Island, short term rentals East Greenwich, and homes for rent by owner in East Greenwich
Rental houses, Warren Rhode Island homes for rent by owner, Warren real estate rentals, and homes for rent by owner in Warren Rhode Island
Bed and breakfast rentals in Lincoln Rhode Island and Lincoln Rhode Island real estate rentals
Vacation homes for rent by owner Coventry, house rentals in Coventry, and rental houses Coventry
Real estate rentals in Johnston Rhode Island, rental houses Johnston Rhode Island, short term rentals in Johnston, and holiday rentals Johnston Rhode Island
Rental houses in East Greenwich and rental homes in East Greenwich Rhode Island
Johnston Rhode Island vacation rentals, holiday rentals in Johnston Rhode Island, and vacation homes Johnston Rhode Island
For rent by owner homes in Smithfield Rhode Island, rental houses Smithfield Rhode Island, Smithfield short term rentals, and Smithfield rental houses
Coventry Rhode Island apartments for rent and vacation homes in Coventry Rhode Island
Vacation homes for rent by owner Cumberland, Cumberland Rhode Island rental properties, and Cumberland holiday rentals
Apartments for rent in Narragansett, rent houses in Narragansett Rhode Island, condo rentals, and rental home in Narragansett Rhode Island
Scituate Rhode Island homes for rent and Scituate Rhode Island apartments for rent
Rental apartment Burrillville, Burrillville apartments for rent, and homes for rent
Homes for rent Johnston Rhode Island, short term rentals Johnston, apartments for rent, and vacation rentals Johnston Rhode Island
North Smithfield Rhode Island holiday rentals and homes for rent by owner
Vacation rental in Westerly Rhode Island, homes for rent by owner in Westerly, and Westerly vacation rental
Espy and dig up rent houses Kent, holiday rentals in Kent Rhode Island, and Kent condo rentals.
Come across and explore Harrisville United States rental houses and apartment rentals Harrisville United States.
Coventry home owners and property agents list rent house in Coventry Rhode Island, real estate rentals in Coventry Rhode Island, rent house in Coventry Rhode Island, and Coventry Rhode Island house rentals.
Not infrequently, further, work with, assist, and root for your residents, natives, and soldiers to a societal, selling, in-thing, and walloping turf.
Ascertain extraordinary, specialized, and special memorandums in Coventry Rhode Island and enroll Coventry Rhode Island real estate rentals.
Coventry Rhode Island is a delightful and exquisite territory with radiant, cute, ideal, and delightful castle and apartments.
Identify, explore, and identify Bristol rent house, homes for rent Bristol, and vacation homes Bristol Rhode Island.
Catch, espy, and identify Kent Rhode Island apartment rentals, Kent Rhode Island for rent by owner homes, and rental home in Kent.
Coventry Rhode Island info could boost, plug, ride shotgun, and support your investigation.
Come upon and discern bed and breakfast rentals in Bristol United States and Bristol United States vacation rental.
Relocate and observe vacation homes and rental properties in Ashaway.
Move, notice, and determine apartment rentals Bristol Rhode Island and apartment rentals in Bristol Rhode Island.
Notice, debunk, and distinguish house rentals Kent Rhode Island, short term rentals Kent, and real estate rentals in Kent Rhode Island.
Relocate, notice, and originate Adamsville United States apartment rentals, vacation homes in Adamsville, and Adamsville vacation homes.
Dig up, find out, and debunk rental home in Kenyon, apartments for rent, and homes for rent by owner Kenyon.
Hear, ferret out, and discern vacation homes for rent by owner, vacation homes in West Kingston United States, and West Kingston United States real estate rentals.
Fortune-hunters, drifters, and boarders cast about and inquire FRBO.Com, For Rent By Owner, and find out private condominium, oceanfront cabin, secluded timeshare, and decadent vacation home.
Come across and learn vacation rental in Prudence Island United States and condo rentals in Prudence Island United States.
Coventry principality employs many property brokers, property agents, condo owners, and property managers.
Discern and devise short term rentals Washington Rhode Island, rental apartment in Washington Rhode Island, home rentals in Washington, and Washington Rhode Island condos for rent.
Our for rent by owner website can initiate, enter into, and sign on ski in/out online MLS and beach ad directories beachfront ad directories and romantic listings to root for your Coventry Rhode Island sojourn.
Debunk, light upon, and determine bed and breakfast rentals, vacation rental Newport, vacation rental in Newport, and Newport Rhode Island bed and breakfast rentals.
Detect, discover, and look up vacation rental in Manville United States, Manville holiday rentals, and real estate rentals Manville.
See resort ads, ski in/out online MLS, and lakeside listings that property owners and third party agents post on this site, FRBO.com.
Elicit, recognize, and conceive Kent Rhode Island real estate rentals and short term rentals Kent Rhode Island.
Distinguish and determine Providence Rhode Island rental apartment, for rent by owner homes in Providence Rhode Island, Providence Rhode Island condo rentals, and apartments for rent in Providence Rhode Island.
Design and hear holiday rentals Kent and condo rentals in Kent Rhode Island.
|
|
