Here's a fine place that worked for what I needed.
Noise was not an issue. To be fair, I grew up in cities, but the construction did not occur during my sleep, which was my only concern. If you open the window, sounds of planes and the nearby highway do get more noticeable, but I kept it closed. The cars and planes end up turning into a sort of white noise, and I slept fine.
Safety was another concerned echoed by other reviews. However, after a day walking around SF, I'd say it's par for the course. In both cities, massive wealth discrepancies result in a great deal of visible poverty. It's sad, and occasionally unnerving, but this area was not unusual. The police station is also comforting.
The space itself seems to be a building of multiple Airbnbs, which was fine for me as I did not hear anything from any neighbors. The entry process was seamless, and communication was great.
Walking in I did notice a open door out to a deck for grilling, and mulled over how easy it might be for someone to enter the building through that open door. As someone with a growing opsec background, that was a mild flag. However, passing by this again in the early morning, I discovered the door closed, and was comforted. The other flag was the lack of a deadbolt on the door, which is understandable given the nature of the apartment but still not great. In my constant carefulness, I placed a chair in front of the door before turning in for the night.
The apartment itself seemed clean and exactly what I expected. I will note a fairly obvious 7 inch black hair on the wash cloth, which I can imagine someone else getting upset about. The towel was clean and fine though and all I needed.
The bed was fine, and so were the pillows. I'd be fine sleeping here for a few more days if needed.
The bathroom seemed newly renovated which is nice. There's a space by the door which would be perfect for a towel bar, especially since all the hooks are on the back of the door. The toilet paper holder nearly tipped over in the night, which scared me as I didn't want to wake any neighbors - it may be worth weighting that down.
The shower takes a long time to heat up, perhaps 90 seconds. My relief when hot water came out cancelled out any concerns.
The internet seemed fine in the evening, but by morning seemed to be having minor issues. Not great, but hopefully just a temporary glitch.
In terms of other minor glitches, I had some issues charging my phone. There are so many reasons that could happen that I hasten to point any fingers but just want to mention here that you should ensure that when you plug in, the phone not only displays charging but increases battery at a normal speed. Switching to the outlet near the window eradicated this issue, but it might just be a loose cord on my end.
I realize much of this review has been regarding potential improvements, but want to be clear that this is a fine place. You will be fine staying here. I've stayed in my share of Airbnbs, and this one is exactly what I needed.