I stayed in at Emmettz during my last travel to New York. It is a very well furnished and elegant apartment and feels quite like home. Its got a stock kitchen, internet, DSTV, washing drying etc. The toilet needs to be shared with another guest but its hardly a problem. It has a bath and is quite clean. The apartment is is floor one and the building has a super. It also has lifts even though you never might need it as its on the first floor. The neighborhood is not the best, however, you have all that you need, food and supplies at walking distance. Its not a bad bet considering its Manhattan and cost of staying on the island is drastically higher.

There are two train stations at walking distance from the apartment and train 1 connects the place. Its one stop from Columbia University and a few stops to times square.

I would personally have no hesitation in recommending this place to other travelers.