ResidentialSingleFamilyResidenceColoradoRoutt CountySteamboat Springs8048728100 Columbine Ridge Rd, Steamboat Springs, CO 80487, USA

28100 Columbine Ridge Rd, Steamboat Springs, CO 80487, USA

28100 Columbine Ridge Rd, Steamboat Springs, CO 80487, USA
  • 5 beds
  • 5 baths
  • 4927, 4927 sq ft
$5,950,000
Request info

Basics

  • Type:
  • Status:
  • Category:
  • Area, sq ft: 4927, 4927 sq ft
  • Lot size, sq ft: 1588197.6, 36.46 sq ft
  • Bedrooms: 5
  • Bathrooms: 5
  • Half baths: 1
  • Total rooms: 13
  • Floors: Two
  • OriginatingSystemName: SUMMIT
  • MLS ID: S1061665
  • Year built: 2019
  • Lot Size Acres: 36.46 acres
  • Date Added: 2025-07-29
  • Days On Market: 43

Description

  • Description:

    Set amidst the serene expanse of Big Valley Ranch, Last Run Ranch is a 5-bedroom, 4.5-bath custom home that presents peak luxury and privacy just minutes from Steamboat Springs. Spanning 4,927 SF and situated on 36.46 acres, this exceptional estate offers a harmonious blend of modern sophistication and rustic charm. Designed by renowned architect Michael Olsen, the home captures dramatic, far-reaching panoramic views of the Steamboat Ski Area and the South Valley from nearly every room. Recent improvements enhance the offering: air conditioning, a reimagined kitchen, and new furnishings transform the interior, while a paved driveway makes year-round access a breeze. Inside, the airy open floor plan is thoughtfully designed for effortless entertaining, featuring a soaring 23-foot ceiling in the great room and an inviting kitchen outfitted with leathered granite countertops, and high-end stainless steel appliances including an induction cooktop, steam oven, and full-size freezer. The main level primary suite includes an ensuite bath and a private patio with stunning views. Outdoor enthusiasts will relish the massive patio, secluded hot tub, fire pit, and ample space for RVs and trailers, including a 980 square foot 3-car garage. The amount of storage space found at this home is astounding. From a 900 SF bonus room naturally cooled to 56 degrees, the ideal temperature for wine storage, to 250 SF of attic storage with windows. Wildlife abounds, with frequent visits from deer, elk, sandhill cranes, and grouse, enhancing the property’s pastoral allure. The area supports equestrian activities, allowing residents to keep horses on-site. Solar system (36 PV panels) 11.6kW DC, producing 18,471 kWh-per year, connected to YVEA grid with essential loads panel ready for battery installation. Located just 10 miles from Steamboat Springs, Last Run Ranch offers quick access to world-class skiing, golf, dining, and shopping, while maintaining a tranquil, nature-steeped atmosphere. LOT 9 BIG VALLEY RANCH AT STEAMBOAT, FILING II-A

    Show all description

Location

  • Directions: From downtown Steamboat, take US 40 east. Right on 131. Right on CR22. Left on CR14 (River Road). continue straight onto CR35 and follow around for a couple of miles. When you see the "Red School House", turn left on Columbine Ridge Rd. Home is the first driveway on the right at the top of the hill.
  • Lot Size Acres: 36.46 acres
  • Neighborhoods: ,

Building Details

  • Water Source: Well
  • Lot Features: SeeRemarks
  • Sewer: SepticTank
  • Construction Materials: Frame,Stone,WoodSiding
  • Garage Spaces: 3
  • Property Condition: Resale
  • Levels: Two
  • View: Mountains,SkiArea,Valley
  • Subdivision Name: BIG VALLEY RANCH
  • Floor covering: , ,
  • Exterior material: , ,
  • Architectural Style: Dishwasher, Disposal, Microwave, Refrigerator, RangeHood, WineCooler, WarmingDrawer, Dryer, Washer
  • Roof: Composition
  • Parcel Number: R4209761
  • Living Area: 4927 sq ft
  • Waterfront: No
  • Heating: Yes
  • Land Lease: No
  • ViewYN: Yes
  • Lot Size Area: 36.46 sq ft
  • Bathrooms Full: 4
  • Open Parking: No

Amenities & Features

  • Parking Features: Attached,FinishedGarage,Garage,HeatedGarage,Oversized,RvAccessParking, Attached,FinishedGarage,Garage,HeatedGarage,Oversized,RvAccessParking
  • Patio & Porch Features: Patio
  • Spa Features: HotTub
  • Utilities: ElectricityAvailable, Propane, TrashCollection, SepticAvailable
  • Cooling: OneUnit
  • Fireplace Features: Gas
  • Fireplaces Total: 2
  • Furnished: Furnished
  • Heating: Propane,Radiant
  • Features:
  • Interior Features: WetBar, BuiltInFeatures, BreakfastArea, FivePieceBathroom, Fireplace, GraniteCounters, HighCeilings, JackAndJillBath, KitchenIsland, PrimarySuite, OpenFloorplan, Pantry, VaultedCeilings, WalkInClosets
  • Laundry Features: MainLevel
  • Fireplace: Yes
  • Spa: Yes
  • CoolingYN: Yes
  • Pets Allowed: Yes
  • PoolPrivateYN: No
  • Lot Features: SeeRemarks
Show all amenities & features

Nearby Schools

  • Middle Or Junior School: Steamboat Springs
  • Elementary School: Soda Creek
  • High School: Steamboat Springs

Expenses, Fees & Taxes

  • Association Fee: $2,300
  • Tax Annual Amount: $8,351.84
  • Tax Year: 2023

Miscellaneous

  • Association Fee Frequency: Annually
  • Community Features: None
  • Exclusions: No

Ask Us About This Home

Phone
By clicking the «REQUEST INFO» button you agree to the Terms of Use and Privacy Policy

Listing Information Courtesy of:

  • Agent Name: Chris Paoli
  • List Office Name: The Agency Steamboat Springs

Share this property

Copy

Or share with

Reset password

Enter your email address and we will send you a link to change your password.

Get started with your account

to save your favourite homes and more

Sign up with email

Get started with your account

to save your favourite homes and more

By clicking the «SIGN UP» button you agree to the Terms of Use and Privacy Policy