$1,695,000
PENDING

Estimated payment $10,082/month

Total Views 217
4 Beds
3.5 Baths
4,436 Sq Ft
$382 Price per Sq Ft

Highlights

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

About This Home

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.

Listing Agent

James McCann

McCann Real Estate

Co-Listing Agent

Mace McCann

McCann Real Estate

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

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

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

  • 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
  • Above Grade Finished Sq Ft: 2522
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Building Stories: 1
  • Kitchen Level: Main
  • 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
  • Below Grade Sq Ft: 1914
  • 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
  • Living Area: 4436
  • Window Features: Window Coverings, Wood Frames
  • Room Bedroom4 Area: 238
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Hardwood
  • Room Bedroom4 Level: Main
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 176
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 234
  • Room Bedroom3 Level: Main
  • Master Bedroom Master Bedroom Width: 20
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Hardwood
  • Room Kitchen Features: Hardwood
  • Room Living Room Area: 384
  • Living Room Features: Hardwood
  • Room Kitchen Area: 195
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 300
  • Room Dining Room Area: 192
  • 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
  • Waterfront: 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_Garage Sq Ft: 576
  • IRESDS_GarageType: Attached

Utilities

  • Heating: Forced Air
  • Utilities: Natural Gas Available
  • Laundry Features: Washer/Dryer Hookups, In Basement
  • Heating Yn: Yes
  • 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
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 7339

Multi Family

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

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
2024 $7,218 $81,003 $16,100 $64,903
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

Property History

Date Event Price Change Sq Ft Price
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% $188 / Sq Ft
09/11/2017 09/11/17 Pending -- -- --
07/12/2017 07/12/17 For Sale $850,000 -- $201 / Sq Ft
Source: IRES MLS

Deed History

Date Type Sale Price Title Company
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
Previous Owner $407,000 Unknown
Previous Owner $80,000 Stand Alone Second
Previous Owner $25,000 Credit Line Revolving
Previous Owner $295,500 Unknown
Previous Owner $263,000 No Value Available
Source: Public Records

