OFF MARKET

Off market dec 2022 for $2.2M

$2,541,453

•

6,470

sq ft

300 Pine Needle Rd, Boulder, CO 80304

About this home

Public Remarks: Located in the coveted Pine Brook Hills, this stunning home sits on a private, 2-acre site w/continuous views of the Flatirons & surrounding foothills. Newly remodeled, this ultra-private estate has picturesque views while providing the highest caliber of quality & comfort. The dramatic great room has soaring ceilings & European Dutch Oak Post & Beam Exposed Design creating a seamless open floor plan. Ideal for entertaining, the chef's kitchen is outfitted with Thermador professional-grade appliances, gorgeous Palomino Gold Quartzite Brazilian Countertops & an oversize Copper Farmhouse sink. The main floor owner's suite boasts a sumptuous spa-like bath w/steam shower & jetted tub. The loft would make a great home office or sitting area & offers a hidden safe room. Secondary bedrooms are spacious & bright w/Jack & Jill bath. A 2nd primary suite boasts patio access and a 2nd spa bath. Lower level would make perfect guest quarters w/full kitchen & tons of storage. This trophy property is equipped w/the finest features including radiant heating throughout, salt water hot spring, wine cave, 4 car garage, & all Ethernet Cat-5 wired throughout. This property is a rare find: in a world of its own w/ultimate mountain seclusion yet 8 minutes to Downtown Boulder.

Single-familyProperty Type

1996Year Built

1.89 acresLot Size

$393Est. Price/Sq.Ft.

4 car garageParking

Listed by Karen Bernardi • Coldwell Banker Realty-Boulder

Contact: 3034495000

Bought with Kelly Moye • Compass-Denver

•303-536-1786 (broker)

Redfin checked: a minute ago

•Source:IRES as Distributed by MLS Grid #973114

Redfin Estimate

$2,541,453

$291K since sold in December 2022$71K since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 2.1% lower than the average sale price ($2.60M) of 6 comparable homes.

SOLD OCT 5, 2026
$3,222,000
A
4 beds4.5 baths4,471 sq ft
150 Valley View Way, Boulder, CO 80304
SOLD MAY 22, 2026
$2,000,000
B
5 beds5 baths5,656 sq ft
2554 Linden Dr, Boulder, CO 80304
SOLD OCT 2, 2026
$3,250,000
C
4 beds3.5 baths5,418 sq ft
337 Wild Horse Cir, Boulder, CO 80304
SOLD OCT 6, 2026
$2,750,000
D
4 beds4.5 baths4,093 sq ft
3945 Promontory Ct, Boulder, CO 80304
SOLD OCT 13, 2026
$1,500,000
E
5 beds3.5 baths3,712 sq ft
114 Balsam Ln, Boulder, CO 80304
SOLD SEP 18, 2026
$2,850,000
F
4 beds3.5 baths4,357 sq ft
1575 Linden Dr, Boulder, CO 80304

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$724,489

Est. take-home

List your home with Redfin and save $25,415

Rent

$8,234/mo

Redfin rental estimate

List your home for rent

Market trends in 80304, CO

Last updated September 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-list price

97.4%

+0.1% MoM

Median sale price

$1.3M

$110K MoM

Avg. days on market

63d

8 days MoM

Recently sold homes

103

15 MoM

New listings for sale

NEW 21 HRS AGO
$3,350,000
4 beds3.5 baths3,495 sq ft
645 Concord Ave, Boulder, CO 80304
COMING SOON
$9,500,000
6 beds7.5 baths9,447 sq ft
1080 Juniper Ave, Boulder, CO 80304
$1,600,000
4 beds3 baths3,215 sq ft
626 Poplar Ave, Boulder, CO 80304
$2,350,000
4 beds2.5 baths4,371 sq ft
86 S Cedar Brook Rd, Boulder, CO 80304
VIDEO TOUR
$2,650,000
4 beds1 bath2,179 sq ft
2003 Balsam Dr, Boulder, CO 80304
$949,000
3 beds3 baths1,816 sq ft
1219 Linden Ave, Boulder, CO 80304
$270,000
2 beds1 bath792 sq ft
2707 Valmont Rd Unit 311D, Boulder, CO 80304
$768,000
3 beds2 baths1,552 sq ft
1683 Yellow Pine Ave, Boulder, CO 80304
$2,189,200
3 beds2.5 baths3,368 sq ft
316 Pine Tree Ln, Boulder, CO 80304
$4,975,000
5 beds6 baths4,687 sq ft
661 Maxwell Ave, Boulder, CO 80304
Karolyn Merrill • RE/MAX of Boulder
See all

