I had a fantastic stay at Red's beautiful apartment. Check in was easy, everything was as advertised. The location is very convenient for exploring Brooklyn, and you can be in Manhattan (Union Sq.) in about 30 minutes or less on the subway.
There are some great restaurants and bars around the neighborhood as well, and you can even walk North across the bridge to Queens and grab the East River ferry to Manhattan (~15 minute walk).
Overall a fantastic stay that I would do again.