Welcome to your dream farmhouse retreat! This stunning 4 bedroom 4 bath home is nestled on an expansive 8.3 acres offering breathtaking views of the surrounding landscape and plenty of privacy. The exterior showcases charming natural wood shutters and elegant stone details that highlight the character of this beautiful property. Step inside to discover a spacious and inviting interior featuring a large kitchen with premium stainless steel appliances, a generous island and custom cabinetry that adds a touch of sophistication, while the expansive windows flood the space with natural light showcasing stunning views throughout. This home also boasts a full unfinished walk-out basement, providing endless opportunities for customization and additional living space. Prime location near wineries and surrounded by beautiful hiking trails! Don't miss the chance to make this exquisite property your own!
Active
Listed by: Triple Creek Realty LLC • Matthew A Herbst • Contact: 573-760-4635
Price cut: $14.9K (6/27)
$585,000
24925 State Route Mm, Farmington, MO 63640
4beds
2,600sqft
Single Family Residence
Built in 2021
8.3 Acres Lot
$571,800 Zestimate®
$225/sqft
$-- HOA
What's special
Generous islandStunning views throughoutPremium stainless steel appliancesElegant stone detailsCharming natural wood shuttersSpacious and inviting interiorLarge kitchen
- 30 days |
- 1,887 |
- 134 |
Zillow last checked:
Listing updated:
Listed by:
Matthew A Herbst 573-760-4635,
Triple Creek Realty LLC
Source: MARIS,MLS#: 26033075
Originating MLS: Mineral Area Board of REALTORS
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 4
- Main level bathrooms: 4
- Main level bedrooms: 4
Heating
- Forced Air, Propane
Cooling
- Ceiling Fan(s), Central Air, Electric
Features
- Basement: Concrete,Unfinished,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Great Room, Masonry
Interior area
- Total structure area: 2,600
- Total interior livable area: 2,600 sqft
- Finished area above ground: 2,600
Property
Parking
- Total spaces: 3
- Parking features: Garage
- Garage spaces: 3
Features
- Levels: One
Lot
- Size: 8.3 Acres
- Features: Landscaped, Other
Details
- Parcel number: 231.0002000000014.0
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Atrium,Craftsman
- Property subtype: Single Family Residence
Materials
- Aluminum Siding, Brick Veneer, Cedar, Frame, Stone Veneer, Vinyl Siding, Wood Siding
Condition
- Year built: 2021
Utilities & green energy
- Electric: Single Phase
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Electricity Connected, Propane
Community & HOA
HOA
- Has HOA: No
Location
- Region: Farmington
Financial & listing details
- Price per square foot: $225/sqft
- Date on market: 5/27/2026
- Cumulative days on market: 30 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
- Electric utility on property: Yes
Estimated market value
Zestimate®
$571,800
Estimated sales range
$543,000 - $600,000
Rent Zestimate®
$2,630/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/27/2026 | Price change | $585,000-2.5%$225/sqft |
Source: | ||
| 6/11/2026 | Pending sale | $599,900$231/sqft |
Source: | ||
| 5/27/2026 | Listed for sale | $599,900$231/sqft |
Source: | ||
| 8/3/2025 | Listing removed | $599,900$231/sqft |
Source: | ||
| 7/3/2025 | Listed for sale | $599,9000%$231/sqft |
Source: | ||
| 6/27/2025 | Listing removed | $599,999$231/sqft |
Source: BHHS broker feed #25021701 Report a problem | ||
| 6/26/2025 | Listed for sale | $599,999$231/sqft |
Source: | ||
| 4/30/2025 | Pending sale | $599,999$231/sqft |
Source: BHHS broker feed #25021701 Report a problem | ||
| 4/30/2025 | Contingent | $599,999$231/sqft |
Source: | ||
| 4/8/2025 | Listed for sale | $599,999-4.8%$231/sqft |
Source: | ||
| 3/4/2025 | Listing removed | $629,999$242/sqft |
Source: BHHS broker feed #24062493 Report a problem | ||
| 1/26/2025 | Price change | $629,999-3.1%$242/sqft |
Source: | ||
| 12/27/2024 | Price change | $649,999-1.5%$250/sqft |
Source: | ||
| 11/26/2024 | Price change | $659,900-2.2%$254/sqft |
Source: | ||
| 11/20/2024 | Listed for sale | $675,000+12.7%$260/sqft |
Source: | ||
| 4/11/2022 | Sold | -- |
Source: | ||
| 3/9/2022 | Pending sale | $599,000$230/sqft |
Source: | ||
| 3/2/2022 | Listed for sale | $599,000+1100.4%$230/sqft |
Source: | ||
| 1/18/2019 | Sold | -- |
Source: | ||
| 12/19/2018 | Pending sale | $49,900$19/sqft |
Source: Goodson Realty #18087036 Report a problem | ||
| 10/30/2018 | Listed for sale | $49,900$19/sqft |
Source: Goodson Realty #18087036 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Principal & interest
$1,547Mortgage insurance
$0Property taxes
$170Home insurance
$105HOA fees
$0Utilities
Not includedAll 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: 63640
Nearby schools
GreatSchools rating
- 4/10Jefferson Elementary SchoolGrades: 1-4Distance: 2.7 mi
- 6/10Farmington Middle SchoolGrades: 7-8Distance: 3.6 mi
- 5/10Farmington Sr. High SchoolGrades: 9-12Distance: 4.1 mi
Schools provided by the listing agent
- Elementary: Farmington R-Vii
- Middle: Farmington Middle
- High: Farmington Sr. High
Source: MARIS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $452,9003 bd2 ba1.7k sqft4831 Valley Forge Rd, Farmington, MO 63640Off Market
Save - $287,6003 bd2 ba1.8k sqft4683 Ee Hwy, Farmington, MO 63640Off Market
Save - $355,2003 bd2 ba1.8k sqft4683 Highway Ee, Farmington, MO 63640Off Market
Save - $331,3004 bd2 ba1.4k sqft4668 Highway Ee, Farmington, MO 63640Off Market
Save - $256,2002 bd1 ba1.2k sqft4681 Ee Hwy, Farmington, MO 63640Off Market
Save - $296,4003 bd2 ba1.6k sqft4669 Ee Hwy, Farmington, MO 63640Off Market
Save - $322,7003 bd2 ba1.3k sqft4668 Ee Hwy, Farmington, MO 63640Off Market
Save - $193,1002 bd1 ba1.7k sqft39843986 Dixon Dr, Farmington, MO 63640Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $479,9004 bd3 ba3k sqft302 Chestnut View Rd, Farmington, MO 63640For Sale
Save 
MLS ID #26029389, Macy L Busenbark, Coldwell Banker Hulsey. MARIS - $589,0004 bd4 ba2.6k sqft1200 Ridge Top Dr, Farmington, MO 63640For Sale
Save 
MLS ID #26036220, Vanessa L Trokey, Coldwell Banker Hulsey. MARIS - $565,0004 bd4 ba2.6k sqft210 Buzzard Rock Rd, Farmington, MO 63640For Sale
Save 
MLS ID #26036671, Tracy L Collins, Berkshire Hathaway HomeServices Select Properties. MARIS - $550,0003 bd4 ba3.5k sqft412 Willow Creek Dr, Farmington, MO 63640For Sale
Save 
MLS ID #26043649, Jon M Barlow, Freedom Realty MO, LLC. MARIS - $450,0004 bd3 ba3k sqft1036 Ridgewood Farms Rd, Farmington, MO 63640For Sale
Save
MLS ID #26025291, Misty Castleberry, Triple Creek Realty LLC. MARIS - $549,9003 bd3 ba2.7k sqft4714 Huntington Dr, Farmington, MO 63640For Sale
Save
MLS ID #26034375, Eric M Kofron, Midwest Real Estate. MARIS - $544,0004 bd2 ba2.1k sqft3403 Weatherby Ln, Farmington, MO 63640New Construction
Save
MLS ID #26016448, Kimberly E Briese, KBH Realty Group. MARIS - $525,0004 bd3 ba3.5k sqft733 Magnolia Dr, Farmington, MO 63640For Sale
Save
MLS ID #26032155, Kim D Hutson, Coldwell Banker Hulsey. MARIS - $499,0005 bd2 ba3.2k sqft5961 Busiek Rd, Farmington, MO 63640For Sale
Save
MLS ID #26019016, Matthew A Herbst, Triple Creek Realty LLC. MARIS - $715,0004 bd4 ba3.2k sqft5437 Hwy D, Farmington, MO 63640For Sale
Save
MLS ID #26029223, Tara L Hebenstreit, Coldwell Banker Realty - Gundaker. MARIS - $440,0005 bd4 ba3.2k sqft301 Ridgewood Ct, Farmington, MO 63640For Sale
Save
MLS ID #26027165, Geoffrey S McDowell, Swinford Realty, LLC. MARIS - $509,9003 bd2 ba2.4k sqft3525 Weatherby Ln, Farmington, MO 63640New Construction
Save
MLS ID #26021018, Tom D Priday, Homestead Real Estate. MARIS - $405,0004 bd3 ba2k sqft4715 Tillman Trl, Farmington, MO 63640For Sale
Save
MLS ID #26040753, Josh Chapman, EXP Realty LLC. MARIS - $500,0004 bd2 ba1.7k sqft5220 Hurryville Rd, Farmington, MO 63640For Sale
Save
MLS ID #26030093, Matthew A Herbst, Triple Creek Realty LLC. MARIS - $519,0004 bd3 ba2.7k sqft1045 Hollercamp Rd, Farmington, MO 63640For Sale By Owner
Save - $365,0004 bd3 ba3.8k sqft1506 Justin Ln, Farmington, MO 63640For Sale
Save
MLS ID #26043333, Natalia Hibbert, Midwest Real Estate. MARIS - $435,0005 bd3 ba2.9k sqft726 Deerfield Ln, Farmington, MO 63640New Construction
Save
MLS ID #26038843, Pamela Chyba, ListWithFreedom.com Inc. MARIS - $489,9003 bd3 ba1.6k sqft6337 Dd Hwy, Farmington, MO 63640For Sale
Save
MLS ID #26039023, David L Werner, ReeceNichols Real Estate. MARIS - $550,0003 bd3 ba1.7k sqft8140 Old Jackson Rd, Farmington, MO 63640For Sale
Save
MLS ID #25077466, Lance Cureton, Living The Dream Inc.. MARIS - $499,0004 bd4 ba3.5k sqft1214 Meadow Lake Ln, Park Hills, MO 63601For Sale
Save
MLS ID #26042031, Kimberly E Briese, KBH Realty Group. MARIS
- Request a tour
as early as today at 11:00 am
Contact agent
- Missouri
- Sainte Genevieve County
- Farmington
- 63640
- 24925 State Route Mm