For sale

$995,000

Est. $6,381/mo —

•

3,976

sq ft

952 Steamboat Valley Rd, Lyons, CO 80540

About this home

Experience breathtaking Front Range beauty from this 37.5± acre foothills estate just minutes above Lyons. Perfectly positioned to capture sweeping views from the valley floor to the summit of Longs Peak. This Northern Colorado property offers privacy while still being close to local amenities and outdoor recreation. The 3,976 sq ft stucco ranch-style home is designed to showcase its surroundings while providing a comfortable capacity for both everyday living and entertaining. It features great rooms on both levels with expansive floor-to-ceiling windows that frame the incredible mountain views and create warm, inviting spaces for indoor gatherings. Take the gathering outside to the expansive deck that includes a year-round hot tub, the perfect place to unwind and soak in Colorado’s ever-changing landscape. The home offers four bedrooms and four bathrooms, including two primary suites, each with its own private bath. Two dedicated offices provide ideal flexibility for remote work, creative space, or guest accommodations. Recent updates include new interior paint and carpet, updated kitchen appliances, a newer HVAC system, and a backup Generac propane generator installed in 2020. With parks, trails, and public lands nearby, this exceptional property offers endless opportunities that reflect Colorado’s outdoor lifestyle. Located just minutes north of Lyons with an easy commute to Boulder or DIA, this remarkable property offers the perfect balance of seclusion, comfort, and convenience.

Single-familyProperty Type

1995Year Built

37.5 acresLot Size

$250Price/Sq.Ft.

$31/moHOA Dues

2 spacesParking

Listed by Mike Williams • Fay Ranches Inc

Contact: mwilliams@fayranches.com,970-290-1617

Listing updated: May 1, 2026 at 08:26am

Redfin checked: 2 minutes ago

•Source:REColorado as Distributed by MLS Grid #3158645

Listing provided courtesy of Metrolist,Inc. (REColorado)

Redfin agents who toured

Amazing views! Home has been recently updated throughout. Road is very tricky. Floor to ceiling windows provide great light and an open feel.
11 years ago• May not reflect the current state of the home
Corey Keach
Redfin Premier agent • Realtor®

Payment calculator

$6,381 per month

Principal and interest$5,229

Property taxes

HOA dues

Home insurance

Utilities

5 minutes to get started. No credit impact.

Affordability tools

See this home in person

This home is unavailable to tour on this day.

Next available date: Wednesday, September 9

Open houses

No upcoming open houses.

Nearby open houses (10)

OPEN WED, 12PM TO 5PM3D WALKTHROUGH
$439,990
3 beds2.5 baths1,375 sq ft
2835 Bear Springs Cir, Longmont, CO 80503
OPEN WED, 12PM TO 5PM3D WALKTHROUGH
$499,990
3 beds2.5 baths1,448 sq ft
2841 Bear Springs Cir, Longmont, CO 80503
OPEN WED, 12PM TO 5PM3D WALKTHROUGH
$459,990
3 beds2.5 baths1,375 sq ft
2839 Bear Springs Cir, Longmont, CO 80503
OPEN WED, 12PM TO 5PM3D WALKTHROUGH
$449,990
3 beds2.5 baths1,375 sq ft
2833 Bear Springs Cir, Longmont, CO 80503
OPEN SAT, 10:30AM TO 12PM3D WALKTHROUGH
$1,850,000
6 beds5 baths5,882 sq ft
818 Confidence Dr, Longmont, CO 80504
OPEN SAT, 11AM TO 2PM
$1,700,000
5 beds4.5 baths5,144 sq ft
2774 Heron Lakes Pkwy, Berthoud, CO 80513
OPEN SAT, 11AM TO 1PM3D WALKTHROUGH
$845,000
5 beds3 baths4,184 sq ft
1628 Naples Ln, Longmont, CO 80503
OPEN SAT, 11AM TO 1PM
$975,000
5 beds3.5 baths2,472 sq ft
405 Raymond Ct, Lyons, CO 80540
OPEN SAT, 12PM TO 2PM3D WALKTHROUGH
$825,000
4 beds2 baths2,513 sq ft
5 Mohawk Rd, Lyons, CO 80540
OPEN SAT, 12PM TO 3PM
$889,900
6 beds4 baths3,850 sq ft
1690 Brown Ct, Longmont, CO 80503

Around this home

Schools

K - 12
Preschool & daycare

Lyons Elementary School

Public PreK-5 • Assigned • 1.2mi

7/10

Lyons Middle/Senior High School

Public 6-12 • Assigned • 2.0mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Offer insights

952 Steamboat Valley Rd · $995,000

Strong offer

$990K and above

75% chance or better to win

Why $990K+ is a strong offer

DAYS ON MARKET

The average home goes pending in 49 days.

SALE-TO-LIST

