I recall seeing such a street right in the heart of SF (I don't think it was that exact street, though) on Zillow when I was scoping out the feasibility of actually living in the Bay Area. No building rights (because it's a street), yet it was somehow for sale independent of the other properties on that street.

I chuckled at the thought of buying that street and charging for access rights (maybe even setting up a little guard shack and a gate), but then moved on to more productive ventures. Fun to know that I wasn't the only one thinking along those lines.