I stayed at Sandra's for five weeks and can wholeheartedly recommend it, especially for longer stays. Communication was effortless online and face to face, everything worked as described, and the house was kept clean and functioning. The guest floor offered both privacy and a chance for socializing with other guests.
The neighbourhood is calm and quiet and offers a welcome change to the fast-paced Manhattan. It takes some time to travel between Brooklyn and Manhattan, but for me it worked out really well, since the Q line took me pretty much anywhere I needed. I found everything necessary nearby (grocery stores, 24h laundry service etc.), and the restaurants I went to in the immediate neighbourhood were good. (Try the ones close to the subway station!). Prospect Park, Brooklyn Museum and Brooklyn Library are a quick subway ride away and definitely worth checking out, too.
The only "problem" during my stay was a small adjustment the water system, which meant that no water was available for 8 hours during one day, but this was clearly communicated well in advance and in a friendly manner. Other than that, everything worked well and I was able to make the most of my stay in NYC. Getting lucky with great flatmates was an extra bonus!