Skip main navigation
Off market
  • $1,818,300

    40078 County Road 23, Weld, CO 80610

    4beds
    3,040sqft
    Single Family Residence
    Built in 2017
    7 Acres Lot
    $1,818,300 Zestimate®
    $598/sqft
    $3,715 Estimated rent

    Home value

    $1,818,300

    $1.73M - $1.91M

    $3,715/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,715/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,715/mo

    Rent Zestimate®

    Refinance and save

    $8,551/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $8,551/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked:

    Source: NextHome,MLS#: 1052522MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 1
    • 1/2 bathrooms: 2
    Features
    • Has basement: No
    Interior area
    • Total structure area: 3,040
    • Total interior livable area: 3,040 sqft

    Property

    Lot
    • Size: 7 Acres
    Details
    • Parcel number: 070512300004

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Condition
    • Year built: 2017

    Community & HOA

    Location
    • Region: Weld

    Financial & listing details

    • Price per square foot: $598/sqft
    • Tax assessed value: $933,824
    • Annual tax amount: $5,158
    • Date on market: 2/26/2026
    • Lease term: Contact For Details

    Price history

    DateEventPrice
    4/28/2026Listing removed$1,899,990$625/sqft
    Source: IRES as distributed by MLS GRID #1052522 Report a problem
    4/23/2026Price change$1,899,990-4%$625/sqft
    Source: IRES as distributed by MLS GRID #1052522 Report a problem
    4/18/2026Price change$1,979,500-1%$651/sqft
    Source: IRES as distributed by MLS GRID #1052522 Report a problem
    3/18/2026Price change$1,999,500-9.1%$658/sqft
    Source: IRES as distributed by MLS GRID #1052522 Report a problem
    2/28/2026Listed for sale$2,200,000$724/sqft
    Source: IRES as distributed by MLS GRID #1052522 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2026$5,158 +29.4%$58,740 +0.7%
    2025$3,987 +10.3%$58,360 +13.9%
    2024$3,614 -6.8%$51,260 -1%
    2023$3,879 +8.9%$51,760 +14%
    2022$3,563 +24%$45,400 -2.8%
    2021$2,874 $46,700 +21.2%
    2020$2,874 +31.1%$38,520 +10.8%
    2019$2,192 -14.7%$34,780 +24.9%
    2018$2,568 +17.2%$27,850 +110.5%
    2017$2,192 +97.2%$13,230 +12.9%
    2016$1,111 +24.1%$11,720
    2015$896 +7.3%$11,720
    2014$834 --
    Find assessor info on the county website

    Neighborhood: 80610

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,818,300
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,818,300