174 N Cedar Brook Rd, Boulder, CO 80304
OFF MARKET

174 N Cedar Brook Rd
Boulder, CO 80304

  • 4 Beds
  • 3.5 Baths
  • 4,436 sqft (on 1.11 acres)

$1,605,800

Trulia Estimate
as of Jul 16, 2026
Est. Refi. Payment $8,878/mo*
Refinance Your Home

$1,605,800

Trulia Estimate
as of Jul 16, 2026
Est. Refi. Payment $8,878/mo*
Refinance Your Home
4 Beds
3.5 Baths
4,436 sqft
(on 1.11 acres)

Local Information

  • Map ViewExplore the area around 174 N Cedar Brook Rd.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

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 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.
174 N Cedar Brook Rd, Boulder, CO 80304 is a 4 bedroom, 4 bathroom, 4,436 sqft single-family home built in 1977. It last sold for $1,620,000 on May 12, 2025 (4% below the $1,695,000 asking price). It is currently off market. The Trulia Estimate is $1,605,800, with a rent estimate of $7,017/month.

Home Highlights

Parking
2 Car Garage
Outdoor
Deck
A/C
Heating only
HOA
$10/Monthly
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 174 N Cedar Brook Rd

Interior Features

Interior Details
Basement: Full,Partially FinishedNumber of Rooms: 10Types of Rooms: Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Laundry, Living Room, Recreation Room, Study
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 2Number of Bathrooms (three quarters): 1Number of Bathrooms (half): 1Number of Bathrooms (main level): 2
Dimensions and Layout
Living Area: 4436 Square Feet
Appliances & Utilities
Utilities: Natural Gas AvailableAppliances: Electric Range, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, DisposalDishwasherDisposalDryerLaundry: Washer/Dryer HookupMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: Forced AirHas HeatingHeating Fuel: Forced Air
Gas & Electric
Electric: XcelGas: Xcel
Windows, Doors, Floors & Walls
Window: Window Coverings, Wood FramesFlooring: Wood
Levels, Entrance, & Accessibility
Stories: 1Levels: OneAccessibility: Main Floor Bath, Accessible BedroomFloors: Wood
View
Has a ViewView: Hills
Security
Security: Fire Alarm

Exterior Features

Exterior Home Features
Roof: TilePatio / Porch: Deck
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2Other Parking: AttachedNo CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Garage Door Opener,Attached
Frontage
Responsible for Road Maintenance: Public Maintained RoadRoad Surface Type: AsphaltNot on Waterfront
Water & Sewer
Sewer: Septic Tank
Farm & Range
Does Not Include Irrigation Water Rights
Finished Area
Finished Area (above surface): 2522 Square Feet

Property Information

Year Built
Year Built: 1977
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family Residence
Building
Construction Materials: FrameNot a New ConstructionNot Attached Property
Property Information
Usage of Home: Single FamilyNot Included in Sale: Owner's personal property and staging items.Parcel Number: R0034787

Price & Status

Price
List Price: $1,695,000

Active Status

MLS Status: Sold

Location

Direction & Address
City: BoulderCommunity: Pine Brook Hills 4
School Information
Elementary School: OtherJr High / Middle School: OtherHigh School: BoulderHigh School District: Boulder Valley Dist RE2

Building

Building Area
Building Area: 2522 Square Feet

Community

Community Features: Park, Trail(s)

HOA

Has an HOAHOA Fee: $125/Annually

Lot Information

Lot Area: 1.1117 Acres

Listing Info

Special Conditions: Private Owner

Offer

Listing Terms: Cash, Conventional, FHA, VA Loan, 1031 Exchange

Miscellaneous

BasementMls Number: 1030573Attribution Contact: 303-823-5466Above Grade Unfinished Area: 2522Activation Date: Tue Apr 08 2025Showing Service Name: ShowingTime

Additional Information

ParkTrail(s)
Last check for updates: about 4 hours ago
Listed by Brian McCann, (303) 823-5466
McCann Real Estate
Mace McCann, (970) 344-9950
McCann Real Estate
Bought with: Alissa Peterson, (720) 648-4144, Compass - Boulder
Source: IRES as distributed by MLS GRID, MLS#1030573

