We stayed for a week in Gerard's apartment in Brooklyn Heights. It is on the 3rd floor of the building, facing out onto the street. The neighborhood is wonderfully peaceful and quiet at night, and we slept well all week. The flat is a very normal brownstone apartment. The photos are accurate, but perhaps don't do justice to the high ceilings and spacious living area. Everything worked just fine - there is very limited wifi, but Gerard provides a cable internet connection and a PC.

The best thing about this apartment is the location. It is two blocks from a subway station, 4 blocks from two other stations, and is essentially 15 minutes away from downtown. Even better, there are citibikes very close, so you can cycle across the Brooklyn Bridge each morning. Brooklyn Heights was a revelation - it has a street of lively independent restaurants, cafes, and shops, and at the bottom of each street is an incredible view of Manhatten. It is virtually free of heavy traffic, filled with tree-lined streets and beautiful historic buildings - we can't recommend it enough as a base in NYC.
Gerard himself was a great host - he was there to meet us, then simply left us to it, checked in midweek to make sure we were fine, then came to collect the keys at the end.