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

280 Santiam Av
Detroit, OR 97342

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,950,000
Beds: 3
Baths: 3
Status: Active
SqFt: 4569
Agency: LUXE CHRISTIE'S INTERNATIONAL REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1992
Notes: There is a place that exists at the intersection of wild and wonder. A waterfront masterpiece sprawling 4,569 square feet on Detroit Lake. An hour east of Salem, this adventure cabin in the Cascades features rare materials. The woodland home, with natural woods and hand-selected stones, is pure rustic luxury. Cherry wood ceilings, black walnut hardwoods and Douglas fir walls fulfill every craftsman’s dream. The great room’s soaring ceilings provide a front-row seat to lake, mountain and forest scenery. There is a place that exists at the intersection of wild and wonder. A waterfront masterpiece sprawling 4,569 square feet on Detroit Lake. An hour east of Salem, this adventure cabin in the Cascades features rare materials turned timeless finishes.The woodland home, with natural woods and hand-selected stones, is pure rustic luxury. As you approach via the stone-clad entry monuments, fir logs and cedar beams pull you forward. A trout door handle lures visitors of every age. Once inside, you’ll be in awe of the outdoors from inside. Cherry wood ceilings, black walnut hardwoods and Douglas fir walls fulfill every craftsman’s dream. The great room’s soaring ceilings provide a front-row seat to lake, mountain and forest scenery. A stone-encased woodburning fireplace is a retreat all its own. The gourmet kitchen offers a double Sub-Zero refrigerator and freezer, dual paneled built-in dishwashers to match the hickory cabinetry, dual farmhouse sinks and Wolf range. Ample storage surrounds a tulip wood island with granite dining bar. An arched rock wall leads to the dining room where an Argentine wood grill awaits culinary creations. Main floor guest quarters flow into a full bathroom with custom walk-in shower and gleaming copper basin. The main floor has a mudroom with cubbies for everyone. A central staircase with driftwood finials leads to a vaulted loft with built-in bar and entertaining conveniences. The adjacent rec room is ideal for movies or gaming. Nearby is a full bathroom and den. The home has ample all-season deck space and a covered balcony. An upstairs owner’s retreat is perfect for a curated spa treatment. Highlights include a soaking tub, granite shower, copper sink atop a maple trunk pedestal and heated lanai.The canyon reservoir offers kayaking, boating, fishing and splashing from the pier. With snow-dusted Mt. Jefferson in the distance and ski areas nearby, a lifestyle of fun awaits at this property dense in beauty.
MlsNumber: 812147


Listing Provided By: LUXE CHRISTIE'S INTERNATIONAL REAL ESTATE, original listing
Name: LUXE CHRISTIE'S INTERNATIONAL REAL ESTATE
Office Name: LUXE FORBES GLOBAL PROPERTIES
Office Phone: (503) 330-6677
Agent Name: SARAH SAWYER
Disclaimer: Copyright © 2024 Willamette Valley Multiple Listing Service. 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 = 2226 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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;
Real Estate Expert Photo for Melissa Schumacher
Melissa Schumacher
ASCIIPremiere Property Group
Call Today!: (541) 974-3877

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App