Seller's Agent in 2025
James McCann
McCann Real Estate
(303) 551-4162
1 in this area
66 Total Sales
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.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,620,000 | None Listed On Document | |
| Personal Reps Deed | $795,000 | None Available | |
| Interfamily Deed Transfer | -- | Chicago Title Co | |
| Deed | $121,000 | -- | |
| Deed | $17,000 | -- | |
| Warranty Deed | $15,000 | -- |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,000,000 | New Conventional | |
| Previous Owner | $263,000 | No Value Available |
| 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 |
| 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 |
|---|---|---|---|---|
| 2025 | $7,339 | $79,694 | $19,544 | $60,150 |
| 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 |
Seller's Agent in 2025
James McCann
McCann Real Estate
(303) 551-4162
1 in this area
66 Total Sales
Seller Co-Listing Agent in 2025
Mace McCann
McCann Real Estate
(970) 344-9950
1 in this area
11 Total Sales
Buyer's Agent in 2025
Alissa Peterson
Compass - Boulder
(720) 648-4144
3 in this area
25 Total Sales
W
Seller's Agent in 2017
William Seaward
HomeSmart Realty
Source: IRES MLS
MLS Number: 1030573
APN: 1461140-02-025