$850,000
OPEN SAT 12PM - 1PM $25K PRICE DROP

5440 Highway 87 Franklin, MO 65250

Estimated payment $4,813/month

Total Views 2,104
4 Beds
3.5 Baths
4,121 Sq Ft
$206 Price per Sq Ft

Highlights

  • Lake Front
  • 50 Acre Lot
  • Partially Wooded Lot
  • New Franklin Elementary School Rated 9+
  • Fireplace in Kitchen
  • Traditional Architecture

About This Home

The Ultimate Missouri Homestead! This one-of-a-kind property blends modern comfort with true homestead living. Situated on a blacktop frontage road with a private paved drive, the custom-built home showcases timeless craftsmanship and thoughtful detail throughout. Step inside to a freshly painted, bright, and open floorplan highlighted by a see-through fireplace, an updated spa-like primary suite with a custom Onyx walk-in shower, double vanity, and expansive closets, plus a sunroom with walls of windows that frame breathtaking views of the land. The chef's kitchen boasts Cambridge stone countertops, a large island, Bosch gas range and hood, and windows with views to your beautiful land, making it as functional as it is beautiful. Outdoors, this property truly shines. Enjoy your morning overlooking the 10-acre stocked lake with private dock, or entertain on expansive patios and in the fenced backyard. A 40x30 metal building wired for electric, plus a custom utility shed for equipment, make it ideal for hobby farming, storage, or workshop use. With space to breathe, water to fish, land to roam, and a home built for both style and function, this property is ready to become your forever homestead.

Listing Agent

Megan Walters

EXP Realty LLC License #2017030193 Listed on: 10/03/2025

EXP Realty LLC

Co-Listing Agent

Jasmyne McMichael

EXP Realty LLC License #2023002564

Open House Schedule

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1993 | Remodeled

Lot Details

  • 50 Acre Lot
  • Lake Front
  • Vinyl Fence
  • Back Yard Fenced
  • Aluminum or Metal Fence
  • Lot Has A Rolling Slope
  • Partially Wooded Lot

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • Wet Bar
  • Paddle Fans
  • Skylights
  • Circulating Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room

Kitchen

  • Eat-In Kitchen
  • Built-In Convection Oven
  • Gas Range
  • Microwave
  • Bosch Dishwasher
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Kitchen Island
  • Solid Surface Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Disposal
  • Fireplace in Kitchen

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Bathroom on Main Level
  • Bathtub with Shower
  • Shower Only

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Partially Finished Basement

  • Walk-Out Basement
  • Interior Basement Entry

Home Security

  • Prewired Security
  • Smart Thermostat
  • Storm Doors
  • Fire and Smoke Detector

Outdoor Features

  • Covered Patio or Porch
  • Storage Shed
  • Shop

Schools

  • New Franklin Elementary And Middle School
  • New Franklin High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Propane
  • Programmable Thermostat
  • Propane
  • Municipal Utilities District Water
  • Water Softener is Owned
  • Lagoon System
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Franklin Subdivision

Listing and Financial Details

  • Assessor Parcel Number 165015000000003000

Home Details

Home Type

Single Family

Year Built

Built in 1993 | Remodeled

Lot Details

0

Parking

2

Listing Details

  • Directions: Hwy 40 to Hwy 87 6.5 miles.
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • Half Bathroom Level: Main
  • Year Built: 1993
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 50.0
  • Road Surface Type: Paved, Public Maintained
  • Subdivision Name: FRANKLIN
  • Above Grade Finished Sq Ft: 3106.0
  • Architectural Style: 15 Story
  • New Construction: No
  • Foundation Type:Walkout Basement: Yes
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Dining:Breakfast Room: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Water District: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Foundation Access:Inside Entrance: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Flooring:Wood2: Yes
  • Patio:Concrete2: Yes
  • Fence:Backyard: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Outbuildings:LawnStorage Shed: Yes
  • Heat Fuel:Propane: Yes
  • Fence:Full: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Fence Material:Metal4: Yes
  • Outbuildings:Shop: Yes
  • Utilities:Sewage-Lagoon: Yes
  • Patio:Brick3: Yes
  • Utilities:GasPropaneTankRented: Yes
  • Fence Material:Vinyl4: Yes
  • Special Features: 4097

