28100 Columbine Ridge Rd

Steamboat Springs, CO 80487

$5,950,000
Price
5
Beds
5
Baths
4,927 Sq. Ft.
$1,208 / Sq. Ft.
4,927
Sq. Ft.
$1,208
per Sq. Ft.
a front view of a house with a yard
an aerial view of multiple house with yard
a living room with furniture large garden view and a flat screen tv
a view of a living room and dining room
a living room with furniture and a large window
a living room with furniture and a large window
a living room with furniture and a large window
a dining room with furniture a chandelier and wooden floor
a room with chandelier and wooden floor
a kitchen with granite countertop white cabinets and stainless steel appliances
a view of a dining room with furniture and wooden floor
a dining table with chairs and a potted plant
a view of an outdoor space with furniture
a dining room with a table and chairs
a view of patio outdoor kitchen
a view of a table and chairs in backyard
a view of a chairs and table in the terrace
a view of a back yard from a balcony
a view of a lake with a forest
a bedroom with a bed and a night stand
a view of a door
a bedroom with bed and window
a bathroom with double sink and a mirror
a living room with furniture a rug and a large window
a view of a yard with patio
a bedroom with a bed and a large window
a bedroom with a large bed and a large window
a en suite bathroom with a granite countertop sink and a mirror
a bedroom with a large bed and a large window
a bathroom with a granite countertop toilet sink and mirror
a bedroom with bed couch and window
a bathroom with a granite countertop sink and a mirror
a view of a workspace with furniture and wooden floor
a bedroom with a bed and a bookshelf
a bathroom with a granite countertop toilet sink and mirror
a kitchen with stainless steel appliances granite countertop a refrigerator and a sink
a view of a garage
a garden view with a lake view
a front view of a house with a yard
a view of yard with mountain
a view of swimming pool

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...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.
  1. Listed by Chris Paoli • The Agency Steamboat Springs

Property Details for 28100 Columbine Ridge Road

Subdivision Name
BIG VALLEY RANCH
View
Mountain(s), Ski Area, Valley
Furnished
Furnished
Pets Allowed
Yes
LISTING UPDATED: 11/13/2025 11:05 AM

Property Details for 28100 Columbine Ridge Road

StatusActive
MLS #S1061665
Days on Market148
Taxes$8,352 / year
HOA Fees$2,300 / year
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built2019
Lot Size36.46 AC / 1,588,197 SF
CountyRoutt County

Location

Listing Courtesy of The Agency Steamboat Springs, Chris Paoli
Add your commute

Building Information for 28100 Columbine Ridge Road

Stories-Year Built2019Building Size-Lot Size36.46 AC / 1,588,197 SF

Payment Calculator

$30,289 per month

30 year fixed, 6.28% Interest

Principal and Interest

$29,401

Property Taxes

$696

HOA Dues

$192

The Payment Calculator is for illustrative purposes only.

Property Information for 28100 Columbine Ridge Road

Summary
Location and General Information
  • Building Features: Not Applicable
  • Community Features: None
  • 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.
  • Elementary School: Soda Creek
  • Middle Or Junior School: Steamboat Springs
  • High School: Steamboat Springs
  • Zoning Description: See Remarks
  • Road Surface Type: Paved
Parking
  • Attached Garage: Yes
  • Garage: Yes
  • Garage Spaces: 3
  • Parking Features: Attached, Finished Garage, Garage, Heated Garage, Oversized, RV Access/Parking
Taxes and HOA Information
  • Association: Yes
  • Tax Block: n/a
  • Tax Legal Description: LOT 9 BIG VALLEY RANCH AT STEAMBOAT, FILING II-A
  • Tax Lot: 9
  • Tax Year: 2023
Property
Lot Information
  • Lot Features: See Remarks
  • Lot Size Source: Public Records
  • Parcel Number: R4209761
  • Living Area Source: Public Records
Property and Assessments
  • Building Area Source: Public Records
  • Construction Materials: Frame, Stone, Wood Siding
  • Property Condition: Resale
  • Spa Features: Hot Tub
  • Spa: Yes
Utilities
  • Cooling: 1 Unit
  • Cooling: Yes
  • Heating: Propane, Radiant
  • Heating: Yes
  • Sewer: Septic Tank
  • Utilities: Electricity Available, Propane, Trash Collection, Septic Available
  • Water Source: Well
Interior and Exterior Features
Exterior Features
  • Patio And Porch Features: Patio
  • Roof: Composition
  • View: Yes
Interior Features
  • Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range Hood, Wine Cooler, Warming Drawer, Dryer, Washer
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Fireplaces Total: 2
  • Flooring: Carpet, Tile, Wood
  • Interior Features: Wet Bar, Built-in Features, Breakfast Area, Five Piece Bathroom, Fireplace, Granite Counters, High Ceilings, Jack and Jill Bath, Kitchen Island, Main Level Primary, Primary Suite, Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
  • Laundry Features: Main Level
  • Levels: Two
  • Rooms Total: 13

Property History for 28100 Columbine Ridge Road

DateEvent & SourcePriceAppreciation
Dec 2, 2015

Sold (Public Record)

Public Record #1111816992

$433,000—
Dec 2, 2015

Sold (Public Record)

Public Record #1111816992

$433,000—
DateEvent & SourcePrice
12/02/2015

Sold (Public Record)

Public Record #1111816992

$433,000
12/02/2015

Sold (Public Record)

Public Record #1111816992

$433,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 28100 Columbine Ridge Road

Taxable ValueLand$23,520Additions$151,740Total$175,260
Tax Record2024$8,590 ($716 / month)
Home Facts
Beds4Total Finished SqFt4,927 SqFtAbove Grade Finished SqFt4,927 SqFtStories2Lot Size1,588,198 SqFtStyleMiscellaneous ResidentialYear Built2017ZoningAFCountyROUTTAPN105700009Fireplace TypeHas Fireplace

Schools near 28100 Columbine Ridge Road

This home is within Steamboat Springs Re-2 School District.
Rating
School
Type
Grades
Distance
Soda Creek Elementary School
Public - PK to 5
Steamboat Springs Middle School
Public - 6 to 8
Steamboat Springs High School
Public - 9 to 12
Yampa Valley School
Public - 9 to 12
Rating
School
Distance
Soda Creek Elementary School
PublicPK to 5

Steamboat Springs Middle School
Public6 to 8

Steamboat Springs High School
Public9 to 12

Yampa Valley School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 28100 Columbine Ridge Road, Steamboat Springs, CO 80487

28100 Columbine Ridge Road is a single family home for sale in Steamboat Springs, CO 80487. This property was listed for sale on July 29, 2025 by The Agency Steamboat Springs, it's currently listed at $5,950,000. It has been on the market for a total of 148 days and was last sold on December 2, 2015. This listing's school district is Steamboat Springs Re-2 School District. Nearby schools include Soda Creek Elementary School, Steamboat Springs Middle School and Steamboat Springs High School. 28100 Columbine Ridge Road is a 5-bed, 5-bath, 4,927 sqft single family home built in 2019.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of The Agency Steamboat Springs, Chris Paoli

All information is deemed reliable, but accuracy is not guaranteed. Listing information is based on information from the Aspen / Glenwood MLS for the period 07/29/2025 12:00 AM through 12/24/2025 09:33 PM. The property information being provided is for the consumer’s personal non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated on 11/13/2025 11:05 AM