Most likely, it would be heavily based on zoning, neighborhood, and proximity to jobs and transit. Take Los Angeles, for example. I would imagine you could actually see taxes in predominantly SFH enclaves like Calabasas or Malibu 1hr+ from job centers go _down_ while taxes on similar single family homes in West Hollywood or Beverly Hills, being much more incorporated into the urban framework of LA, would go up.
Wealthy people can still have their expansive estates elsewhere, but the incentive is to move them off of land that would have a better use serving more people: just as it doesn’t make too much sense for the Empire State Building to be built in Aspen, CO, it doesn’t make much sense for a single-family, detached vacation home with a white picket fence and yard to be built in the financial district of Manhattan.