Another big sinkholes opened up in that neighborhood this past winter. You'd have to be nuts to buy there, even if you could afford it. There are all kinds of old abandoned water tunnels going through there, and what lies below is mostly poorly consolidated mudstone, though not as Jello-ish as in the nearby Marina district. Besides, for slightly less than a million you can get your own two story condo right on the water. The main residence is in the rusty camper shell itself; and when the tide is high, you simply move to the top floor, and sleep on the camper roof instead. And free crab dinner every night, once the tide moves out. Or if the tide is just too high, it might be the crabs that get a free dinner!
Heck, Brad - you don't know how good you're got it. I drove through Sonora early today. Yeah, the main drag has gotten way over developed for my taste, and 120 has pretty bad traffic; but most of the side roads are still lovely. I get homesick for the hill country. But I was chasing the weather on the east side based on the forecast, and did get some wonderful cloud activity; also some darn cold windy nights up high. Couldn't even set up a tripod in the Bristlecone ridges at 11,000 ft. But my Fuji 6X9 RF came to the rescue handheld. One of the waterfalls at Sonora Pass was frozen this morning.
But for the rest of you. ... Don't take your stereotypes too far. Yes, crime is bad in certain neighborhoods, including downtown SF more than before. West Oakland has been a war zone as long as I can remember, and gives that city its bad reputation; but even more of Oakland, up in the hills, is highly affluent and lovely. After all, the Bay Area is the world epicenter of not only electronics tech, but also Biotech, Pharmaceutical R&D, and perhaps Ai soon too. We have the most open space and dedicated park space of any urban area in the US (Regional Parks, States Parks, and NP holdings); and the crime rate in those spaces is extremely low. I've never felt unsafe in any of those places. No- I wouldn't leave a camera bag in plain sight on a car seat in a parking lot - but I don't do that anywhere, period.
But that particular remodel - what a waste! Wholly out of character for the area, especially at that price. Looks more like something a SoCal or Central Valley developer would do, not a skilled local renovator with actual taste. Gosh knows how many of those stunts I've seen which instantly got "un-remodeled" by the new buyers at great further expense, just to bring back a prior vintage look instead. White paint on open ceiling beams. All the woodwork drywalled over. Probably even some of the flooring and decking is synthetic. Sick.