Skip main navigation
Pending
  • $1,695,000

    174 N Cedar Brook Rd, Boulder, CO 80304

    4beds
    4,436sqft
    : 
    Residential-Detached, Residential
    Built in 1977
    1.11 Acres Lot
    $-- Zestimate®
    $382/sqft
    $10/mo HOA

    What's special

    Mature pinesSurrounding foothill viewsWalk out basementLuxury flooringMain level primary bedroomLarge formal dining roomMultiple decks
    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.
    17 days
    on Zillow
    |
    428
    |
    34
    |

    Zillow last checked: 7 hours ago

    Listing updated: April 11, 2025 at 07:16am

    Listed by:

    Brian Mccann 303-823-5466,

    McCann Real Estate,

    Mace Mccann 970-344-9950,

    McCann Real Estate

    Source: IRES,MLS#: 1030573MLS Logo
    Travel times

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 2
    • 3/4 bathrooms: 1
    • 1/2 bathrooms: 1
    • Main level bedrooms: 4
    Primary bedroom
    • Area: 300
    • Dimensions: 15 x 20
    Bedroom 2
    • Area: 234
    • Dimensions: 18 x 13
    Bedroom 3
    • Area: 176
    • Dimensions: 16 x 11
    Bedroom 4
    • Area: 238
    • Dimensions: 14 x 17
    Dining room
    • Area: 192
    • Dimensions: 16 x 12
    Kitchen
    • Area: 195
    • Dimensions: 15 x 13
    Living room
    • Area: 384
    • Dimensions: 16 x 24
    Heating
    • Forced Air
    Appliances
    • Included: Electric Range/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
    • Laundry: Washer/Dryer Hookups, In Basement
    Features
    • Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Beamed Ceilings, Open Floor Plan, Walk-in Closet
    • Flooring: Wood, Wood Floors, Carpet
    • Windows: Window Coverings, Wood Frames, Wood Windows
    • Basement: Full
    Interior area
    • Total structure area: 4,436
    • Total interior livable area: 4,436 sqft
    • Finished area above ground: 2,522
    • Finished area below ground: 1,914
    Video & virtual tour

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage Door Opener
    • Attached garage spaces: 2
    • Details: Garage Type: Attached
    Accessibility
    • Accessibility features: Main Floor Bath, Accessible Bedroom
    Features
    • Stories: 1
    • Patio & porch: Deck
    • Has view: Yes
    • View description: Hills
    Lot
    • Size: 1.11 Acres
    • Features: Fire Hydrant within 500 Feet, Wooded, Rolling Slope, Sloped, Steep Slope, Rock Outcropping
    Details
    • Parcel number: R0034787
    • Zoning: F
    • Special conditions: Private Owner

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Residential-Detached, Residential
    Materials
    • Wood/Frame
    • Roof: Concrete
    Condition
    • Not New, Previously Owned
    • New construction: No
    • Year built: 1977

    Utilities & green energy

    • Gas: Natural Gas, Xcel
    • Sewer: Septic
    • Water: District Water, Pine Brook
    • Utilities for property: Natural Gas Available

    Community & HOA

    Community
    • Features: Park, Hiking/Biking Trails
    • Subdivision: Pine Brook Hills 4
    HOA
    • Has HOA: Yes
    • HOA fee: $125 annually
    Location
    • Region: Boulder

    Financial & listing details

    • Price per square foot: $382/sqft
    • Tax assessed value: $1,264,000
    • Annual tax amount: $7,339
    • Date on market: 4/9/2025
    • Listing terms: Cash,Conventional,FHA,VA Loan,1031 Exchange
    • Exclusions: Owner's Personal Property And Staging Items.
    • Road surface type: Paved, Asphalt
    • Loading