Renting the apartment in SF will not be cheap because the land has extremely high value. It's just the government will capture the high value of that land instead of landlords and that high value land capture will be used to remove other taxes like income tax and property tax. Land prices in SF would fall slightly as the LVT removes most speculation. So likely rents go from $6000/month to something like $5400/month. But the government might capture $4500 of that to reduce other taxes.

If we still had 1870's small government the idea would be to put most of the LVT into a Citizen's Dividend which functions like a UBI and helps people pay for their cost of living (including some of the land taxes).