I stayed at Juan's place for 1 month during a visiting student rotation at NYP Columbia. I will say that the location is farther than advertised on the map. It is 9 blocks away which is a 12-15 minute walk to the campus.
Cleanliness-wise, Juan keeps things very clean. No complaints there, only notable thing is that there are quite a few cockroaches in the apartment.
If you are considering an extended stay, notably no washer-dryer in unit and you will have to go down the street to a laundromat.
As a host, Juan is very accommodating and quick with responding to text/call.
Overall a fine place