Skip main navigation
For sale
$5,950,000
5beds
4,927sqft

28100 Columbine Ridge, Steamboat Springs, CO 80487

5beds
4,927sqft
Single family residence
Built in 2019
36.46 Acres
3 Attached garage spaces
$1,208 price/sqft
$192/mo HOA

What's special

Dramatic far-reaching panoramic viewsMassive patioFire pitMain level primary suiteLeathered granite countertopsReimagined kitchenHigh-end stainless steel appliances

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 ...

334 days
|
517
|
16
|
Source: Altitude Realtors,MLS#: S1061665MLS LogoOriginating MLS: Steamboat Springs Board of Realtors
Travel times

Living Room

Kitchen

Outdoor 2

Dining Room

Family Room

Zillow last checked:

Listing updated:

Listed by:

Chris Paoli 970-457-6880,

The Agency Steamboat Springs

Source: Altitude Realtors,MLS#: S1061665MLS LogoOriginating MLS: Steamboat Springs Board of Realtors

Facts & features

Interior

Bedrooms & bathrooms
  • Bedrooms: 5
  • Bathrooms: 5
  • Full bathrooms: 4
  • 1/2 bathrooms: 1
Primary bedroom
  • Level: Main
Bedroom
  • Level: Lower
Bedroom
  • Level: Lower
Bedroom
  • Level: Main
Bedroom
  • Level: Lower
Family room
  • Level: Lower
Other
  • Level: Lower
Other
  • Level: Lower
Other
  • Level: Lower
Half bath
  • Level: Main
Laundry
  • Level: Main
Mud room
  • Level: Main
Other
  • Level: Main
Heating
  • Propane, Radiant
Cooling
  • 1 Unit
Appliances
  • Included: Dishwasher, Disposal, Microwave, Refrigerator, Range Hood, Wine Cooler, Warming Drawer, Dryer, Washer
  • Laundry: Main Level
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)
  • Flooring: Carpet, Tile, Wood
  • Number of fireplaces: 2
  • Fireplace features: Gas
  • Furnished: Yes
Interior area
  • Total interior livable area: 4,927 sqft
Video & virtual tour

Property

Parking
  • Total spaces: 3
  • Parking features: Attached, Finished Garage, Garage, Heated Garage, Oversized, RV Access/Parking
  • Attached garage spaces: 3
Features
  • Levels: Two
  • Has view: Yes
  • View description: Mountain(s), Ski Area, Valley
Lot
  • Size: 36.46 Acres
  • Features: See Remarks
Details
  • Parcel number: R4209761
  • Zoning description: See Remarks

Construction

Type & style
  • Home type: SingleFamily
  • Property subtype: Single Family Residence
Materials
  • Frame, Stone, Wood Siding
  • Roof: Composition
Condition
  • Resale
  • Year built: 2019

Utilities & green energy

  • Sewer: Septic Tank
  • Water: Well
  • Utilities for property: Electricity Available, Propane, Trash Collection, Septic Available

Community & HOA

Community
  • Features: None
  • Subdivision: Big Valley Ranch
HOA
  • Has HOA: Yes
  • HOA fee: $2,300 annually
Location
  • Region: Steamboat Springs

Financial & listing details

  • Price per square foot: $1,208/sqft
  • Tax assessed value: $2,609,570
  • Annual tax amount: $8,351
  • Date on market: 7/29/2025
  • Exclusions: No
  • Road surface type: Paved

Price history

DateEventPrice
7/29/2025Listed for sale$5,950,000-5.6%$1,208/sqft
Source: Altitude Realtors #S1061665 Report a problem
9/30/2024Listing removed$6,300,000$1,279/sqft
Source: Altitude Realtors #S1050681 Report a problem
6/27/2024Listed for sale$6,300,000+1355%$1,279/sqft
Source: Altitude Realtors #S1050681 Report a problem
12/2/2015Sold$433,000$88/sqft
Source: Altitude Realtors #SSS142194 Report a problem

Public tax history

YearProperty taxesTax assessment
2024$8,590 +2.9%$175,260
2023$8,352 +1.3%$175,260 +33.2%
2022$8,241 +0.1%$131,600 -2.8%
2021$8,232 -2.6%$135,430 -4%
2020$8,452 +54.3%$141,130 +49.7%
2019$5,476 +11909.4%$94,290 +2828.3%
2017$46 -12.6%$3,220 +265.9%
2016$52 +16.9%$880
2015$45 +15.9%$880 +20.5%
2014$39 $730

Find assessor info on the county website

Monthly payment

Est. payment
$31,546/mo
Principal & interest
$29718
Property taxes
$1636
HOA Fees
$192
More affordability toolsChevron Right

    Estimated market value

    $5,516,300

    $5.24M - $5.79M

    $7,429/mo

    Climate risks

    Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.

    Neighborhood: 80487

    Nearby schools

    Soda Creek Elementary School
    Grades PK-5 • 8 miles
    8/10
    GreatSchools® Rating
    Test Score Rating
    8/10
    Student Progress Rating
    8/10
    Steamboat Springs Middle School
    Grades 6-8 • 8.5 miles
    8/10
    GreatSchools® Rating
    Test Score Rating
    9/10
    Student Progress Rating
    8/10
    Steamboat Springs High School
    Grades 9-12 • 8 miles
    7/10
    GreatSchools® Rating
    College Readiness Rating
    9/10
    Student Progress Rating
    5/10

        Nearby cities

        Nearby zip codes

        Other Steamboat Springs Topics

          Search
          Updates
          Favorites
          Plan
          Inbox