Nestled in the heart of Boulder County's equestrian paradise, this extraordinary property offers over 5 acres with panoramic mountain views from Rocky Mountain National Park to Boulder's Flatirons! The cozy home offers meticulous attention to detail and quality throughout including in-floor radiant heat on the main level, enormous kitchen, large windows in perfect locations to bring the outdoors in! Located just a short drive from national level horse trainers, fabulous restaurants and entertainment, and all the conveniences you could want in the vibrant cities of Boulder, Niwot, Longmont, and Lyons! Great outdoor spaces & a flowing floorplan that are perfect for entertaining or just enjoying the views from the hot tub! Located directly across from Boulder County open space, this home has the ideal balance with exceptional privacy and also easy access to your daily needs all at an affordable price! The barn has three adjustable 12x12 stalls, tack room, wash rack and hay storage! The arena is suitable for dressage or stadium jumping with the perfect grade for drainage. 2 gentle sloping grazing pastures, foal fences, smooth wire cross fences, wood posts throughout, and an automatic waterer in the pasture. 50 minutes to Denver International Airport, 23 minutes to Boulder, 8 minutes to Longmont!
Utility FeaturesNatural Gas Available, Electricity Available
SEWERSeptic
WATER SOURCEDistrict Water, Left Hand
Year Built1991
BasementFull
FINISHED BASEMENT SIZE980.0
RoofComposition
EXTERIOR FEATURESHot Tub Included
Parking FeaturesRV/Boat Parking, Oversized
FenceFenced
Lot FeaturesLawn Sprinkler System, Level, Abuts Ditch, Unincorporated
Garage spaces3
ViewMountain
CITYLongmont
SUBDIVISIONTrevarton East Nupud
COUNTYBoulder
AREASuburban Plains
STATECO
SENIOR COMMUNITYNo
TAX AMOUNT8664.0
LATEST UPDATE2025-03-26T20:06:57.608Z
DAYS ON MARKET64
PRICE CHANGE(S)
$1,950,000 Jan 18, 2025
$1,850,000 Mar 26, 2025
CUMULATIVE DAYS ON MARKET384
Market Trends
New Properties On Market
55
112%
Increase In New Listings
Average Asking Price
$1,089,188
$150,345 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$322
$40 Decrease In List Price/Sq. Ft.
Average Days On Market
19
30 Day
Decrease In Days On Market
Data as of Apr 21, 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.