Clinton was a great host. My friend who was staying with me got delayed at EWR, resulting in us missing our arrival window to meet Clinton at the unit. Clinton went out of his way to put a lock box at the unit so we could check-in after hours and even left us a bottle of wine.
The location is great. The unit is only a 10 minute walk to the N/W subway lines at the Astoria-Dittmars station. If you are wanting to do the gambit of tourist attractions in NYC, these two lines are the way to go. They have stops at or within a few blocks of most of the Manhattan attractions. The only time we had to do transfers was to visit the Met and AMNH.
Astoria is a great part of Queens. It has everything you need plus is quiet at night. There are numerous restaurants and the view at night of Manhattan from Astoria Park is breathtaking.