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

30620 Relay Court
Oak Creek, CO 80467
Michelle Parilla with The Agency Steamboat Springs, original listing - (970) 457-6880

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2625 Square Feet
Agency: The Agency Steamboat Springs
Agency Phone: (970) 457-6880

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: This stunning new half-duplex, designed to feel like a spacious single-family home, offers over 2,600 sq ft of thoughtfully planned living space. With four bedrooms, four bathrooms, and an additional flex space, it's built for comfort and versatility.<br /> <br /> On the lower level, you can enter directly from the main front door, or for extra convenience pull in to your attached 2 car garage and step right into your dedicated mudroom—perfect for organizing outdoor gear. This floor also features a convenient laundry room, and a generously-sized bedroom with an ensuite bath, plus a bonus room which can be used and finished as an additional bedroom or home office, or allow the builder to create a fully functioning ADU ideal for guests, private quarters or as rental income opportunity.<br /> <br /> Heading upstairs, you're welcomed into a bright and open living space that’s perfect for entertaining or everyday relaxation. The modern kitchen boasts a grand island and flows seamlessly into the dining area and living room. From here, two expansive sliding doors open to a large deck with breathtaking views of Young’s Peak and the Stagecoach Ski Area. Whether hosting or unwinding, this space is designed to impress.<br /> <br /> Down the hall, you’ll find a luxurious primary suite, a guest bedroom, and a bonus room that can flex as an office, reading nook, or whatever your heart desires. With ceilings over 10 feet high, the home takes full advantage of the views in every direction, flooding the space with natural light.<br /> <br /> Finished with natural stone and wood accents, this mountain-modern home blends curb appeal with timeless design. Ideally located, you’ll have easy access to nearby walking trails and be just a short drive or bike ride to Stagecoach Reservoir, where endless outdoor activities like boating, fishing, and paddleboarding await.<br /> <br /> Ready to make Stagecoach your home? Contact the listing agent today!
MlsNumber: --
ListingId: S1054957


Listing Provided By: The Agency Steamboat Springs, original listing
Phone: (303) 591-0929
Office Phone: (970) 457-6880
Agent Name: Michelle Parilla
Disclaimer: Copyright © 2024 Altitude REALTORS &#174;. 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