Interior Features

  • Has Basement: Walk-Out Access
  • Flooring: Wood, Carpet, Tile
  • Interior Amenities: High Spd Int Access, Tub/Shower, Stand AloneShwr/MBR, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Bar-Wet Bar, Smart Thermostat, Breakfast Room, Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Counter-SolidSurface, Cabinets-Wood, Kitchen Island, Pantry
  • Appliances: Water Softener Owned
  • Possible Use: Horses
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1015.0
  • Door Features: Storm Door(s)
  • Fireplace Features: Air Circulating, In Living Room, In Kitchen, Gas
  • Fireplace: Yes
  • Living Area: 4121.0
  • Window Features: Skylight(s), Windows-Vinyl
  • Fireplace:Gas: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Counter-SolidSurface: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Kitchen Features Pantry: Yes
  • KitchenFeatures:Range-Gas: Yes
  • Fireplace:Air Circulating: Yes
  • Fireplace:In Kitchen: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:ENERGY STAR Qualified Appliances: Yes
  • InteriorFeatures:Programmable Thermostat(s): Yes
  • InteriorFeatures:Remodeled: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Utility Sink: Yes
  • KitchenFeatures:Refrigerator: Yes
  • InteriorFeatures:Water Softener Owned: Yes
  • KitchenFeatures:Convection Oven: Yes
  • KitchenFeatures:Vent Fan: Yes
  • KitchenFeatures:Wall Oven(s): Yes
  • InteriorFeatures:Storm Door(s): Yes
  • InteriorFeatures:Skylight(s): Yes
  • InteriorFeatures:Wired for Sec Sys: Yes

Exterior Features

  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Metal, Vinyl
  • Lot Features: No Crops, Rolling Slope
  • Waterfront Features: Lake(s)
  • Waterfront: Yes
  • Foundation Details: Poured Concrete
  • Other Structures: Lawn/Storage Shed, Shop
  • Patio And Porch Features: Concrete, Back, Brick, Front Porch
  • Property Condition: Remodeled
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Garage Dr Opener(s), Attached
  • General Property Description:Garage Capacity: 2
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

  • Utilities: Sewage-Lagoon, Water-District, Cable Available, Electric-County, GasPropaneTankRented, Trash-Private
  • Cooling: Central Electric, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Propane
  • Laundry Features: Utility Sink, Laundry-Main Floor
  • Security: Wired for Sec Sys, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: New Franklin
  • Junior High Dist: New Franklin
  • High School: New Franklin
  • Middle Or Junior School: New Franklin

Lot Info

  • Current Use: Livestock, Pasture, Recreational
  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Lot Size Sq Ft: 2178000.0
  • Parcel #: 165015000000003000
  • Zoning Description: None

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $4,092 $56,780 $0 $0
2024 $4,092 $56,780 $0 $0
2023 $4,093 $56,780 $0 $0
2022 $4,094 $56,780 $0 $0
2021 $3,852 $56,780 $0 $0
2020 $3,866 $56,780 $0 $0
2019 $3,234 $56,810 $0 $0
2018 $3,217 $56,790 $0 $0
2017 $3,188 $56,790 $0 $0
2016 $3,185 $56,790 $0 $0
2015 -- $56,790 $0 $0
2014 -- $56,700 $0 $0
2013 -- $56,710 $0 $0
2012 -- $56,710 $0 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/12/2025 11/12/25 Price Changed $850,000 -2.9% $206 / Sq Ft
10/03/2025 10/03/25 For Sale $875,000 -- $212 / Sq Ft
Source: Columbia Board of REALTORS®

Source: Columbia Board of REALTORS®

MLS Number: 430087

Columbia Board of REALTORS®

APN: 16-5.0-15-000-000-003.000