The apartment is exactly as described. I'm not sure it is clear from the description, but it is actually a basement apartment: the living areas are at ground level, but the bedrooms are downstairs. That means the bedrooms are warm, dark and quiet: amazingly quiet for an inner city location. The funky decoration - bright yellow splashed across all the walls - means that it doesn't feel at all dingy.
The location is brilliant. 125th St and Lenox Ave - two minutes walk away - is a busy centre with shopping restaurants and bars. The subway there takes you to mid-town in about 10-15 mins. Given that it was pretty cold (in January), we were glad to have all these facilities on our door step.