Public Remarks: Great equestrian estate with 109 acres of private land & incredible views. Located only minutes from Longmont, Berthoud and TPC Colorado. The property features a 4 bed 4.5 bath ranch home, 19 stall horse barn, indoor arena, heated workshop, hay barn, foreman/guest home, loafing sheds, riding trails, extensive fencing, water rights, irrigation ditches & more.The property is currently being used as a Hemp operation. The main house is being used as offices. The secondary home is also being used as offices. Great Views of Longs Peak and Ish Reservoir.
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Weld County
APN
—
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Apr 12, 2023.
A
Agricultural District
Rural areas where conservation of agricultural resources is of major value, and where residential development compatible with agricultural uses is allowed.
Permitted uses
Include but are not limited to:
Agriculture
Equestrian facility
Livestock production
Religious facility
Day care facility
Housing-Group
Housing-Single unit
Bed & breakfast
Educational/school
Kennel
Property details
Parking
Parking Features
Covered Spaces: 4
Garage: Yes
Attached Garage: Yes
Garage Spaces: 4
Interior
Bedroom Information
Bedrooms Total: 4
Exterior
Exterior Features
Fencing: Partial
Roof: Composition
Land Information
Irrigation Source: Flood, Sub-Irrigated, Ditches
Lot Information
Horse(s): Yes
Barn with 3+ Stalls, Corral(s)
Lot Features: Water Rights Included
Other Structures: Corral(s), Barn(s), Machine Shed, Livestock Shed
Zoning: Ag
Property Information
Property Type: Farm
Waterfront: No
Subdivision Information
Subdivision Name: none
MLS Area Major: Suburban Plains
Building Information
Construction Materials: Wood/Frame, Brick/Brick Veneer
Financial
Tax Information
Parcel Number: R0055575
Tax Annual Amount: 5892
Tax Year: 2021
Utilities
Utility Information
Sewer: Septic
Location
HOA Information
Association: No
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Mead
Middle or Junior School: Mead
High School: Mead
Location Information
Directions: The North East corner of 287 and Yellowstone Rd
Unparsed Address: 11021 Yellowstone Rd Longmont CO 80504
Street Number: 11021
Street Name: Yellowstone
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80504
Coordinates: -105.09742,40.24946
Latitude: 40.24946
Longitude: -105.09742
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Weld County
APN: —
Home facts updated by county records on Apr 12, 2023
Other
Miscellaneous Information
Exclusions: Equipment and Property TBD
Listing Information
Attribution Contact: 9706741990
Close Price: $2,700,000
Photos Count: 21
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Thursday, May 26, 2022
Cumulative Days on Market: 518
Days on Market: 192
Listing Contract Date: Wednesday, November 3, 2021
Modification Timestamp: Thursday, August 1, 2024 5:21 PM
Home Information
Year Built: 1985
Around this home
Schools
Mead Elementary School
Public PreK-5 • Assigned • 5.1mi
9/10
Mead Middle School
Public 6-8 • Assigned • 5.0mi
8/10
Mead High School
Public 9-12 • Assigned • 7.0mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
A vibrant northern Colorado community known for its scenic mountain views, extensive parks and trails, greenways, and a mix of established neighborhoods and newer housing options.