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: * 7-11 Gas/Convenience - 5 min.* Jeannots (bakery) and Westbound (restaurant) - 6* Brewing Market (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?
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave
FIREPLACE FEATURES
Gas, Primary Bedroom
Heating
Forced Air, Baseboard
Cooling
Central Air, Room Air Conditioner, Ceiling Fan(s)
Utility Features
Natural Gas Available, Cable Available
SEWER
Septic
WATER SOURCE
District Water, Left Hand Water
Year Built
1987
Basement
Full, Partially Finished, Walk-Out Access
FINISHED BASEMENT SIZE
2543.0
ARCHITECTURAL STYLE
Ranch
Roof
Tile
EXTERIOR FEATURES
Hot Tub Included
Parking Features
Oversized
Lot Features
Lawn Sprinkler System, Abuts Private Open Space, Lake Access, River Access
Garage spaces
3
View
Mountain(s), Foothills View, Plains View, City, Water, Panoramic
CITY
Boulder
SUBDIVISION
Ertl Farms
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Park, Hiking/Biking Trails, Gated
HOA
1
TAX AMOUNT
26846.52
HOA FEE
1400.0
HOA FREQUENCY
Annually
LATEST UPDATE
2025-03-24T19:14:58.920Z
DAYS ON MARKET
193
PRICE CHANGE(S)
$4,495,000 Sep 10, 2024
CUMULATIVE DAYS ON MARKET
193
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)4
Property Sub TypeResidential-Detached
Square Feet6,994
MLS #1018344
Bathrooms (Half)2
AppliancesGas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave
FIREPLACE FEATURESGas, Primary Bedroom
HeatingForced Air, Baseboard
CoolingCentral Air, Room Air Conditioner, Ceiling Fan(s)
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-03-24T19:14:58.920Z
DAYS ON MARKET193
PRICE CHANGE(S)
$4,495,000 Sep 10, 2024
CUMULATIVE DAYS ON MARKET193
Market Trends
New Properties On Market
76
117%
Increase In New Listings
Average Asking Price
$996,962
$505,363 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$455
$55 Decrease In List Price/Sq. Ft.
Average Days On Market
11
22 Day
Decrease In Days On Market
Data as of Apr 07, 2025.
Remaining statistics above are calculated on activity within the period from Feb 01, 2025 to Mar 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.