Arin & Brian's place is a really great choice. The appartment itself is located very close to G train with what you can be in the City very quickly, around 35 minutes (with one transfer to E). You can find lots of shops, restaurants, laundries, and everything you need, around. And the NYC ferry is about 8 minutes walk. The apartment has a nicely furnished guest room with a comfortable bed and all the things you need (including AC, NY can be really hot also in the fall). The neighborhood is really silent.
Arin and Brian are gorgeous hosts, they are nice and friendly, it was my second time staying with them and I would choose their place again if I'd go to NYC.
All in all I fully recommend it!