We stayed at this apartment for close to 2 weeks, and found it to be exactly what we needed for our vacation.
It's relatively far from where most tourist attractions are located, but transportation is not a problem (whether it be via bus or subway, just get the unlimited MTA pass). It is still within Manhattan and it's one of the more affordable places in the island. Food is also not a problem, and it's even cheaper than those in midtown and downtown. Plus, the area also has its own charm and its share of scenic spots (it's close to riverside park).
The room we stayed in and the bathroom were spacious enough, clean and tidy. The windows in the room provide more natural light if guests prefer. Once in a while, expect some noise during the night (the area is also near Harlem), but after a long day of walking and touring the city, it will have little effect and you'd most likely still fall asleep.
We had very good interactions with Jay (the owner). He was very accommodating and hospitable. To maintain the place's cleanliness, he expects guests to observe some simple and practical house rules. Other than that, feel free to make it your second home.
We highly recommend anyone thinking of visiting New York to consider staying in this apartment. If you're thinking of touring mostly Manhattan locations, then this certainly is a very good option.