Tour
$10,000 Closing Credit¹
#IR1024333, Nicholas Quenzer, Listing Office: Compass-Denver
#IR1030573·
Listing office: McCann Real Estate·
Listing agent: Brian McCann·
Listing office phone: 3038235466
$1,695,000 List price
174 N Cedar Brook Rd Boulder, CO 80304
$10,000
Closing credit¹
4 beds
2 full, 2 partial
4,436 sqft
1.1 acres
$382 / sqft
House
Property details
About 174 N Cedar Brook Rd
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.
Highlights
Home typeSingle Family Residence
HeatingForced Air
StatusSale Pending
(Pending)
(Pending)
Size4,436 sqft
BasementYes
Lot size1.11 Acres
Year built1977
MLS #IR1030573
Attached garage2 spaces
ViewMountain(s)
Summary
- MLS Number: IR1030573
- MLS Name: RECOLORADO
- Office Name: McCann Real Estate
- Office Phone: (303) 823-5466
- Listing Agent: Brian McCann
Listings courtesy of REColorado as distributed by MLS GRID.
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.
©2025 METROLIST, INC., DBA RECOLORADO® - All Rights Reserved.
Presented by Rocket Homes Real Estate, LLC
Licensed in Colorado Brokerage License # EC. 100073419
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Rocket Homes Real Estate, LLC are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved
6455 S. Yosemite St., Suite 300
Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 4/17/2025, 5:12:53 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$1,695,000
174 N Cedar Brook Rd
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Oct 20, 2017 | Home Sold | $795,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2023 | $84,688 | $7,218 |
| 2022 | $68,548 | $6,670 |
| 2021 | $70,521 | $6,348 |
| 2020 | $56,986 | $5,276 |
| 2019 | $57,384 | $4,671 |
| 2018 | $50,198 | $4,530 |
| 2017 | $50,198 | $4,043 |
History based on county public records data.
Nearby schools
8
Foothill Elementary School
Public District KG-5
1.5 mi
•1001 Hawthorn Ave
7
Crest View Elementary School
Public District KG-5
1.5 mi
•1897 Sumac Ave
5
Columbine Elementary School
Public District PK-5
2.2 mi
•3130 Repplier St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $142,857. The majority of Boulder, CO residents have income $200k+ annually. The majority of families are married, no kids. The most common level of education of people living in this area is post secondary degree.
How much money do the neighbors make?
8%
<35k
24%
35k-100k
30%
100k-200k
38%
200k+
What level of education do the neighbors have?
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
26%
Single, No Kids
4%
Single, with Kids
52%
Married, No Kids
18%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
10%
<11 yrs old
6%
12-17 yrs old
9%
18-34 yrs old
53%
35-64 yrs old
22%
65+ yrs old
What do the neighbors do for fun?
Skiing/snowboarding
PGA/LPGA
Yoga/pilates
Where do the neighbors shop?
BJs Wholesale Club
Stein Mart
H&M
Where do the neighbors go to eat?
Panera
Cracker Barrel
Dominos Pizza
What do the neighbors drive?
Infiniti
Lexus
Audi
What do the neighbors listen to?
Adult Hits
Oldies- Alternative
All data provided by Home Junction and Claritas
Similar homes for sale
Tour
$10,000 Closing Credit¹
#6424854, Nicholas Quenzer, Listing Office: Compass - Denver
7 days on RocketTour
$10,000 Closing Credit¹
#IR1030749, The Zach Zeldner Team, Listing Office: Compass - Boulder
2 days on Rocket
$10,000 Closing Credit¹
#IR1031173, Ryan McIntosh, Listing Office: LIV Sotheby's Intl Realty
$10,000 Closing Credit¹
#1028670, David Mans, Listing Office: Compass - Boulder
$10,000 Closing Credit¹
#IR1028347, John Hoeffler, Listing Office: WK Real Estate
Tour
$10,000 Closing Credit¹
#IR1028204, Terry Larson, Listing Office: RE/MAX of Boulder, Inc
Tour
$10,000 Closing Credit¹
#4874007, Tracy Colburn, Listing Office: Due South Realty
$10,000 Closing Credit¹
#IR1030219, Chris Cook, Listing Office: Open Real Estate
$10,000 Closing Credit¹
#IR1026738, Michael Hughes, Listing Office: milehimodern - Boulder
Frequently asked questions
About 174 N Cedar Brook Rd
This home is located at 174 N Cedar Brook Rd in Boulder, CO and zip code 80304 in the Pine Brook Hills neighborhood. This 4,436 square foot home, which was built in 1977, sits on a 1.11 acre lot. Features: 4 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since April 9, 2025 and is currently priced at $1,695,000.
In March 2025, from all listings sold in Boulder, CO there were more than 13 sold above asking price, over 69 sold below and more than 26 were sold right at the asked price. The number of homes for sale in Boulder, CO increased by 33.2% between February and March 2025. In March 2025, listings were on the market for 51 days. During the same period, the median list price in this real estate market was $982,256.
From Rocket Homes Real Estate and based on county public records data.