Last Sold Price
4 beds4,436 sqft$365/sqft
174 N Cedar Brook Rd, Boulder, CO 80304

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.
LISTING CLOSED: 05/12/2025 12:00 AM

  1. Listed by Brian McCann • McCann Real Estate
    P: (303)-823-5466 C: (303)-551-4162 brianmccannrealestate@gmail.com
  2. Listed by Mace McCann • McCann Real Estate
    P: (970)-344-9950 C: (970)-344-9950 macesells303@gmail.com

Property Details for 174 North Cedar Brook Road

Status
MLS #
1030573
Days on Compass
3
Taxes
$7,339 / year
HOA Fees
$125 / year
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
1977
Lot Size
1.11 AC / 48,351 SF
Locale
Boulder
Description 1
House

Location

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

Sold By Compass - Boulder, Alissa Peterson

Add your commute

Building Information for 174 North Cedar Brook Road

Stories-Year Built1977Building Size-Lot Size1.11 AC / 48,351 SF

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

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
Public - K to 5
Public - 6 to 8
Public - 9 to 12
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

$1,650,000 | 1800 Sumac Avenue, Boulder, CO 80304
1/37

MLS #1065759

Listed By Coldwell Banker RealtyVirtual Tour

$1,650,000

7
Bedrooms
3,991
Square Feet
0.47
Acres
$2,800,000 | 2550 Balsam Drive, Boulder, CO 80304
1/50

milehimodern - Boulder • MLS #1065769

Coming SoonVirtual Tour

$2,800,000

4
Bedrooms
3,022
Square Feet
0.21
Acres
$595,000 | 1380 Rosewood Avenue, Unit E, Boulder, CO 80304
1/37

MLS #1065697

Compass Coming Soon

$595,000

2
Bedrooms
858
Square Feet
6.47
Acres
$1,457,000 | 2447 20th Street, Boulder, CO 80304
1/37

Open Real Estate • MLS #1065712

New

$1,457,000

3
Bedrooms
1,994
Square Feet
0.16
Acres
$4,950,000 | 536 Linden Park Drive, Boulder, CO 80304
1/13

Open Real Estate • MLS #1065651

$4,950,000

5
Bedrooms
4,233
Square Feet
0.25
Acres
$1,395,000 | 3416 Iris Court, Boulder, CO 80304
1/30

Maven Group Realty • MLS #1065661

Coming SoonOpen: 8/8 11:00AM - 03:00PM

$1,395,000

5
Bedrooms
2,940
Square Feet
0.15
Acres
$235,000 | 2707 Valmont Road, Unit 202C, Boulder, CO 80304
1/27

MLS #1065463

Listed By Compass

$235,000

1
Bedrooms
576
Square Feet
$1,395,000 | 1095 Terrace Circle South, Boulder, CO 80304
1/29

MLS #1065551

Listed By Coldwell Banker Realty

$1,395,000

4
Bedrooms
4,396
Square Feet
0.12
Acres
$875,000 | 1120 Poplar Avenue, Boulder, CO 80304
1/48

Century 21 Altitude Real Estate, LLC • MLS #4207334

Virtual Tour

$875,000

3
Bedrooms
1,636
Square Feet
0.08
Acres

Nearby home values

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

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.