Off market may 2025 for $1.6M

$2,019,219

Est. refi paymentEst. refi $8,708/mo

•

4,436

sq ft

174 N Cedar Brook Rd, Boulder, CO 80304

About this home

Welcome to your forever home: 174 N Cedar Brook Rd, Beautifully updated. Elegant yet contemporary and newly finished throughout this executive family home and mountain retreat in the highly sought-after Pine Brook Hills Multi-Million dollar neighborhood; on a 1 Acre treed setting only 1.5 miles up Linden Ave. An Open and inviting floor plan featuring large wooden Beams from the 1800's accenting Huge living room with fireplace, Large Formal dining room, Chefs gourmet kitchen with custom cabinetry and granite countertops, SS appliances and a large picture window to see the world Main level primary bedroom split from the other bedrooms for comfort and privacy. This home will impress you, your family, and your guests with its perfect blend of modern upgrades, natural beauty, and timeless mountain charm. Tucked among mature pines and dramatic rock outcroppings, this property offers peaceful seclusion just minutes from the heart of downtown Boulder. Inside, you'll find a fresh feel with a myriad of new features, luxury flooring, completely remodeled bathrooms, with custom tile, elegant new light fixtures throughout No detail forgotten. Soaring ceilings and expansive windows fill the home with natural light, while multiple decks invite you to relax, entertain, and soak in the surrounding foothill views. Walk out basement - perfect for guests -, in-laws or Au pair. Whether you're hosting friends or enjoying quiet mornings with coffee and wildlife, this home delivers comfort and style at every turn. Don't miss your chance to own a slice of mountain luxury in one of Boulder's most prestigious neighborhoods.

Single-familyProperty Type

1977Year Built

1.11 acresLot Size

$455Est. Price/Sq.Ft.

2 car garageParking

Listed by Brian McCann • McCann Real Estate

Listed by Mace McCann • McCann Real Estate

Contact: 3038235466

Bought with Alissa Peterson

Redfin checked: a minute ago

•Source:IRES as Distributed by MLS Grid #1030573

Redfin Estimate

$2,019,219

$399K since sold in May 2025$40K since October

Recently sold homes
Estimate history
Homes for sale

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

SOLD SEP 21, 2026
$2,100,000
A
4 beds3 baths3,995 sq ft
252 Pine Tree Ln, Boulder, CO 80304
SOLD OCT 5, 2026
$3,222,000
B
4 beds4.5 baths4,471 sq ft
150 Valley View Way, Boulder, CO 80304
SOLD JUL 30, 2026
$2,100,000
C
4 beds4 baths3,162 sq ft
770 N Cedar Brook Rd, Boulder, CO 80304
Listing provided by metrolistCO
SOLD JUL 16, 2026
$1,450,000
D
4 beds4 baths4,229 sq ft
28 Pine Brook Rd, Boulder, CO 80304
SOLD OCT 13, 2026
$1,500,000
E
5 beds3.5 baths3,712 sq ft
114 Balsam Ln, Boulder, CO 80304
SOLD OCT 15, 2026
$1,500,000
F
4 beds3 baths3,783 sq ft
335 Pine Tree Ln, Boulder, CO 80304

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

Earn from this home

Sell

$638,231

Est. take-home

List your home with Redfin and save $20,192

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$7,805/mo

Redfin rental estimate

List your home for rent

Market trends in 80304, CO

Last updated October 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-list price

97.4%

+0.1% MoM

Median sale price

$1.3M

$110K MoM

Avg. days on market

63d

8 days MoM

Recently sold homes

103

15 MoM

New listings for sale

