Imagine a neighborhood with only two single family homes in it; you can only have two families live there, so if more than two families want to live there, they're going to bid up the price. In this case, the cost of the property is the cost of housing in general in that neighborhood, since it's one home per lot.
Now imagine one of those SFHs is replaced by an apartment building with 40 units. Now 41 families can live in that neighborhood, so there's comparatively less competition for housing, which drives down the cost to live there. But the landlord for that apartment building can make a lot more in rent from the units in that building than they could from renting a house to one family, because it's distributed across 40.
If there's enough demand for housing in that area (and in general right now there is in many places due to lack of supply), there are probably lots of people who'd be interested in replacing that second house with another apartment building, and the property values would reflect that. So yeah basically: housing prices go down, property values go up.
WFH works also, but then you don’t need to be near where your jobs is.