Everything as published.
The location is good, you are a few metro stops away from Manhattan. The neighborhood is not so nice, but, for example, if you're gonna stay in upper west-side Manhattan, is exactly the same.
Forget about TV, the satellite service doesn't work.
Is a ground-level apartment, but is in a very quiet area. We sleep very well.
The best: the space (is huge!), the kitchen (away from the living-bedroom area), the location.
The worst: very dark, forget to be there without AC, TV service (but who needs TV in NYC!).
Is recommendable if you're gonna be in the street all day and just coming back to eat-sleep.