I'll second the suggestion to look at the YMCA program where you are interested in.

The Finger Lakes area of upstate New York has some great camps, but no SPG properties close by.

http://rochesterymca.org/camps/day-camps/camp-cory

Just curious - why wouldn't you rent an apartment? I got to believe that it would be cheaper.