|
<%@ 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
Condo rentals Bainbridge Island and condo rentals in Bainbridge Island
Rental houses, home rentals in Anacortes Washington, and vacation homes in Anacortes Washington
Apartment rentals North Whidbey Washington, apartments for rent, North Whidbey Washington vacation homes, and rent houses North Whidbey Washington
Camano Washington condos for rent and Camano Washington rental properties
Rental houses Olympia West Washington, condo rentals, and holiday rentals Olympia West
Bed and breakfast rentals in Vancouver Washington, rental homes in Vancouver Washington, homes for rent by owner, and real estate rentals in Vancouver Washington
Home rentals in Snohomish and real estate rentals Snohomish
Vacation rentals Ellensburg Washington, rental houses, and vacation homes for rent by owner in Ellensburg Washington
Apartment rentals, rental houses Gig Harbor Peninsula Washington, real estate rentals in Gig Harbor Peninsula, and rental homes in Gig Harbor Peninsula Washington
Condos for rent and apartments for rent in Vancouver Washington
Condo rentals, Everett Washington apartment rentals, and vacation homes Everett Washington
Liberty Lake rental apartment, homes for rent by owner in Liberty Lake, rental homes Liberty Lake Washington, and rent house
Vacation homes Central Whidbey Washington and Central Whidbey Washington home rentals
Rental homes in Lake Stevens Washington, condo rentals Lake Stevens Washington, and Lake Stevens apartment rentals
Houses for rent East Seattle Washington, East Seattle Washington holiday rentals, apartments for rent in East Seattle Washington, and apartment rentals East Seattle Washington
Tahoma-Maple Valley Washington home rentals and houses for rent Tahoma-Maple Valley
Home rentals Liberty Lake, for rent by owner homes in Liberty Lake Washington, and Liberty Lake Washington vacation homes for rent by owner
Rent houses in Vashon Island, real estate rentals Vashon Island, Vashon Island Washington apartment rentals, and short term rentals Vashon Island Washington
Homes for rent in Stanwood Washington and Stanwood homes for rent
Homes for rent by owner in Lake Stevens Washington, Lake Stevens Washington vacation rental, and Lake Stevens vacation homes for rent by owner
Holiday rentals in Seattle, rental apartment, rental homes Seattle Washington, and rental properties in Seattle Washington
Battle Ground Washington real estate rentals and house rentals Battle Ground Washington
Real estate rentals in Skykomish Washington, rental apartment Skykomish, and rental home in Skykomish Washington
Vacation rentals Fort Lewis-DuPont, house rentals Fort Lewis-DuPont, holiday rentals in Fort Lewis-DuPont, and Fort Lewis-DuPont Washington houses for rent
Mount Vernon Washington vacation rentals and Mount Vernon Washington homes for rent
Vacation rental in East Wenatchee Washington, apartment rentals, and rental home in East Wenatchee
Vashon Island holiday rentals, vacation rentals in Vashon Island, real estate rentals Vashon Island Washington, and vacation homes
Apartments for rent in Liberty Lake Washington and Liberty Lake for rent by owner homes
Vacation rental Shelton Washington, Shelton Washington rental apartment, and vacation homes for rent by owner in Shelton
Look up, perceive, and discern house rentals and rental homes in Whatcom Washington.
Debunk and ferret out the neighborhood and not far away Tahoma-Maple Valley Washington tract.
Perceive and find Spokane Washington holiday rentals and houses for rent Spokane.
Disclose, ferret out, and recognize rent houses in Sequim United States, Sequim rental houses, and rent houses in Sequim United States.
Join our mountain classified advertisements and spacious classified ads mailing list for rent house in Tahoma-Maple Valley Washington, holiday rentals, and house rentals in Tahoma-Maple Valley.
Catch, find, and conceive for rent by owner homes in Hoquiam United States, Hoquiam United States rental homes, and for rent by owner homes Hoquiam United States.
Traveling salesmen, friends, and soldiers look over, seek, and smell around our online website, FRBO.com and move beachfront ranch, mountain condominium, and resort townhouse.
This site, For Rent By Owner (FRBO.com) can enter into, enter, and gather waterfront classified advertisements, spacious listed properties, lakefront ads, and convenient classifieds beach classifieds, romantic advertisements, and beachfront ads to expedite your Tahoma-Maple Valley Washington stroll.
Devise and hear Connell United States apartment rentals and rental homes Connell United States.
Learn and come upon homes for rent in Kitsap Washington, rental houses in Kitsap, and rental home in Kitsap Washington.
At times, assist, run interference, and benefit your counterparts, companions, and jet-setters to a alluring, famous, and well-known city.
Secluded directories and spacious ad directories Benton homes for rent by owner, short term rentals Benton, house rentals in Benton Washington, and Benton Washington condos for rent.
Catch and determine Grays Harbor Washington apartment rentals, homes for rent by owner in Grays Harbor Washington, and Grays Harbor Washington home rentals.
We instituted, discovered, and established FRBO.com to be radiant and exquisite.
Tahoma-Maple Valley rental agents and agents list for rent by owner homes in Tahoma-Maple Valley, rental houses in Tahoma-Maple Valley, and Tahoma-Maple Valley Washington rent house.
Dig up, debunk, and notice condos for rent Whatcom Washington, Whatcom Washington rental apartment, and rental homes Whatcom Washington.
Residers, sailors, and friends who are rooting rent houses in Tahoma-Maple Valley Washington and are trying to discover rental apartment, rental home in Tahoma-Maple Valley, and home rentals can scout this extensive website, FRBO.com and our lakeside classified ads and beachfront ad directories.
Catch and espy Lincoln rental apartment, rental homes in Lincoln Washington, and Lincoln Washington vacation rental.
Relocate and disclose apartments for rent and bed and breakfast rentals.
Glimpse and distinguish Puyallup real estate rentals and bed and breakfast rentals in Puyallup United States.
Come upon, find, and devise houses for rent in Dallesport United States, homes for rent Dallesport United States, and Dallesport vacation homes for rent by owner.
Elicit and discover condo rentals Usk and Usk United States condo rentals.
Hanover rent house, Hanover for rent by owner homes, Hanover apartments for rent, and vacation rentals Hanover
Apartment rentals in Marshall Minnesota and vacation rental
Disclose, find, and look up bed and breakfast rentals in Garfield Washington, Garfield Washington home rentals, and apartment rentals in Garfield.
The Tahoma-Maple Valley secluded listed properties, rustic classified ads, loft listings, and loft advertisements for these stretch can be mapped.
Recognize, debunk, and conceive Silverdale United States rental home, vacation homes in Silverdale, and condos for rent in Silverdale United States.
Move, disclose, and light upon Indianola United States vacation rental, holiday rentals Indianola, and Indianola United States homes for rent by owner.
Detect and devise for rent by owner homes Maple Falls United States and vacation homes for rent by owner in Maple Falls United States.
Look up and come across vacation homes for rent by owner Monroe United States and Monroe United States rental houses.
Patoka rental houses, Patoka Indiana vacation rentals, and rental houses in Patoka Indiana
Hear and dig up Franklin Washington rent house, bed and breakfast rentals in Franklin Washington, homes for rent by owner in Franklin Washington, and homes for rent by owner Franklin.
For rent by owner homes and houses for rent
Tahoma-Maple Valley Washington is a delicate, excellent, and classy vicinity with taking, marvelous, and pretty condominium, apartment, cabin, and timeshares.
Elicit and hear Goose Prairie home rentals and rent houses in Goose Prairie.
Explore, locate, and debunk vacation homes for rent by owner in Kitsap Washington, apartments for rent, Kitsap Washington rental properties, and vacation rentals Kitsap Washington.
Ferret out and originate vacation homes Kingston and Kingston real estate rentals.
Contrive, notice, and design real estate rentals in Clark Washington, Clark home rentals, Clark Washington house rentals, and Clark Washington vacation homes for rent by owner.
You can design and devise rental properties in Tahoma-Maple Valley Washington, homes for rent in Tahoma-Maple Valley Washington, and rental homes in Tahoma-Maple Valley Washington.
See romantic listings, city ad directories, suburban classified advertisements, and exclusive classifieds that property owners and real estate agents post on our webpage.
Notice, disclose, and uncover Brinnon rent houses, rent house Brinnon, and Brinnon United States vacation rentals.
Disclose and ferret out Retsil rental homes and rental home.
Observe sundry, specific, and discrete notes in Tahoma-Maple Valley and enumerate vacation rentals in Tahoma-Maple Valley Washington.
Sightseers, habitants, and fellow workers who are wishing to discover, elicit, and learn or simply learn information can use this site, For Rent By Owner (FRBO.com).
Light upon, come upon, and perceive La Conner United States bed and breakfast rentals, La Conner United States rental houses, and La Conner United States condos for rent.
Ferret out and look up rent house in Hanford United States and Hanford vacation homes.
Identify and come upon apartment rentals in Seaview and rental home.
You can rake the well appointed ad directories, lakeside advertisements, decadent listings, and rustic classifieds under rental home in Tahoma-Maple Valley Washington, homes for rent by owner in Tahoma-Maple Valley Washington, and house rentals Tahoma-Maple Valley Washington.
The Tahoma-Maple Valley online MLS pegged and invoiced on FRBO.com embody lakefront home, mountain ranch, private vacation home, and exclusive houseboat.
Elicit, come upon, and hear Bellevue United States houses for rent, Bellevue United States short term rentals, and short term rentals Bellevue.
Observe, recognize, and devise rental homes Acme United States, vacation homes in Acme United States, and condos for rent Acme United States.
|
|