Similar Homes in Boulder, CO

  • 2500 Pampas Ct, Boulder, CO 80304

    $2,000,000

    • 3 Beds
    • 3 Baths
    • 2,306 Sq Ft
    • 2500 Pampas Ct
    • Boulder, CO

    Experience One-Level Living in North Boulder. This home is perfectly situated on a premier lot backing to a privately owned neighborhood park. This exceptional custom built residence exemplifies the best of single-story living, with views from all rooms of the natural outdoor setting. Featuring a split floor plan with two bedroom suites with private baths and walk in closets, a versatile 3rd

    Kimberly (Kiki) Kidder Compass - Boulder

    Section Image
  • 531 Sky Trail Rd, Boulder, CO 80302

    $1,475,000

    • 4 Beds
    • 3 Baths
    • 2,842 Sq Ft
    • 531 Sky Trail Rd
    • Boulder, CO

    Welcome to The Sky House-where comfortable living and design meets nature. Soak in striking views with dramatic sunsets over the Colorado peaks, and morning cloud inversions, all experienced through multi-story windows. Backing to 300+ acres of forest for endless hiking and biking, wildlife is abundant, and the home's warmth centers the soul. Set on three acres in Boulder Heights, this 4-bed,

    Emelie Griffith Porchlight RE Group-Boulder

    Section Image
  • 36 High View Dr, Boulder, CO 80304

    $2,050,000

    • 3 Beds
    • 3 Baths
    • 3,700 Sq Ft
    • 36 High View Dr
    • Boulder, CO

    Once in a while a very special home comes on the market. This is one of those homes in Pine Brook Hills. Mountain living with City conveniences just 7 minutes from Broadway. 2-acre tree covered UNPARALLELED VIEW lot this BEAUTIFUL timeless stucco design with over 3,700 SF finished provides rare main level living. An awesome entrance opens onto a spacious living & dining room with 17' ceilings & a

    lancene cadora Equity Colorado-Front Range

    Section Image
  • 1280 N Cedar Brook Rd, Boulder, CO 80304

    $1,695,000

    • 4 Beds
    • 3 Baths
    • 2,957 Sq Ft
    • 1280 N Cedar Brook Rd
    • Boulder, CO

    Perched above Boulder in a peaceful enclave of Pine Brook Hills, this 2,957 Sq.Ft. mountain home blends rustic charm with practical updates on nearly an acre of forested privacy. Just minutes from Boulder, the property offers a rare combination of quiet mountain living and city convenience. Crafted with knotty pine log walls, hand-hewn ceiling beams, the home has been meticulously maintained with

    Ryan McIntosh LIV Sotheby's Intl Realty

    Section Image
  • 15 Arrowleaf Ct, Boulder, CO 80304

    $1,690,000

    • 3 Beds
    • 3.5 Baths
    • 3,155 Sq Ft
    • 15 Arrowleaf Ct
    • Boulder, CO

    Striking custom home just two true minutes to Broadway. Best of both worlds. Tucked in the trees and foothills yet just a few hundred yards from the city limits. Stunning views through walls of windows framing the surrounding mountain landscape. Step inside to discover a warm and charming residence with informal and impressive living spaces. Sophisticated kitchen with SubZero and Viking

    John Hoeffler WK Real Estate

    Section Image
  • 37 Wagner Cir, Boulder, CO 80304

    $1,998,000

    • 4 Beds
    • 6 Baths
    • 4,096 Sq Ft
    • 37 Wagner Cir
    • Boulder, CO

    Nestled in the heart of Boulder, where the Rocky Mountains rise in breathtaking splendor, lies 37 Wagner Circle—a home that perfectly blends luxury with the tranquility of nature. This stunningly remodeled residence, spanning an expansive 5,195 square feet, is more than just a place to live—it’s a retreat, a sanctuary, a masterpiece. As you approach, the gentle whispers of the surrounding

    Nicholas Quenzer Compass - Denver

    Section Image
  • 595 Northstar Ct, Boulder, CO 80304

    $1,900,000

    • 4 Beds
    • 3 Baths
    • 2,594 Sq Ft
    • 595 Northstar Ct
    • Boulder, CO

    Rare opportunity to own this beautiful Wonderland Hills home that backs to Wonderland Lake Park open space and City of Boulder trails. Upon entering this well cared for home, you are greeted with new hardwood floors, a cozy gas fireplace, abundant sun and soaring vaulted ceilings. The light filled and airy living area boasts expansive views and abuts open space, just steps from Wonderland Lake.

    Chris Cook Open Real Estate

    Section Image
  • 789 Zamia Ave, Boulder, CO 80304

    $2,050,000

    • 5 Beds
    • 4 Baths
    • 4,265 Sq Ft
    • 789 Zamia Ave
    • Boulder, CO

    Stunning Craftsman in Northbriar Estates with Mountain Views & High-End FinishesExperience effortless living in this beautifully designed charming Craftsman-style home in NW Boulder's highly sought-after Northbriar Estates. Just north of Wonderland Lake and Foothills Community Park, this home offers quick access to open spaces, scenic trails, and dog parks, all while enjoying stunning Foothill

    Denise Maslanka RE/MAX of Boulder, Inc

    Section Image
  • 4825 6th St, Boulder, CO 80304

    $2,185,000

    • 5 Beds
    • 4 Baths
    • 4,000 Sq Ft
    • 4825 6th St
    • Boulder, CO

    Homes in Boulder are known for their stunning views, but this one—wow. Nestled at the base of Four Mile Creek Trailhead, this home isn’t just surrounded by the foothills; it’s within them. Inside, you’re greeted by expansive windows that frame the beauty of the foothills, bringing the views into every room. The updated kitchen, with Blum Cabinets, is a chef’s dream. The cozy living room, complete

    Jamie Bearden Your Castle Real Estate Inc

    Section Image

Source: IRES MLS

MLS Number: 1030573

IRES MLS

APN: 1461140-02-025