That's funny because a lot of people in Huntsville, AL would consider San Francisco, CA to be a literal shit hole. And yet SF real estate prices are much higher. It turns out there are many factors: local government development policies, weather, jobs, geography, etc.

https://www.sfgate.com/bayarea/article/Human-waste-shuts-dow...