Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1591 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1591 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1591 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2020 Persimmon Hill Lane
Lampe, MO 65681
Carolyn S. Mayhew with Mayhew Realty Group LLC, original listing - (417) 319-6955

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3675 Square Feet
Agency: Mayhew Realty Group LLC
Agency Phone: (417) 319-6955

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 33 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Welcome to the exquisite lakefront retreat you've been waiting for! Nestled on over 33+ acres of pristine beauty, this stunning Table Rock Lake home boasts more than 1200 feet of gentle lake frontage, offering unparalleled access to the water's edge.Upon arrival, a paved county road leads you to the driveway, where you are greeted by an electric gate flanked by two street lights. As you drive in, you will be captivated by the park-like setting featuring all-season landscaping, a serene waterfall, charming courtyard arches, and lush perennial vines and bushes.Step inside to a dramatic foyer that opens up to a spacious, open floor plan designed to impress. Soaring cathedral ceilings create an airy ambiance, while the floor-to-ceiling river rock fireplace serves as the focal point of the living area, perfect for cozy gatherings. The large kitchen, with its generous island and versatile Spanish influence, is a chef's dream, offering ample space for culinary creativity.This expansive 3500-square-foot home is packed with extras, ensuring every need and hobby is catered to. Stay fit in the dedicated workout room, indulge in your favorite crafts in the hobby room, and enjoy the convenience of a garage that accommodates four cars and includes a greenhouse section. Additionally, a whole-home propane generator ensures you are never without power.Comfort and efficiency are paramount in this home, featuring a newer high-efficiency HVAC system to keep you comfortable year-round.Whether you are seeking a full-time residence or a luxurious vacation home, this property offers an unmatched combination of elegance, comfort, and functionality. Experience the best of lakefront living in this breathtaking home on Table Rock Lake, where every detail has been thoughtfully designed to create a perfect blend of sophistication and tranquility. Don't miss the opportunity to make this dream home your own!
MlsNumber: --
ListingId: 60287589


Listing Provided By: Mayhew Realty Group LLC, original listing
Phone: (417) 319-6955
Office Phone: (417) 319-6955
Agent Name: Carolyn S. Mayhew
Disclaimer: Copyright © 2025 Southern Missouri Regional MLS, LLC (SOMO). All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1591 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for LaNora Kay
LaNora Kay
ASCIIWeichert, REALTORS - The Griffin Company
Call Today!: (417) 331-3200

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App