Provided by Redfin

Sale history for 300 Pine Needle Rd

Date

Event

Price

IRES as Distributed by MLS Grid #973114

Dec 22, 2022

Sold

$2,250,000

$348/sq ft

Nov 30, 2022

Contingent

—

Oct 4, 2022

Price Changed

$2,497,500

$386/sq ft

Aug 11, 2022

Listed

$2,900,000

$448/sq ft

IRES as Distributed by MLS Grid #966456

Aug 4, 2022

Listing Removed

—

May 24, 2022

Listed

$2,900,000

$448/sq ft

IRES as Distributed by MLS Grid #4657115

Apr 25, 2022

Listing Removed

—

Dec 3, 2021

Listed

$2,900,000

$448/sq ft

IRES as Distributed by MLS Grid #4770364

Jul 15, 2021

Listing Removed

—

May 20, 2021

Listed

$2,000,000

$309/sq ft

IRES as Distributed by MLS Grid #2038600

Feb 23, 2021

Listing Removed

—

Jul 27, 2020

Listed

$1,998,000

$309/sq ft

IRES as Distributed by MLS Grid #919335

Mar 6, 2021

Listing Removed

—

Feb 24, 2021

Contingent

—

Feb 8, 2021

Contingent

—

Jan 2, 2021

Price Changed

$1,998,000

$309/sq ft

Jan 2, 2021

Price Changed

$1,995,000

$308/sq ft

Nov 18, 2020

Price Changed

$2,050,000

$317/sq ft

Oct 8, 2020

Price Changed

$2,095,000

$324/sq ft

Aug 31, 2020

Price Changed

$2,158,000

$334/sq ft

Jul 25, 2020

Listed

$2,399,000

$371/sq ft

IRES as Distributed by MLS Grid #7677841

Jun 24, 2020

Listing Removed

—

May 22, 2020

Listed

$1,899,000

$294/sq ft

REColorado as Distributed by MLS Grid #IR912588

Jun 26, 2020

Listing Removed

—

May 21, 2020

Listed

$1,899,000

$294/sq ft

IRES as Distributed by MLS Grid #2097782

Mar 6, 2020

Listing Removed

—

Feb 15, 2020

Listed

$2,400,000

$371/sq ft

IRES as Distributed by MLS Grid #902876

Mar 6, 2020

Listing Removed

—

Jan 29, 2020

Listed

$2,400,000

$371/sq ft

IRES as Distributed by MLS Grid #881314

Nov 7, 2019

Listing Removed

—

Sep 27, 2019

Price Changed

$2,500,000

$386/sq ft

Sep 9, 2019

Listing Removed

—

Jun 19, 2019

Price Changed

$2,700,000

$417/sq ft

May 16, 2019

Listed

$2,995,000

$463/sq ft

IRES as Distributed by MLS Grid #8476215

May 1, 2019

Listing Removed

—

Feb 7, 2019

Listed

$3,395,000

$525/sq ft

IRES as Distributed by MLS Grid #871374

May 2, 2019

Listing Removed

—

Feb 1, 2019

Listed

$3,395,000

$525/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$13,544 (+19.8%)

$26,413 + $111,181

$137,594

2024

$11,306 (+1.7%)

$26,413 + $111,181

$137,594

2023

$11,120 (+57.9%)

$23,022 + $101,766

$124,788

2017

$7,043

$17,856 + $60,185

$78,041

2016

$7,043 (+5.2%)

$17,856 + $60,185

$78,041

2015

$6,693 (+5.8%)

$23,323 + $52,329

$75,652

2014

$6,327 (−6.1%)

$23,800 + $43,597

$67,397

2013

$6,739 (+23.2%)

$23,800 + $43,597

$67,397

2012

$5,472 (+3.6%)

$23,800 + $43,597

$67,397

2011

$5,283 (−2.6%)

$15,920 + $42,825

$58,745

2010

$5,424 (+17.8%)

$15,920 + $42,825

$58,745

2009

$4,604

$19,640 + $42,180

$61,820

Tax history for 300 Pine Needle Rd

Year

Property tax

Land + Additions

Assessment*

2025

$13,544 (+19.8%)

$26,413 + $111,181

$137,594

2024

$11,306 (+1.7%)

$26,413 + $111,181

$137,594

2023

$11,120 (+57.9%)

$23,022 + $101,766

$124,788

2017

$7,043

$17,856 + $60,185

$78,041

2016

$7,043 (+5.2%)

$17,856 + $60,185

$78,041

2015

$6,693 (+5.8%)

$23,323 + $52,329

$75,652

2014

$6,327 (−6.1%)

