Title Page Background
DEBUG FN args: Array ( [0] => 1491 [1] => [2] => [3] => agent ) BEFORE: Site: 1491 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1491 Igate: njhud LocID: 1491 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1491 AND i.igate IN ('mohud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1491 [1] => [2] => [3] => lender ) BEFORE: Site: 1491 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1491 Igate: njhud LocID: 1491 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1491 AND i.igate IN ('mohud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1491 [1] => [2] => [3] => other ) BEFORE: Site: 1491 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1491 Igate: njhud LocID: 1491 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1491 AND i.igate IN ('mohud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

28864 Hunter Lane
Shell Knob, MO 65747

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2573 Square Feet
Agency: Keller Williams Tri-Lakes
Agency Phone: (417) 336-4999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Step into a world of timeless charm and sophistication with this homestead on 10-acres, featuring French country design elements that evoke a sense of rustic elegance. From the inviting wrap-around deck to the interior adorned with beautiful lighting, gorgeous windows, hard wood floors and ceiling; every corner exudes warmth and character. Walk in the front door into the custom-built kitchen with tall, soft close cabinetry and a one-of-a-kind island repurposed from an antique piece. The kitchen flows into the great room with 10' ceilings giving a sense of spatial ambiance for any furniture ensemble. Step into the Main Bedroom, a tranquil sanctuary, huge custom walk-in closet, custom made vanity and a walk-in shower to relax & unwind. The split floorplan allows for privacy, as the other rooms can be a nice office or welcoming guest bedrooms. The home sits on 10-acres, mostly flat, a small pond, mature trees, a garden area & fruit trees, where the landscaping elements have been done for you. With 8 water spickets throughout the estate, energize your inner outdoor enthusiast . The entrance is welcoming with a circular driveway and the workshop/garage has 16' ceilings, heated and cooled, 6-8'' of concrete to park heavy vehicles or equipment or your favorite cars or boats that need to be protected. With 2 distinct living areas, the possibilities are endless. The apartment has 1 bedroom/1 bathroom, heated & cooled, full kitchen, full bathroom & appliances. Welcome to a home where every aspect has been thoughtfully designed and the attention to detail is amazing. So close to the Table Rock Lake you have access to 4 public boat ramps- putting your boat into the Lake anytime you desire as you can walk to the water within the subdivision on the Kings River. Bring your fishing rods, reels, boats, kayaks, 4-wheelers or horses. You will be amazed when you see this property and what is has to offer and SO MUCH MORE!!! Check it out and experience it!
MlsNumber: --
ListingId: 60267839


Listing Provided By: Keller Williams Tri-Lakes, original listing
Phone: (667) 201-8374
Office Phone: (417) 336-4999
Agent Name: Carolyn Boss
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App