OPEN HOUSE THIS SATURDAY, AUGUST 9. You've been curious! Come and see! The BEST views in Boulder + Private Access to City Open Space for fishing, boating, hiking, etc. There is nothing like this in Boulder. Type "Boulder White Rocks Villa" into YouTube and see for yourself with our feature video. The fish featured in the photos is on this private access parcel - you can see the home in the background on the hillside! Then... COME AND SEE This is an opportunity to own a generational property featuring unrivaled views of Boulder Valley just minutes from the heart of downtown Boulder. Ertl Farms is an enclave of nine homes approached via a 6000 ft driveway through rolling hills framed by Longs Peak and the entire back range. You will be transported to the beautiful villas of Tuscany or Santa Barbara - combined with the magical views and mountains of Boulder, Colorado. It's an oasis but VERY quick to get to great amenities: * Gas/Convenience - 5 min.* Restaurants - 6 * Coffee - 6 * YMCA - 7 * Walmart - 8 * King Soopers - 8 * Gunbarrel Restaurants (Apertivo, Sancho's, Ampersand) - 8 * Whole Foods - 10 * Costco - 14 * 20th and Pearl St. - 17 Be sure to check out the beautiful renderings and floorplan ideas in the photos to create your dream kitchen. Expansive outdoor, view-facing deck space provides the perfect venue for relaxation and hosting Boulder's most memorable gatherings. Ten 4th of July fireworks displays are visible from the living room.The main floor primary bedroom's large windows directly faces all of Boulder Valley but retains privacy on this expansive two-acre lot. A mother-in-law apartment with its own entrance allows the perfect retreat for guests or live-in assistance. An entry foyer is reminiscent of European breezeways, the perfect place to sit among flowers, read or entertain. Again, Ertl Farms residents have PRIVATE access to Open Space allowing residents to walk out the backdoor and enjoy. Is there anything like this in all of Boulder?
Utility FeaturesNatural Gas Available, Cable Available
SEWERSeptic
WATER SOURCEDistrict Water, Left Hand Water
Year Built1987
BasementFull, Partially Finished, Walk-Out Access
FINISHED BASEMENT SIZE2543.0
ARCHITECTURAL STYLERanch
RoofTile
EXTERIOR FEATURESHot Tub Included
Parking FeaturesOversized
Lot FeaturesLawn Sprinkler System, Abuts Private Open Space, Lake Access, River Access
Garage spaces3
ViewMountain(s), Foothills View, Plains View, City, Water, Panoramic
CITYBoulder
SUBDIVISIONErtl Farms
COUNTYBoulder
AREASuburban Plains
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESPark, Hiking/Biking Trails, Gated
HOA1
TAX AMOUNT26846.52
HOA FEE1400.0
HOA FREQUENCYAnnually
LATEST UPDATE2025-08-08T17:18:11.473Z
DAYS ON MARKET327
PRICE CHANGE(S)
$4,495,000 Sep 10, 2024
$4,345,000 May 15, 2025
$4,295,000 Jul 23, 2025
$3,995,000 Jul 29, 2025
CUMULATIVE DAYS ON MARKET426
Market Trends
New Properties On Market
50
28%
Increase In New Listings
Average Asking Price
$887,009
$220,442 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$421
$1 Decrease In List Price/Sq. Ft.
Average Days On Market
19
23 Day
Decrease In Days On Market
Data as of Aug 17, 2025.
Remaining statistics above are calculated on activity within the period from Jun 01, 2025 to Jul 31, 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.