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.
Sold for $2,500,000
$2,500,000
700 Yellow Pine Avenue, Boulder, CO 80304
4beds
4,805sqft
Single Family Residence
Built in 1998
8,771 Square Feet Lot
$2,480,700 Zestimate®
$520/sqft
$7,524 Estimated rent
Home value
$2,480,700
$2.31M - $2.65M
$7,524/mo
Zestimate® history
Owner options
List your home for rent
$7,524/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$7,524/mo
Rent Zestimate®
Refinance and save
$11,773/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$11,773/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Molly Stauffer 303-345-1434 molly@milehimodern.com,
Milehimodern
Bought with:
Stephen Remmert, 40025285
Compass - Boulder
Source: REcolorado as distributed by MLS GRID,MLS#: 3239968
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 2
- 3/4 bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Bedroom
- Features: Primary Suite
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bathroom
- Level: Main
Bathroom
- Features: En Suite Bathroom
- Level: Upper
Bathroom
- Features: En Suite Bathroom
- Level: Upper
Bathroom
- Features: En Suite Bathroom
- Level: Upper
Bathroom
- Features: En Suite Bathroom
- Level: Upper
Bonus room
- Level: Basement
Dining room
- Level: Main
Family room
- Level: Main
Kitchen
- Level: Main
Laundry
- Level: Main
Living room
- Level: Main
Office
- Level: Main
Heating
- Radiant Floor
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
- Laundry: Laundry Closet
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
- Flooring: Concrete, Stone, Tile, Wood
- Windows: Window Coverings
- Basement: Finished
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 4,805
- Total interior livable area: 4,805 sqft
- Finished area above ground: 3,172
- Finished area below ground: 1,297
Property
Parking
- Total spaces: 3
- Parking features: Electric Vehicle Charging Station(s), Heated Garage, Oversized, Tandem
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Deck, Front Porch
- Exterior features: Gas Valve, Lighting, Private Yard, Rain Gutters
- Fencing: Full
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 8,771 Square Feet
- Features: Landscaped, Near Public Transit, Open Space, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: R0117074
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Frame, Stucco
- Roof: Shingle
Condition
- Year built: 1998
Utilities & green energy
- Electric: 220 Volts, 220 Volts in Garage
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Internet Access (Wired), Natural Gas Connected, Off Grid, Phone Available
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smoke Detector(s)
- Subdivision: Northbriar Estates
HOA
- Has HOA: Yes
- HOA fee: $100 annually
- HOA name: Boulder HOA
- HOA phone: 720-810-4626
Location
- Region: Boulder
Financial & listing details
- Price per square foot: $520/sqft
- Tax assessed value: $2,577,700
- Annual tax amount: $15,332
- Date on market: 10/23/2025
- Listing terms: Cash,Conventional,Other
- Exclusions: Seller's Personal Property And/Or Staging Items.
- Ownership: Individual
- Electric utility on property: Yes
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 12/15/2025 | Sold | $2,500,000-3.5%$520/sqft |
Source:  REcolorado as distributed by MLS GRID #3239968 Report a problem | ||
| 11/17/2025 | Pending sale | $2,590,000$539/sqft |
Source: REcolorado as distributed by MLS GRID #3239968 Report a problem | ||
| 11/3/2025 | Price change | $2,590,000-3.7%$539/sqft |
Source: REcolorado as distributed by MLS GRID #3239968 Report a problem | ||
| 10/23/2025 | Listed for sale | $2,690,000+17%$560/sqft |
Source: REcolorado as distributed by MLS GRID #3239968 Report a problem | ||
| 8/18/2021 | Sold | $2,300,000-4%$479/sqft |
Source:  IRES as distributed by MLS GRID #943710 Report a problem | ||
| 7/27/2021 | Price change | $2,395,000-2.2%$498/sqft |
Source: IRES as distributed by MLS GRID #943710 Report a problem | ||
| 6/28/2021 | Price change | $2,450,000-5.4%$510/sqft |
Source: IRES as distributed by MLS GRID #943710 Report a problem | ||
| 6/20/2021 | Listed for sale | $2,590,000+159%$539/sqft |
Source: IRES as distributed by MLS GRID #943710 Report a problem | ||
| 11/18/2009 | Sold | $1,000,000-28.6%$208/sqft |
Source: Public Record Report a problem | ||
| 12/21/2008 | Listing removed | $1,400,000$291/sqft |
Source: Homes.com #562954 Report a problem | ||
| 4/22/2008 | Listed for sale | $1,400,000+99%$291/sqft |
Source: Homes.com #562954 Report a problem | ||
| 6/14/1999 | Sold | $703,500$146/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $15,332 +1.8% | $161,107 -9.6% |
| 2024 | $15,066 +22.9% | $178,146 -2.1% |
| 2023 | $12,263 +4.9% | $181,891 +37.7% |
| 2022 | $11,693 +18.2% | $132,050 -2.8% |
| 2021 | $9,895 | $135,850 +19.5% |
| 2020 | $9,895 +10.6% | $113,671 |
| 2019 | $8,945 | $113,671 +10.2% |
| 2018 | $8,945 | $103,176 -9.5% |
| 2017 | $8,945 +3.4% | $114,067 +14.1% |
| 2016 | $8,653 +5.6% | $99,954 +28.4% |
| 2015 | $8,193 +25.1% | $77,865 |
| 2014 | $6,547 -1.4% | $77,865 |
| 2013 | $6,642 +0.9% | $77,865 -1.8% |
| 2012 | $6,583 +2.3% | $79,282 |
| 2011 | $6,434 +7.1% | -- |
| 2010 | $6,007 -6.1% | $79,600 -11.2% |
| 2009 | $6,399 +3.5% | $89,610 -10.4% |
| 2008 | $6,180 -3.3% | $100,010 |
| 2007 | $6,392 +3.9% | $100,010 |
| 2006 | $6,154 +7.6% | $100,010 |
| 2005 | $5,718 +0.7% | $100,010 +6.9% |
| 2004 | $5,677 -6.2% | $93,580 |
| 2003 | $6,049 +10.3% | $93,580 +7.9% |
| 2002 | $5,483 | $86,690 -90.8% |
| 2001 | -- | $947,400 |
Find assessor info on the county website
Neighborhood: Northbriar
Nearby homes
- $2,649,6004 bd4 ba5k sqft4647 7th St, Boulder, CO 80304Off Market
- $2,408,9004 bd3 ba3.2k sqft748 Yellow Pine Ave, Boulder, CO 80304Off Market
- $1,283,7005 bd4 ba2.9k sqft4757 10th Street, Boulder, CO 80304Off Market
- $2,550,0006 bd5 ba5.4k sqft4655 7th St, Boulder, CO 80304Sold
- $1,953,2005 bd4 ba4.6k sqft721 Yellow Pine Ave, Boulder, CO 80304Off Market
- $2,022,4004 bd3 ba3.1k sqft770 Yellow Pine Ave, Boulder, CO 80304Off Market
- $2,711,6005 bd5 ba6.4k sqft4669 7th St, Boulder, CO 80304Off Market
- $2,556,9005 bd5 ba5.1k sqft771 Yellow Pine Ave, Boulder, CO 80304Off Market
Nearby schools
GreatSchools rating
- 8/10Foothill Elementary SchoolGrades: K-5Distance: 1.7 mi
- 7/10Centennial Middle SchoolGrades: 6-8Distance: 1.4 mi
- 10/10Boulder High SchoolGrades: 9-12Distance: 3.3 mi
Schools provided by the listing agent
- Elementary: Foothill
- Middle: Centennial
- High: Boulder
- District: Boulder Valley RE 2
Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,480,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,480,700
- Colorado
- Boulder County
- Boulder
- 80304
- Northbriar
- 700 Yellow Pine Avenue
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Boulder Topics
