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;

1611 Mountain Dr
Stayton, OR 97383

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $834,900
Beds: 4
Baths: 4
Status: Active
SqFt: 3781
Agency: HomeSmart Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: A RARE opportunity to move into this beautiful custom built home in Prestigious Mountain estates. Bright and open, the house sits on over half an acre. Built in 2004 immaculately maintained and lots of updates with 3773 sq ft, 4 beds, 4 baths, one ADA, plus an office, 3 car garage and full daylight basement with a entertainment system, pellet stove, full kitchen, bedroom & bath ideal for multi generational living. High end appliances granite counters Covered deck overlooking over yard & pond with ramp, 400AMP panel. Detached shop,mature landscaping. Surveillance cameras incl. Close to shopping, coffee shops and restaurants.Welcome to this custom-built oasis nestled in the prestigious Mountain Estates. With an open floor plan flooding the main floor with natural light, this home offers a serene retreat on a generous 0.56-acre lot. Step outside to discover the beauty of a full multi-zone sprinkler system and a stunning custom koi pond complete with a tranquil waterfall, creating a picturesque backdrop for outdoor gatherings.Inside, the 3,773 square feet of living space boast 4 bedrooms & 4 bathrooms, with a kitchen conveniently situated on both levels. The upstairs kitchen has been tastefully remodeled with custom granite countertops, dual sinks, a gas cooking stove, garbage compactor, and three ovens, ideal for culinary enthusiasts and entertaining alike.Luxurious features abound, including a walk-in shower, ADA-compliant amenities, and a heated floor in the main bathroom for added comfort. The daylight basement offers versatile living options, perfect for a movie room or multi-family living, complete with a bedroom, full bathroom, and kitchenette and cozy pellet stove.Step onto the custom outside deck, adorned with hand-made powder-coated rails, views of the pond and meticulously landscaped surroundings. For added security and convenience, six outdoor cameras provide surveillance, and wired soffits make holiday decorating a delight.Additional features include easy attic access with full-length lighting, a 400-amp panel upstairs, and a secondary panel downstairs, ensuring ample power for all your needs. With a 3-car garage providing plenty of storage space as well as private office, this home seamlessly combines luxury, functionality, and tranquility.Don't miss this opportunity!See rendered video below under facts and features.
MlsNumber: 813298


Listing Provided By: HomeSmart Realty Group, original listing
Name: HomeSmart Realty Group
Phone: (971) 599-5865
Office Name: HOMESMART REALTY GROUP
Office Phone: (971) 599-5865
Agent Name: VANESSA RILEY
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