$300,000
1 bed1 bath400 sq ft
2711 Mapleton Ave #1, Boulder, CO 80304
Lydia Moy • WK Real Estate
3D WALKTHROUGH
$1,050,000
2 beds1 bath1,474 sq ft
3115 Broadway St, Boulder, CO 80304
$1,175,000
3 beds4.5 baths2,992 sq ft
555 Laramie Blvd, Boulder, CO 80304
3D WALKTHROUGH
$1,450,000
4 beds2.5 baths2,554 sq ft
1780 Redwood Ave, Boulder, CO 80304
$985,000
4 beds2 baths1,812 sq ft
2445 Forest Ave, Boulder, CO 80304
$1,200,000
4 beds3.5 baths2,434 sq ft
4747 10th St, Boulder, CO 80304
3D WALKTHROUGH
$749,500
1 bed1 bath617 sq ft
417 Mapleton Ave Unit A, Boulder, CO 80304
VIDEO TOUR
$1,350,000
4 beds2 baths2,014 sq ft
3875 15th St, Boulder, CO 80304
$289,000
1 bed1 bath592 sq ft
3745 Birchwood Dr #34, Boulder, CO 80304
$180,654
2 beds2 baths1,362 sq ft
1734 Yaupon Ave #3, Boulder, CO 80304
See all

Provided by Redfin

Sale history for 174 N Cedar Brook Rd

Date

Event

Price

IRES as Distributed by MLS Grid #1030573

May 12, 2025

Sold

$1,620,000

$365/sq ft

Apr 10, 2025

Pending

—

Apr 8, 2025

Listed

$1,695,000

$382/sq ft

IRES as Distributed by MLS Grid #826314

Oct 20, 2017

Sold

$795,000

$179/sq ft

Sep 12, 2017

Pending

—

Aug 16, 2017

Price Changed

$819,000

$185/sq ft

Jul 14, 2017

Relisted

—

Jul 13, 2017

Listed

—

+26

Public Remarks

Come live the Rocky Mountain experience in this contemporary 4,436 finished SF mountain home in lower Pine Brook Hills on a one acre wooded lot, this beautiful home is located 3 minutes from Broadway, close to downtown Boulder's shops and restaurants and hiking/biking trails. Lodge-like open floor plan featuring large beams from an 1800's warehouse and 2 story moss rock fireplace. 3 bd,3 ba, living room, dining, kitchen, master and office on mail level with finished lower walk-out basement.

REColorado as Distributed by MLS Grid #2502952

Sep 12, 2017

Contingent

—

Aug 16, 2017

Price Changed

$819,000

$185/sq ft

Jul 13, 2017

Listed

$850,000

$192/sq ft

Public Records

Mar 3, 1977

Sold

$121,000

$27/sq ft

Join or sign in to view all info

Year

Property tax

Land + Additions

Assessment*

2025

$7,845 (+6.9%)

$19,544 + $60,150

$79,694

2024

$7,339 (+1.7%)

$19,544 + $60,150

$79,694

2023

$7,218 (+8.2%)

$16,100 + $64,903

$81,003

2022

$6,671 (+5.1%)

$19,785 + $64,903

$84,688

2021

$6,349 (+20.3%)

$15,839 + $52,709

$68,548

2020

$5,277 (+1.6%)

$16,295 + $54,226

$70,521

2019

$5,196 (+11.2%)

$22,380 + $34,606

$56,986

2018

$4,671 (+3.1%)

$22,380 + $34,606

$56,986

2017

$4,530 (+12.1%)

$15,048 + $35,150

$50,198

2016

$4,043 (+5.2%)

$15,048 + $35,150

$50,198

2015

$3,842 (+21.0%)

$19,184 + $32,206

$51,390

2014

$3,176 (−11.7%)

$23,880 + $17,910

$41,790

2013

$3,598 (+61.2%)

$23,880 + $17,910

$41,790

2012

$2,232 (+3.6%)

$23,880 + $17,910

$41,790

2011

$2,155 (−33.7%)

$14,328 + $9,632

$23,960

2010

$3,248 (+5.8%)

$14,328 + $9,632

$23,960

2009

$3,072

$24,680 + $12,340

$37,020

Tax history for 174 N Cedar Brook Rd

Year

Property tax

Land + Additions

Assessment*

2025

$7,845 (+6.9%)

$19,544 + $60,150

$79,694

2024

$7,339 (+1.7%)

