Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 92 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 92 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 92 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1027 Kuehne Rd
Keller, AK 99740
Paul Valentine with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: --
Baths: --
Status: Active
SqFt: 4640 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 247 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Opportunity knocks on this large Columbia River waterfront property! 247 acres in 4 parcels with amazing views of the Columbia River and Sanpoil River confluence. Enjoy the peace and quiet while watching the Keller ferry crossing the Columbia River right from your front porch. Large 4640 sq ft home is solid but needs some TLC. Bring your tool belt and turn this property into your private oasis. Kuehne Rd dead ends at the propertyThe ancient geologic landscape of the upper Columbia River cradles Lake Roosevelt in walls of stone carved by massive ice age floods. Come explore the shorelines and learn the stories of American Indians, traders and trappers, settlers and dam builders who called this place home. Swim, boat, hike, camp, and fish at this hidden gem in Northeast Washington, created by the Grand Coulee Dam. Lake Roosevelt sees dramatic changes in weather throughout the year. In the summer months, temperatures can range from 75ºF to 113ºF during the day, and from 50ºF to 80ºF at night. Spring and fall serve as the transitional periods between hot and cold. Winter sees light to heavy snowfall in all districts and can severly impact roads and access to certain parts of the lake. In addition, the northern reaches of the lake are cooler and wetter, while the southern portion is hotter and drier. The weather combined with lake level changes produces a variety of beautiful landscapes year round. Grand Coulee Dam was the key to the development of power on the Columbia River - the greatest potential source of hydroelectric energy in the United States. Original plans considered ten dams on the Columbia River between the Canadian border and the mouth of the river. Grand Coulee Dam forms Lake Roosevelt, extending 151 miles upstream to the Canadian border. It has a 600-mile shoreline and a surface area of 82,000 acres. In 1948, Congress designatedLake Roosevelt National Recreation Area, which is operated by the National Park Service. Grand Coulee Dam provides water to irrigate approximately 600,000 acres in theColumbia Basin Project. In addition to its irrigation and power functions, Grand Coulee Dam is a primary factor in controlling the floods on the Columbia River. Lake Roosevelt, also known as Lake Franklin D. Roosevelt, is located in the state of Washington in the United States. It is a large reservoir that was created by the construction of the Grand Coulee Dam on the Columbia River. The lake stretches from the Canada-U.S. border to just above the town of Coulee City. It offers ample opportunities for visitors to explore its serene waters, including hiking, fishing, boating, and more.
MlsNumber: --
ListingId: 11333824


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (360) 239-1994
Office Phone: (970) 674-1990
Agent Name: Paul Valentine
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 92 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App