Price History for 174 N Cedar Brook Rd

DatePriceEventSource
05/12/2025$1,620,000Sold
IRES as distributed by MLS GRID #1030573
04/10/2025$1,695,000PendingIRES as distributed by MLS GRID #1030573
04/09/2025$1,695,000Listed For SaleIRES as distributed by MLS GRID #1030573
10/20/2017$795,000Sold
IRES as distributed by MLS GRID #826314
09/13/2017$819,000PendingAgent Provided
08/16/2017$819,000PriceChange
Agent Provided
07/14/2017$850,000PendingToActiveAgent Provided
07/13/2017$850,000PendingAgent Provided
07/13/2017$850,000PendingToActiveAgent Provided
07/13/2017$850,000PendingAgent Provided
07/13/2017$850,000Listed For SaleAgent Provided

Market trends in Boulder

Last updated June 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$891K
$60.83KMoM
Sale-to-List Price
98.2%
0.4%MoM
Price per sq ft
$503
$2MoM
Available listings
778
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$7,339
Assessment$1,275,100
Home facts updated by county records

Comparable Sales for 174 N Cedar Brook Rd

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
93 Pine Needle Rd, Boulder, CO
0.10
Single-Family Home
$1,200,000
12/31/25
4
4
2,651
1577 Linden Drive, Boulder, CO
0.28
Single-Family Home
$1,500,000
02/25/26
4
3
4,220
71 Ridge Dr, Boulder, CO
0.62
Single-Family Home
$1,800,000
01/12/26
3
3.5
4,013
37 Wagner Cir, Boulder, CO
0.77
Single-Family Home
$1,600,000
08/22/25
6
4
5,195
2433 Linden Dr, Boulder, CO
0.72
Single-Family Home
$1,400,000
02/06/26
3
2.5
3,151
994 Timber Lane, Boulder, CO
0.75
Single-Family Home
$1,610,000
02/03/26
3
2.5
3,328
1472 Timber Ln, Boulder, CO
0.85
Single-Family Home
$2,900,000
06/11/26
4
3.5
3,983
795 Pine Brook Rd, Boulder, CO
0.60
Single-Family Home
$2,175,000
04/03/26
4
4
3,129
230 Cactus Ct, Boulder, CO
0.64
Single-Family Home
$2,868,000
02/17/26
3
2.5
3,476
468 Locust Pl, Boulder, CO
0.60
Single-Family Home
$1,784,280
09/30/25
5
3
4,248

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 174 N Cedar Brook Rd.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Boulder

