Brian Clodius | Clodius & Company
    Brian Clodius
    (303) 829-8806brian@clodiusandco.com
    • Search
    • Your Communities
      • Boulder
      • Nederland
      • Louisville
      • Broomfield
      • Thornton
      • Erie
      • Lafayette
      • Westminster
      • Littleton
      • Lakewood
      • Arvada
      • Wheat Ridge
      • Longmont
      • Windsor
      • Fort Collins
    • What do you love in a home?
    • What do you perceive as value?
    • Giving Through Golf
    • Donate to Food for Hope
    • Your Home Health Check
    • About
      • Learn More
      • Meet the Expert
      • Our Testimonials
      • Partners
      • Articles
    • Contact
    • Brian Clodius(303) 829-8806
      brian@clodiusandco.com
      Copy Email
    • Clodius & Company
      14884 Fillmore Way
      Thornton, Colorado 80602

    Home

    • Search
    • Your Communities
    • What do you love in a home?
    • What do you perceive as value?
    • Giving Through Golf
    • Donate to Food for Hope
    • Your Home Health Check
    • About
    • Contact
    Brian Clodius | Clodius & Company - Footer Logo
    • Notice of Exclusive Property Listing
    • Notice of Exclusive Property Listing
    © 2025 Clodius & Company. All rights reserved.
    Website built by CloseHack.
    REcolorado
    Based on information submitted to the MLS GRID as of 2025-12-07 22:35:52 UTC. 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.
    • Legal Notice
    • Publisher's Notice
    • Copyright Notice
    • Buyer Agency Compensation
    Pikes Peak MLS

    The real estate listing information and related content displayed on this site 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. This information and related content is deemed reliable but is not guaranteed accurate by the Pikes Peak REALTOR® Services Corp.

    $2,590,000
    Backup Offers

    700 Yellow Pine Avenue

    Boulder, CO 80304
    4805 sqft | 4 beds | 4 baths | 0.20 acres | #3239968
    • Save
    • Contact
    • Share
    • Price Change Alerts
    Listing OfficeMilehimodern
    44 photos
    Type:Purchase
    Structure:House
    Zone:Residential

    Description

    Unrivaled mountain vistas and elegant design define this exceptional Northbriar Estates residence, perfectly positioned against open space with unobstructed views of the Flatirons and foothills. Thoughtfully crafted with every luxury in mind, this expansive home offers en-suite privacy in each bedroom and an open layout ideal for entertaining. The gourmet kitchen dazzles with high-end appliances and a seamless flow into the living and dining areas, where expansive windows and a gas fireplace frame breathtaking scenery. Brazilian cherry wood and travertine floors with radiant heat add warmth and sophistication throughout. The finished garden-level basement extends the living space with a rec room, while a dedicated office with built-ins offers a work-from-home haven. Outside, a southwest-facing deck in a sprawling backyard invites sunset gatherings. Sustainable living is built in with a Tesla solar tile roof, two Tesla Powerwalls; and a heated three-car garage with a dedicated workshop.

    • Interior Details
        • InteriorBuilt-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceili
        • Fireplaces1
      • Beds & Baths
        • Bedrooms4
        • Bathrooms4
        • Full Baths2
        • Half Baths1
        • 3/4 Baths2
    • Property Details
        • Lot DescriptionLandscaped, Near Public Transit, Open Space, Sprinklers In Front, Sprinklers In Rear
        • Exterior MaterialsGas Valve, Lighting, Private Yard, Rain Gutters
        • ViewMountain(s)
      • Measurements
        • Square Feet4805
        • Acres0.2
      • Parking
        • Parking TypeGarage
        • Parking Spaces3
        • Parking Garage Spaces3
    • Construction Details
        • Property TypePurchase
        • BasementFinished
      • Condition
        • Year Built1998
    • Utilities / Energy Details
        • Utility FeaturesElectricity Connected, Internet Access (Wired), Natural Gas Connected, Off Grid, Phone Available
        • Sewer InformationPublic Sewer
        • Utility SourcePublic
    • Community and Neighborhood Details
        • SubdivisionNorthbriar Estates
      • Location
        • School DistrictBoulder Valley RE 2
        • Middle SchoolCentennial
        • Elementary SchoolFoothill
        • High SchoolBoulder
        • CountyBoulder
    • Financial Details
        • Original List Price$2,690,000
        • Taxes Annual$15,332
      • HOA
        • Hoa Fees100
        • Hoa1
    • Other
        • MLS #3239968

    Location

    Legal

    Based on information submitted to the MLS GRID as of 2025-11-17 16:38:16 UTC. 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.

    Last Updated: Yesterday at 5:31 PM. Source: RECOLORADO

    Provided By
    Listing Agent: Molly Stauffer (#REC55045447), Phone: 303-345-1434, Email: molly@milehimodern.com
    Listing Office: Milehimodern (#RECM5432)

    • Legal Notice
    • Publisher's Notice
    • Copyright Notice
    • Buyer Agency Compensation
    Brian Clodius | Clodius & CompanyReal Estate Group
    Facebook
    Google
    OR

    Interested in Purchasing 700 Yellow Pine Avenue?

    Get an estimate on monthly payments on this property.

    Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

    Estimated Monthly Payment
    $0.00
    Loan Amount
    $0.00
    $
    years

    Down Payment

    $
    %
    10.0%

    Interest Rate

    %
    6.0%

    Tax Rate

    %
    2.6%
    $
    $
    annually
    $
    monthly