Skip main navigation
For sale
  • $6,950,000

    16175 N Old Ter #7, Harrisburg, MO 65256

    5beds
    9,600sqft
    : 
    $46,195/mo
    Get pre-qualified
    Farm
    Built in 2011
    423 Acres Lot
    $-- Zestimate®
    $724/sqft
    $-- HOA

    What's special

    Fenced backyardFish cleaning stationRv hookupsEstablished hunting blindsAbundant storageOn-demand water heaterCentral vacuum system
    423± acre estate in Harrisburg, MO featuring a 27-acre stocked lake, 9,600± sq ft custom home, lake cabin, multiple shops, horse barn, and productive farm ground. Gated and highly improved, the property offers luxury living, livestock infrastructure, trophy hunting, and year-round recreation with excellent fishing, a year-round creek, and abundant wildlife.Located just north of Columbia, Missouri, and only 2.5 miles West of Highway 63, Lost Lake Farm is a rare opportunity to own a highly improved 423± acre estate centered around a remarkable 27-acre private lake. Thoughtfully assembled over two decades, the property combines luxury living, productive agricultural ground, exceptional hunting, and year-round recreation in a private setting accessed by a gated entrance and paved road frontage. The ranch is anchored by a custom-built 9,600± square foot residence completed in 2011. Designed with comfort, efficiency, and functionality in mind, the home offers 5 total bedrooms (3 on the main level) with a dedicated office, along with multiple gathering spaces and expansive views overlooking the lake. The primary suite features lake views, separate walk-in closets with a seating area, dual vanities, a large tile shower, and a jetted soaking tub. Two upstairs guest suites each include private bathrooms. The kitchen is designed for entertaining and everyday living, featuring a gas cooktop, double ovens, double refrigerators, a built-in wine refrigerator, and a wood-burning fireplace equipped with a thermostat and blower. The lower level includes two bedrooms connected by a Jack-and-Jill bathroom, a large recreation area with a bar, poker table, pool table, abundant storage, and a 12'x14 reinforced concrete safe room. A full concrete bunker beneath the garage provides approximately 700 square feet of additional storage, including a walk-in cooler and food storage area. Energy efficiency was a priority throughout construction. Improvements include a 6,000-watt solar system, Generac generator system, spray foam insulation, extensive blown-in insulation, radiant floor heat, an on-demand water heater, central vacuum system, and 35 emergency lights located throughout the home. Outdoor living spaces are equally impressive, featuring a screened outdoor kitchen, steam sauna, fire pit, smoker, and a fenced backyard. A separate lake cabin overlooks the water and provides additional accommodations for guests. The 27-acre private lake is a standout feature of the property. Stocked with trophy fish species, the lake has produced crappie exceeding four pounds and largemouth bass reaching double digits. Improvements at the lake include a boat dock with power, concrete boat ramp, fish cleaning station, RV hookups, and a drain valve system. Agricultural infrastructure throughout the ranch supports both livestock and hay production. Approximately 200 acres are currently in wheat production with plans for alfalfa establishment. The property is fenced and cross-fenced, with approximately 3 miles of newer woven-wire fencing and pipe fencing along the entrance. The ranch comfortably supports 45 to 60 cows and includes livestock working facilities, automatic waterers, and year-round water sources. Additional improvements include a 60'x80 shop with concrete floors and oversized overhead doors, a fully insulated 30'x50 shop with water and electric service, a horse barn complete with tack and feed rooms, and multiple supporting structures. Recreation is abundant throughout the property. A year-round creek, five ponds, established hunting blinds, and excellent populations of white-tailed deer and wild turkey create exceptional hunting opportunities. Lost Lake Farm offers a rare combination of luxury improvements, productive land, private water, and outdoor recreation, all within a manageable and thoughtfully developed setting in central Missouri. Property Highlights 423± acres 27-acre stocked private lake 9,600± sq ft custom home built in 2011 5 bedrooms plus office and recreation spaces throughout 700± sq ft concrete bunker with walk-in cooler Gated entrance with paved road access 60'x80 shop and 30'x50 insulated shop Lake cabin, boat dock, and concrete boat ramp Horse barn and livestock working facilities 200± acres currently in wheat production Year-round creek and 5 ponds Trophy white-tailed deer, turkey hunting, and established blinds Solar system, Generac generators, radiant heat, and extensive insulation Showings are by appointment only and may require proof of funds or other evidence of financial capability prior to scheduling.
    13 days
    |
    825
    |
    52
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Allen Treadwell 479-903-4109,

    Hayden Outdoors Real Estate

    Source: My State MLS,MLS#: 11835020

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 7
      • Full bathrooms: 6
      • 1/2 bathrooms: 1
      Features
      • Basement: Full
      • Has fireplace: No
      Interior area
      • Total structure area: 9,600
      • Total interior livable area: 9,600 sqft
      • Finished area above ground: 9,600

      Property

      Features
      • On waterfront: Yes
      Lot
      • Size: 423 Acres
      Details
      • Lease amount: $0

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Farm
      Condition
      • New construction: No
      • Year built: 2011

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Harrisburg

      Financial & listing details

      • Price per square foot: $724/sqft
      • Date on market: 7/22/2026
      • Date available: 06/12/2026
      • Listing agreement: Exclusive

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $5,888/mo

        Price history

        DateEventPrice
        7/22/2026Listed for sale$6,950,000$724/sqft
        Source: My State MLS #11835020 Report a problem
        7/22/2026Listing removed$6,950,000$724/sqft
        Source: NY State MLS #11835020 Report a problem
        6/17/2026Listed for sale$6,950,000$724/sqft
        Source: NY State MLS #11835020 Report a problem

        Public tax history

        Tax history is unavailable.

        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.

        Climate risks

        Neighborhood: 65256

        Getting around

        0 / 100
        Car-Dependent
        10 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: 000000

        Source: My State MLS. 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.

        Browse local experts