Skip main navigation
For sale
    • Price increase: $5 (7/24)
    $1,999,975

    677 County Road 18, Longmont, CO 80504

    4beds
    8,214sqft
    : 
    $12,190/mo
    Get pre-qualified
    Mixed Use
    Built in 1985
    10 Acres Lot
    $-- Zestimate®
    $243/sqft
    $-- HOA

    What's special

    Fully fenced propertyMain-level primary suiteGranite countertopsAbundant cabinetryAttached three-car garageLarge windows and skylightsTwo walk-in pantries
    Experience the best of Colorado county living on this private, irrigated 10-acre estate just 10 minutes from Longmont and 30 minutes from Boulder. Tucked away at the end of a quiet road in Weld County, this exceptional 7,050 sq. ft. Cape Cod-style farmhouse captures breathtaking 360-degree mountain and plains views. Designed for comfortable living and entertaining, the home features expansive rooms filled with natural light from large windows and skylights. Choose between a main-level primary suite or an upper-level suite with an adjoining nursery and sitting room. Two moss-rock fireplaces add warmth and charm, while fresh interior and exterior paint, new carpet, a new roof, and newer HVAC systems make this home truly move-in ready. The chef's kitchen is equipped with a commercial Viking gas range, granite countertops, abundant cabinetry, and two walk-in pantries. An oversized mudroom includes a convenient walk-up dog wash. A 900 sq. ft. basement provides additional storage. The attached three-car garage is complemented by 1,164 sq. ft. of unfinished space above, offering excellent potential for an ADU, guest quarters, studio, or home office. Outside the fully fenced property includes LHWD domestic tap water, a private well, and a versatile 2,200 sq. ft. barn/kennel with its own bathroom and separate septic system. Whether you envision horses, a hobby farm, orchard, greenhouse, apiary, cidery, chickens, or extensive gardens, this property offers endless homestead possibilities. With no HOA, no covenants, and no conservation easement, you'll enjoy the freedom to create the lifestyle you've always imagined. A rare opportunity to own and extraordinary country estate with privacy, flexibility, and spectacular views in one of northern Colorado's most desirable locations.
    33 days
    |
    1,078
    |
    67
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Arnold Turner 303-776-1105,

    Turner Realty,

    Patricia Turner 303-362-3821,

    Turner Realty

    Source: IRES as distributed by MLS GRID,MLS#: 1063026MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 2
      • 3/4 bathrooms: 1
      • 1/2 bathrooms: 2
      • Main level bathrooms: 3
      Primary bedroom
      • Description: Tile
      • Features: 3/4 Primary Bath, Full Primary Bath
      • Level: Main
      • Area: 345 Square Feet
      • Dimensions: 23 x 15
      Bedroom 2
      • Description: Hardwood
      • Level: Main
      • Area: 168 Square Feet
      • Dimensions: 14 x 12
      Bedroom 3
      • Description: Carpet
      • Level: Upper
      • Area: 833 Square Feet
      • Dimensions: 17 x 49
      Bedroom 4
      • Description: Carpet
      • Level: Upper
      • Area: 280 Square Feet
      • Dimensions: 20 x 14
      Dining room
      • Description: Hardwood
      • Level: Main
      • Area: 156 Square Feet
      • Dimensions: 13 x 12
      Kitchen
      • Description: Hardwood
      • Level: Main
      • Area: 442 Square Feet
      • Dimensions: 26 x 17
      Laundry
      • Description: Linoleum
      • Level: Main
      • Area: 168 Square Feet
      • Dimensions: 21 x 8
      Living room
      • Description: Hardwood
      • Level: Main
      • Area: 280 Square Feet
      • Dimensions: 14 x 20
      Recreation room
      • Description: Carpet
      • Level: Upper
      • Area: 720 Square Feet
      • Dimensions: 40 x 18
      Study
      • Description: Hardwood
      • Level: Main
      • Area: 180 Square Feet
      • Dimensions: 10 x 18
      Heating
      • Forced Air, Baseboard, Zoned, Radiant, 2 or more Heat Sources, 2 or more H20 Heaters
      Cooling
      • Central Air, Ceiling Fan(s)
      Appliances
      • Included: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Disposal
      • Laundry: Sink, Washer/Dryer Hookup
      Features
      • Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Pantry, Walk-In Closet(s), Kitchen Island, Two Primary Suites, High Ceilings, Sun Room, Split Bedroom Plan
      • Flooring: Wood
      • Windows: Skylight(s), Window Coverings, Wood Frames
      • Basement: Unfinished,Sump Pump
      • Has fireplace: Yes
      • Fireplace features: Insert, Two or More, Living Room, Family Room
      Interior area
      • Total structure area: 6,085
      • Total interior livable area: 8,214 sqft
      • Finished area above ground: 6,085
      Video & virtual tour

      Property

      Parking
      • Total spaces: 3
      • Parking features: Garage Door Opener, RV Access/Parking, Attached, Oversized
      • Attached garage spaces: 3
      • Details: Attached
      Accessibility
      • Accessibility features: Level Lot, Level Drive, Accessible Hallway(s), Low Carpet, Accessible Doors, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
      Features
      • Levels: One and One Half
      • Stories: 1
      • Patio & porch: Patio, Deck
      • Exterior features: Sprinkler System
      • Spa features: Bath
      • Fencing: Fenced,Dog Run/Kennel,Vinyl
      • Has view: Yes
      • View description: Mountain(s), Hills, Plains View, Panoramic
      Lot
      • Size: 10 Acres
      • Features: Evergreen Trees, Deciduous Trees, Native Plants, Level, Unincorporated, Water Rights Included, Mineral Rights Excluded
      Details
      • Additional structures: Storage
      • Parcel number: R4357606
      • Zoning: AG
      • Special conditions: Private Owner
      • Other equipment: Fireplace Tools Included
      • Horses can be raised: Yes
      • Horse amenities: Zoning Appropriate for 4+ Horses, Barn, Corral(s), Pasture, Tack Room, Riding Trail

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Cape Cod,Farmhouse,Contemporary
      • Property subtype: Mixed Use
      Materials
      • Frame, Brick, Vinyl Siding
      • Roof: Composition
      Condition
      • New construction: No
      • Year built: 1985

      Utilities & green energy

      • Electric: Xcel
      • Gas: Propane
      • Sewer: Septic Tank
      • Water: District, Well
      • Utilities for property: Electricity Available, Propane, Wood/Coal, Satellite Avail, High Speed Avail
      Green energy
      • Energy efficient items: Sun Space, Windows, Doors, Thermostat

      Community & HOA

      Community
      • Security: Fire Alarm
      • Subdivision: Rec Exempt
      HOA
      • Has HOA: No
      Location
      • Region: Longmont

      Financial & listing details

      • Price per square foot: $243/sqft
      • Tax assessed value: $1,403,666
      • Annual tax amount: $8,266
      • Date on market: 6/29/2026
      • Listing terms: Cash,Conventional,FHA,VA Loan
      • Exclusions: N/A
      • Electric utility on property: Yes
      • Road surface type: Gravel

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/24/2026Price change$1,999,975+0%$243/sqft
        Source: IRES as distributed by MLS GRID #1063026 Report a problem
        6/29/2026Listed for sale$1,999,970$243/sqft
        Source: IRES as distributed by MLS GRID #1063026 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$8,266 +29.3%$90,690 +3.4%
        2025$6,392 +4.3%$87,730 +11.5%
        2024$6,130 -1.8%$78,710 -1%
        2023$6,242 -1.7%$79,470 +19.5%
        2022$6,352 +6.6%$66,510 -2.8%
        2021$5,961 $68,420 +5.6%
        2020$5,961 -5.5%$64,790
        2019$6,309 +4.6%$64,790 -5.6%
        2018$6,029 -4.4%$68,630
        2017$6,309 +4.2%$68,630 +20.7%
        2016$6,053 +24.1%$56,870
        2015$4,876 +9.6%$56,870 +9.3%
        2014$4,450 $52,050
        2013-- $52,050 -19%
        2012-- $64,290
        2011-- $64,290 -10.4%
        2010-- $71,770
        2009-- $71,770 +26.8%
        2008-- $56,580
        2007-- $56,580
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 80504

        Getting around

        0 / 100
        Car-Dependent
        0 / 100
        No Nearby Transit
        25 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Grand View
        • Middle: Coal Ridge
        • High: Mead

        Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Longmont Topics

                Search
                Updates
                Favorites
                Plan
                Inbox