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','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

99 Diamond View Lane
Kimberling City, MO 65686

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4492
Agency: Keller Williams Tri-Lakes

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2010
Notes: 100% turnkey furnished luxury is here & 99 Diamond View Lane is a new watermark. You've been cordially invited to indulge in this perfectly private, MTV Cribs style, #tablerocklakeview estate, exceptionally & lovingly updated to todays, top of the line HGTV dream house standards. Welcome home to your over an acre private hillside. You will long for that feeling of complete relaxation as you turn into the drive of this 100% no updating required, over 4,300 sq. ft. home which includes 5 beds, 4 baths, attached 2 car garage & 40'x60' insulated drive-through shop building, & many more unparalleled amenities w/a canvas of crystal clear Table Rock Lake as a backdrop. Finished w/natural materials for beauty & longevity this home with fill you with excitement every turn of the way. The foyer allows guests to promptly enjoy vast open spaces from living to kitchen upon entering the home. The highlight: a master chef's kitchen designed w/ cooking & entertaining in mind, w/custom cabinetry, a pantry, & all new stainless appliances including a luxury zline gas stove. The main floor is filled w/light, vaulted wood-beamed ceilings, that add a level of opulence to the home, & the most incredible owner's suite w/a spa-like ensuite, intricate custom closet, & stunning tiled shower. The floors are brand new w/hardwoods, walls adorned w/new paint, new windows, new siding & newer HVAC. The lower level boasts an expansive wet bar/kitchenette & room enough for a family room & game room, XL guest beds & a workout room, full bath, a fraidy room, & all walk out to a gently sloping backyard. The ultimate lake place wouldn't be complete without the most awesome firepit gazebo you have ever seen. Need some lake time? There's an offering of a private 14x30 & 10x24 boat slip(add $) just a short cart drive away. Comprising:No!Manifesting dreams:Yes!@99 Diamond View Lane! ***ADDITIONAL LOTS AVAILABLE ADJACENT TO HOME-ALL HAVE ELECTRIC,WATER & SEWER HOOKUPS. MORE INFO/PRICES IN DOCUMENTS & PICTURES
MlsNumber: 60247876


Listing Provided By: Keller Williams Tri-Lakes, original listing
Name: Keller Williams Tri-Lakes
Phone: (417) 336-4999
Office Name: Keller Williams Tri-Lakes
Office Phone: (417) 336-4999
Agent Name: Ann Ferguson
Disclaimer: Copyright © 2024 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','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 Susan Halfacre
Susan Halfacre
ASCIISterling Real Estate Group
Call Today!: (417) 331-0933

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App