Janiese Alton

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of The Agency Steamboat Springs- MLS# S1061665MLS Provider

28100 Columbine RidgeSteamboat Springs, CO 80487

Single Family · 5 Beds · 4 Full Baths · 1 Half Bath · 4,927 Sq. ft. | 36.46 Acres
$5,950,000 Active

28100 Columbine Ridge Overview

Time on Site:
336 days
Visits:
0

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.

Virtual Tour
Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map

28100 Columbine Ridge Facts & Features

  • Type Single Family
  • Sq. ft. 4,927
  • Price/Sq.ft. $1,208
  • Lot 36.46 Acres

Details

General

Association/HOA

  • Association Fee: 2300.0
  • Association Fee Frequency: Annually
  • Association: true

School Information

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

Green Features

  • Green Building Verification Type: Unknown

Building Information

  • Year Built: 2019

Location/Region

  • County Or Parish: Routt
  • MLS Area Major: South Valley
  • MLS Area Minor: Unknown
  • Postal City: Steamboat Springs
  • Subdivision Name: BIG VALLEY RANCH

Community/Development

  • Community Features: None

Tax Information

  • Tax Annual Amount: 8351.84
  • Tax Year: 2023

General Information

  • Exclusions: No
  • Furnished: Furnished
  • Parcel Number: R4209761
  • Pets Allowed: Yes
  • Property Condition: Resale
  • Property Sub Type: Single Family Residence
  • Property Type: Residential

Interior

Parking Information

  • Garage Spaces: 3.0
  • Garage: true

Beds/Baths

  • Bathrooms Full: 4
  • Bathrooms Half: 1
  • Bathrooms Three Quarter: 0
  • Bathrooms Total: 5
  • Bedrooms Total: 5

Building Interior

  • Building Area Source: Public Records
  • Building Area Total: 4927.0

General Information

  • Appliances: Dishwasher,Disposal,Microwave,Refrigerator,Range Hood,Wine Cooler,Warming Drawer,Dryer,Washer
  • Building Features: Not Applicable
  • Fireplace Features: Gas
  • Fireplace: true
  • 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
  • Living Area: 4927.0
  • Living Area Source: Public Records
  • Rooms Total: 13

Exterior

Parking Information

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

Lot Information

  • Lot Features: See Remarks
  • Lot Size Acres: 36.46
  • Lot Size Area: 36.46
  • Lot Size Source: Public Records
  • Lot Size Square Feet: 1588197.6
  • Lot Size Units: Acres
  • Road Surface Type: Paved
  • Water Source: Well

Waterfront/View

    Building Exterior/Construction

    • Attached Garage: true
    • Construction Materials: Frame,Stone,Wood Siding
    • Roof: Composition

    General Information

    • Sewer: Septic Tank
    • Utilities: Electricity Available,Propane,Trash Collection,Septic Available

    Room Information

    Room: Bedroom

    • Level: Lower

    Room: Bedroom

    • Level: Lower

    Room: Bedroom

    • Level: Lower

    Room: Family Room

    • Level: Lower

    Room: Full Bath

    • Level: Lower

    Room: Full Bath

    • Level: Lower

    Room: Full Bath

    • Level: Lower

    Room: Bedroom

    • Level: Main

    Room: Half Bath

    • Level: Main

    Room: Laundry

    • Level: Main

    Room: Mud Room

    • Level: Main

    Room: Primary Bedroom

    • Level: Main

    Room: Primary Full Bath

    • Level: Main

    28100 Columbine Ridge Neighborhood

    Community

    80487 (Steamboat Springs) Demographics

    41
    Median Age
    25
    Population Density (per sq. mile)
    62%
    College Educated
    $79,162
    Estimated Median Income
    5,369
    Estimated Total Home Owners
    1,829
    Estimated Total Renters
    75% / 25%
    Estimated Owner / Renter Divide
    2
    Estimated Average Household Size
    Community data courtesy of LiveBy, Inc.

    Schools

    School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

    28100 Columbine Ridge Monthly Cost

    $
    $ %
    %
    $
    $
    * All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

    28100 Columbine Ridge Market Data

    Based on the last 30 days in this zip code

    $2,503,746
    Average List Price
    $1,024
    Average Price per Square Foot
    39
    Properties Sold
    153
    Average Days on Market
    481
    Properties for Sale
    Calculations provided by Reliance Network

    28100 Columbine Ridge History

    Date Event Value Agent
    7/31/2025Source: Summit MLS Added to Database
    July 29, 2025
    8/13/2024Source: Summit MLS Added to Database
    August 13, 2024