I highly recommend staying with Andrew! I was in town over the 4th of July weekend to do some biking around the city - Andrew was highly communicative and very considerate. His home is a great place to explore Brooklyn (or Manhattan) from. The metro is extremely close by - just a few blocks - as is Prospect Park. The room was very clean and the furthest away from the bathroom and other rooms, which was great because you won't need to worry about hearing any noise (toilets flushing, etc.) at night. Also, the room had a fan and an air conditioning unit.
I'll be staying with Andrew again when I'm back in the city.