970.222.1020
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Boulder » 80304 » 700 Yellow Pine Ave, Boulder, CO, 80304
$2,690,000

700 Yellow Pine Ave, Boulder, CO, 80304

4 Beds
5 Baths
4,805 Square Feet

Open House

October 25 1:00 pm - 3:00 pm

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.
Offered By
Molly Stauffer molly@milehimodern.com,303-345-1434, Milehimodern

Property Details

Property Type Residential
Status Active
Bedrooms 4
Bathrooms (Full) 2
Property Sub Type Residential-Detached
Square Feet 4,805
MLS # 3239968
Bathrooms (¾) 2
Bathrooms (Half) 1

Market Trends

New Properties On Market
62
130% Increase In New Listings
Average Asking Price
$2,218,030
$540,886 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$691
$40 Increase In List Price/Sq. Ft.
Average Days On Market
26
25 Day Decrease In Days On Market
Data as of Oct 24, 2025. Remaining statistics above are calculated on activity within the period from Aug 01, 2025 to Sep 30, 2025.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance

Similar Listings

3945 Promontory Ct, Boulder, CO 80304 Listing Photo  1
$2,995,000
3945 Promontory Ct
Boulder, CO
4 Beds
|
5 Baths
|
4,093 Square Feet
Offered By Joel Ripmaster Slifer Smith & Frampton-Bldr
495 S Cedar Brook Rd, Boulder, CO 80304 Listing Photo  1
$2,950,000
495 S Cedar Brook Rd
Boulder, CO
4 Beds
|
4 Baths
|
4,818 Square Feet
Offered By Robert Fellows Phelco Group
3560 16th St, Boulder, CO 80304 Listing Photo  1
$2,950,000
3560 16th St
Boulder, CO
5 Beds
|
4 Baths
|
3,513 Square Feet
Offered By The Zach Zeldner Team Coldwell Banker Realty 02
1801 Redwood Ave, Boulder, CO 80304 Listing Photo  1
$2,890,000
1801 Redwood Ave
Boulder, CO
5 Beds
|
4 Baths
|
3,456 Square Feet
Offered By Michelle Clifford Coldwell Banker Realty 02
Information deemed reliable but not guaranteed by the MLS. Listing information 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. Data Source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © 2025 IRES. Property data was last updated on 10/23/2025 at 5:07 pm