As a Brooklyn local myself, I can say with confidence that you will have a hard time finding a place that has as much open space, natural light AND street parking as Gabriel's place!
My fiance and I loved the loft and I was particularly crushing hard on all of the plants.
The loft might not be suitable for someone traveling with small kids or if you have trouble going up and down the stairs. I am 7 months pregnant at the moment though and definitely had no issues getting up to the bed on the second level.
Lots of great restaurants in the area, ample street parking and close to public transportation as well as major highways, bridges and tunnels (if you are commuting by car).
Overall, excellent stay during my visit back home.