I stayed in Ravanna's place middle of October. It did look like the pictures which was great. The kitchen is small but had everything you need for a short stay. There is a dining table in the main area but it is rather large for the space, maybe a smaller one would be better and give more room. My bed was very comfortable.
Location wise, there were lots of places to buy food and drinks close by or within a 10min walk.
The subway was between a 5-10 min walk depending on which line you were taking.
I would recommend staying here if you want to stay in Brooklyn.