Family visiting during summer

Hi all. Long time lurker first time poster. I will be on a military assignment for 30 days or so this summer, likely in July. I know it's going to be hot. My family wants to come and visit for 2 and 1/2 weeks or so. Do you have any suggestions about where they might want to stay? It doesn't need to be luxurious, but I would love some suggestions of lodging that's sort of near the water. I will likely be staying on station and we'll have an opportunity to visit my family after hours. I've got two kids that are elementary and middle school age, so I'm hopeful there will be plenty of stuff for them to do to keep busy and to have fun with mom while dad is at work!

I don't want to break the bank if possible, so I was hopeful for some accommodations that are modestly priced. Any suggestions?

by PastorDan1984