I write this as someone who has been in and out of New Orleans for the past 10 years for work and visiting family and friends, sometimes for several months at a time. I'm very familiar with the city and know to take those "this place is in a rough area" reviews with a grain of salt. I am hopeful this review will help other guests book with an informed mind.
The good: The photos of the space are accurate and as represented in the listing. The location is great if your intention is to explore Treme or spend a lot of time in the French Quarter, as you can do all of it on foot. It's also a short walk to a streetcar that will take you to the CBD (which you could also do with a long walk), or Mid-City. There are two cafes a couple of blocks away where you can grab your morning coffee and/or breakfast.
The not-so-good: Because I know New Orleans, if it were possible to know the address of this place ahead of time, I would not have booked it. The house is directly on North Claiborne, which runs parallel with I-10. This means the house is constantly rumbling with interstate traffic noise. If you sleep in the back room, you hear less, but it's definitely not peaceful. If you need to use the pullout in the front room, you will be sleeping right by the front door and closest to traffic. There is never a quiet moment, as cars and trucks are always whizzing by overhead.
If this is the kind of thing that doesn't bother you, or you plan to get so sauced you'll just pass out, then you should book. If you're looking for a slightly more peaceful respite from your outings, this may not meet the mark. When I told Barrett we'd be using the pullout, he did let me know there is a white noise machine in the front room. Earplugs were also provided. For us, this only provided mild relief.