Set on 40 private acres with panoramic views of the Rocky Mountains, Longs Peak, and the Flatirons, 6880 Saint Vrain Road is a reimagined Colorado estate where privacy, natural beauty, and luxury converge. Gutted and remodeled in 2024, this exceptional compound includes a 10,801 SF main home, a 4,658 SF modern barn conversion, and a 4,950 SF second barn - plus a pool, spa, pond, waterfall, fire pit, tennis court, outdoor kitchen, multiple patios, and valuable water rights. Zoned for horses, the land offers ample space for future stables, pasture, or agricultural use. Inside, thoughtful design meets dramatic scale. Vaulted ceilings, wide-plank floors, exposed beams, and oversized windows create a warm yet elevated ambiance. A floor-to-ceiling stone fireplace anchors the great room, which flows into a chef's kitchen with Wolf and Miele appliances, a waterfall island, and walk-in butler's pantry. A breakfast nook captures iconic Flatirons views. The main level also includes a formal dining room, lounge, office, oversized four-car garage, pool equipment room, mudroom, and laundry with dual washer/dryers. Upstairs, the primary suite is a private retreat with a fireplace, balcony, soaking tub, and zero-entry steam shower. Three additional en-suite bedrooms and a second laundry room provide comfort and convenience. The walk-out lower level includes a wet bar, wine cellar, theater, gym, guest bedroom, and a one-bedroom suite with full kitchen, living room, bathroom, and patio. The converted barn features a commercial-grade kitchen, vaulted entertaining space, fireplace, bathroom, and oversized garage doors that open to the outdoors. The secondary barn provides soaring ceilings and flexible potential for equestrian use, a workshop, or creative pursuits. Just 20 minutes to Boulder, 10 minutes to Longmont, and 1 mile from the shops and restaurants of Hygiene.
Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Disposal, Fire Alarm
FIREPLACE FEATURES
Two or More, Gas, Living Room, Bedroom, Great Room, Dining Room
Heating
Zoned, Radiant
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available
SEWER
Septic Tank, See Remarks
WATER SOURCE
District
Year Built
2006
Basement
Full, Partially Finished, Walk-Out Access
FINISHED BASEMENT SIZE
0.0
Roof
Metal, Tile
EXTERIOR FEATURES
Sprinkler System, Balcony, Hot Tub, Tennis Court(s), >8' Garage Door, Heated Garage, Oversized Garage, Drive Through Garage
Parking Features
RV Access/Parking
Fence
Fenced, Metal
Lot Features
Evergreen Trees, Deciduous Trees, Native Grass, Abuts Private Open Space, Meadow, Outbuildings, House Faces North, Pond(s), Water Rights Included
Garage spaces
4
Other Structures
Storage
View
Mountain(s), Hills, Plains View
CITY
Longmont
SUBDIVISION
Foothills East
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
TAX AMOUNT
38024.0
LATEST UPDATE
2026-01-23T00:30:46.917Z
PRICE CHANGE(S)
$25,000,000 Oct 30, 2025
Property Details
Property TypeResidential
StatusActive
Bedrooms6
Bathrooms (Full)3
Property Sub TypeMixed Use
Square Feet10,801
MLS #1038939
Bathrooms (¾)4
Bathrooms (Half)1
FlooringWood
AppliancesGas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Disposal, Fire Alarm
FIREPLACE FEATURESTwo or More, Gas, Living Room, Bedroom, Great Room, Dining Room
HeatingZoned, Radiant
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available
SEWERSeptic Tank, See Remarks
WATER SOURCEDistrict
Year Built2006
BasementFull, Partially Finished, Walk-Out Access
FINISHED BASEMENT SIZE0.0
RoofMetal, Tile
EXTERIOR FEATURESSprinkler System, Balcony, Hot Tub, Tennis Court(s), >8' Garage Door, Heated Garage, Oversized Garage, Drive Through Garage
Parking FeaturesRV Access/Parking
FenceFenced, Metal
Lot FeaturesEvergreen Trees, Deciduous Trees, Native Grass, Abuts Private Open Space, Meadow, Outbuildings, House Faces North, Pond(s), Water Rights Included
Garage spaces4
Other StructuresStorage
ViewMountain(s), Hills, Plains View
CITYLongmont
SUBDIVISIONFoothills East
COUNTYBoulder
AREASuburban Plains
STATECO
TAX AMOUNT38024.0
LATEST UPDATE2026-01-23T00:30:46.917Z
PRICE CHANGE(S)
$25,000,000 Oct 30, 2025
Market Trends
New Properties On Market
50
257%
Increase In New Listings
Average Asking Price
$905,186
$756,242 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$352
$164 Decrease In List Price/Sq. Ft.
Average Days On Market
13
34 Day
Decrease In Days On Market
Data as of Feb 05, 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.