OFF MARKET

Off Market May 2024 for $1.9M

$1,948,139

Est. refi paymentEst. refi $12,164/mo

•

2,974

sq ft

3174 Redstone Rd, Boulder, CO 80305

About this home

Unobstructed VIEWS of Devil's Thumb unfold from this immaculately maintained Shanahan Ridge/upper Table Mesa home. Tucked into a private lane, this low-maintenance property boasts unparalleled access to open space, trails and parks. Thoughtfully designed for modern living, an open floorplan seamlessly integrates the living room, dining area and kitchen for a harmonious flow. Vaulted ceilings draw the eyes upward as a vast wall of south-facing windows showcase breathtaking views. A fireplace grounds a large living room w/ a wet bar. Sliding glass doors in a dining area open to an expansive deck in a private backyard poised against a backdrop of mountain views. The kitchen is a chef's dream w/ light wood cabinetry and ample counter space. Retreat to a main-floor primary suite boasting a cozy fireplace, walk-in closet and direct access to the deck. The upper level includes an additional room that offers quiet space for a home office/den. Filled w/ natural light, a garden-level basement offers flexible living space w/ a secondary living area. A 2-car attached garage offers additional storage. Highly sought after South Boulder public schools. Open space trails, Viele Lake, Whole foods, Sobo Rec Center. RTD bus route all within walking distance.

Single-familyProperty Type

1988Year Built

7,239 sq ftLot Size

$655Est. Price/Sq.Ft.

2 car garageParking

Listed by Lynn Ryan • milehimodern - Boulder

Contact: 3034890309

Bought with Tracy Zaik • Compass - Boulder

Redfin checked: a minute ago

•Source:REColorado as Distributed by MLS Grid #IR1004965

Listing provided courtesy of Metrolist,Inc. (REColorado)

Redfin Estimate

$1,948,139

$32K since sold in May 2024$3,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 15% higher than the average sale price ($1.69M) of 6 comparable homes.

SOLD JUL 1, 2026
$1,686,000
A
4 beds3.5 baths2,798 sq ft
2423 Powderhorn Ln, Boulder, CO 80305
SOLD JUN 2, 2026
$1,800,000
B
3 beds2.5 baths2,828 sq ft
1936 Hardscrabble Dr, Boulder, CO 80305
SOLD JUN 22, 2026
$1,650,000
C
5 beds3.5 baths2,794 sq ft
1590 Findlay Way, Boulder, CO 80305
SOLD JUL 2, 2026
$1,420,000
D
5 beds3.5 baths3,148 sq ft
1220 Edinboro Dr, Boulder, CO 80305
SOLD OCT 31, 2025
$2,294,000
E
4 beds3 baths3,292 sq ft
3380 Longwood Ave, Boulder, CO 80305
SOLD JAN 15, 2026
$1,313,368
F
4 beds3.5 baths2,677 sq ft
3196 Galena Way, Boulder, CO 80305

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$316,231

Est. take-home

List your home with Redfin and save $19,481

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$5,128/mo

Redfin rental estimate

List your home for rent

Market trends in 80305, CO

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

98.9%

+0.6% MoM

Median sale price

$993K

$23K MoM

Avg. days on market

43d

3 days MoM

Recently sold homes

9 MoM

New listings for sale

COMING SOON
$999,999
3 beds3 baths3,010 sq ft
2335 Dartmouth Ave, Boulder, CO 80305
Bob Klein • Engel & Voelkers Aspen - Snowmass
OPEN SEP 12, 2PM TO 4PM
$1,250,000
4 beds2 baths1,800 sq ft
2295 Hillsdale Cir, Boulder, CO 80305
$1,250,000
4 beds3 baths2,372 sq ft
1050 Miami Way, Boulder, CO 80305
COMING SOON
$850,000
5 beds2 baths2,800 sq ft
3685 Martin Dr, Boulder, CO 80305
3D WALKTHROUGH
$700,000
4 beds3.5 baths2,379 sq ft
1415 Bradley Dr, Boulder, CO 80305
3D WALKTHROUGH
$1,595,000
4 beds3 baths2,273 sq ft
3310 Heidelberg Dr, Boulder, CO 80305
$725,000
3 beds2 baths1,412 sq ft
1345 Bear Mountain Dr Unit B, Boulder, CO 80305
Colorado Home Source • RE/MAX Alliance
See all

Provided by Redfin

Sale history for 3174 Redstone Rd

Date

Event

Price

IRES as Distributed by MLS Grid #1004965

May 16, 2024

Sold

$1,980,000

