The hotel is very conveniently located in Greenpoint (North Brooklyn) and very near to Long Island. The nearest subway station is Vernon Blvd from the 7 line. The hotel has a shuttle that will take you there or you can just walk over the bridge (10 min).
The rooms are like studio apartments, very stilishly decorated and sparkling clean. The staff was helpful and courteous at all times.
There is also a restaurant at the hotel (The Lantern). The food is quite good (especially the breakfast) but it is a bit expensive (like most of Greenpoint).
We will definitely come back.