174 North Cedar Brook Road

Sold 5/12/25
Sold 5/12/25
Gallery Image 1
Gallery Image 2
Gallery Image 3
Gallery Image 4
Gallery Image 5
Gallery Image 6
Gallery Image 7
Gallery Image 8
Gallery Image 9
Gallery Image 10
Gallery Image 11
Gallery Image 12
Gallery Image 13
Gallery Image 14
Gallery Image 15
Gallery Image 16
Gallery Image 17
Gallery Image 18
Gallery Image 19
Gallery Image 20
Gallery Image 21
Gallery Image 22
Gallery Image 23
Gallery Image 24
Gallery Image 25
Gallery Image 26
Gallery Image 27
Gallery Image 28
Sold
Last Sold Price
$1,620,000
4 beds4,436 sqft$365/sqft
174 N Cedar Brook Rd, Boulder, CO 80304
Single FamilyProperty Type
1.11 acresLot Size
1977Year Built
$365/sq ftPrice per sq ft
$125/yrHOA Fees
2 carsParking Spaces

Description

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...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.
  • Listed by: Brian McCann 303.823.5466 brianmccannrealestate@gmail.com • McCann Real Estate
  • Listed by: Mace McCann 970.344.9950 macesells303@gmail.com • McCann Real Estate
Listing closed: 05/12/2025 12:00 AM • Source: IRES as distributed by MLS GRID, MLS#: 1030573

Recent comparable sales

Median sold price

$1,814,500

Avg days on market

72

Sale-to-list ratio

93.0%

Boulder, CO

9 comparable properties found

a front view of a house with a yard
1/41
1

$1,610,000

Sold 02/03/25

4
Bedrooms
3,812
Square Feet
0.26
Acres

1258 Oakleaf Circle, Boulder, CO 80304

$1,450,000 | 28 Pine Brook Road, Boulder, CO 80304
1/48
2

$1,450,000

Sold 07/16/26

4
Bedrooms
4,229
Square Feet
1.49
Acres

28 Pine Brook Road, Boulder, CO 80304

$1,820,000 | 995 Quince Avenue, Boulder, CO 80304
1/51
3

$1,820,000

Sold 07/14/26

4
Bedrooms
3,794
Square Feet
0.18
Acres

995 Quince Avenue, Boulder, CO 80304

a view of a house with a yard
1/41
4

$1,895,000

Sold 02/21/25

4
Bedrooms
4,023
Square Feet
0.17
Acres

1465 Periwinkle Drive, Boulder, CO 80304

a front view of a house with garden
1/41
5

$1,625,000

Sold 01/16/25

4
Bedrooms
3,784
Square Feet
0.16
Acres

2160 Jonathan Place, Boulder, CO 80304

an aerial view of a house
1/40
6

$1,500,000

Sold 02/25/26

4
Bedrooms
4,220
Square Feet
3.34
Acres

1577 Linden Drive, Boulder, CO 80304

a view of a house with a yard
1/33
7

$2,000,000

Sold 03/28/25

4
Bedrooms
4,025
Square Feet
0.22
Acres

3584 Kirkwood Place, Boulder, CO 80304

$1,814,500 | 2167 Jordan Place, Boulder, CO 80304
1/41
8

$1,814,500

Sold 06/12/25

4
Bedrooms
4,570
Square Feet
0.19
Acres

2167 Jordan Place, Boulder, CO 80304

a view of a house with a small yard plants and large tree
1/34
9

$1,942,500

Sold 08/06/25

4
Bedrooms
3,526
Square Feet
0.12
Acres

3865 Newport Lane, Boulder, CO 80304

Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of McCann Real Estate, Brian McCann; McCann Real Estate, Mace McCann

Sold By Compass - Boulder, Alissa Peterson

Add your commute

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$8,856 per month

30 year fixed, 6.55% Interest

Principal and Interest

$8,234

Property Taxes

$612

HOA Dues

$10

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 174 North Cedar Brook Road

Property Details
  • Taxes: $7,339 / year
  • MLS Type: Residential / Single Family Residence
  • County: Boulder County
  • Locale: Boulder
  • Description 1: House
Building Information
  • Year Built: 1977
  • Lot Size: 1.11 AC / 48,351 SF
Summary
Location and General Information
  • Road Access 2: County Maintained
  • Latitude: 40.05
  • Longitude: -105.30
Parking
  • Garage SqFt: 576
  • Total Parking: 2.00
  • Parking Features: Garage Door Opener, Attached
