700 Yellow Pine Avenue
Boulder, CO 80304
Northbriar
4 Beds
4.5 Baths
4,805 sqft
$2,500,000
Last Sold: Dec 15, 2025
3% below list $2.59M
$520/sqft
Est. Refi. Payment $13,428/mo*
$2,500,000
Last Sold: Dec 15, 2025
3% below list $2.59M
$520/sqft
Est. Refi. Payment $13,428/mo*
4 Beds
4.5 Baths
4,805 sqft
Homes for sale near 700 Yellow Pine Avenue
The Zach Zeldner Team, Compass - Boulder- NEW CONSTRUCTIONThe Agency - Boulder, MLS#9515294
- NEW CONSTRUCTIONThe Agency - Boulder, MLS#1688667
- NEW CONSTRUCTIONThe Agency - Boulder, MLS#5840706
- Tracy Zaik, milehimodern - Boulder
- The Bernardi Group, Coldwell Banker Realty-Boulder
See more homes for sale inBoulder
Apartments for Rent
- PET FRIENDLY
- NEW - 1 DAY AGOPET FRIENDLYFURNISHEDTotal price$2,102 - $4,944/mo1-3 bd1-4 baBoulder Commons | 2530 Junction Pl #A-208,
Boulder, CO 80301 - PET FRIENDLYTotal price$1,670 - $4,826/moStudio-3 bd1-3 baS'PARK Apartments | 3303 Bluff St #Townhouse 2,
Boulder, CO 80301 - PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLY
- PET FRIENDLYINCOME RESTRICTEDTotal price$1,345 - $1,845/moStudio-2 bd1-2 baNest on 30th Apartments | 2995 Eagle Way #139a58f96,
Boulder, CO 80301 
See more homes for rent inBoulder
Local Information
© Google
-- mins to
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.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from December 17, 2025
Home Highlights
Parking
3 Car Garage
Outdoor
Porch, Deck
A/C
Heating & Cooling
HOA
$8/Monthly
Price/Sqft
$520/sqft
Listed
180+ days ago
Home Details for 700 Yellow Pine Avenue
|
|---|
Interior Details Basement: FinishedNumber of Rooms: 16Types of Rooms: Bedroom, Bathroom, Bonus Room, Dining Room, Family Room, Kitchen, Laundry, Living Room, Office |
Beds & Baths Number of Bedrooms: 4Number of Bathrooms: 5Number of Bathrooms (full): 2Number of Bathrooms (three quarters): 2Number of Bathrooms (half): 1Number of Bathrooms (main level): 1 |
Dimensions and Layout Living Area: 4805 Square Feet |
Appliances & Utilities Utilities: Electricity Connected, Internet Access (Wired), Natural Gas Connected, Off Grid, Phone AvailableAppliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, WasherDishwasherDisposalDryerLaundry: Laundry ClosetMicrowaveRefrigeratorWasher |
Heating & Cooling Heating: Radiant FloorHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Radiant Floor |
Fireplace & Spa Number of Fireplaces: 1Fireplace: Family Room, GasHas a Fireplace |
Gas & Electric Electric: 220 Volts, 220 Volts in GarageHas Electric on Property |
Windows, Doors, Floors & Walls Window: Window CoveringsFlooring: Concrete, Stone, Tile, Wood |
Levels, Entrance, & Accessibility Stories: 2Levels: TwoFloors: Concrete, Stone, Tile, Wood |
View Has a ViewView: Mountain(s) |
Security Security: Carbon Monoxide Detector(s), Smoke Detector(s) |
|
|---|
Exterior Home Features Roof: ShinglePatio / Porch: Covered, Deck, Front PorchFencing: FullExterior: Gas Valve, Lighting, Private Yard, Rain Gutters |
Parking & Garage Number of Garage Spaces: 3Number of Covered Spaces: 3No CarportHas a GarageHas an Attached GarageParking Spaces: 3Parking: Electric Vehicle Charging Station(s),Heated Garage,Oversized,Tandem |
Frontage Road Frontage: PublicResponsible for Road Maintenance: Public Maintained RoadRoad Surface Type: PavedNot on Waterfront |
Water & Sewer Sewer: Public Sewer |
Finished Area Finished Area (above surface): 3172 Square FeetFinished Area (below surface): 1297 Square Feet |
|
|---|
Year Built Year Built: 1998 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: HouseArchitecture: Traditional |
Building Construction Materials: Frame, StuccoNot Attached Property |
Property Information Not Included in Sale: Seller's Personal Property And/Or Staging Items.Parcel Number: R0117074 |
|
|---|
Price List Price: $2,590,000Price Per Sqft: $520/sqft |
Status Change & Dates Off Market Date: Sun Nov 16 2025Possession Timing: Close Of Escrow |
|
|---|
MLS Status: Closed |
|
|---|
|
|---|
Direction & Address City: BoulderCommunity: Northbriar Estates |
School Information Elementary School: FoothillElementary School District: Boulder Valley RE 2Jr High / Middle School: CentennialJr High / Middle School District: Boulder Valley RE 2High School: BoulderHigh School District: Boulder Valley RE 2 |
|
|---|
Building Area Building Area: 4805 Square Feet |
|
|---|
Not Senior Community |
|
|---|
HOA Name: Boulder HOAHOA Phone: 720-810-4626Has an HOAHOA Fee: $100/Annually |
|
|---|
Lot Area: 8771 sqft |
|
|---|
Special Conditions: Standard |
|
|---|
Contingencies: None KnownListing Terms: Cash, Conventional, Other |
|
|---|
Mobile Home Park Mobile Home Units: Feet |
|
|---|
Business Information Ownership: Individual |
|
|---|
BasementMls Number: 3239968Attribution Contact: molly@milehimodern.com, 303-345-1434Above Grade Unfinished Area: 3172Below Grade Unfinished Area: 336Showing Service Name: Showing Time |
Last check for updates: about 1 hour ago
Listed by Molly Stauffer, (303) 345-1434
Milehimodern
Bought with: Stephen Remmert, (720) 339-5033, Compass - Boulder
Source: REcolorado as distributed by MLS GRID, MLS#3239968
Price History for 700 Yellow Pine Avenue
| Date | Price | Event | Source |
|---|---|---|---|
| 12/15/2025 | $2,500,000 | Sold | REcolorado as distributed by MLS GRID #3239968 |
| 11/17/2025 | $2,590,000 | Pending | REcolorado as distributed by MLS GRID #3239968 |
| 11/03/2025 | $2,590,000 | PriceChange | REcolorado as distributed by MLS GRID #3239968 |
| 10/23/2025 | $2,690,000 | Listed For Sale | REcolorado as distributed by MLS GRID #3239968 |
| 08/18/2021 | $2,300,000 | Sold | IRES as distributed by MLS GRID #943710 |
| 07/27/2021 | $2,395,000 | PriceChange | IRES as distributed by MLS GRID #943710 |
| 06/28/2021 | $2,450,000 | PriceChange | IRES as distributed by MLS GRID #943710 |
| 06/20/2021 | $2,590,000 | Listed For Sale | IRES as distributed by MLS GRID #943710 |
| 11/18/2009 | $1,000,000 | Sold | N/A |
| 12/21/2008 | $1,400,000 | ListingRemoved | Agent Provided |
| 04/22/2008 | $1,400,000 | Listed For Sale | Agent Provided |
| 06/14/1999 | $703,500 | Sold | N/A |
- Results are loading
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $15,332 |
| Assessment | $2,577,700 |
Home facts updated by county records
Comparable Sales for 700 Yellow Pine Avenue
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.03 | Single-Family Home | $2,550,000 | 05/28/25 | 6 | 5 | 5,438 | |
0.09 | Single-Family Home | $1,850,000 | 07/01/25 | 5 | 4 | 4,265 | |
0.22 | Single-Family Home | $1,650,000 | 07/01/25 | 5 | 4 | 3,756 | |
0.11 | Single-Family Home | $1,550,000 | 12/11/25 | 4 | 3.5 | 2,498 | |
0.17 | Single-Family Home | $1,225,000 | 11/24/25 | 5 | 3 | 3,860 | |
0.33 | Single-Family Home | $1,725,000 | 01/14/26 | 6 | 3.5 | 4,221 | |
0.49 | Single-Family Home | $1,784,280 | 09/30/25 | 5 | 3 | 4,248 | |
0.61 | Single-Family Home | $2,800,000 | 10/28/25 | 5 | 4.5 | 5,179 | |
0.22 | Single-Family Home | $1,040,000 | 08/15/25 | 4 | 3.5 | 2,359 |
Assigned Schools
These are the assigned schools for 700 Yellow Pine Avenue.
- Boulder High School
- 9-12
- Public
- 2074 Students
10/10GreatSchools RatingParent Rating AverageTerrible experience here. Constantly made fun of and picked on by students and teachers treated me like a total idiot. Went from being respected by peers and teachers at my old school to ridiculed and laughed at by the entire class.Other Review2mo ago - Centennial Middle School
- 6-8
- Public
- 567 Students
7/10GreatSchools RatingParent Rating AverageAs a parent, you hope for a school that sees your child, truly sees them, and helps them grow into the person they’re meant to be. Centennial doesn’t just meet that hope; it exceeds every expectation. My worries over this phase of life for my child have been replaced with joy.My daughter is thriving here in a way I never expected. From the numerous clubs that help explore talents and make new friends to dedicated teachers nurturing her talents and spark for learning. She’s discovering passions she didn’t know she had. These aren’t just activities to her anymore; they’re pieces of who she is becoming. The environment at Centennial is warm, safe and genuinely caring. My daughter says it best, “I love Centennial!”Parent Review4mo ago - Foothill Elementary School
- K-5
- Public
- 437 Students
8/10GreatSchools RatingParent Rating AverageMy 4th grade teacher was really mean I hope they're doing horrible my 5th grade teacher lives in my neighborhood so I can't really say anything negative about them they were pretty nice anyway tho and my third grade teacher was mean and then started not being mean I was only there for 3 year and it contributed to my mental health issues and set me up for failure or something idk my friends were really mean and I hated the principal that was probably why I hate this school so muchOther Review2y ago 
Check out schools near 700 Yellow Pine Avenue.
Neighborhood Overview
Neighborhood stats provided by third party data sources.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
© 2026 REcolorado® All rights reserved. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, REcolorado®. Some IDX listings have been excluded from this website. Click here for more information
Homes for rent near 700 Yellow Pine Avenue
- Results are loading
Off Market Homes Near 700 Yellow Pine Avenue
- SOLDMAY 8, 2026Kim Dunning, Compass - Boulder
- SOLDMAY 8, 2026Cari Higgins, Compass - Boulder
- SOLDMAY 8, 2026Jon Hatch, Compass - Boulder
- SOLDMAY 5, 2026Catherine Burgess, Compass - Boulder
- SOLDMAY 5, 2026Kevin Konczak, LoKation
- SOLDMAY 4, 2026Wendy Kahn-Robson, RE/MAX of Boulder, Inc
- SOLDMAY 4, 2026Thom Sandrock, Sandrock Real Estate
- SOLDMAY 1, 2026Ardee Imerman, WK Real Estate
- SOLDMAY 1, 2026Tim Shea, Compass - Boulder
- SOLDAPR 30, 2026Kentwood Real Estate DTC, LLC, MLS#8169666
- See more homes for sale inBoulder
Explore by feature
NEW - 1 DAY AGOSPECIAL OFFERPET FRIENDLYFURNISHEDTotal price$2,102 - $4,944/mo1-3 bd1-4 baBoulder Commons | 2530 Junction Pl #A-208,
Boulder, CO 80301
SPECIAL OFFERPET FRIENDLY
SPECIAL OFFERPET FRIENDLYFURNISHED
PET FRIENDLYINCOME RESTRICTED
PET FRIENDLY
PET FRIENDLY
PET FRIENDLY
SPECIAL OFFERPET FRIENDLY
SPECIAL OFFERPET FRIENDLY
SPECIAL OFFERPET FRIENDLYTotal price$1,670 - $4,826/moStudio-3 bd1-3 baS'PARK Apartments | 3303 Bluff St #Townhouse 2,
Boulder, CO 80301
700 Yellow Pine Avenue, Boulder, CO 80304 is a 4 bedroom, 5 bathroom, 4,805 sqft single-family home built in 1998. 700 Yellow Pine Avenue is located in Northbriar, Boulder. This property is not currently available for sale. 700 Yellow Pine Avenue was last sold on Dec 15, 2025 for $2,500,000 (3% lower than the asking price of $2,590,000). The current Trulia Estimate for 700 Yellow Pine Avenue is $2,496,300.