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.
Listed by Molly Stauffer
·
License #55045447
·
Milehimodern
·
303-345-1434
Last updated October 21, 2025
·
Source: REcolorado #3239968
Listing Facts
TypeSingle-family
NeighborhoodNorth Boulder
Bedrooms4
Bathrooms5
HOA/Maint. Fees$100/annual
Taxes$15,332/year
Size4,469 sqft
Price per sqft$602
Amenities
Dishwasher
Private Outdoor Space
Washer/Dryer
Air Conditioning
Parking
Location
Mortgage Calculator
Property Details for 700 Yellow Pine Avenue
Association
Fees
Association Fee: $100.00 Annually
General
Association Name: Boulder HOA
Exterior
Construction
Roof: Solar Shingles
Structure Type: House
Window Features: Window Coverings
Year Built: 1998
Architectural Style: Traditional
Construction Materials: Frame, Stucco
Exterior Features: Gas Valve, Lighting, Private Yard, Rain Gutters
Features
Direction Faces: North
Fencing: Full
Patio And Porch Features: Covered, Deck, Front Porch
Road Frontage Type: Public
View: Mountain(s)
Measurements
Building Area Total: 4,805
Lot Features: Landscaped, Near Public Transit, Open Space, Sprinklers In Front, Sprinklers In Rear
Interior Features: Built-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Radon Mitigation System, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s), Wired For Data
Measurements
Living Area: 4,469
Rooms
Basement: Finished
Has Basement: Yes
Bathrooms Full: 2
Bathrooms Half: 1
Bathrooms Three Quarter: 2
Bathrooms Total Integer: 5
Bedrooms Total: 4
Main Level Bathrooms: 1
Other
General
Exclusions: Seller's personal property and/or staging items.
Location
Subdivision Name: Northbriar Estates
Parking
Parking
Attached Garage: Yes
Garage Spaces: 3
Parking Features: 220 Volts, Electric Vehicle Charging Station(s), Heated Garage, Oversized, Tandem
Parking Total: 3
Schools
Elementary School
Elementary School: Foothill
Elementary School District: Boulder Valley RE 2
High School
High School: Boulder
High School District: Boulder Valley RE 2
Middle or Junior School
Middle Or Junior School: Centennial
Middle Or Junior School District: Boulder Valley RE 2
Utilities
Equipment
Cooling: Central Air
Electric: 220 Volts
Heating: Radiant Floor
Laundry Features: Sink, Laundry Closet
Sewer: Public Sewer
Utilities: Electricity Connected, Internet Access (Wired), Natural Gas Connected, Off Grid, Phone Available
Water Source: Public
The content relating to real estate for sale in this Web site comes in part from the Internet Data
eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers
other than Prevu are marked with the IDX Logo. This information is being provided for the consumers'
personal, non-commercial use and may not be used for any other purpose. All information subject to
change and should be independently verified.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.