We are Greenpt residents that needed an extended stay while there was construction going on our in apartment. So yes, we emphatically love the hood and the hotel is uniquely placed near the Pulaski Bridge which you can walk across and get to Midtown Manhattan on the 7 train within 15 mins or so. They've got cars that can take you up to a mile away if you don't want to walk or are unable to do so, and ubers/cabs are all over.
The loft apartments have sweeping high ceilings and cute decorative touches, the kitchens are rather basic but perfect for extended stays. The bathrooms are large, water pressure and temperature were perfect and the towels are fluffy, ample and replaced every day. We stayed in a room vs a loft and definitely preferred the loft apartments.
There are also 2 TVs in the living room and bedroom which can be plugged into your laptop/gaming unit etc via an HDMI cable which is a nice touch.
There are quirks - there is no room service (despite a restaurant/bar being downstairs) but you can use seamless to get whatever your heart desires in this city. Front desk staff are slow and there was always a line, so come prepared to be very autonomous while you are here. The kitchen is quite basic so you have to come with things like spatulas, baking sheets, salt/pepper, paper towels, oil/spices etc if you have an extended stay and plan on cooking, but there is a rather basic grocery store down the street. The cleaning staff are always nice but don't do a very thorough cleaning every day, and don't really clean the floors thoroughly, even if you ask them to do so. The wifi gets really slow at the end of the day from 6 PM on when people are back in their rooms.
All in all it's a good value if you can't find an airbnb in the same price range - it's a unique hotel and there are always weddings/room parties on the weekends so interesting people watching to be had. The rooms are actually quite quiet despite the festive atmosphere. Enjoy!