$19,544 + $60,150

$79,694

2023

$7,218 (+8.2%)

$16,100 + $64,903

$81,003

2022

$6,671 (+5.1%)

$19,785 + $64,903

$84,688

2021

$6,349 (+20.3%)

$15,839 + $52,709

$68,548

2020

$5,277 (+1.6%)

$16,295 + $54,226

$70,521

2019

$5,196 (+11.2%)

$22,380 + $34,606

$56,986

2018

$4,671 (+3.1%)

$22,380 + $34,606

$56,986

2017

$4,530 (+12.1%)

$15,048 + $35,150

$50,198

2016

$4,043 (+5.2%)

$15,048 + $35,150

$50,198

2015

$3,842 (+21.0%)

$19,184 + $32,206

$51,390

2014

$3,176 (−11.7%)

$23,880 + $17,910

$41,790

2013

$3,598 (+61.2%)

$23,880 + $17,910

$41,790

2012

$2,232 (+3.6%)

$23,880 + $17,910

$41,790

2011

$2,155 (−33.7%)

$14,328 + $9,632

$23,960

2010

$3,248 (+5.8%)

$14,328 + $9,632

$23,960

2009

$3,072

$24,680 + $12,340

$37,020

*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

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

1.11 Acres

Year renovated

2001

Sq. Ft.

4,436

Year built

1977

Style

Single Family Residential

County

Boulder County

APN

R0034787

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 2, 2026.

Forestry District

Rural areas established for the purpose of efficiently using land to conserve forest resources, protect the natural environment, and preserve open areas.

Permitted uses

Include but are not limited to:

Agriculture
Equestrian facility
Livestock production
Housing-Group
Housing-Single unit
Bed & breakfast
Office
Public service
Communications tower
Park & open space

Property details

Parking

Parking Information
Garage Type: Attached
Garage Sq. Ft.: 576
Parking Features: Garage Door Opener, Attached
Garage Spaces: 2

Interior

Virtual Tour

Bedroom Information
# of Bedrooms: 4
All Bedrooms Conform: 1

Bathroom Information
# of Full Baths (Total): 2
# of Three Quarter Baths (Total): 1
# of Half Baths (Total): 1
# of Full Baths (Main): 1
# of Full Baths (Basement): 1
# of Half Baths (Main): 1
# of Three Quarters Baths (Basement): 1

Study Information
Has Study: 1

Family Room Information
Has Family Room: 0

Basement Information
Basement Features: Full, Partially Finished

Heating & Cooling
Heating Information: Forced Air

Interior Features
Interior Features: Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-in Closet(s), Beamed Ceilings
Window Features: Window Coverings
Appliances: Electric Range, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
Flooring: Wood

Exterior

Building Information
Construction Materials: Frame
Roof: Tile

Exterior Features
Patio And Porch Features: Deck

Property Information
Levels: One
Has Improvements: No
Sq. Ft. Main Floor: 2522
New Construction Status: Not New, Previously Owned
Property Type: Residential
Property Sub Type: Single Family Residence
Accessibility Features: Main Floor Bath, Main Level Bedroom
Above Grade Finished Area: 2,522
Below Grade Finished Area: 1,914
Zoning: F

Land Information
Possible Use: Single Family

Lot Information
Flood Plain: Minimal Flood or C Rating
Lot Features: Wooded, Evergreen Trees, Deciduous Trees, Native Grass, Rolling Lot, Sloping Lot, Steep Lot, Rock Outcropping, Paved, Fire Hydrant within 500 Feet
Road Surface Type: Asphalt
Road Frontage Type: County Maintained

Financial

Tax Information
Tax Annual Amount: $7,339
Tax Year: 2024

Utilities

Utility Information
Water Source: District
Has Water Rights: No
Is Water Meter Installed: Yes
Sewer: Septic Tank
Utilities: Natural Gas Available
Gas: Xcel

Location

HOA Information
Association Fee YN: Yes
Association Transfer Fee: No
Association Reserve: No
Has HOA
Association Fee: $125
Association Fee Frequency: Annually