$23,800 + $43,597

$67,397

2013

$6,739 (+23.2%)

$23,800 + $43,597

$67,397

2012

$5,472 (+3.6%)

$23,800 + $43,597

$67,397

2011

$5,283 (−2.6%)

$15,920 + $42,825

$58,745

2010

$5,424 (+17.8%)

$15,920 + $42,825

$58,745

2009

$4,604

$19,640 + $42,180

$61,820

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

1.89 Acres

Year renovated

2010

Sq. Ft.

5,572

Year built

1996

Style

Single Family Residential

County

Boulder County

APN

R0034574

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 5, 2026.

Forestry District

Rural areas established for the purpose of efficiently using land to conserve forest resources, protect the natural environment, and preserve open areas.

Permitted uses

Include but are not limited to:

Agriculture
Equestrian facility
Livestock production
Housing-Group
Housing-Single unit
Bed & breakfast
Office
Public service
Communications tower
Park & open space

Property details

Parking

Parking Features
Covered Spaces: 4
Garage: Yes
Attached Garage: Yes
Garage Spaces: 4
Parking Features: Garage Door Opener, RV/Boat Parking, Oversized, Tandem

Interior

Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 2
Bathrooms (Three Quarter): 1

Bedroom Information
Bedrooms Total: 5

Heating & Cooling
Cooling: Yes
Evaporative Cooling, Ceiling Fan(s)
Heating: Yes
Wood Stove, Radiant, 2 or more Heat Sources

Interior Features
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Water Purifier Owned, Disposal
Fireplace: Yes
Fireplace Features: Free Standing, Electric, Primary Bedroom, Great Room
Flooring: Wood Floors
High Speed Internet, Central Vacuum, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Loft, Wet Bar, Jack & Jill Bathroom, Kitchen Island, Two Primary Suites, Steam Shower, 9ft+ Ceilings, Beamed Ceilings
Laundry Features: Sink, Washer/Dryer Hookups, Main Level

Room Information
Basement: Crawl Space, Walk-Out Access, Daylight, Built-In Radon

Exterior

Exterior Features
Attached Greenhouse, Balcony, Hot Tub Included
Patio and Porch Features: Patio, Deck
Roof: Composition

Pool Information
Spa: Yes
Spa Features: Bath

Land Information
Road Surface Type: Dirt, Gravel

Lot Information
Horse(s): No
Lot Features: Fire Hydrant within 500 Feet, Wooded, Sloped
Other Structures: Workshop
Zoning: RES

Property Information
Property Type: Residential
View: Yes
Waterfront: No

Subdivision Information
Subdivision Name: Pine Brook Hills
MLS Area Major: Suburban Mountains

Building Information
Above Grade Finished Area: 4827
Below Grade Finished Area: 1643
Building Area Total: 4827
Construction Materials: Wood/Frame, Stone, Stucco, Other

Financial

Tax Information
Tax Annual Amount: 7873
Tax Year: 2020

Financial Information
Listing Terms: Cash, Conventional

Utilities

Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric
Gas: Natural Gas
Sewer: Septic

Location

HOA Information
Association: Yes

School Information
High School District: Boulder Valley Dist RE2
Elementary School: Foothill
Middle or Junior School: Centennial
High School: Boulder

Location Information
Directions: From Broadway head west on Linden Avenue. Turn Right on North Cedar Brook. Turn Right on Pine Needle Road. Head 1/2 mile. Home is on the Right.
Unparsed Address: 300 Pine Needle Rd Boulder CO 80304
Street Number: 300
Street Name: Pine Needle
Street Suffix: Rd
City: Boulder
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80304
Coordinates: -105.30193,40.04809
Latitude: 40.04809
Longitude: -105.30193

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 5,572
Stories: 1.0
Lot Size: 1.89 acres
Style: Single Family Residential
Year Built: 1996
Year Renovated: 2010
County: Boulder County
APN: R0034574

Home facts updated by county records on Oct 5, 2026

Other

Miscellaneous Information
Exclusions: Seller's Personal Property (some furniture negotiable)

Listing Information
Attribution Contact: 3034495000
Close Price: $2,250,000
Photos Count: 40
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed

Listing Date Information
Close Date: Thursday, December 22, 2022
Cumulative Days on Market: 213
Days on Market: 134
Listing Contract Date: Thursday, August 11, 2022
Modification Timestamp: Friday, August 2, 2024 1:54 AM

Home Information
Direction Faces: South
Door Features: French Doors
Levels: Four-Level, Three Or More
Window Features: Window Coverings, Skylight(s)
Year Built: 1996

