OPEN HOUSE SATURDAY - FEB 22ND FROM 1-3PM BRING AN OFFER, HEAVY EQUIPMENT AVAILABLE - INCOME POTENTIAL FOR A FARM/HORSE RETREAT/HOTEL/THERAPY/POLO EVENTS. HAVE YOUR BUSINESS RUNNING BY SPRING SEASON - WE CAN HELP. OTHER USES FOR THIS PROPERTY ARE ALSO AVAILABLE - CALL LISTING AGENTS FOR MORE INFORMATION 303.720.2865. Experience one of Boulder County's rarest opportunities - an exceptional ACREAGE PROPERTY with a SPECIAL USE PERMIT ALLOWING 45 HORSES (IMPOSSIBLE TO GET TODAY), located in unincorporated Boulder County with expansive Front Range views and strong income potential! Create a year-round fully operational equestrian center which includes a BRAND NEW INSULATED INDOOR ARENA 150' x 90' with premium rubber-sand footing and professional lighting for year-round riding and training. 3 outdoor arenas include: 150' x 150' lighted arena, 65' x 90' training arena, and regulation dressage arena suitable for clinics, competition prep, and professional programs. 5 barns with flexible layouts offer up to 45 stalls and multiple configurations including box stalls, open stalls with runs, and enclosed heated options, each equipped with automatic waterers, organized feed storage, and tack rooms. A round pen, efficient manure and shavings systems, and well-designed paddock layout support smooth day-to-day operations. A covered hay barn stores approximately 6,720 small bales and a 600 sq ft shop provides space for tools and equipment. The 5-room clubhouse overlooking the indoor arena offers client space, offices or event hosting potential. Residential 3 Bedroom, 2 Bath open floor plan home provides on-site living for Owners AND Trainers OR COME BUILD YOUR DREAM HOME. Located right by Teller Farm Open Space Trail and 6 miles from Downtown Boulder, the property offers an unbeatable blend of privacy. VERY AFFORDABLE/LOW UTILITIES include Left Hand District water, a private agricultural well, 2 septic systems (LOW OPERATING COSTS).
Offered By
Alexis Papadakis-Greenberg, Coldwell Banker Global Luxury Denver
Natural Gas Available, Electricity Available, Cable Available
SEWER
Septic Tank
WATER SOURCE
City, Well
Year Built
1976
Basement
Partial, Unfinished, Crawl Space, Slab
FINISHED BASEMENT SIZE
1198.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
Parking Features
Attached
Fence
Fenced
Lot Features
Level, Abuts Public Open Space, Meadow, Outbuildings, Paved
Garage spaces
1
View
Mountain(s), Hills
CITY
Boulder
SUBDIVISION
Boulder Equestrian Center
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
TAX AMOUNT
19465.0
LATEST UPDATE
2026-02-21T22:19:15.250Z
DAYS ON MARKET
115
PRICE CHANGE(S)
$3,299,900 Feb 21, 2026
$3,500,000 Jan 27, 2026
Property Details
Property TypeResidential
StatusActive
Bedrooms3
Bathrooms (Full)1
Property Sub TypeMixed Use
Square Feet1,543
MLS #4495115
Bathrooms (¾)1
AppliancesDishwasher, Refrigerator, Microwave
FIREPLACE FEATURESLiving Room
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERSeptic Tank
WATER SOURCECity, Well
Year Built1976
BasementPartial, Unfinished, Crawl Space, Slab
FINISHED BASEMENT SIZE1198.0
ARCHITECTURAL STYLEContemporary/Modern
RoofComposition
Parking FeaturesAttached
FenceFenced
Lot FeaturesLevel, Abuts Public Open Space, Meadow, Outbuildings, Paved
Garage spaces1
ViewMountain(s), Hills
CITYBoulder
SUBDIVISIONBoulder Equestrian Center
COUNTYBoulder
AREASuburban Plains
STATECO
TAX AMOUNT19465.0
LATEST UPDATE2026-02-21T22:19:15.250Z
DAYS ON MARKET115
PRICE CHANGE(S)
$3,299,900 Feb 21, 2026
$3,500,000 Jan 27, 2026
Market Trends
New Properties On Market
23
360%
Increase In New Listings
Average Asking Price
$1,062,430
$649,430 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$615
$119 Increase In List Price/Sq. Ft.
Average Days On Market
22
50 Day
Decrease In Days On Market
Data as of Feb 21, 2026.
Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 31, 2026.
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.