The apartment looks like in the pictures and is really close to the metro that can bring you quickly to manhattan within 20min-which is the most important thing for me in a city like New York. The bed was comfortable and unlike in the other comments I did not hear noises from children from upstairs.
Nevertheless the apartment could be cleaner. The neighborhood is rather poor but if you go to Brooklyn Harbour there are some nice places to have a good time.