Redfin is joining Rocket

Discover how we're simplifying your journey home.

$5,950,000

28100 Columbine Rdg Steamboat Springs, CO 80487

5 beds
4 full, 1 partial
4,927 sqft
36.5 acres
$1,208 / sqft
House

Property details

About 28100 Columbine Rdg

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.

Highlights

Home typeSingle Family Residence
HeatingPropane, Radiant
StatusActive
Size4,927 sqft
Lot size36.46 Acres
Year built2019
ParkingAttached, Garage, Heated Garage, Oversized, RV Access/Parking
MLS #S1061665
Attached garage3 spaces
FireplaceGas
ViewMountain(s), Valley

Summary

  • Partial Bathrooms: 1
  • Full Bathrooms: 4
  • Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range Hood, Wine Cooler, Warming Drawer, Dryer, Washer
  • Flooring Type: Carpet, Tile, Wood
  • Interior: Wet Bar, Built-in Features, Granite Counters, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
  • Fireplace: Gas
  • Total Bedroom Count: 5
  • Garage Space: 3 spaces
  • Attached Garage: Yes
  • Parking: Attached, Garage, Heated Garage, Oversized, RV Access/Parking
  • View: Mountain(s), Valley
  • Exterior: Patio
  • Heating: Propane, Radiant
  • List Price: $5,950,000
  • Price/SqFt: $1,207
  • HOA Amount: $2300 Annually
  • Annual Tax Amount: $8,351
  • Tax Year: 2023
  • Lot: See Remarks
  • 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.
  • Year Built: 2019
  • Living Area: 4,927 SqFt
  • Lot Size: 36.46 Acres
  • MLS Number: S1061665
  • MLS Name: SummitMLS
  • Office Name: The Agency Steamboat Springs
  • Office Phone: (970) 457-6880
  • Listing Agent: Chris Paoli

Copyright © 2025 Summit MLS, Inc., a wholly owned subsidiary of Summit Association of REALTORS® (SAR). All rights reserved.

The information being provided is for the consumer's non-commercial, personal use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. The information provided is not guaranteed and should be independently verified. You may not reprint or redistribute the information, in whole or in part, without the expressed written consent of Summit Association of REALTORS®.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/31/2025, 9:45:39 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

DateEventPrice
Dec 04, 2015
Home Sold
$433,000

Tax history

YearAssessmentProperty Tax
2023$175,260$8,351
2022$131,600$8,241
2021$135,430$8,231
2020$141,130$8,452
2019$94,290$5,476
2018$28,230$1,584
2017$940$52

History based on county public records data.

Nearby schools

8

Soda Creek Elementary School

Public District KG-5

8.0 mi

220 Park Ave

8

Strawberry Park Elementary School

Public District KG-5

8.6 mi

39620 Amethyst St

6

South Routt Elementary School

Public District KG-5

16.1 mi

448 Main St

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $52,976. Most Steamboat Springs, CO residents have annual incomes between $35k-100k. The majority of families are married, no kids. The majority of residents in this area have post secondary degree education.

How much money do the neighbors make?

30%
<35k
50%
35k-100k
17%
100k-200k
3%
200k+

What level of education do the neighbors have?

No High School
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate

What types of families live nearby?

34%
Single, No Kids
9%
Single, with Kids
36%
Married, No Kids
21%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

14%
<11 yrs old
8%
12-17 yrs old
13%
18-34 yrs old
53%
35-64 yrs old
12%
65+ yrs old

What do the neighbors do for fun?

  • HuntingHunting
  • College FootballCollege Football
  • NASCARNASCAR

Where do the neighbors shop?

  • Dick's Sporting GoodsDick's Sporting Goods
  • DillardsDillards
  • Express/Express For MenExpress/Express For Men

Where do the neighbors go to eat?

  • Texas RoadhouseTexas Roadhouse
  • Cracker BarrelCracker Barrel
  • SonicSonic

What do the neighbors drive?

  • SubaruSubaru
  • CadillacCadillac
  • KiaKia

What do the neighbors listen to?

  • New CountryNew Country
  • News/Talk/InformationNews/Talk/Information
  • Classic CountryClassic Country
All data provided by Home Junction and Claritas

Frequently asked questions

About 28100 Columbine Rdg

The listing price of 28100 Columbine Rdg property is $5,950,000.

The property 28100 Columbine Rdg is a house located in Steamboat Springs, Colorado, 80487.

Active Listing: 28100 Columbine Rdg is For Sale (Active/New) which means the seller is accepting offers.

The nearby schools for 28100 Columbine Rdg are: Soda Creek Elementary School (GreatSchools Rating 8/10), Strawberry Park Elementary School (GreatSchools Rating 8/10), South Routt Elementary School (GreatSchools Rating 6/10), Soroco Middle School (GreatSchools Rating 10/10), Steamboat Springs Middle School (GreatSchools Rating 7/10), Hayden Middle School (GreatSchools Rating 6/10), Steamboat Springs High School (GreatSchools Rating 7/10), Hayden High School (GreatSchools Rating 2/10).

According to the records, the last property tax for 2023 is $8,351 (source: MLS/based on county public records data).

The last sale was on December 4, 2015 for $433,000 (source: MLS/tax record).

The property at 28100 Columbine Rdg has 5 bedrooms and 4 full and 1 half bathrooms.

The property 28100 Columbine Rdg is 4,927 SqFt (source: MLS/tax record).

The year of construction for 28100 Columbine Rdg is 2019.

This home is located at 28100 Columbine Rdg in Steamboat Springs, CO and zip code 80487. This 4,927 square foot home, which was built in 2019, sits on a 36.46 acre lot. Features: 5 bedrooms, 5 bathrooms. It has been listed on Rocket Homes since July 29, 2025 and is currently priced at $5,950,000.

From Rocket Homes Real Estate and based on county public records data.

More resources

Housing market reports in Routt County