We found everything exactly as described. Within Astoria you can easily do everything on foot. The Q69 bus stops right outside the front door and if you like to ride your bike there is a CitiBike parking 50 meters away.
Manhattan is also only 30 minutes away by subway. This accommodation is absolutely recommendable.