REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Rick Perez

rick@wesell5280.com +1(303) 295-2995

$ 1,979,500

Est. payment | -/mo

4 Beds

3 Baths

3,330 SqFt

Save Virtual Tour

$ 1,979,500

Est. payment | -/mo

Save Virtual Tour

4 Beds

3 Baths

3,330 SqFt

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 3,330 sqft

Price per Sqft $594

Subdivision Rec Exempt Re-277

MLS Listing ID IR1052522

Bedrooms 4

Full Baths 1

Three Quarter Bath 2

HOA Y/N No

Abv Grd Liv Area 2,220

Year Built 2017

Annual Tax Amount $5,158

Tax Year 2025

Lot Size 7.000 Acres

Acres 7.0

Property Sub-Type Single Family Residence

Source recolorado

Property Description

7 acres. 2017-built. Dual parcel. Income producing. Agricultural well. This exceptional Weld County property combines a quality-built 2017 residence, a separate income-producing dwelling, and a rare licensed agricultural well on 7 acres of fully usable land - a combination that is genuinely difficult to replicate in Northern Colorado today. The primary residence at 40078 CR 23 offers 3,040 square feet of finished living space with 4 bedrooms, 3 bathrooms, mountain views, central air, spa, and an open main-level layout designed for both daily living and entertaining. A five-car detached shop with an attached greenhouse sits directly adjacent - providing exceptional capacity for equipment, vehicles, agricultural operations, or workspace. The second parcel at 40076 CR 23 includes a separate dwelling currently generating rental income, adding immediate investment return to the property from day one. Additional infrastructure includes a large second shop, a traditional barn, and a dedicated chicken coop - improvements that took years to assemble and would cost hundreds of thousands of dollars to rebuild from the ground up. The licensed agricultural well supports irrigation potential for approved agricultural uses. New wells permitted for comparable agricultural use in this area of Weld County require costly and complex augmentation plans, making existing permitted wells of this type increasingly scarce. Zoned agricultural. No HOA. VA and USDA loan eligible. Located 15 minutes from Fort Collins and 30 minutes from Greeley and I-25 - accessible to Front Range employment and amenities while maintaining genuine rural privacy. Equestrian, hobby farm, multi-generational living, and investment use all supported. Properties combining this level of infrastructure, income, and water resource on 7 acres near the Front Range are rarely available. Schedule a private showing.

Location

State CO

County Weld

Zoning Res

Rooms

Main Level Bedrooms 1

Interior

Heating Forced Air, Propane

Cooling Central Air

Fireplace N

Appliance Dishwasher, Oven, Refrigerator

Exterior

Exterior Feature Spa/Hot Tub

Parking Features RV Access/Parking

Garage Spaces 5.0

Utilities Available Electricity Available

View Mountain(s)

Roof Type Composition

Total Parking Spaces 5

Building

Lot Description Sprinklers In Front

Water Well

Level or Stories One

Structure Type Frame

Schools

Elementary Schools Range View

Middle Schools Windsor

High Schools Windsor

School District Weld Re-4

Others

Ownership Individual

Acceptable Financing 1031 Exchange, Cash, Conventional, FHA, USDA Loan, VA Loan

Listing Terms 1031 Exchange, Cash, Conventional, FHA, USDA Loan, VA Loan

Virtual Tour https://listings.nextdoorphotos.com/vd/233065606

Listed by NextHome Rocky Mountain

Schools and Properties Nearby

Find out why customers are choosing LPT Realty to meet their real estate needs

+1(303) 295-2995

rick@wesell5280.com

40078 County Road 23 Ault, CO 80610