Most homes are selling 2% below list price.

About offer insights

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Interior features
Breakfast bar
Built-in features
Ceiling fan(s)
Five-piece bath
Granite counters
Window coverings
Finished full basement with walk-out access
Two fireplaces (gas and wood-burning stove)

Bedrooms
Four bedrooms total
Three bedrooms on the main level, including a primary suite
One bedroom in the basement

Bathrooms
Four full bathrooms
Two full bathrooms on the main level
Two full bathrooms in the basement (both include en suite features for some rooms)

Kitchen
Oven
Range
Refrigerator
Granite counters
Breakfast bar
Dishwasher

Laundry & utility
Washer
Dryer
Basement laundry room

Flooring
Carpet
Vinyl
Wood

Heating & cooling
Forced air heating
Central air conditioning

Sale and tax history for 952 Steamboat Valley Rd

Sale History
Tax History

Date

Event

Price

IRES as Distributed by MLS Grid #3158645

Mar 13, 2026

Listed

$995,000

$250/sq ft

Mar 13, 2026

Listed

$995,000

$250/sq ft

+40

Experience breathtaking Front Range beauty from this 37.5 acre foothills estate just minutes above Lyons. Perfectly positioned to capture sweeping views from the valley floor to the summit of Longs Peak. This Northern Colorado property offers privacy while still being close to local amenities and outdoor recreation. The 3,976 sq ft stucco ranch-style home is designed to showcase its surroundings while providing a comfortable capacity for both everyday living and entertaining. It features great rooms on both levels with expansive floor-to-ceiling windows that frame the incredible mountain views and create warm, inviting spaces for indoor gatherings. Take the gathering outside to the expansive deck that includes a year-round hot tub, the perfect place to unwind and soak in Colorado's ever-changing landscape. The home offers four bedrooms and four bathrooms, including two primary suites, each with its own private bath. Two dedicated offices provide ideal flexibility for remote work, creative space, or guest accommodations. Recent updates include new interior paint and carpet, updated kitchen appliances, a newer HVAC system, and a backup Generac propane generator installed in 2020. With parks, trails, and public lands nearby, this exceptional property offers endless opportunities that reflect Colorado's outdoor lifestyle. Located just minutes north of Lyons with an easy commute to Boulder or DIA, this remarkable property offers the perfect balance of seclusion, comfort, and convenience.

IRES as Distributed by MLS Grid #1039163

Feb 28, 2026

Listing Removed

—

Dec 17, 2025

Price Changed

$1,100,000

$277/sq ft

Aug 7, 2024

Listed

$1,249,950

$314/sq ft

IRES as Distributed by MLS Grid #762005

Aug 22, 2016

Sold

$615,000

$155/sq ft

Jul 1, 2016

Contingent

—

Jun 10, 2016

Price Changed

$625,000

$157/sq ft

Oct 22, 2015

Price Changed

$624,999

$157/sq ft

Oct 22, 2015

Price Changed

$650,000

$163/sq ft

Oct 22, 2015

Price Changed

$625,500

$157/sq ft

Oct 20, 2015

Price Changed

$625,000

$157/sq ft

Sep 25, 2015

Price Changed

$635,000

$160/sq ft

May 1, 2015

Listed

$650,000

$163/sq ft

REColorado as Distributed by MLS Grid #8488520

Jul 1, 2016

Pending

—

Jun 10, 2016

Price Changed

$625,000

$157/sq ft

Oct 22, 2015

Price Changed

$650,000

$163/sq ft

Oct 22, 2015

Price Changed

$624,999

$157/sq ft

Oct 22, 2015

Price Changed

$625,500

$157/sq ft

Oct 20, 2015

Price Changed

$625,000

$157/sq ft

Sep 28, 2015

Price Changed

$635,000

$160/sq ft

May 1, 2015

Relisted

—

Nov 17, 2014

Listing Removed

—

Nov 7, 2014

Price Changed

$650,000

$163/sq ft

Sep 10, 2014

Price Changed

$675,000

$170/sq ft

May 12, 2014

Price Changed

$699,900

$176/sq ft

Feb 28, 2014

Listed

$700,000

$176/sq ft

IRES as Distributed by MLS Grid #746759

Nov 17, 2014

Listing Removed

—

Sep 11, 2014

Price Changed

$650,000

$163/sq ft

Sep 10, 2014

Listed

$675,000

$170/sq ft

IRES as Distributed by MLS Grid #728648

Sep 10, 2014

Listing Removed

—

May 12, 2014

Price Changed

$699,900

$176/sq ft

Feb 28, 2014

Listed

$700,000

$176/sq ft

Public Records

Sep 27, 2002

Sold

$499,900

$126/sq ft

IRES as Distributed by MLS Grid #339769

Aug 15, 2002

Sold

$499,900

$126/sq ft

