Clean and well-maintained apartment in a great location, as advertised. A short walk to some of the best bars, restaurants, and cafés in Astoria, and the train. We got excellent coffee and bagels from the place just downstairs every morning!
The apartment was especially nice for our dog and toddler- uncluttered inside, large and safe-feeling entryway, non-slip steps. Astoria Park and Hoyt Playground are maybe a 5-10 min walk too.
You can hear some "city sounds" from the apartment, but it was reasonably quiet- light sleepers might want to bring earplugs or a sound machine though. We slept well without. Parking was also reasonably easy to find (it's free w/o many restrictions), but we were never lucky enough to find a spot on the same block. All in all what you'd expect in a central city location.