I had a great stay at Daniel's place in Astoria. It was a great location with so much to do (and eat!) nearby.
I think the biggest disappointment was the train service (which clearly Daniel had no control over) While there was a station only a couple of blocks from the apartment, the service was subpar on the weekends and at night. Be prepared for headaches on the subway at those times if you stay in this area on your trip.