$5,950,000
OPEN THU 9AM - 11:30AM

28100 Columbine Ridge Steamboat Springs, CO 80487

Estimated payment $33,057/month

Total Views 5,180
5 Beds
4.5 Baths
4,927 Sq Ft
$1,208 Price per Sq Ft

Highlights

  • Views of Ski Resort
  • RV Access or Parking
  • 36.46 Acre Lot
  • Soda Creek Elementary School Rated A-
  • Primary Bedroom Suite
  • Open Floorplan

About This Home

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.

Listing Agent

Chris Paoli

The Agency Steamboat Springs License #FA100002352 Listed on: 07/29/2025

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,352

Year Built

  • Built in 2019

Lot Details

  • 36.46 Acre Lot

HOA Fees

  • $192 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • RV Access or Parking

Property Views

  • Ski Resort
  • Mountain
  • Valley

Home Design

  • Frame Construction
  • Composition Roof
  • Wood Siding
  • Stone

Interior Spaces

  • 4,927 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Furnished
  • Built-In Features
  • Vaulted Ceiling
  • 2 Fireplaces
  • Gas Fireplace
  • Great Room
  • Family Room
  • Dining Room

Kitchen

  • Breakfast Area or Nook
  • Range Hood
  • Warming Drawer
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Jack-and-Jill Bathroom

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Schools

  • Soda Creek Elementary School
  • Steamboat Springs Middle School
  • Steamboat Springs High School

Utilities

  • Heating System Uses Propane
  • Radiant Heating System
  • Propane
  • Well
  • Septic Tank
  • Septic System

Community Details

  • Big Valley Ranch Subdivision

Listing and Financial Details

  • Assessor Parcel Number R4209761

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,352

Year Built

Built in 2019

Lot Details

0

HOA Fees

$192 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 36.46
  • Road Surface Type: Paved
  • Subdivision Name: BIG VALLEY RANCH
  • 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.
  • Garage Yn: Yes
  • Unit Levels: Two
  • Year Built: 2019
  • Property Sub Type Additional: Single Family Residence
  • Special Features: 4097

Interior Features

  • Furnished: Furnished
  • Spa Features: Hot Tub
  • Private Spa: Yes
  • Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range Hood, Wine Cooler, Warming Drawer, Dryer, Washer
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplaces: 2
  • Fireplace: Yes
  • Flooring: Carpet, Tile, Wood
  • Interior Amenities: Wet Bar, Built-in Features, Breakfast Area, Five Piece Bathroom, Fireplace, Granite Counters, High Ceilings, Jack and Jill Bath, Kitchen Island, Primary Suite, Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
  • Living Area: 4927.0
  • Dining Room Type: Dining Room, Family Room, Great Room

Exterior Features

  • Lot Features: See Remarks
  • View: Mountain(s), Ski Area, Valley
  • View: Yes
  • Exclusions: No
  • Construction Type: Frame, Stone, Wood Siding
  • Patio And Porch Features: Patio
  • Property Condition: Resale
  • Roof: Composition

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Parking Features: Attached, Finished Garage, Garage, Heated Garage, Oversized, RV Access/Parking

Utilities

  • Laundry Features: Main Level
  • Green Building Features: Not Applicable
  • Cooling: 1 Unit
  • Cooling Y N: Yes
  • Heating: Propane, Radiant
  • Heating Yn: Yes
  • Sewer: Septic Tank
  • Utilities: Electricity Available, Propane, Trash Collection, Septic Available
  • Water Source: Well

Condo/Co-op/Association

  • Community Features: None
  • Association Fee: 2300.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • Pets Allowed: Yes

Schools

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

Lot Info

  • Lot Size Sq Ft: 1588197.6
  • Parcel #: R4209761
  • Zoning Description: See Remarks

Green Features

  • Green Building Verification Type: Unknown

Tax Info

  • Tax Annual Amount: 8351.84
  • Tax Block: n/a
  • Tax Lot: 9
  • Tax Year: 2023

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $8,590 $175,260 $23,520 $151,740
2023 $8,590 $175,260 $23,520 $151,740
2022 $8,241 $131,600 $19,770 $111,830
2021 $8,232 $135,430 $20,380 $115,050
2020 $8,452 $141,130 $16,530 $124,600
2019 $5,476 $94,290 $0 $0
2018 $1,585 $28,230 $0 $0
2017 $52 $940 $0 $0
2016 $46 $880 $880 $0
2015 $45 $880 $880 $0
2014 $39 $730 $730 $0
2012 -- $630 $630 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/29/2025 07/29/25 For Sale $5,950,000 +1274.1% $1,208 / Sq Ft
12/02/2015 12/02/15 Sold $433,000 0.0% --
11/02/2015 11/02/15 Pending -- -- --
10/28/2015 10/28/15 For Sale $433,000 -- --
Source: Summit MLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $433,000 Heritage Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $300,000 Credit Line Revolving
Open $1,070,000 New Conventional
Closed $100,000 Credit Line Revolving
Closed $254,000 New Conventional
Closed $50,000 Credit Line Revolving
Closed $1,010,000 Adjustable Rate Mortgage/ARM
Closed $1,571,000 Construction
Source: Public Records

About the Listing Agent

Chris Paoli

The Agency Steamboat Springs

(970) 507-4618

Section Image

Chris Paoli serves as the esteemed Managing Partner of The Agency Steamboat Springs. With a tenure in real estate since 2005, Chris brings an unparalleled level of expertise to the industry. Hailing from Suffern, New York, he specializes in luxury properties and new developments in the Yampa Valley region, and boasts a deep understanding of the market landscape. Chris' track record speaks volumes. He led the top-producing, award-winning real estate team, The Paoli Group, and has achieved the

