78 Photos

$1,000,000

507 Leach Branch Road

none, Hermann, Missouri, 65041

MLS® 26048927 · Listed by RE/MAX Results

2 bedrooms3 bathrooms3236.00 sqftResidential8 days on marketBuilt 1996Lot 1853478.00$2,485 taxes (2025)2 garageElectric,Forced Air · Central AirBathroom,Partially Finished,Full,Walk-Out Access basement
Take the virtual tour

About this property

Escape to your own private retreat with this extraordinary custom timber-frame home nestled on 42 breathtaking acres ml. Featuring a stocked 1+ acre lake, a charming guest cabin/studio, and a 40' x 30' Morton building with workshop, this remarkable property offers the perfect blend of comfort, recreation, and country living. Ideally located less than 15 minutes from Hermann's renowned wineries, restaurants, and shops, and only 10 minutes from the Katy Trail. Designed by the original owner/architect, this one-of-a-kind home showcases warm, inviting spaces and spectacular views of the lake, woods, and rolling fields from nearly every room. The thoughtfully updated kitchen features quartz countertops, updated appliances, two pantries—including a walk-in pantry—and abundant workspace for entertaining. The spacious primary suite includes a large walk-in closet and a beautifully renovated bath. A stunning loft overlooks the main living area and can easily serve as a fourth bedroom, while an additional loft space makes a perfect children's playroom, library, or home office. Expansive windows fill the home with natural light, capturing the surrounding beauty. Three fireplaces—one on each level—create cozy gathering spaces throughout the home. The finished 3rd level (included in the total square footage) offers a family room, bedroom, full bath, and generous storage. Additional updates include a new HVAC system installed in 2022. Step outside to enjoy fishing from one of two private docks, hiking through your own acreage, relaxing by the lake, or hosting guests in the charming cabin. Whether you're looking for a full-time residence, weekend getaway, or private family retreat, this exceptional property delivers an unforgettable lifestyle in the heart of Missouri wine country.

Room details

RoomLevelDimensionsFeatures
OtherMain9.00 × 7.00
HearthMain21.00 × 14.00
KitchenMain19.00 × 15.00
OtherMain5.00 × 4.00
BathroomMain8.00 × 6.00
LaundryMain8.00 × 7.00
Bathroom 3Main13.00 × 9.00
SunroomMain13.00 × 10.00
LoftMain21.00 × 4.00
LoftSecond19.00 × 8.00
Primary BedroomSecond19.00 × 12.00
Primary BathroomSecond14.00 × 9.00
OtherSecond10.00 × 9.00
Bonus RoomSecond16.00 × 14.00
LibrarySecond16.00 × 14.00
Family RoomThird18.00 × 19.00
Bedroom 2Third17.00 × 10.00
StorageThird19.00 × 8.00
StorageThird7.00 × 6.00

Ask Maryam about this home

Your details go directly to Maryam and are never shared.

Comparable recent sales

Sold records the MLS® data provider selected as comparable to this home — nearby recent sales at a similar price, bed count, and property type. Locations are shown at the neighborhood level only.

SoldJun 24, 2026

$1,000,000

Listed at $1,150,000

none, Hermann, Missouri

2 bd · 3 ba · 3236.00 sqft · Residential

SoldJun 9, 2026

$1,100,000

Listed at $1,149,000

Innsbrook, Innsbrook, Missouri

2 bd · 3 ba · 3200.00 sqft · Residential

MLS® data for this listing last updated Aug 15, 2026.

Market snapshot

The none, Hermann market

Closed sales in none, Hermann over the last 12 months.

$199,750

Median sold price

67

Avg. days on market

16

Homes sold

Median sold price by month

Median sold price trend from Nov 2025 ($85,500) to Aug 2026 ($332,500)Nov 2025Aug 2026