This listing's location is pretty unbeatable; South Main is a very cool street to have less than a block away from you. Plenty of great cafes, restaurants, shops, and it's a transit thoroughfare too. South Main itself definitely has a lot of street noise (its four lanes and pretty heavily trafficked), but the house is far enough away from the street that you don't hear it unless you start opening windows. The basement apartment was also very clean; it's a bit small, but fine for one or two people!
Other reviewers have already mentioned the same cons I had personally: the mattress is on the softer side, and you'll positively sink into the pillows. I prefer a firmer mattress and pillows, so that's just something to keep in mind if you're like me. The wifi definitely struggles and can be slow. Also, yes, the noise from upstairs is pretty loud, especially in the morning. I expected some noise because the listing preps you for it and, thankfully, I assumed that meant kids; there are definitely kids! I usually spend the entire day out exploring when I'm on a trip, so the morning is the only time I noticed the noise, myself. I came prepared with ear plugs and, honestly, that's enough. If you like to sleep past 6am, just have some earplugs and it's fine.
Overall, a good value to explore South Main or hop a bus to other parts of town!