970.367.6240
 | 
Login Account
 | 
Signup
Home » Real Estate » CO » Steamboat Springs » 80487 » 28100 Columbine Ridge, Steamboat Springs, CO, 80487
$5,950,000

28100 Columbine Ridge, Steamboat Springs, CO, 80487

5 Beds
5 Baths
4,927 Square Feet
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.
Offered By
Chris Paoli, The Agency Steamboat Springs

Property Details

Property Type Residential
Status Active
Bedrooms 5
Bathrooms (Full) 4
Property Sub Type Single Family Residence
Square Feet 4,927
MLS # S1061665
Bathrooms (Half) 1

Market Trends

New Properties On Market
104
41% Increase In New Listings
Average Asking Price
$2,044,111
$358,566 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$915
$60 Increase In List Price/Sq. Ft.
Average Days On Market
6
17 Day Decrease In Days On Market
Data as of Jun 03, 2026. Remaining statistics above are calculated on activity within the period from Apr 01, 2026 to May 31, 2026.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance

Similar Listings

1010 Yampa Street, #R3, Steamboat Springs, CO 80487 Listing Photo  1
$6,550,000
1010 Yampa Street, #R3
Steamboat Springs, CO
4 Beds
|
5 Baths
|
3,781 Square Feet
Offered By Cam Boyd Steamboat Sotheby's International Realty
1010 Yampa Street, #R2, Steamboat Springs, CO 80487 Listing Photo  1
$6,550,000
1010 Yampa Street, #R2
Steamboat Springs, CO
4 Beds
|
5 Baths
|
3,781 Square Feet
Offered By Cam Boyd Steamboat Sotheby's International Realty
1010 Yampa Street, #R5, Steamboat Springs, CO 80487 Listing Photo  1
$6,550,000
1010 Yampa Street, #R5
Steamboat Springs, CO
4 Beds
|
5 Baths
|
3,783 Square Feet
Offered By Cam Boyd Steamboat Sotheby's International Realty
1010 Yampa Street, #R4, Steamboat Springs, CO 80487 Listing Photo  1
$6,550,000
1010 Yampa Street, #R4
Steamboat Springs, CO
4 Beds
|
5 Baths
|
3,781 Square Feet
Offered By Cam Boyd Steamboat Sotheby's International Realty
© 2025 Summit MLS, Inc., a wholly owned subsidiary of Summit Association of REALTORS®. 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®.