Taxes and HOA Information
  • Has HOA: Yes
  • HOA Fee: $125.00
  • Legal Description: LOT 226 PINE BROOK HILLS 4
  • Tax Information: No
  • Has HOA 2: No
  • HOA2 Fee Amount: $0
  • Tax Year: 2024
  • Association Fee Frequency: Annually
  • HOA Transfer Fee: No
  • Has Association Fee: Yes
  • Has Association Reserve: No
  • Tax Annual Amount: $7,339
  • Parcel Number: R0034787
Property
Lot Information
  • Lot Improvements: Wooded, Evergreen Trees, Deciduous Trees, Native Grass, Rolling Lot, Sloping Lot, Steep Lot, Rock Outcropping, Paved, Fire Hydrant within 500 Feet
  • Lot Size Area: 48,424.00
  • Has Irrigation Water Rights: No
  • Has Improvements: No
  • Vegetation: Grassed, Wooded
Property and Assessments
  • Total Finished Area Source: Assessor
  • Living SqFt: 2522
  • Above Grade Finished Area Source: 2522
  • Sq Ft Apx: 1914
  • Total Finished Area: 4436
  • Property Attached YN: No
  • Are Ditches Active: No
  • New Construction YN: No
  • Levels: One
Utilities
  • Electric: Xcel
  • Sewer: Septic Tank
Interior and Exterior Features
Exterior Features
  • Construction Materials: Frame
  • Flooring: Wood
Interior Features
  • Interior Features: Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Wood Windows, Natural Woodwork, Walk-In Closet(s), Washer/Dryer Hookup, Beamed Ceilings, Full Primary Bath
  • Laundry Features: Electric Range, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
  • Window Features: Window Coverings
  • All Bedrooms Conform: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Rough-in Bathrooms: 0
  • Three Quarters Bathrooms: 1
  • Baths Full Additional: 0
  • Baths Full Basement: 1
  • Baths Full Upper: 0
  • Baths Full Main: 1
  • Baths Full Lower: 0
  • Baths Half Additional: 0
  • Baths Half Basement: 0
  • Baths Half Upper: 0
  • Baths Half Main: 1
  • Baths Half Lower: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 1
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0
  • Baths Three Quarters Main: 0
Room Information
Room 1
  • RoomDescription: Carpet
  • RoomLength: 18.0
  • RoomLevel: Main
  • RoomType: Bedroom 2
  • RoomWidth: 13.0
Room 2
  • RoomDescription: Carpet
  • RoomLength: 16.0
  • RoomLevel: Main
  • RoomType: Bedroom 3
  • RoomWidth: 11.0
Room 3
  • RoomDescription: Carpet
  • RoomLength: 14.0
  • RoomLevel: Main
  • RoomType: Bedroom 4
  • RoomWidth: 17.0
Room 4
  • RoomDescription: Hardwood
  • RoomLength: 16.0
  • RoomLevel: Main
  • RoomType: Dining Room
  • RoomWidth: 12.0
Room 5
  • RoomDescription: Hardwood
  • RoomLength: 15.0
  • RoomLevel: Main
  • RoomType: Kitchen
  • RoomWidth: 13.0
Room 6
  • RoomLength: 10.0
  • RoomLevel: Basement
  • RoomType: Laundry
  • RoomWidth: 9.0
Room 7
  • RoomDescription: Hardwood
  • RoomLength: 16.0
  • RoomLevel: Main
  • RoomType: Living Room
  • RoomWidth: 24.0
Room 8
  • RoomDescription: Hardwood
  • RoomLength: 15.0
  • RoomLevel: Main
  • RoomType: Primary Bedroom
  • RoomWidth: 20.0
  • Room Features: Full Primary Bath
Room 9
  • RoomLength: 24.0
  • RoomLevel: Basement
  • RoomType: Recreation Room
  • RoomWidth: 26.0
Room 10
  • RoomDescription: Carpet
  • RoomLength: 15.0
  • RoomLevel: Basement
  • RoomType: Study
  • RoomWidth: 20.0
Rental
Rental Information
  • Horse YN: No
  • Occupant Type: Owner

Property History for 174 North Cedar Brook Road

DateEvent & SourcePriceAppreciation
May 12, 2025

Sold (Public Record)

Public Record #1557748514

$1,620,000

+9.9% / yr

Oct 20, 2017

Sold (Public Record)

Public Record #607509197

$795,000—
DateEvent & SourcePrice
05/12/2025

Sold (Public Record)

Public Record #1557748514

