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 = 1563 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 = 1563 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 = 1563 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;

1693 Country Club
Theodosia, MO 65761
Selenia Hulen-Ehrlich with Keller Williams Tri-Lakes, original listing - (417) 336-4999

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3170 Square Feet
Agency: Keller Williams Tri-Lakes
Agency Phone: (417) 336-4999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Put on your sunscreen and drive to 1693 Country Club Drive, where flip-flops and bathing suits will be your wardrobe! Here you can experience all the Lake time you desire! Minutes from the Marina and you are off to fish, tube, wakeboard and even scuba dive and snorkel! Enjoy the pristine waters of Bull Shoals Lake, known for it's unpolluted water allowing underwater visibility of 20-30 feet! Your Lake view home will allow you the security and safety of knowing you made a sound decision choosing this area to live in! Plus, the beauty and comfortability of a modern home! The Home has 3 large bedrooms, with the Primary bedroom on the main level. A beautiful bedroom on the Upper Level with it's own private deck and then you will find on the lower level another breathtaking view of the lake from bedroom #3. You will also find an extra room that could be used as a 4th bedroom (non-conforming). Each level has it's own bathroom and the 1/2 bath is near the front door. Everywhere you look you will see the Lake shimmering out your window. And the easy landscaping is drought tolerant, so you won't be spending a ton of your time taking care of the lawn. Do you golf? There is a golf course LITERALLY across the street! REALLY! At the Main house you have a 2 Car garage that opens to the front of the house for easy access to the kitchen and pantry. Now, on to the detached Garage where you have 2 additional bays to park in. One of the stalls is extra long to house your boat, Wave runners, or anything else you like....maybe a Golf Cart? :) There is also a work bench inside the garage. Lastly, there is a convenient Guest House as part of the detached garage. Here you will find an additional kitchen, dining, living, bath and bedroom! The bedroom is in the loft area with a beautiful view of the Lake! There's more to tell you about, but no more room to type! So, come see for yourself all that you can have here on Country Club Drive!
MlsNumber: --
ListingId: 60291289


Listing Provided By: Keller Williams Tri-Lakes, original listing
Phone: (417) 350-8901
Office Phone: (417) 336-4999
Agent Name: Selenia Hulen-Ehrlich
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 = 1563 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 Christi Fox
Christi Fox
ASCIIRachel McDonald & Associates
Call Today!: (417) 372-3079

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App