As a buyer using public sites you are at a disadvantage in your search. The typical tools made available to the public are limited and you'll be wading through just about every waterfront home in S. Carolina to find the one you want.
I had a client looking for the same thing a few years back and I had a search set up for him that alerted me to every listing that had Fish, fishing, pond, private lake and a few other terms. I found a few that worked.
Find an agent familiar with the area you are interested in, preferably one who is a good negotiator and a fellow fisherman. They can set up a similar search and will have a good grasp on what you are looking for.