$1,620,000

+9.9% / yr

10/20/2017

Sold (Public Record)

Public Record #607509197

$795,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 174 North Cedar Brook Road

Taxable ValueLand$21,264Additions$65,443Total$86,707
Tax Record2025$7,845 ($654 / month)
Home Facts
Beds4Baths3Total Finished SqFt6,350 SqFtAbove Grade Finished SqFt4,436 SqFtFinished Basement SqFt1,914 SqFtStories1Lot Size48,424 SqFtStyleSingle Family ResidenceYear Built1977Year Renovated2001ZoningFCountyBOULDERAPNR0034787

Schools near 174 North Cedar Brook Road

This home is within Boulder Valley Re 2 School District.
Rating
School
Type
Grades
Distance
Foothill Elementary School
Public - K to 5
Centennial Middle School
Public - 6 to 8
Boulder High School
Public - 9 to 12
University Hill Elementary School
Public - PK to 5
Rating
School
Distance
Foothill Elementary School
PublicK to 5

Centennial Middle School
Public6 to 8

Boulder High School
Public9 to 12

University Hill Elementary School
PublicPK to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 80304

$289,900 | 3765 Birchwood Drive, Unit 49, Boulder, CO 80304
1/29

Thrive Real Estate Group • MLS #2698635

New

$289,900

1
Bedrooms
684
Square Feet

3765 Birchwood Drive, Unit 49, Boulder, CO 80304

$2,900,000 | 1510 Violet Avenue, Boulder, CO 80304
1/21

Windemere Realty Inc., Non-IRES • MLS #1067507

$2,900,000

Unavailable
Bedrooms
Unavailable
Bathrooms
Unavailable
Square Feet
1
Acres

1510 Violet Avenue, Boulder, CO 80304

$1,095,000 | 3027 11th Street, Boulder, CO 80304
1/40

RE/MAX of Boulder, Inc • MLS #1067342

$1,095,000

3
Bedrooms
1,061
Square Feet
0.14
Acres

3027 11th Street, Boulder, CO 80304

$398,000 | 1111 Maxwell Avenue, Unit 228, Boulder, CO 80304
1/44

Sandrock Real Estate • MLS #1067381

$398,000

2
Bedrooms
816
Square Feet
1.36
Acres

1111 Maxwell Avenue, Unit 228, Boulder, CO 80304

$899,900 | 1552 Oak Avenue, Boulder, CO 80304
1/49

MLS #1067390

Listed By CompassVirtual Tour

$899,900

4
Bedrooms
1,584
Square Feet

1552 Oak Avenue, Boulder, CO 80304

$665,000 | 2693 Juniper Avenue, Boulder, CO 80304
1/41

MLS #1067410

Listed By Compass

$665,000

3
Bedrooms
1,554
Square Feet

2693 Juniper Avenue, Boulder, CO 80304

$1,650,000 | 4859 Dakota Boulevard, Boulder, CO 80304
1/27

RE/MAX Alliance-Boulder • MLS #1067416

$1,650,000

6
Bedrooms
3,836
Square Feet
0.19
Acres

4859 Dakota Boulevard, Boulder, CO 80304

$1,450,000 | 630 Terrace Avenue, Unit B, Boulder, CO 80304
1/28

MLS #1067304

Listed By Compass

$1,450,000

2
Bedrooms
1,692
Square Feet
0.73
Acres

630 Terrace Avenue, Unit B, Boulder, CO 80304

$300,000 | 3765 Birchwood Drive, Unit 52, Boulder, CO 80304
1/35

RE/MAX Alliance • MLS #2044672

$300,000

1
Bedrooms
624
Square Feet

3765 Birchwood Drive, Unit 52, Boulder, CO 80304

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 174 North Cedar Brook Road, Boulder, CO 80304
$1,620,000
4
4,436
48,351
156 North Cedar Brook Road, Boulder, CO 80304
–
3
1.5
1,710
41,826
194 Meadowlook Way, Boulder, CO 80304
–
3
1.75
2,404
168,227
27 Pine Needle Road, Boulder, CO 80304
$663,000
4
2,495
37,026
193 North Cedar Brook Road, Boulder, CO 80304
–
3
2.5
2,462
35,472
98 North Cedar Brook Road, Boulder, CO 80304
–
3
1.75
1,865
39,795

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of McCann Real Estate, Brian McCann; McCann Real Estate, Mace McCann

Based on information submitted to the MLS GRID as of 05/12/2026 04:16 AM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.