$666/sq ft

Apr 5, 2024

Contingent

—

Mar 13, 2024

Listed

$2,095,000

$704/sq ft

+34

Public Remarks

IRES as Distributed by MLS Grid #521539

Jun 17, 2007

Listing Removed

—

Feb 21, 2007

Listed

$950,000

$319/sq ft

IRES as Distributed by MLS Grid #519366

Feb 21, 2007

Listing Removed

—

Jan 30, 2007

Listed

$982,000

$330/sq ft

IRES as Distributed by MLS Grid #499622

Nov 7, 2006

Listing Removed

—

Jul 6, 2006

Listed

$1,049,900

$353/sq ft

IRES as Distributed by MLS Grid #246596

Feb 16, 2001

Sold

$799,000

$269/sq ft

Jan 10, 2001

Listed

$799,000

$269/sq ft

Public Records

Mar 22, 1989

Sold

$244,100

$82/sq ft

Public Records

Aug 26, 1988

Sold

$60,000

$20/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$10,769 (+2.7%)

$56,438 + $56,500

$112,938

2024

$10,485 (+1.8%)

$56,438 + $56,500

$112,938

2023

$10,303 (+18.4%)

$61,124 + $58,176

$119,300

2022

$8,703 (+4.9%)

$64,809 + $58,176

$122,985

2021

$8,299 (+18.3%)

$49,991 + $43,729

$93,720

2020

$7,015 (+1.6%)

$51,430 + $44,988

$96,418

2019

$6,908 (−2.1%)

$48,978 + $31,617

$80,595

2018

$7,058 (+3.2%)

$48,978 + $31,617

$80,595

2017

$6,837 (−2.3%)

$44,784 + $36,619

$81,403

2016

$6,998 (+5.6%)

$44,784 + $36,619

$81,403

2015

$6,626 (+14.1%)

$39,402 + $41,440

$80,842

2014

$5,809 (+2.2%)

$25,950 + $41,623

$67,573

2013

$5,682 (+5.4%)

$25,950 + $41,623

$67,573

2012

$5,388 (+0.9%)

$25,950 + $41,623

$67,573

2011

$5,341 (−1.3%)

$19,900 + $44,417

$64,317

2010

$5,411 (+7.1%)

$19,900 + $44,417

$64,317

2009

$5,053

$36,460 + $30,490

$66,950

Tax history for 3174 Redstone Rd

Year

Property tax

Land + Additions

Assessment*

2025

$10,769 (+2.7%)

$56,438 + $56,500

$112,938

2024

$10,485 (+1.8%)

$56,438 + $56,500

$112,938

2023

$10,303 (+18.4%)

$61,124 + $58,176

$119,300

2022

$8,703 (+4.9%)

$64,809 + $58,176

$122,985

2021

$8,299 (+18.3%)

$49,991 + $43,729

$93,720

2020

$7,015 (+1.6%)

$51,430 + $44,988

$96,418

2019

$6,908 (−2.1%)

$48,978 + $31,617

$80,595

2018

$7,058 (+3.2%)

$48,978 + $31,617

$80,595

2017

$6,837 (−2.3%)

$44,784 + $36,619

$81,403

2016

$6,998 (+5.6%)

$44,784 + $36,619

$81,403

2015

$6,626 (+14.1%)

$39,402 + $41,440

$80,842

2014

$5,809 (+2.2%)

$25,950 + $41,623

$67,573

2013

$5,682 (+5.4%)

$25,950 + $41,623

$67,573

2012

$5,388 (+0.9%)

$25,950 + $41,623

$67,573

2011

$5,341 (−1.3%)

$19,900 + $44,417

$64,317

2010

$5,411 (+7.1%)

$19,900 + $44,417

$64,317

2009

$5,053

$36,460 + $30,490

$66,950

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning
Permits

Beds

Baths

3.5

Stories

—

Lot width

—

Lot depth

—

Lot size

7,239 Sq. Ft.

Year renovated

1999

Sq. Ft.

2,974

Year built

1988

Style

Single Family Residential

County

Boulder County

APN

R0105733

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 2, 2026.

RL-2

Residential-Low 2 District

Medium density residential areas primarily used for small-lot residential development, including without limitation, duplexes, triplexes, or townhouses, where each unit generally has direct access at ground level.

Permitted uses

Include but are not limited to:

Religious facility
Housing-Single unit
Housing-Multiple units
Educational/school
Recreation
Agriculture-Cropland
Park & open space

Property details

Parking

Parking/Garage Information
Parking Total: 2
Garage Spaces: 2
AttachedGarageYN: Yes

