We stayed here for a week after arriving in New York before we got an apartment. It was a truly wonderful stay-- the attention to detail was incredible, the house had everything we could possibly need, including a fully functional kitchen, mini fridge in the room, clothes iron, and hair dryer. The free snacks were a great bonus! Our room had plenty of natural light and a great view. There's decent wifi, and a work table if you want to get work done. The common living area is also a good place to work. The house was cleaned regularly.
Connectivity: it's a 20 mintue walk to the junction boulevard subway station, and just 5 minutes from a bus stop. There are plenty of small grocery stores, bakeries and food places around. It's a quiet, residential area with pretty houses and walkable streets. I never felt unsafe walking to and from the station, although I probably wouldn't want to be out on my own after 9pm.
One word of caution: you'll need to go up two flights of stairs to get to the front door, so if you have heavy luggage, be prepared to carry it up the stairs.
Overall, would highly recommend-- it was great value for the cost!