The rooms are exactly as listed and the neighborhood is, well, Greenpoint.
What more could you ask for?