Chris' Other Listings

  • 33250 Ravenswood Ln, Steamboat Springs, CO 80487

    $5,450,000 Open Thu 9AM - 11:30AM

    • 5 Beds
    • 5.5 Baths
    • 6,860 Sq Ft
    • 33250 Ravenswood Ln
    • Steamboat Springs, CO

    Sustainability meets luxury at 33250 Ravenswood Lane spanning 6,860 square feet on 7.84 acres, with sweeping 360-degree views that include the Steamboat Ski Area, the Flat Tops, Hahns Peak, and the Zirkel Mountains. Geothermal heating and cooling, solar panels, and a wind turbine support low-impact living, delivering the environmental footprint of a downtown condo in a setting that feels like a

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 30625 County Road 14e, Steamboat Springs, CO 80487

    $2,250,000

    • Land
    • 38.77 Acres
    • $58,035 per Acre
    • 30625 County Road 14e
    • Steamboat Springs, CO

    Discover nearly 39 acres of possibility in Steamboat Springs’ sought-after South Valley. Just under 8 miles from the world-renowned Steamboat Ski Resort, via fully paved roads, this exceptional parcel offers the rare combination of space, scenic views, and proximity to downtown’s shops, dining, and golf. With an incredibly quiet location that captures dramatic sightlines of the Ski Area and 360

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • TBD Highway 131, Oak Creek, CO 80467

    $1,950,000

    • 4 Beds
    • 3.5 Baths
    • 2,499 Sq Ft
    • TBD Highway 131
    • Oak Creek, CO

    Two individual parcels form 30 peaceful acres within the Steamboat School District. The 3-bedroom, 3.5-bath residence on 20 acres offers both privacy and convenience, just 15 minutes from shops and dining in Steamboat and the recreational opportunities at Stagecoach Reservoir. An additional elevated, 9-acre lot is included, and offers a second homesite with panoramic views. Use the combined

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 31900 County Road 22 Unit A&B, Steamboat Springs, CO 80487

    $3,950,000

    • 4 Beds
    • 3.5 Baths
    • 3,747 Sq Ft
    • 31900 County Road 22
    • Unit A&B
    • Steamboat Springs, CO

    31900 County Road 22 is an exemplar of modern farmhouse style, where rustic charm meets present-day sophistication. Only 5 minutes from the Steamboat Ski Resort, this home offers a rural escape, yet is convenient to skiing, shopping, dining, and schools. The 10-acre parcel includes a main home, bunkhouse, and barn, plus the ability to build a new main home while keeping the existing residence.

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 29390 Highway 131, Oak Creek, CO 80467

    $1,450,000

    • 3 Beds
    • 3.5 Baths
    • 2,499 Sq Ft
    • 29390 Highway 131
    • Oak Creek, CO

    20 peaceful acres within the Steamboat School District. The 3-bedroom, 3.5-bath residence on 20 acres offers both privacy and convenience,just 15 minutes from shops and dining in Steamboat and the recreational opportunities at Stagecoach Reservoir. Located off paved andplowed Highway 131, year-round living effortless. The open great room features a woodburning stove and connects to a remodeled

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 34015 Colorado 131, Steamboat Springs, CO 80487

    $8,940,000

    • 6 Beds
    • 5.5 Baths
    • 5,387 Sq Ft
    • 34015 Colorado 131
    • Steamboat Springs, CO

    This is an exceptional opportunity to own over 70 acres LESS THAN 5 MILES from the slopes of the Steamboat Ski Resort, downtown Steamboat, and within a stone's throw of the Chuck Lewis State Wildlife Area. Paniolo Ranch is the embodiment of the western ideal: wide open spaces, majestic views, adventures on horseback, and casting flies for trophy trout. Revel in uninterrupted views of the ski

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 34225 Colorado 131, Steamboat Springs, CO 80487

    $5,940,000

    • 6 Beds
    • 5.5 Baths
    • 5,387 Sq Ft
    • 34225 Colorado 131
    • Steamboat Springs, CO

    Paniolo Ranch is the embodiment of the western ideal: wide open spaces, majestic views, adventures on horseback, and casting flies for trophy trout. Savor the privacy, solitude, and convenience afforded by 35 acres LESS THAN 5 MILES from the slopes of the world-famous Steamboat Ski Resort, downtown Steamboat, and 3 golf courses. Revel in uninterrupted views of the ski area, South Valley, and

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 31605 Aspen Ridge Rd, Steamboat Springs, CO 80487

    $5,975,000 Pending

    • 6 Beds
    • 6.5 Baths
    • 6,906 Sq Ft
    • 31605 Aspen Ridge Rd
    • Steamboat Springs, CO

    Unobstructed Ski Area views, absolute privacy, and just 3 miles from the slopes. 31605 Aspen Ridge Road combines panoramic Ski Area views, convenient access to town and space to spread out. There are no vacant lots in Dakota Ridge facing the Ski Area, making this a scarce setting for a home designed to capture views from every room. With 7 bedrooms, all with Ski Area views, multiple gathering

    Chris Paoli The Agency Steamboat Springs

    Section Image
  • 31640 Vistas Ct, Steamboat Springs, CO 80487

    $3,450,000 Pending

    • 4 Beds
    • 5 Baths
    • 3,246 Sq Ft
    • 31640 Vistas Ct
    • Steamboat Springs, CO

    Minutes from downtown, the Steamboat Ski Resort, several golf courses and all that Steamboat has to offer,with short-term vacation rentals allowed and National Forest Access!! This brand-new mountain modernmasterpiece offers an unparalleled blend of luxury, adventure, and investment potential. 31640 Vistas Court ismore than a home, it is a luxury basecamp for those who live to

    Chris Paoli The Agency Steamboat Springs

    Section Image

Source: Summit MLS

MLS Number: S1061665

Summit MLS

APN: R4209761