Great location for going to the US Open. The place was easy to get to from Manhattan and with easy access for going anywhere in NYC. I wouldn't expect going out in the immediate neighborhood much unless you speak Spanish as the restaurants and bars seem to be for locals. Place itself is in an older NYC building so it's what you'd expect if you've stayed in NYC before. I would recommend not leaving any food out though; we left a cookie out one afternoon and saw a cockroach in the evening. We put the cookie in a ziplock bag and never saw any cockroach again.
Great location for sleeping and showering before exploring the city. It was also great that we were able to check-in early to drop our stuff off before going to the Open. Very convenient.