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 = 2947 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 2947 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 2947 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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;

242 Little Rock Creek Rd
Cook, WA 98605
Denise McCravey with Gorge Property Real Estate, original listing - (800) 387-6703

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2408 Square Feet
Agency: Gorge Property Real Estate
Agency Phone: (800) 387-6703

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Enjoy listening to Little Rock Creek from every room in this home. The year-round creek flows all seasons and can be seen from many windows of the house. Imagine morning coffee with windows open listening to the water flow. This Northwest contemporary home is custom built with attention to detail. A curved driveway leads you into a private forested setting to the front door. The entry, powder room, kitchen and laundry room have tile floors. White Oak wood floors are in the main room with generous skylights and a fireplace. Custom book cases flank the fireplace. The sun room has sliding glass doors with full views and sounds of Little Rock Creek. The kitchen and dining room face the creek with doors leading to a deck for outdoor dining and a hot tub. There is a lovely forested hill on the other side of the creek that gives a lush background of Fir, Cedar and Maple trees surrounding you with privacy. The primary suite on the main floor has a fireplace and windows facing the creek. The updated bathroom has a tile floor and shower. From the master is a door to a large office with built-in desk. The office has an exterior entry to a walkway from the garage or to the creek. A large laundry/mud room has plenty of room for coats and boots with an entry from the three car over sized garage. Upstairs there are two bedrooms and a bath with a tub/shower combo. One bedroom has a fireplace, bookshelves and a Murphy bed. Large closets are in each bedroom.Distances...22 minutes to White Salmon 25 minutes to Hood River25 minutes to Stevenson, WA 58 minutes to Washougal
MlsNumber: --
ListingId: 24508178


Listing Provided By: Gorge Property Real Estate, original listing
Phone: (800) 387-6703
Office Phone: (800) 387-6703
Agent Name: Denise McCravey
Disclaimer: Copyright © 2024 Regional Multiple Listing Services. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App