School Information
Elementary School: Other
Middle Or Junior High School: Other
High School: Boulder
High School District: Boulder Valley Dist RE2

Location Information
Directions: Google Maps will provide ample directions

Community Information
Community Features: Park, Trail(s)

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 4,436
Stories: 1.0
Lot Size: 1.11 acres
Style: Single Family Residential
Year Built: 1977
Year Renovated: 2001
County: Boulder County
APN: R0034787

Home facts updated by county records on Sep 2, 2026

Around this home

Schools

K - 12
Preschool & daycare

Foothill Elementary School

Public K-5 • Assigned • 1.5mi

9/10

Centennial Middle School

Public 6-8 • Assigned • 1.9mi

6/10

Boulder High School

Public 9-12 • Assigned • 3.0mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

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

4/10 Fire Factor

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

2/10 Heat Factor

2 days above 92° expected this year, 6 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, 1 days in 30 years

Provided by First Street

Historical weather

Boulder, CO • 80304

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.5 hours in June and 6 hours in December, placing it above the U.S. average for solar exposure.

10.5 hrs

6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.92M – $2.32M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

3D & VIDEO TOUR

$1,850,000

4 beds4 baths2,379 sq ft

1284 Elder Ave, Boulder, CO 80304

Private street • Mature landscaping • Open layout

Listing provided by REColorado as Distributed by MLS Grid

$1,395,000

Land— sq ft

1559 Orchard Ave, Boulder, CO 80304

Shovel ready lot • Mature landscaping

3D WALKTHROUGH

$2,595,000

5 beds3.5 baths2,344 sq ft

3115 3rd St, Boulder, CO 80304

Unobstructed views • Steam shower • Custom kitchen

$1,295,000

4 beds3.5 baths2,202 sq ft

295 Laramie Blvd, Boulder, CO 80304

Private deck • Gas fireplace • Open kitchen

$2,250,000

5 beds4 baths3,926 sq ft

3979 Springleaf Ln, Boulder, CO 80304

Geothermal heating • Solar energy • Stone walkway

Listing provided by REColorado as Distributed by MLS Grid

3D WALKTHROUGH

$6,500,000

3 beds3.5 baths4,065 sq ft

250 Cactus Ct, Boulder, CO 80304

Two primary suites • Spa like bath • Outdoor kitchen

New listings for sale in 80304

$300,000

1 bed1 bath400 sq ft

2711 Mapleton Ave #1, Boulder, CO 80304

Modern appliances • Designated parking • Common laundry

Listing provided by REColorado as Distributed by MLS Grid

3D WALKTHROUGH

$1,050,000

2 beds1 bath1,474 sq ft

3115 Broadway St, Boulder, CO 80304

Goat trail • North boulder park • Mature greenery

$1,175,000

3 beds4.5 baths2,992 sq ft

555 Laramie Blvd, Boulder, CO 80304

End-unit townhome • Corner lot • Brick facade

3D WALKTHROUGH

$1,450,000

4 beds2.5 baths2,554 sq ft

1780 Redwood Ave, Boulder, CO 80304

Designer kitchen • Inviting living room • Mature trees

$985,000

4 beds2 baths1,812 sq ft

2445 Forest Ave, Boulder, CO 80304

Remodeled kitchen • Remodeled bath • Adu potential

$1,200,000

4 beds3.5 baths2,434 sq ft

4747 10th St, Boulder, CO 80304

Open floor plan • Glamorous kitchen • Quartz counter tops

3D WALKTHROUGH

$749,500

1 bed1 bath617 sq ft

417 Mapleton Ave Unit A, Boulder, CO 80304

Remodeled kitchen • Quartz countertops • Tile backsplash

VIDEO TOUR

$1,350,000

4 beds2 baths2,014 sq ft

3875 15th St, Boulder, CO 80304

Fully fenced yard • Vaulted main level • Arched window

$289,000

1 bed1 bath592 sq ft

3745 Birchwood Dr #34, Boulder, CO 80304

