Archer Mountain Properties

Save
Ask
Tour
Hide
Share
$1,695,000
11 Days On Site

174 N Cedar Brook Rd
Boulder, CO 80304

For Sale|Single Family Residence|Pending
4
Beds
2
Full Baths
2
Partial Baths
4,436
SqFt
$382
/SqFt
1977
Built
Subdivision:
Pine Brook Hills 4
County:
Boulder
Call Now: 720.523.3624
Is this the home for you? We can help make it yours.
720.523.3624
174 N Cedar Brook Rd174 N Cedar Brook Rd174 N Cedar Brook Rd174 N Cedar Brook Rd
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$7,733
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,695,000
Days On Site 
11 Days
Bedrooms 
4
Inside Area (SqFt) 
4,436 sqft
Total Baths 
4
Full Baths 
2
Partial Baths 
2
Lot Size 
1.11 Acres
Year Built 
1977
MLS® Number 
1030573
Status 
Pending
Property Tax 
$7,339
HOA/Condo/Coop Fees 
$10.42 monthly
Sq Ft Source 
Assessor
Friends & Family
Recent Activity
a week agoListing updated with changes from the MLS®
a week agoStatus changed to Pending
2 weeks agoPrice changed to $1,695,000
2 weeks agoListing first seen on site
General Features
Acres 
1.11
Additional Property Use 
Single Family
Attached Garage 
Yes
Garage 
Yes
Garage Spaces 
2
Number Of Stories 
1
Parking 
Garage Door OpenerAttached
Property Sub Type 
Single Family Residence
Security 
Smoke Detector(s)
Sewer 
Septic Tank
SqFt Above 
2522
SqFt Below 
1914
SqFt Total 
2522
Stories 
One
Style 
Ranch
Utilities 
Natural Gas Available
Zoning 
F
Interior Features
Appliances 
Self Cleaning OvenDishwasherRefrigeratorWasherDryerMicrowaveDisposalOven
Basement 
FullPartially Finished
Heating 
Forced Air
Interior 
Eat-in KitchenOpen FloorplanPantryWalk-In Closet(s)Beamed CeilingsHigh CeilingsCathedral Ceiling(s)
Laundry Features 
In Basement
Window Features 
Window CoveringsWood Frames
Bedroom 2 
Dimensions - 18x13Level - MainArea - 234Description - Carpet
Bedroom 3 
Dimensions - 16x11Level - MainArea - 176Description - Carpet
Bedroom 4 
Dimensions - 14x17Level - MainArea - 238Description - Carpet
Dining Room 
Dimensions - 16x12Level - MainArea - 192Description - Hardwood
Kitchen 
Dimensions - 15x13Level - MainArea - 195Description - Hardwood
Laundry 
Dimensions - 10x9
Living Room 
Dimensions - 16x24Level - MainArea - 384Description - Hardwood
Master Bathroom 
Description - Full Primary Bath
Master Bedroom 
Dimensions - 15x20Level - MainArea - 300Description - Hardwood
RecRoom 
Dimensions - 24x26Level - Basement
Study 
Dimensions - 15x20Level - Basement
Save
Ask
Tour
Hide
Share
Exterior Features
Lot Features 
WoodedRolling SlopeSlopedSteep SlopeRock Outcropping
Patio And Porch 
Deck
Roof 
Concrete
Windows/Doors 
Window CoveringsWood Frames
Community Features
Association Dues 
125
Community Features 
Park
Financing Terms Available 
CashConventionalFHAVA Loan1031 Exchange
HOA Fee Frequency 
Annually
MLS Area 
Suburban Mountains
Roads 
PavedAsphalt
School District 
Boulder Valley Dist RE2
Schools
School District
Boulder Valley Dist RE2
Elementary School
Other
Middle School
Other
High School
Boulder
Listing courtesy of McCann Real Estate


Compensation information displayed on listing details is only applicable to other participants and subscribers of the source MLS.

Information source: Information and Real Estate Services, LLC. Information deemed reliable but not guaranteed by the MLS. Listing 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. Provided for limited non-commercial use only under IRES Rules © Copyright IRES. Digital Millenium Copyright Act

Last checked 2025-04-18 09:02 PM MST.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share