Mountain Homes Realty
Enter City, Zip or MLS

6880 saint vrain rd

Longmont, CO 80503

$25,000,000

6 BEDS 8 BATHS
10,801 SQFT39.91 AC LOT
Residential - Mixed Use
Image 1: Welcome to 6880 Saint Vrain Road! Set amidst the wide-open beauty of Boulder County, 6880 Saint Vrain Road is a fully transformed estate retreat where thoughtful design, luxurious comfort, and natural splendor converge.
Image 2: Completely remodeled in 2024, this remarkable compound includes a main residence, a multi-purpose modern barn conversion, a 2nd large barn, pool, spa, waterfall & tennis court, all situated on 40 acres with dramatic views of the Rocky Mountains.
Image 3: Positioned at the edge of the property, the second barn is a blank slate with concrete flooring and soaring ceilings. Whether envisioned for future equestrian use, hobby storage, or large-scale workshops, the space is full of potential.
Image 4: Multi-purpose modern barn conversion.
Bedrooms 6
Total Baths 8
Full Baths 3
Square Feet 10801
Acreage 39.92
Status Active
MLS # 1038939
County Boulder
More Info
Category Residential - Mixed Use
Status Active
Square Feet 10801
Acreage 39.92
MLS # 1038939
County Boulder
Listed By: Listing Agent The Zach Zeldner Team
Coldwell Banker Realty 02 - (720) 480-7650
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 with vaulted ceilings, wide plank floors, exposed beams, and oversized windows creating 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 and dryers. Upstairs, the primary suite is a private retreat with a fireplace, balcony, soaking tub, and zero-entry steam shower, while three additional en-suite bedrooms and a second laundry room provide comfort and convenience. The lower level is a full height walk-out level with substantial natural light and functional living spaces. This 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 one mile from the shops and restaurants of Hygiene.
Location not available

Exterior Features

  • Construction Mixed Use
  • Siding Frame, Stone, Stucco
  • Exterior Sprinkler System, Balcony, Hot Tub, Tennis Court(s), ">8 Garage Door", Heated Garage, Oversized Garage, Drive Through Garage
  • Roof Metal, Tile
  • Garage Yes
  • Garage Description RV Access/Parking, Attached
  • Water District
  • Sewer Septic Tank, See Remarks
  • Lot Description Evergreen Trees, Deciduous Trees, Native Grass, Abuts Private Open Space, Meadow, Outbuildings, House Faces North, Pond(s), Water Rights Included

Interior Features

  • Appliances Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Disposal, Fire Alarm
  • Heating Zoned, Radiant
  • Cooling Central Air
  • Basement Full, Partially Finished, Walk-Out Access
  • Fireplaces Description Two or More, Gas, Living Room, Bedroom, Great Room, Dining Room
  • Living Area 10,801 SQFT
  • Year Built 2006
  • Stories Two

Neighborhood & Schools

  • Subdivision Foothills East
  • School Disrict ST Vrain Dist RE 1J
  • Elementary School Blue Mountain
  • Middle School Altona
  • High School Silver Creek

Financial Information

  • Parcel ID R0071847
  • Zoning A

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Coldwell Banker Realty 02 - (720) 480-7650
Listings provided courtesy of the IRESDS MLS as distributed by MLS GRID.

Information is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 04/04/2026 11:04:42 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 IRESDS MLS, Inc.
Listing data is current as of 04/04/2026.

Contact Our Agent

By clicking “Submit”, you agree that Mountain Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.