Private entrance • Private patio • 0.47 acre lot

Home values near 174 N Cedar Brook Rd

Data from public records.

Address	Redfin Estimate
194 North Cedar Brook Rd, Boulder, CO 4 Beds \| 2.5 Baths \| 2214 Sq. Ft.	—
193 North Cedar Brook Rd, Boulder, CO 3 Beds \| 2.5 Baths \| 2462 Sq. Ft.	$1,239,308
371 North Cedar Brook Rd, Boulder, CO 4 Beds \| 3 Baths \| 2500 Sq. Ft.	$1,243,900
62 North Cedar Brook Rd, Boulder, CO 3 Beds \| 2 Baths \| 2149 Sq. Ft.	$1,173,108
450 North Cedar Brook Rd, Boulder, CO 4 Beds \| 3.5 Baths \| 2948 Sq. Ft.	$1,246,054
168 Meadowlook Way, Boulder, CO 4 Beds \| 4 Baths \| 3840 Sq. Ft.	$1,679,290
115 Meadowlook Way, Boulder, CO 4 Beds \| 3 Baths \| 3009 Sq. Ft.	$1,346,556

Address	Redfin Estimate
330 North Cedar Brook Rd, Boulder, CO 3 Beds \| 3 Baths \| 3178 Sq. Ft.	$1,698,991
223 North Cedar Brook Rd, Boulder, CO 2 Beds \| 1.5 Baths \| 2337 Sq. Ft.	$1,243,379
105 North Cedar Brook Rd, Boulder, CO 3 Beds \| 3.5 Baths \| 3048 Sq. Ft.	$1,778,207
98 North Cedar Brook Rd, Boulder, CO 3 Beds \| 2 Baths \| 1865 Sq. Ft.	$1,208,520
476 North Cedar Brook Rd, Boulder, CO 3 Beds \| 2 Baths \| 2119 Sq. Ft.	$1,008,439
27 Pine Needle Rd, Boulder, CO 4 Beds \| 3 Baths \| 2495 Sq. Ft.	$1,281,272
118 Meadowlook Way, Boulder, CO 3 Beds \| 2 Baths \| 2127 Sq. Ft.	$1,414,599

Address	Redfin Estimate
417 North Cedar Brook Rd, Boulder, CO 3 Beds \| 2.5 Baths \| 3013 Sq. Ft.	$1,434,778
156 North Cedar Brook Rd, Boulder, CO 3 Beds \| 1.5 Baths \| 1710 Sq. Ft.	$1,021,261
60 North Cedar Brook Rd, Boulder, CO 4 Beds \| 3 Baths \| 3930 Sq. Ft.	$1,436,046
425 North Cedar Brook Rd, Boulder, CO 3 Beds \| 2.5 Baths \| 3276 Sq. Ft.	$2,173,885
445 North Cedar Brook Rd, Boulder, CO 3 Beds \| 3 Baths \| 3132 Sq. Ft.	$1,362,578
1596 Linden Dr, Boulder, CO 3 Beds \| 3 Baths \| 3480 Sq. Ft.	$1,865,196
166 Meadowlook Way, Boulder, CO 2 Beds \| 2 Baths \| 3240 Sq. Ft.	$1,411,698

Property information provided by IRES as Distributed by MLS Grid when last listed in 2025. 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.

Redfin Brokerage Licenses

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.

Central Boulder homes for sale
Wonderland Hills homes for sale
North Boulder homes for sale
Newlands homes for sale
Wonderland Lake homes for sale

Houses for rent in Pine Brook Hill	Agents near me	Fort Collins, CO homes for sale	Pine Brook Hill 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	Pine Brook Hill Property Records
Condos for sale near me	Littleton, CO homes for sale	CO New Listings

Denver homes for sale
Boulder homes for sale
Arvada homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 80304, CO

Sale history for 174 N Cedar Brook Rd

Tax history for 174 N Cedar Brook Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 80304

Home values near 174 N Cedar Brook Rd

More real estate resources