We had a great time in Rachel's place. Greenpoint is a fantastic neighborhood and the street has all that you need.
The apartment is bright and well equipped, along with dishwasher and washing machine in the basement. The backyard is great if you're staying during the warmer months.