At least 537 Trulia users voted on each feature.

  • 94 % Say it's dog friendly

  • 90 % Say there are sidewalks

  • 81 % Say people would walk alone at night

  • 81 % Say parking is easy

  • 75 % Say there's wildlife

  • 72 % Say it's walkable to restaurants

  • 71 % Say it's walkable to grocery stores

  • 67 % Say there's holiday spirit

  • 65 % Say yards are well-kept

  • 64 % Say it's quiet

  • 61 % Say kids play outside

  • 59 % Say neighbors are friendly

  • 58 % Say car is needed

  • 53 % Say streets are well-lit

  • 51 % Say they plan to stay for at least 5 years

  • 39 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Nancypautsch
    "This is a dog friendly neighborhood. Several neighbors have dogs that they walk which is fun to see. We don’t presently have dogs, but we always had one to two dogs with our three kids as they were growing up. Pets definitely are park of a neighborhood community. "
    0
    Flag
  • Trulia User
    "There’s the Boulder Creek festival, which is all right.. otherwise the neighbors really just keep to themselves"
    0
    Flag
  • Hwilliams3421
    "I like how we’re all living in separate spaces but we have a communal bond through out the neighborhood. I like how all the dogs are nice and friendly too. "
    0
    Flag
  • Megan La Grave
    "Fantastic neighborhood for all ages and pets! Come walk it sometime and see for yourself. Close to the trails "
    0
    Flag
  • Spencer House
    "This neighborhood is very private and secure. The location is convenient with access to the university, Hospital and many other business. It also supports many bike trails."
    0
    Flag
  • Sage M
    "My commute is quiet - I walk to work most of the year. Cars are not always mindful of pedestrians, but traffic is low and I only rarely have had issues in the last four years. "
    0
    Flag
  • Michelle Lee
    "We have an antique car show on the block once a month during the summer. We are in walking distance to all the events on Pearl Street."
    0
    Flag
  • Siera.kennedy2226
    "The only way I could do that was if you wanted me too I could come and pick it out and then I can go pick up it from your place or you could just pick me out of there "
    0
    Flag
  • J
    "An insulated community. Seemingly progressive but lacking in generosity and very elitist. Good schools if all you care about is academic learning."
    0
    Flag
  • Charnelle Setser
    "Make sure you have a mud room to be able to wash your dogs cu they going to get dirty here but it’s absolutely gorgeous "
    1
    Flag
  • RG
    "There are not many children friendly directly in the area but there is several parks wearily within walking distance. "
    0
    Flag
  • Trulia User
    "Yes I live it hfff everyone is different and it’s just not the i yoi and the i but the people that I love are my "
    0
    Flag
  • Trulia User
    "pretty easy to get around, there's multiple bus transits nearby. pretty easy to catch a bus. its close to the bus station, so when you get on board it's usually empty. great seat priority."
    0
    Flag
  • Trulia User
    "Halloween is crazy busy with tons of kids! Meet friends when walking around wonderland lake. Used to spend lots of time at the pool and tennis courts"
    0
    Flag
  • Trulia User
    "Public transportation is very convenient, my car needs too much work so I am not driving it now. I actually live in Dakota Ridge and used to live on Promontory Ct and Utica Ave, been living in N Boulder for almost 30 years!"
    0
    Flag
  • Trulia User
    "We have Wonderland Lake and the trails and lots of privacy and wildlife. Small town feel with Lucky’s Market & Bakery, Logan’s, China Gourmet and Dagabi Cucina where we see and chat with our neighbors. "
    0
    Flag
  • Trulia User
    "There are great access to public transportation and lots of paths are maintained for biking or for walking"
    0
    Flag
  • Trulia User
    "On the bus line, easy commute! Walk to Table Mesa Shopping Center, King Soopers, Whole Foods, near NCAR, bike to CU."
    0
    Flag
  • Trulia User
    "I’ve lived in Dakota Ridge for 20 years and I love it here. We have a strong and fun dog owner community! We look out for one another😊"
    1
    Flag
  • Trulia User
    "I bike to campus in 20 minutes and it’s great besides the traffic and gas fumes from cars which sucks transit is very good here, bus stops all up and down Broadway."
    0
    Flag
  • Trulia User
    "Great people and fun when the dogs get to play and we talk! So many wonderful people, places to walk to and eat, get coffee,…I’ve lived in the townhomes for 20 years now!"
    0
    Flag
  • Trulia User
    "Lots of open space and dog parks. I take my dog walking there all the time. Great place to meet people and other dog owners and for dogs to play."
    0
    Flag
  • Trulia User
    "Quiet and family friendly. Good hiking, only thing is prices are starting to go up like crazy so that’s unfortunate "
    0
    Flag
  • Trulia User
    "We have neighborhood concerts/block parties. Really great way to connect and hear live music. We also have Farm to Bus, which is a farmer's market on a bus. They have fresh eggs and bread, as well as locally grown honey. There's a park nearby which is a great place to exercise abd chat with other neighbors."
    0
    Flag
  • Trulia User
    "this area is close to campus so there are a lot of college students. that being said, there are also a lot of families as well (it's a mix) and I have found the neighborhood to be very kind and reasonable (i.e. no late and loud partying). everyone I've interacted with has been respectful."
    0
    Flag
  • Trulia User
    "Dogs are happy and can be greeted with their owners while walking in the neighborhood. Close to parks and trails for running and walking."
    0
    Flag
  • Trulia User
    "Quiet and close to the mountains. Great schools. Good shopping nearby. Houses with yards. Nice people."
    1
    Flag
  • Trulia User
    "There are lots of kids in the neighborhood, the supermarket is so close to pick up last minute groceries- a great bakery, coffee shop, Lucky’s of course. The foothills trail is awesome to walk, walk dogs, and play by the lake. And the pool and tennis courts are so much fun!"
    0
    Flag
  • Trulia User
    "Easy to walk on the streets and hiking areas- there is nothing not to like in the Mapleton area- boulder creek is close by so dogs can go swimming too"
    0
    Flag
  • Trulia User
    "Central to everything and great hiking nearby but also noisy, rude college kids. Lots of illegally off leash dogs. "
    1
    Flag
  • Trulia User
    "Lots of dogs around. People are generally respectful of other dogs and keep them on leash. Lots of off-leash trails nearby."
    0
    Flag
  • Trulia User
    "It seems as if most people own dogs . Very dog friendly . Dogs always seem well trained . Dogs also seem very friendly . "
    1
    Flag
  • Trulia User
    "Lovely quiet neighborhood - people are friendly and there is plenty of space to be active. Only 10-15 minutes from trailheads. "
    0
    Flag
  • Trulia User
    "I have lived in North Boulder for 30 years- Wonderland Hills and Dakota Ridge, it has always felt safe here. My children attended Boulder Public Schools, I give the schools an A+! We live a convenient short distance to restaurants, grocery stores, schools, and shopping, ...friends hang out at our house and tell me I’m a great baker of Chocolate Chip Cookies! I love to send them home with cookies or fresh dough to bake cookies with their own families! You should bring your kids to our house on Halloween, what a treat! I walk to Pearl Street by way of Foothills Trail, through beautiful neighborhoods apple orchards, Mt. Sanitas and am fascinated by the rock formations. I bicycle many days a week and many miles, such a perfect location to start from and end up! It’s a family and friends tradition to do the Bolder Boulder on the Monday of Memorial Day weekend, so fun! I have been taking it easy for a while due to some physical injuries, but continue to build up my strength and stamina walking my dog, climbing and hiking - I get a great workout! Here’s a tidbit! Keep your dog on leash and clean u"
    0
    Flag
  • Trulia User
    "The neighborhood is Nice for kids. Would recommend it to families and it is no less safe than other neighborhoods in Boulder. "
    2
    Flag
  • Lee24seven
    "We just moved into the area. We love the peace and quiet of our neighborhood. The surrounding area is open space perfect for hiking. "
    5
    Flag
  • Roguengineer
    "private neighborhood surrounded by open space! convenient to groceries, coffee house, and neighborhood restaurants. great schools, too!"
    1
    Flag
  • Lexi V.
    "It’s not the worst place to live but not ideal if you want peace and quiet. Also tons of dogs out being walked on a regular basis. Ge"
    6
    Flag
  • Kimberly A. J.
    "It’s Boulder, Colorado, what’s not to love? I just hand-fed a hummingbird out of a feeder after mtn climbing in perfect 80 degree sunshine."
    0
    Flag
  • Strike3
    "Amazing neighborhood in great location. Great for families. Walkable to most things including downtown. We love it."
    2
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

308 pet-friendly rentals in Boulder, CO

Explore by feature - Garage

237 rentals with a garage in Boulder, CO

Explore by feature - Air Conditioning

506 rentals with air conditioning in Boulder, CO

Explore by feature - Pool

290 rentals with a pool in Boulder, CO

Explore by feature - Washer/dryer

743 rentals with a washer/dryer in Boulder, CO

Explore by feature - Outdoor Space

100 rentals with an outdoor space in Boulder, CO

Homes for sale near 174 N Cedar Brook Rd

Skip to last item
Skip to first item

Off Market Homes Near 174 N Cedar Brook Rd

Skip to last item
Skip to first item
Based on information submitted to the MLS GRID as of 2026-07-16 07:13:08 PDT. 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. Some IDX listings have been excluded from this website. Click here for more information