If you're looking for a comfortable place to stay in Astoria that is close to public transportation and good food/nightlife options, Igor's place can fit that bill. It's a block off a main street with plenty of food, bars and cafes and only a 7-8 minute walk from a subway station (25 minutes to Times Square). For a NYC apartment, it is fairly quiet. Granted, I am a deep sleeper and live in Chicago, but I wasn't bothered by any noise and I had the window open at night. It was a bit hot the first couple nights and it would have been nice to be able to run the ceiling fan without the light on to get some air flow, but the place is very clean and the water pressure in the shower is fantastic (if that matters to you). Igor was very easy to communicate with and I had a completely hassle-free stay. Thanks!