I can recommend Rafik's place for long or short term stay. There is a lot of space and the apartment is equipped with everything you need for pleasant stay, everything as described on description of the appartment and it looks the same as on pictures. The place was very clean and it is a very calm place in Astoria. Rafik is a great host and responded very quickly on any of my requests. A good problem solver.
However, it takes some 15-20 minutes walk to a subway station.