$1,620,000
SOLD MAY 12, 2025
4 Beds
3.5 Baths
4,436 Sq Ft
1.11 Acres

Recently Sold

$365 Per Sq Ft

4% Below List Price

2 Days on Market

Highlights

  • Open Floorplan
  • Deck
  • Cathedral Ceiling
  • Foothill Elementary School Rated A
  • Wooded Lot
  • Wood Flooring

About This Home

As of May 2025

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.

Last Agent to Sell the Property

James McCann

McCann Real Estate Listed on: 04/08/2025

Co-Listed By

Mace McCann

McCann Real Estate

Last Buyer's Agent

Alissa Peterson

Compass - Boulder

Compass - Boulder

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,339

Year Built

  • Built in 1977

Lot Details

  • 1.11 Acre Lot
  • Rock Outcropping
  • Steep Slope
  • Wooded Lot
  • Landscaped with Trees

HOA Fees

  • $10 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Concrete Roof

Interior Spaces

  • 4,436 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Beamed Ceilings
  • Cathedral Ceiling
  • Window Treatments
  • Wood Frame Window
  • Dining Room
  • Home Office
  • Wood Flooring
  • Fire and Smoke Detector
  • Property Views

Kitchen

  • Eat-In Kitchen
  • Electric Oven or Range
  • Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Primary bathroom on main floor

Laundry

  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Laundry in Basement

Outdoor Features

  • Deck

Schools

  • Boulder High School

Utilities

  • Forced Air Heating System
  • Septic System

Listing and Financial Details

  • Assessor Parcel Number R0034787

Community Details

Overview

  • Pine Brook Hills 4 Subdivision

Recreation

  • Park
  • Hiking Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,339

Year Built

Built in 1977

Lot Details

0

HOA Fees

$10 per month

Parking

2

Listing Details

  • Inclusions: Window Coverings,Electric Range/Oven,Self-Cleaning Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Garage Door Opener,Disposal,Smoke Alarm(s)
  • Year Built: 1977
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 1.11
  • Road Surface Type: Paved, Asphalt
  • Co List Office Mls Id: BMCRE
  • Subdivision Name: Pine Brook Hills 4
  • Directions: Google Maps will provide ample directions
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 4436
  • ResoBuildingAreaSource: Assessor
  • Special Features: VirtualTour
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Accessibility Features: Main Floor Bath, Main Level Bedroom
  • Has Basement: Full, Partially Finished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Beamed Ceilings
  • Window Features: Window Coverings, Wood Frames
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Hardwood
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Main
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom3 Level: Main
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Hardwood
  • Room Kitchen Features: Hardwood
  • Living Room Features: Hardwood
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Concrete
  • Lot Features: Fire Hydrant within 500 Feet, Wooded, Rolling Slope, Sloped, Steep Slope, Rock Outcropping
  • View: Foothills View
  • View: Yes
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener
  • IRESDS_GarageType: Attached

Utilities

  • Heating: Forced Air
  • Utilities: Natural Gas Available
  • Laundry Features: Washer/Dryer Hookups, In Basement
  • Security: Smoke Detector(s)
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: Septic
  • Water Source: District Water, Pine Brook
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Community Features: Park, Hiking/Biking Trails
  • Senior Community: No
  • Association Fee: 125
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Other
  • HighSchool: Boulder
  • Junior High Dist: Boulder Valley Dist RE2
  • Middle Or Junior School: Other

Lot Info

  • Zoning: F
  • Lot Size Sq Ft: 48424
  • Parcel #: R0034787
  • Irrigation Water Rights: No
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 7339

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 8, 2025
Closed on
May 12, 2025
Sold by
Colorado Lohi Properties Llc
Bought by
Glow Worm Dell Family Trust and M Jeannette Sherwood Trust
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
$1,631,762

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$11,762
Avg. Annual Appreciation
1.12%
Original Mortgage
$1,000,000
Outstanding Balance
$973,437
Interest Rate
4.53%
Mortgage Type
New Conventional
Estimated Equity
$658,325

Purchase Details

Listed on
Jul 12, 2017
Closed on
Oct 10, 2017
Sold by
Seaward Stelg and Seaward Sharon L
Bought by
Colorado Lohi Properties Llc
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
Seaward William S
Bought by
Seaward Sharon L

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
Seaward Sharon L

Purchase Details

Closed on
Jul 9, 1976
Bought by
Seaward Sharon L

Purchase Details

Closed on
Jun 10, 1975
Bought by
Seaward Sharon L
Source: Public Records
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

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 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,000,000 New Conventional
Previous Owner $263,000 No Value Available
Source: Public Records

Property History

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 Compared to Growth

Source: Public Records

Tax History

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
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 1030573

IRES MLS

APN: 1461140-02-025