Interior

Bedroom Information
Bedrooms Total: 3
Upper Level Bedrooms: 2
Main Level Bedrooms: 1

Bathroom Information
Bathrooms Total Integer: 4
Bathrooms Full: 2
Bathrooms Three Quarter: 1
Bathrooms Half: 1
Upper Level Bathrooms: 1
Main Level Bathrooms: 2
Basement Level Bathrooms: 1

Room 1 Information
Primary Bedroom
Description: Carpet
Length: 21
Width: 15
Level: Main

Room 2 Information
Bedroom
Description: Carpet
Length: 14
Width: 11
Level: Upper

Room 3 Information
Bedroom
Description: Carpet
Length: 13
Width: 11
Level: Upper

Room 4 Information
Dining Room
Description: Carpet
Length: 12
Width: 10
Level: Main

Room 5 Information
Kitchen
Length: 15
Width: 14
Level: Main

Room 6 Information
Laundry
Description: Other
Length: 1
Width: 1
Level: Basement

Room 7 Information
Living Room
Description: Carpet
Length: 21
Width: 15
Level: Main

Room 8 Information
Office
Description: Carpet
Length: 14
Width: 10

Room 9 Information
Level: Main

Room 10 Information
Family Room
Description: Carpet
Length: 23
Width: 22
Level: Basement

Room 11 Information
Level: Upper

Room 12 Information
Level: Main

Room 13 Information
Level: Basement

Interior Features
Interior Features: Eat-in Kitchen,Five Piece Bath,Kitchen Island,Open Floorplan,Pantry,Smart Thermostat,Vaulted Ceiling(s),Walk-In Closet(s),Wet Bar
Appliances: Dishwasher, Disposal, Microwave, Oven, Refrigerator, Self Cleaning Oven
Flooring: Wood
Window Features: Double Pane Windows, Skylight(s), Window Coverings
Other Equipment: Satellite Dish
Laundry Features: In Unit

Basement Information
Has Basement
Basement: Daylight, Full, Sump Pump

Fireplace Information
Fireplace Features: Family Room, Gas, Living Room, Other, Primary Bedroom

Exterior

Building Information
Building Area Total: 2,974
Building Area Source: Assessor
Structure Type: House
Construction Materials: Frame

Exterior Features
Patio And Porch Features: Deck, Patio
Fencing: Fenced
Roof: Metal

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Property Unattached
Living Area: 2,974
Above Grade Finished Area: 2,038
Below Grade Finished Area: 936
Levels: Three Or More
Possible Use: Residential
Ownership: Individual
Security Features: Smoke Detector(s)

Land Information
Vegetation: Wooded

Lot Information
Lot Size Square Feet: 7,239
Lot Size Acres: 0.17
Lot Features: Level, Sprinklers In Front
Water Source: Public
Road Surface Type: Paved
Road Frontage Type: Public
Zoning: RES

Financial

Tax Information
Tax Annual Amount: $8,703
Tax Year: 2022
Parcel Number: R0105733

Utilities

Utility Information
Utilities: Cable Available, Electricity Available, Internet Access (Wired), Natural Gas Available
Sewer: Public Sewer

Heating & Cooling
Cooling: Ceiling Fan(s), Central Air
Heating: Forced Air

Location

HOA Information
Has Association
Association Amenities: Trail(s)
Association Fee: $50
Association Fee Frequency: Monthly
Association Fee Annual: $600
Association Fee Total Annual: $600
Association Fee Includes: Reserves

School Information
Elementary School: Mesa
Elementary School District: Boulder Valley RE 2
Middle Or Junior School: Southern Hills
High School: Fairview
High School District: Boulder Valley RE 2

Public facts

Beds: 3
Baths: 3.5
Sq. Ft.: 2,974
Stories: —
Lot Size: 7,239 square feet
Style: Single Family Residential
Year Built: 1988
Year Renovated: 1999
County: Boulder County
APN: R0105733

Home facts updated by county records on Sep 2, 2026

Around this home

Schools

Mesa Elementary School

Public PreK-5 • Assigned • 0.6mi

9/10

Southern Hills Middle School

Public 6-8 • Assigned • 0.8mi

10/10

Fairview High School

Public 9-12 • Assigned • 0.7mi

10/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Local insights from Redfin agents

There's a distinctly European ease to Boulder — a town where café culture and mountain culture coexist effortlessly. Pearl Street's patios stay full year-round, cyclists outnumber cars on weekend mornings, and the Flatirons loom just close enough to...
2 months ago • Boulder
Chuck Klijewski
Redfin agent
Was this helpful?

