$3,895,000

Estimated payment $22,877/month

Total Views 580
4 Beds
6 Baths
6,994 Sq Ft
$557 Price per Sq Ft

Highlights

  • Water Views
  • River Access
  • Gated Community
  • Douglass Elementary School Rated A-
  • Spa
  • 2.1 Acre Lot

About This Home

Discover one of Boulder County's most extraordinary homes in coveted Ertl Farms, offering epic, sweeping views of all of Boulder, the Front Range and surrounding areas. From sunrise to sunset, the panorama is so stunning that every window feels like a piece of art, framing nature in its best light.Set within an exceptionally private and peaceful setting, the property comes with exclusive access to City of Boulder Open Space-including a pond and section of Boulder Creek that is available to you for fishing, a gentle paddle, walking, and brilliant bird-watching. It's a true sanctuary right at your doorstep and only the nine residents of Ertl Farms are allowed to use it. It's an extraordinarily rare benefit.The home is designed to maximize views and provide comfort and flexibility, featuring a fully private in-law suite/apartment with its own separate entrance. Ideal for guests, multigenerational living or extended stays. The suite offers independence while keeping everyone connected.Despite the remarkable privacy, you're just 7-10 minutes from groceries, restaurants, and coffee, and only 18 minutes to downtown Boulder-close enough for convenience, far enough for genuine tranquillity.This is a exceptionally rare find and opportunity that blends big views, open space, serenity, and effortless access to Boulder. A generational home to be enjoyed for many years to come.

Listing Agent

Jim Candy

Live West Realty Listed on: 12/08/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,262

Year Built

  • Built in 1987

Lot Details

  • 2.1 Acre Lot
  • Open Space
  • Southern Exposure
  • Sprinkler System

HOA Fees

  • $117 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Driveway Level

Property Views

  • Water
  • Panoramic
  • City
  • Mountain

Home Design

  • Tile Roof
  • Stucco

Interior Spaces

  • 6,994 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Bar Fridge
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Security Gate
  • Laundry on main level

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher

Flooring

  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Spa
  • River Access
  • Access To Lake
  • Deck

Schools

  • Douglass Elementary School
  • Platt Middle School
  • Centaurus High School

Utilities

  • Cooling System Mounted To A Wall/Window
  • Forced Air Heating and Cooling System
  • Baseboard Heating
  • Septic System
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R0100716

Community Details

Overview

  • Association fees include snow removal, security
  • Ertl Farms Association
  • Ertl Farm Nupud Subdivision

Recreation

  • Park
  • Hiking Trails

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,262

Year Built

Built in 1987

Lot Details

0

HOA Fees

$117 per month

Parking

3

Listing Details

  • Inclusions: Gas Range/Oven,Dishwasher,Refrigerator,Bar Refrigerator,Microwave
  • Year Built: 1987
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 2.1
  • Road Frontage Type: Priv Rd up to County Standards
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Ertl Farm Nupud
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Southern Exposure
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 6994
  • Special Features: None
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave
  • Accessibility Features: Level Drive, Main Level Laundry
  • Has Basement: Full, Partially Finished, Walk-Out Access
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Gas, Primary Bedroom
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry
  • IRESDS_HasFamilyRoom: No
  • Master Bedroom Master Bedroom Level: Main
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Stone Floor
  • Master Bathroom Features: Full Primary Bath, 5 Piece Primary Bath

Exterior Features

  • Roof: Tile
  • Lot Features: Lawn Sprinkler System, Abuts Private Open Space, Lake Access, River Access
  • View: Mountain(s), Foothills View, Plains View, City, Water, Panoramic
  • View: Yes
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Stucco
  • Exterior Features: Hot Tub Included
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Wall/Window Unit(s), Ceiling Fan(s)
  • Heating: Forced Air, Baseboard
  • Utilities: Natural Gas Available, Cable Available
  • Security: Security Gate
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: Septic
  • Water Source: District Water, Left Hand Water
  • Gas Company: Natural Gas

Condo/Co-op/Association

  • HOA Fee Includes: Snow Removal, Security
  • Community Features: Park, Hiking/Biking Trails, Gated
  • Senior Community: No
  • Association Fee: 1400
  • Association Fee Frequency: Annually
  • Association Name: Ertl Farms
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Douglass
  • HighSchool: Centaurus
  • Junior High Dist: Boulder Valley Dist RE2
  • Middle Or Junior School: Platt

Lot Info

  • Zoning: A
  • Lot Size Sq Ft: 91388
  • Parcel #: R0100716
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 27262

Multi Family

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $27,262 $271,169 $37,150 $234,019
2024 $27,262 $271,169 $37,150 $234,019
2023 $26,847 $291,236 $24,643 $270,278
2022 $26,058 $263,753 $21,962 $241,791
2021 $24,875 $271,343 $22,594 $248,749
2020 $20,420 $213,170 $42,614 $170,556
2019 $20,106 $213,170 $42,614 $170,556
2018 $18,661 $195,782 $39,168 $156,614
2017 $18,130 $216,448 $43,302 $173,146
2016 $15,732 $163,498 $36,377 $127,121
2015 $14,817 $147,260 $47,760 $99,500
2014 $13,364 $147,260 $47,760 $99,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/08/2025 12/08/25 For Sale $3,895,000 -- $557 / Sq Ft
Source: IRES MLS

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- None Available
Special Warranty Deed $3,650,000 Stewart Title Guaranty Co
Interfamily Deed Transfer -- None Available
Warranty Deed $2,550,000 Fahtco
Warranty Deed $1,200,000 --
Warranty Deed $850,000 --
Warranty Deed $265,000 --
Deed -- --
Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $650,000 No Value Available
Source: Public Records

Source: IRES MLS

MLS Number: 1048236

IRES MLS

APN: 1465080-06-002