Seller's Agent in 2025
James McCann
McCann Real Estate
(303) 551-4162
1 in this area
61 Total Sales
174 N Cedar Brook Rd Boulder, CO 80304
Pine Brook Hill NeighborhoodEstimated Value: $1,699,000 - $1,868,901
4
Beds
3.5
Baths
4,436
Sq Ft
$397/Sq Ft
Est. Value
Highlights
- Open Floorplan
- View of Hills
- Recreation Room
- Foothill Elementary School Rated A
- Deck
- Wooded Lot
About This Home
As of May 2025Welcome 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.
Last Agent to Sell the Property
McCann Real Estate Brokerage Phone: 3038235466 License #100050003 Listed on: 04/08/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $7,339
Year Built
- Built in 1977
Lot Details
- 1.11 Acre Lot
- Rock Outcropping
- Paved or Partially Paved Lot
- Steep Slope
- Wooded Lot
- Landscaped with Trees
HOA Fees
- $10 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
Home Design
- Tile Roof
Interior Spaces
- 4,436 Sq Ft Home
- 1-Story Property
- Open Floorplan
- Woodwork
- Beamed Ceilings
- Cathedral Ceiling
- Window Treatments
- Living Room
- Dining Room
- Recreation Room
- Wood Flooring
- Views of Hills
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
Kitchen
- Eat-In Kitchen
- Self-Cleaning Oven
- Electric Range
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- Primary Bathroom is a Full Bathroom
- Primary bathroom on main floor
Laundry
- Laundry Room
- Dryer
- Washer
Outdoor Features
- Deck
Schools
- Boulder High School
Utilities
- Forced Air Heating System
- Septic Tank
Listing and Financial Details
- Assessor Parcel Number R0034787
Community Details
Overview
- Pine Brook Hills 4 Subdivision
Recreation
- Park
- Trails
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 8, 2025
Closed on
May 12, 2025
Sold by
Bought by
Seller's Agent
James McCann
McCann Real Estate
Buyer's Agent
Alissa Peterson
Compass - Boulder
List Price
$1,695,000
Sold Price
$1,620,000
Premium/Discount to List
-$75,000
-4.42%
Views
12
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$140,975
Avg. Annual Appreciation
7.88%
Original Mortgage
$1,000,000
Outstanding Balance
$912,185
Interest Rate
4.53%
Mortgage Type
New Conventional
Estimated Equity
$848,790
Purchase Details
Listed on
Jul 12, 2017
Closed on
Oct 10, 2017
Sold by
Bought by
Seller's Agent
William Seaward
HomeSmart Realty
Buyer's Agent
James McCann
McCann Real Estate
List Price
$850,000
Sold Price
$795,000
Premium/Discount to List
-$55,000
-6.47%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.87%
Purchase Details
Closed on
Apr 1, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$263,000
Interest Rate
6.25%
Purchase Details
Closed on
Mar 3, 1977
Bought by
Purchase Details
Closed on
Jul 9, 1976
Bought by
Purchase Details
Closed on
Jun 10, 1975
Bought by
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,620,000 | None Listed On Document | ||
| $795,000 | None Available | ||
| -- | Chicago Title Co | ||
| $121,000 | -- | ||
| $17,000 | -- | ||
| $15,000 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $1,000,000 | ||
| Previous Owner | $263,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 05/12/2025 05/12/25 | Sold | $1,620,000 | -4.4% | $365 / Sq Ft | |
| 04/10/2025 04/10/25 | Pending | -- | -- | -- | |
| 04/08/2025 04/08/25 | For Sale | $1,695,000 | +113.2% | $382 / Sq Ft | |
| 01/28/2019 01/28/19 | Off Market | $795,000 | -- | -- | |
| 10/20/2017 10/20/17 | Sold | $795,000 | -6.5% | $179 / Sq Ft | View Prior Sale |
| 09/11/2017 09/11/17 | Pending | -- | -- | -- | |
| 07/12/2017 07/12/17 | For Sale | $850,000 | -- | $192 / Sq Ft |
Source: IRES MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $7,845 | $86,707 | $21,264 | $65,443 |
| 2025 | $7,845 | $86,707 | $21,264 | $65,443 |
| 2024 | $7,339 | $79,694 | $19,544 | $60,150 |
| 2023 | $7,218 | $81,003 | $19,785 | $64,903 |
| 2022 | $6,671 | $68,548 | $15,839 | $52,709 |
| 2021 | $6,349 | $70,521 | $16,295 | $54,226 |
| 2020 | $5,277 | $56,986 | $22,380 | $34,606 |
| 2019 | $5,196 | $56,986 | $22,380 | $34,606 |
| 2018 | $4,671 | $50,198 | $15,048 | $35,150 |
| 2017 | $4,530 | $55,497 | $16,636 | $38,861 |
| 2016 | $4,044 | $51,390 | $19,184 | $32,206 |
| 2015 | $3,842 | $41,790 | $23,880 | $17,910 |
| 2014 | $3,598 | $41,790 | $23,880 | $17,910 |
Source: Public Records
Agents Affiliated with this Home
-
James McCann
-
Mace McCann
Seller Co-Listing Agent in 2025
Mace McCann
Brokers Guild Real Estate
(970) 344-9950
1 in this area
12 Total Sales
-
Alissa Peterson
Buyer's Agent in 2025
Alissa Peterson
Compass - Boulder
(720) 648-4144
3 in this area
23 Total Sales
-
W
Seller's Agent in 2017
William Seaward
HomeSmart Realty
Map
Source: IRES MLS
MLS Number: IRE1030573
APN: 1461140-02-025
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Based on information submitted to the 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. Some IDX listings have been excluded from this website. 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.
Information deemed reliable but not guaranteed by the MLS.
Based on information submitted to the MLS GRID
Listings courtesy of IRES MLS as distributed by MLS GRID
Nearby Homes
- 194 N Cedar Brook Rd Unit 4
- 142 Meadowlook Way
- 150 Valley View Way
- 166 Valley View Way
- 1573 Linden Dr
- 607 N Cedar Brook Rd
- 1575 Linden Dr
- 634 Fountaintree Ln
- 770 N Cedar Brook Rd
- 865 N Cedar Brook Rd
- 3945 Promontory Ct
- 3132 Linden Dr
- 2990 Linden Dr
- 50 Wildwood Ln
- 3966 Promontory Ct
- 725 Timber Ln
- 28 Pine Brook Rd Unit 1
- 210 Cactus Ct
- 86 S Cedar Brook Rd
- 2857 Linden Dr
- 156 N Cedar Brook Rd
- 196 N Cedar Brook Rd
- 168 Meadowlook Way Unit 4
- 196 N Cedar Brook Rd
- 193 N Cedar Brook Rd
- 194 Meadowlook Way
- 27 Pine Needle Rd
- 166 Meadowlook Way
- 330 N Cedar Brook Rd
- 98 N Cedar Brook Rd
- 371 N Cedar Brook Rd
- 223 N Cedar Brook Rd
- 153 Meadowlook Way
- 450 N Cedar Brook Rd
- 105 N Cedar Brook Rd
- 115 Meadowlook Way
- 62 N Cedar Brook Rd
- 476 N Cedar Brook Rd
- 417 N Cedar Brook Rd
- 118 Meadowlook Way
Your Personal Tour Guide
Ask me questions while you tour the home.