Green Information
Green Building Verification Type: HERS Score = 67
Green Energy Efficient: Southern Exposure

Around this home

Schools

Foothill Elementary School

Public K-5 • Assigned • 1.3mi

9/10

Centennial Middle School

Public 6-8 • Assigned • 1.8mi

6/10

Boulder High School

Public 9-12 • Assigned • 2.8mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

5/10 Fire Factor

3% chance of being in a wildfire in next 30 years

2/10 Heat Factor

4 days above 92° expected this year, 9 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

2/10 Air Factor

2 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Boulder, CO • 80304

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.5 hours in June and 6 hours in December, placing it above the U.S. average for solar exposure.

10.5 hrs

6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$2.42M – $2.92M

Reach more buyers when you sell with Redfin. Save up to $25,415 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

NEW 21 HRS AGO

$3,350,000

4 beds3.5 baths3,495 sq ft

645 Concord Ave, Boulder, CO 80304

$1,325,000

4 beds3 baths3,968 sq ft

3540 19th St, Boulder, CO 80304

Jennifer Crow • RE/MAX Professionals

$2,975,000

4 beds3.5 baths3,215 sq ft

3123 3rd St, Boulder, CO 80304

NEW CONSTRUCTIONVIDEO TOUR

$3,495,000

6 beds6.5 baths5,106 sq ft

5354 2nd St, Boulder, CO 80304

$1,800,000

4 beds4 baths2,735 sq ft

1975 Norwood Ave, Boulder, CO 80304

$1,395,000

Land— sq ft

1559 Orchard Ave, Boulder, CO 80304

New listings for sale in 80304

NEW 21 HRS AGO

$3,350,000

4 beds3.5 baths3,495 sq ft

645 Concord Ave, Boulder, CO 80304

COMING SOON

$9,500,000

6 beds7.5 baths9,447 sq ft

1080 Juniper Ave, Boulder, CO 80304

$1,600,000

4 beds3 baths3,215 sq ft

626 Poplar Ave, Boulder, CO 80304

$2,350,000

4 beds2.5 baths4,371 sq ft

86 S Cedar Brook Rd, Boulder, CO 80304

VIDEO TOUR

$2,650,000

4 beds1 bath2,179 sq ft

2003 Balsam Dr, Boulder, CO 80304

$949,000

3 beds3 baths1,816 sq ft

1219 Linden Ave, Boulder, CO 80304

$270,000

2 beds1 bath792 sq ft

2707 Valmont Rd Unit 311D, Boulder, CO 80304

$768,000

3 beds2 baths1,552 sq ft

1683 Yellow Pine Ave, Boulder, CO 80304

$2,189,200

3 beds2.5 baths3,368 sq ft

316 Pine Tree Ln, Boulder, CO 80304

Home values near 300 Pine Needle Rd

Data from public records.

Address	Redfin Estimate
295 Pine Needle Road, Boulder, CO 4 Beds \| 2 Baths \| 2773 Sq. Ft.	$1,330,300
312 Pine Needle Road, Boulder, CO 4 Beds \| 3.5 Baths \| 3906 Sq. Ft.	$2,114,474

Address	Redfin Estimate
145 Pine Needle Road, Boulder, CO 3 Beds \| 2.5 Baths \| 2631 Sq. Ft.	$1,225,092
324 Pine Needle Road, Boulder, CO 3 Beds \| 3.5 Baths \| 3381 Sq. Ft.	$2,215,317

Address	Redfin Estimate
101 Pine Needle Road, Boulder, CO 3 Beds \| 4.5 Baths \| 3890 Sq. Ft.	$2,237,462
309 Pine Needle Road, Boulder, CO 3 Beds \| 3.5 Baths \| 4527 Sq. Ft.	$1,752,466

Property information provided by undefined .

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Central Boulder homes for sale
Wonderland Hills homes for sale
North Boulder homes for sale
Newlands homes for sale
Wonderland Lake homes for sale

Houses for rent in Pine Brook Hill	Agents near me	Fort Collins, CO homes for sale	Pine Brook Hill Housing Market
Houses for sale near me	Denver, CO homes for sale	Aurora, CO homes for sale
Land for sale near me	Colorado Springs, CO homes for sale	Arvada, CO homes for sale
Open Houses near me	Boulder, CO homes for sale	Pine Brook Hill Property Records
Condos for sale near me	Littleton, CO homes for sale	CO New Listings

Denver homes for sale
Boulder homes for sale
Arvada homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 80304, CO

Sale history for 300 Pine Needle Rd

Tax history for 300 Pine Needle Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 80304

Home values near 300 Pine Needle Rd

More real estate resources