My husband and I stayed in this great apartment in Greenpoint. There are few casual bars, restaurants, and coffee shops within short walking distance. During the day, it is a very convenient location for walking to other neighborhoods - Seapoint, De Waterkant, V&A etc.
Apartment was a fine size for two people, very clean, and had a lot of light. It is located on a Main Street so a bit noisy if you are a light sleeper (fine for us coming from New York City!).
Be sure to arrange an exact check in time with the host. We were under the impression that the keys would be at the front desk when we arrived within the check in window. However, because we did not tell him an exact arrival time (hard to do with delayed flights coming from airports with no wifi), they were not. We had to find a way to contact the host once arriving and had to wait in the lobby for about an hour. The doorman was friendly and tried to be as helpful as possible.
Overall we would recommend this as a place to stay if you plan on spending most of your time outside enjoying the city!