May 31, 2002

Listed

$499,900

$126/sq ft

IRES as Distributed by MLS Grid #332495

May 31, 2002

Listing Removed

—

Mar 25, 2002

Listed

$549,000

$138/sq ft

IRES as Distributed by MLS Grid #318656

Nov 21, 2001

Listing Removed

—

Sep 25, 2001

Listed

$550,000

$138/sq ft

IRES as Distributed by MLS Grid #310666

Sep 25, 2001

Listing Removed

—

Jul 2, 2001

Listed

$599,000

$151/sq ft

Public Records

Jun 24, 1999

Sold

$300,000

$75/sq ft

IRES as Distributed by MLS Grid #198453

Jun 23, 1999

Listing Removed

—

Mar 4, 1999

Listed

$300,000

$75/sq ft

Public Records

Aug 5, 1993

Sold

$32,500

$8/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$9,863 (+12.2%)

$62,131 + $20,406

$82,537

2024

$8,789 (+1.6%)

$62,131 + $20,406

$82,537

2023

$8,653 (+20.0%)

$53,271 + $31,410

$84,681

2022

$7,211 (+0.8%)

$56,957 + $31,410

$88,367

2021

$7,155 (+28.7%)

$51,152 + $17,292

$68,444

2020

$5,560 (+1.5%)

$52,624 + $17,789

$70,413

2019

$5,477 (+21.6%)

$19,806 + $34,842

$54,648

2018

$4,505 (+1.6%)

$19,806 + $34,842

$54,648

2017

$4,434 (+12.9%)

$19,728 + $25,337

$45,065

2016

$3,927 (+6.0%)

$19,728 + $25,337

$45,065

2015

$3,704 (+4.7%)

$27,542 + $11,622

$39,164

2014

$3,537 (+9.6%)

$5,492 + $31,195

$36,687

2013

$3,227 (+17.7%)

$5,492 + $31,195

$36,687

2012

$2,743 (+7.6%)

$5,492 + $31,195

$36,687

2011

$2,549 (−10.0%)

$12,258 + $19,263

$31,521

2010

$2,832 (+4.6%)

$12,258 + $19,263

$31,521

2009

$2,708

$15,150 + $19,820

$34,970

Public record

Public record
Zoning

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

37.48 Acres

Year renovated

2010

Finished Sq. Ft.

3,976

Unfinished Sq. Ft.

—

Total Sq. Ft.

3,976

Year built

1995

Style

Mobile/Manufactured Home

County

Boulder County

APN

R0077803

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 2, 2026.

Agricultural District

Rural areas where conservation of agricultural resources is of major value, and where residential development compatible with agricultural uses is allowed.

Permitted uses

Include but are not limited to:

Agriculture
Equestrian facility
Livestock production
Religious facility
Day care facility
Housing-Group
Housing-Single unit
Bed & breakfast
Educational/school
Kennel

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

7/10 Fire Factor

15% chance of being in a wildfire in next 30 years

2/10 Heat Factor

0 hot days expected this year, 0 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Lyons, CO • 80540

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

84/ 100

Very good sunlight

Sunscore

There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

9.4 hrs

6.1 hrs

JuneDecember

Provided by Shadowmap

Redfin Estimate for 952 Steamboat Valley Rd

We cannot show automated home-value estimates for this home.

Nearby homes have recently sold between $815,000 and $1,342,500.

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $815K to $1.3M.

SOLD MAR 26, 2026
$815,000 Last sold price
3 beds2.5 baths2,758 sq ft
5306 Foothills Dr, Berthoud, CO 80513
$46/sq ft
smaller lot
1 year newer
SOLD AUG 20, 2026
$1,275,000 Last sold price
4 beds3.5 baths4,728 sq ft
119 Eagle Canyon Cir, Lyons, CO 80540
$20/sq ft
smaller lot
4 years newer
SOLD DEC 19, 2025
$910,000 Last sold price
4 beds3.5 baths4,868 sq ft
105 Eagle Canyon Cir, Lyons, CO 80540
$63/sq ft
smaller lot
4 years newer
SOLD JUN 22, 2026
$891,000 Last sold price
2 beds2.5 baths2,558 sq ft
122 Longs Peak Dr, Lyons, CO 80540
$98/sq ft
smaller lot
2 years older
SOLD JUL 7, 2026
$1,342,500 Last sold price
5 beds4 baths2,728 sq ft
125 Longs Peak Dr, Lyons, CO 80540
$242/sq ft
smaller lot
16 years older
SOLD JUL 24, 2026
$979,900 Last sold price
4 beds2 baths3,314 sq ft
5001 W County Road 4, Berthoud, CO 80513
$46/sq ft
smaller lot
23 years older

Tour for free, no strings attached

Make a winning offer with the help of a local agent

(720) 897-0763