The CM 4228 should work for you unless you need the PBS station out of New Haven on channel 6.
I'm using the 4228 in Cheshire, right next to Prospect, 06712. It picks up the Hartford stations fine, and almost always the New Haven ones from the backside without moving the antenna. I am right in the middle of the two antenna farms. You would almost definitely need a rotor, but the antenna will work well.
I would like to avoid using a rotor. Any thought on a useful multidirectional antenna?
Not that it matters but do you mean NYC or Albany, NY?