You can spect the best location within the Astoria/Long Island city area if you like a commercial street.
Daniel is as attentive as it gets, and met every request and need we had during our stay… even customizing the cable tv contract to our needs.
It works perfectly for both long and short stays.
Even if you don’t know well the area it is very easy to get aquatinted fast. I hardly knew Astoria before this visit and was immediately in love with it.
If you are having doubts because feel it’s a bit apart from Manhattan attractions, it’s really not; it’s a short ride either in subway or in taxi, and the communication with the Brooklyn coast by ferry it’s just perfect. A bit far from downtown, but even then you will get there in just a subway ride without even transferring trains.