We are german tourists and stayed for 10 days.
The place was perfect for a long stay as we had fresh towels, dishes and AC in the bed rooms.
The commute to Manhatten is really straight forward. The bus to the subway station comes every few minutes and then theirs just the 7 Train.