Sounds like the Golden Cue in Queens.
The Golden Cue is a great room with a lot of serious players. I went to college nearby the Albany area (RPI in Troy) and it was the best place to shoot after our Student Union closed for the evening.
They used to hold a weekly Wed night 9-ball handicapped tournament with a lot of strong local shooters including Mike Zuglan, who I met there.
A guy named Rocky was behind the desk and he was a great guy.
+ they also had a couple of carom tables which is, of course, always nice...
-Ira