I was also going to suggest the Y. I used to go to the Waverly one and there were people of all ages. Raggedy tshirts are welcomed. They do have personal trainers but I have no idea how much they cost. There's a rehab place associated with a local hospital in there too if you need a physical therapist.

Another suggestion would be that if there are any trainers you liked at the JCC, look them up and see where they are/if you can go there/if you can get appts with them at other gyms.