The hosts were very responsive. Entry was super easy. The house was overall clean enough. We didn't use the kitchen a lot, but it seemed usable. There were dishes, paper towels, garbage bags etcetera. There were plenty of towels and there were enough beds and the floor was very clean. The AC was pretty good. There are window units in most of the rooms.
The walk to the trolley and restaurants is not bad. It is probably about 5-10 minutes. Once you are on the trolley it is a 15-20 minute ride to the french quarter. The trolley ride is $1.25 and an uber is about $12. The neighborhood is a bit mixed and changes for the worst just a couple streets over. There are a few restaurants, Walgreens, bars, etc. that are about a 10 minute walk a way. The walls are a bit thin and you can hear what is going on in the neighboring house. There are a lot of cats in the neighborhood.
While the advertisement is accurate, the home was much smaller than I expected. It is a shotgun house with no hallways. You must enter every room to get to the one behind it. The kitchen is the last room and so all bedrooms need to be entered to get to the kitchen. So if privacy is a concern this is not the best option for you. We were a bunch of old college friends, so it was fine for us. Also, Netflix was not working on one of the two TVs. The host tried to fix it but it did not work.