Summerville area fishing

[Baggy]

I’m starting a job in Summerville that should last around a year. I’m going to be in and out , with some down time to kill. I’m not bringing a boat so I’m needing suggestions on brackish, fresh and saltwater shore opportunities in the area. Any help as far as areas , species to target , and how to fish the tide will be greatly appreciated. I do a lot of freshwater, but have know idea about coastal rivers , tides and such.