My stay at Marjories apartment was perfect! Marjorie was there to welcome me and gave me information whenever I asked her. I felt very welcome at her place ;-)
It was very hot outside (35°celsius) and the airco worked well. It was also nice to have my own bathroom.
About the transport: you need some time to get to e.g. Manhattan, but there is a bus nearby to go to the closest metrostation. I liked to take the bus, because there was always a lot of interaction in the bus, people were very friendly. In summertime there is also the ferry (so nice to cross the water by ferry and to arrive close to wall street).
If you take the public transport a lot, I recommend the 7-day-metrocard for 32 dollars (you can only buy it at a desk, not at a machine).
About the neighbourhood: I enjoyed my staying in Red Hook, the waterfront was so nearby and my first evening I could already see the skyline from Manhattan, lady liberty and there it was so quiet to sit and read a book.
Very nice as well to come home after a very busy day to be in a quiet neighbourhood…