For those unfamiliar with NYC, Greenpoint is one of the neighborhoods in relatively close proximity to Manhattan that hasn't been entirely gentrified, yet is exceedingly safe. There's a beautiful park three blocks away with a spotless and large playground for kids and plenty of grassy areas and a great dog rug - which our pooch loved. Pretty much everything you need is within walking distance (under a mile). The neighborhood is a mix of first and second-generation Polish families (infants to grandmothers), young hipster moms and a bit of an art and film scene (a number of the many warehouses nearby serve as film studios).
Getting to the city is pretty straightforward - just grab the G train and either go south into Brooklyn or north into Queens and you'll find plenty of trains going into and around Manhattan and the outer boroughs. The Williamsburg waterfront is beautiful and filled with tourists (and wealthy hipsters), which is great on the one hand, but it does make me a bit sad as when I lived there 20 years ago it was a quiet and quaint place to be, with stunning views of the city from the roof of the warehouse where I lived.
As far as Vida and the other staff, my experience was very positive. They were simultaneously laid back, while also being responsive. The rooms are cute, very IKEA modern. The beds are super comfortable, though the rest of the furniture a bit less so. Either way, I'd highly recommend it.