I had an awesome stay at Maria's apartment in Greenpoint. It's right opposite a really nice park, a supermarket, a laundromat (right around the corner) and the subway is a 10min walk away.
The check-in went super smooth with no hick-ups at all, with Maria's neighbor giving me her key. Maria also left her place super clean and also left me some special welcoming gifts which was a nice touch. The kitchen was shared which didn't cause any issues, you might just have to be conscious of noise for the adjacent studio, I didn't have any issues though.
This place would be perfect for a single person visiting town for a week or more, great chill area and super easy and quick to get into Manhattan.
Thanks again Maria!