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.
Sold for $1,620,000
$1,620,000
174 N Cedar Brook Rd, Boulder, CO 80304
4beds
4,436sqft
Single Family Residence
Built in 1977
1.11 Acres Lot
$1,605,900 Zestimate®
$365/sqft
$6,072 Estimated rent
Home value
$1,605,900
$1.49M - $1.72M
$6,072/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 20, 2025 at 09:08pm
Listed by:
Brian McCann 3038235466,
McCann Real Estate,
Mace McCann 970-344-9950,
McCann Real Estate
Bought with:
Alissa Peterson, 100057017
Compass - Boulder
Source: IRES,MLS#: 1030573
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 2
Primary bedroom
- Description: Hardwood
- Features: Full Primary Bath
- Level: Main
- Area: 300 Square Feet
- Dimensions: 20 x 15
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 234 Square Feet
- Dimensions: 13 x 18
Bedroom 3
- Description: Carpet
- Level: Main
- Area: 176 Square Feet
- Dimensions: 11 x 16
Bedroom 4
- Description: Carpet
- Level: Main
- Area: 238 Square Feet
- Dimensions: 17 x 14
Dining room
- Description: Hardwood
- Level: Main
- Area: 192 Square Feet
- Dimensions: 12 x 16
Kitchen
- Description: Hardwood
- Level: Main
- Area: 195 Square Feet
- Dimensions: 13 x 15
Laundry
- Level: Basement
- Area: 90 Square Feet
- Dimensions: 9 x 10
Living room
- Description: Hardwood
- Level: Main
- Area: 384 Square Feet
- Dimensions: 24 x 16
Recreation room
- Level: Basement
- Area: 624 Square Feet
- Dimensions: 26 x 24
Study
- Description: Carpet
- Level: Basement
- Area: 300 Square Feet
- Dimensions: 20 x 15
Heating
- Forced Air
Appliances
- Included: Electric Range, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
- Laundry: Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Natural Woodwork, Walk-In Closet(s), Beamed Ceilings
- Flooring: Wood
- Windows: Window Coverings, Wood Frames
- Basement: Full,Partially Finished
Interior area
- Total structure area: 4,436
- Total interior livable area: 4,436 sqft
- Finished area above ground: 2,522
- Finished area below ground: 1,914
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener
- Attached garage spaces: 2
- Details: Attached
Accessibility
- Accessibility features: Main Floor Bath, Accessible Bedroom
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck
- Has view: Yes
- View description: Hills
Lot
- Size: 1.11 Acres
- Features: Wooded, Evergreen Trees, Deciduous Trees, Native Plants, Rolling Slope, Sloped, Steep Slope, Rock Outcropping, Paved, Fire Hydrant within 500 Feet
Details
- Parcel number: R0034787
- Zoning: F
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame
- Roof: Tile
Condition
- New construction: No
- Year built: 1977
Utilities & green energy
- Electric: Xcel
- Gas: Xcel
- Sewer: Septic Tank
- Water: District
- Utilities for property: Natural Gas Available
Community & neighborhood
Security
- Security features: Fire Alarm
Community
- Community features: Park, Trail(s)
Location
- Region: Boulder
- Subdivision: Pine Brook Hills 4
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $125 annually
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan,1031 Exchange
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 5/12/2025 | Sold | $1,620,000-4.4%$365/sqft |
Source:  IRES #1030573 Report a problem | ||
| 4/10/2025 | Pending sale | $1,695,000$382/sqft |
Source: IRES #1030573 Report a problem | ||
| 4/9/2025 | Listed for sale | $1,695,000+113.2%$382/sqft |
Source: IRES #1030573 Report a problem | ||
| 10/20/2017 | Sold | $795,000-2.9%$179/sqft |
Source: IRES #826314 Report a problem | ||
| 9/13/2017 | Pending sale | $819,000$185/sqft |
Source: HomeSmart Cherry Creek #2502952 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $7,339 +1.7% | $79,694 -5.9% |
| 2024 | $7,218 +8.2% | $84,688 -6.6% |
| 2023 | $6,671 +5.1% | $90,678 +32.3% |
Find assessor info on the county website
Neighborhood: 80304
Nearby schools
GreatSchools rating
- 8/10Foothill Elementary SchoolGrades: K-5Distance: 1.5 mi
- 7/10Centennial Middle SchoolGrades: 6-8Distance: 1.9 mi
- 10/10Boulder High SchoolGrades: 9-12Distance: 3 mi
Schools provided by the listing agent
- High: Boulder
Source: IRES. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell with ease on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for —faster.
$1,605,900
2% more+$32,118
With Zillow Showcase(estimated)$1,638,018