The apartment is very much as described and Ed (on messages) and Sarah (as the host I dealt with) are very friendly, quick to respond and great hosts. They are very candid about the lack of air-conditioning before accepting a booking and do take that seriously especially if you are considering June-August in NYC. The night times are cool with cross ventilation if you open windows and put screens but Summers in NY can get hot and sticky.
The location is good (it is 2 minutes from the local C train stop, which has service into downtown and West side of Manhattan every 15-18 minutes) with restaurants, services (drop-off laundry, pharmacy, groceries) within 2-5 minutes walk. It is a good 15 minute walk to Atlantic Terminal, which has a lot more subway lines into Manhattan.
Sarah provided eggs, orange juice, bread, jam, butter, milk, a beer, snacks, all of which was unexpectedly nice. Lots of towels/pillows etc. The internet is fast and a decent number of plugs. There is no TV at all (a bit of a bummer during World Cup) but that is clearly noted. The apartment is ground floor so you will need to have lights on even as the bedroom gets plenty of natural light from the back garden area (which looks lovely but off limits.) It is a very quiet residential street with some foot and auto traffic but not much noise at all.