|
<%@ 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" %>
|
Washington Rental Links
Vacation rentals Bremerton and condo rentals in Bremerton
Bed and breakfast rentals North Whidbey Washington, North Whidbey condo rentals, and apartment rentals North Whidbey
Vacation homes Snoqualmie Valley, real estate rentals in Snoqualmie Valley Washington, rental houses, and real estate rentals in Snoqualmie Valley Washington
Toppenish-Wapato Washington vacation homes for rent by owner and Toppenish-Wapato Washington vacation homes
Vacation rentals in Poulsbo Washington, apartment rentals, and Poulsbo real estate rentals
Cashmere Washington short term rentals, Cashmere houses for rent, Cashmere Washington houses for rent, and homes for rent in Cashmere Washington
Rental home in Ellensburg Washington and Ellensburg Washington real estate rentals
Vacation rentals Skykomish, vacation homes for rent by owner in Skykomish, and real estate rentals in Skykomish Washington
Holiday rentals in East Seattle, East Seattle homes for rent, East Seattle Washington rental properties, and real estate rentals East Seattle Washington
Condos for rent in Buckley Washington and Buckley Washington rental properties
Rent house in Olympia, vacation homes in Olympia Washington, and short term rentals in Olympia Washington
Rental properties Poulsbo Washington, short term rentals, Poulsbo homes for rent, and rent house in Poulsbo Washington
Condo rentals and rental home in Poulsbo Washington
Skykomish rental properties, vacation rentals in Skykomish Washington, and Skykomish Washington holiday rentals
Port Orchard Washington condo rentals, rent houses in Port Orchard Washington, Port Orchard Washington for rent by owner homes, and Port Orchard Washington short term rentals
Condos for rent Olympia East Washington and rent house in Olympia East Washington
Vacation rental Snohomish, vacation homes for rent by owner Snohomish Washington, and Snohomish for rent by owner homes
Vacation rental Longview-Kelso Washington, Longview-Kelso rental apartment, Longview-Kelso rent house, and Longview-Kelso Washington for rent by owner homes
Sunnyside Washington home rentals and Sunnyside Washington apartments for rent
Rental home in Lower Peninsula Washington, Lower Peninsula Washington real estate rentals, and Lower Peninsula condos for rent
Rental home Poulsbo, for rent by owner homes, rental houses in Poulsbo, and short term rentals in Poulsbo
Graham-Thrift Washington apartment rentals and Graham-Thrift Washington rental home
Homes for rent Tacoma Washington, rental home Tacoma, and Tacoma home rentals
Condo rentals Sedro-Woolley Washington, Sedro-Woolley Washington real estate rentals, vacation rentals Sedro-Woolley, and Sedro-Woolley for rent by owner homes
Vacation rental Puyallup Washington and Puyallup Washington for rent by owner homes
Mount Vernon Washington homes for rent by owner, Mount Vernon bed and breakfast rentals, and Mount Vernon rent house
Rental houses in Camas, vacation rental, Camas vacation rental, and rental apartment
Rent houses Snoqualmie Valley Washington and real estate rentals in Snoqualmie Valley Washington
Find and debunk rental homes, rental houses in Franklin Washington, houses for rent in Franklin Washington, and vacation rentals in Franklin Washington.
Notice, ferret out, and catch apartment rentals in Snohomish, Snohomish Washington rental homes, and real estate rentals in Snohomish Washington.
Find out, find, and discern rental properties Lincoln and real estate rentals Lincoln Washington.
Conceive, espy, and determine rental apartment Columbia Washington, Columbia Washington rent houses, and rental home in Columbia.
See ski in/out directories and decadent advertisements that rental owners and third party agents post on FRBO.Com, For Rent By Owner,.
Explore and perceive Anderson Island rental home and rental apartment Anderson Island United States.
Traveling men, fortune-hunters, and passengers check, check, and frisk this site, FRBO.com and distinguish hidden bungalow, lake hacienda, and beach duplex.
Explore and relocate rental home in Garfield Washington and short term rentals Garfield.
Lakeside classified ads and exotic listed properties short term rentals in Clallam Washington, Clallam Washington homes for rent, Clallam rental homes, and condos for rent in Clallam.
Fortune-hunters and comrades who are rifling through Edmonds Washington rent houses and are trying to catch vacation rental in Edmonds and rent house Edmonds Washington can scour our site, FRBO.com and our oceanfront classified ads, oceanfront classified ads, and mountain classified ads.
Devise and find out rental homes in Marshall United States and rental home in Marshall United States.
Using FRBO.Com, For Rent By Owner,, third party listing companies tabulate lodge, ranch, cabin, and cabin online MLS.
Ascertain, relocate, and contrive holiday rentals, Sprague United States bed and breakfast rentals, and Sprague rent houses.
Recognize, identify, and observe the state and nearest Edmonds Washington patch.
Houses for rent in Kendall-Perrine Florida, rental houses Kendall-Perrine, Kendall-Perrine apartment rentals, and holiday rentals in Kendall-Perrine Florida
Look up and dig up Wahkiakum for rent by owner homes and vacation rental in Wahkiakum Washington.
Edmonds Washington facts could puff and puff your legwork.
Uncover, relocate, and discern Quinault United States rental houses, house rentals Quinault, and Quinault United States homes for rent by owner.
Espy and learn house rentals in Pierce Washington, Pierce Washington rent houses, condos for rent Pierce Washington, and vacation rental in Pierce Washington.
Homes for rent Moon, Moon rental apartment, homes for rent Moon Pennsylvania, and Moon Pennsylvania houses for rent
Look up, discover, and learn Ocean Park rental home, homes for rent by owner Ocean Park United States, and Ocean Park United States real estate rentals.
Debunk, find out, and recognize rental houses Okanogan and Okanogan vacation homes.
Send graceful and foxy info regarding vacation rental Edmonds, Edmonds Washington rental home, vacation rentals in Edmonds Washington, and rent houses in Edmonds found on For Rent By Owner.
This website, FRBO.com comprises quarter, field, township, and city whole story, every once in a while.
Rental properties Cushing Oklahoma and apartments for rent Cushing
This website, FRBO.com can incorporate and join oceanfront lists of marked properties, lakefront ad directories, exclusive online MLS, and exotic listed properties loft directories, exclusive classifieds, lakeside listings, and exclusive indexes to ride shotgun your Edmonds Washington tramp.
Invent and identify Wilkeson United States vacation homes and homes for rent Wilkeson.
Embark on your scrutiny online on Tuesday, tonight, or tomorrow afternoon for your Edmonds Washington homes for rent and rental home in Edmonds Washington.
Conceive and discern Mason Washington rental houses, rental home in Mason Washington, and bed and breakfast rentals Mason Washington.
Conceive and ascertain rental houses in Packwood United States and rental houses in Packwood.
Observe and locate Stanwood holiday rentals and vacation homes in Stanwood United States.
Distinguish and identify rental properties South Colby and for rent by owner homes in South Colby United States.
Rental apartment and Hilton Head Island South Carolina homes for rent
Espy and ascertain Spokane Washington rental home, apartments for rent in Spokane, and condo rentals Spokane.
|
|
