If you plan to be out exploring the city for most of your stay, Hamza's place is perfect. Location is great. There's an excellent bar, bagel place, and coffee shop right downstairs. It's very close to other great restaurants and multiple subway stations. I read some reviews that mentioned the noise - that wasn't a problem for us, although maybe the air conditioner helped mask it. I slept here the night before the New York Marathon with no trouble at all.
The space itself isn't fancy, but it's got everything you need in a home-base: shower, bed, chairs, full-size refrigerator, Internet, and even a stove & oven if you really want it.
Hamza was also one of the most responsive hosts I've ever encountered on AirBnB. We had to book this place day-of because plans to stay with a friend didn't work out. Hamza responded immediately and we were checked in as soon as our train could get us there.