Climate risks

1/10 Flood Factor

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

5/10 Fire Factor

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

3/10 Heat Factor

6 days above 90° expected this year, 16 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

2/10 Air Factor

2 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Boulder, CO • 80305

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.4 hours in June and 6.1 hours in December, placing it above the U.S. average for solar exposure.

10.4 hrs

6.1 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.85M – $2.24M

Reach more buyers when you sell with Redfin. Save up to $19,481 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$615,000

2 beds1.5 baths1,064 sq ft

3420 Cripple Creek Sq Unit G20, Boulder, CO 80305

3D WALKTHROUGH

$1,375,000

4 beds3 baths1,788 sq ft

727 Ithaca Dr, Boulder, CO 80305

Chase Diamond • The Diamond Group

OPEN SEP 13, 12PM TO 2PM3D WALKTHROUGH

$1,200,000

4 beds2 baths1,628 sq ft

3620 Silver Plume Ln, Boulder, CO 80305

$750,000

3 beds2 baths1,224 sq ft

905 36th St, Boulder, CO 80303

$899,000

4 beds2 baths1,950 sq ft

110 Mohawk Dr, Boulder, CO 80303

$1,545,000

2 beds2.5 baths1,519 sq ft

22 Artesian Dr, Eldorado Springs, CO 80025

New listings for sale in 80305

COMING SOON

$999,999

3 beds3 baths3,010 sq ft

2335 Dartmouth Ave, Boulder, CO 80305

Bob Klein • Engel & Voelkers Aspen - Snowmass

OPEN SEP 12, 2PM TO 4PM

$1,250,000

4 beds2 baths1,800 sq ft

2295 Hillsdale Cir, Boulder, CO 80305

$1,250,000

4 beds3 baths2,372 sq ft

1050 Miami Way, Boulder, CO 80305

COMING SOON

$850,000

5 beds2 baths2,800 sq ft

3685 Martin Dr, Boulder, CO 80305

3D WALKTHROUGH

$700,000

4 beds3.5 baths2,379 sq ft

1415 Bradley Dr, Boulder, CO 80305

3D WALKTHROUGH

$1,595,000

4 beds3 baths2,273 sq ft

3310 Heidelberg Dr, Boulder, CO 80305

$725,000

3 beds2 baths1,412 sq ft

1345 Bear Mountain Dr Unit B, Boulder, CO 80305

Colorado Home Source • RE/MAX Alliance

Home values near 3174 Redstone Rd

Data from public records.

Address	Redfin Estimate
3008 Redstone Lane #A1, Boulder, CO 2 Beds \| 1 Baths \| 832 Sq. Ft.	$476,088
3006 Redstone Lane #1, Boulder, CO 2 Beds \| 1.5 Baths \| 1064 Sq. Ft.	$552,068

Address	Redfin Estimate
3010 Redstone Lane #H1, Boulder, CO 2 Beds \| 1.5 Baths \| 1064 Sq. Ft.	$539,353
3172 Redstone Road, Boulder, CO 4 Beds \| 4 Baths \| 3740 Sq. Ft.	$1,920,672

Address	Redfin Estimate
3004 Redstone Lane #B1, Boulder, CO 2 Beds \| 1 Baths \| 832 Sq. Ft.	$478,994
3176 Redstone Road, Boulder, CO 4 Beds \| 3.5 Baths \| 3274 Sq. Ft.	$1,806,332

Property information provided by REColorado as Distributed by MLS Grid when last listed in 2024. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

80026 homes for sale
80027 homes for sale
80301 homes for sale
80303 homes for sale
80305 homes for sale

Houses for rent in Boulder	Agents near me	Fort Collins, CO homes for sale	Boulder Housing Market
Houses for sale near me	Denver, CO homes for sale	Aurora, CO homes for sale
Land for sale near me	Colorado Springs, CO homes for sale	Arvada, CO homes for sale
Open Houses near me	Boulder, CO homes for sale	Boulder Property Records
Condos for sale near me	Littleton, CO homes for sale	CO New Listings

Denver homes for sale
Arvada homes for sale
Golden homes for sale

Devil's Thumb-Rolling Hills homes for sale
South Boulder homes for sale
Shanahan Ridge homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 80305, CO

Sale history for 3174 Redstone Rd

Tax history for 3174 Redstone Rd

Public record

Property details

Around this home

Schools

Lifestyle

Local insights from Redfin agents

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 80305

Home values near 3174 Redstone Rd

More real estate resources