In Australia at least, I'd guess that standalone homes are at the juncture of 'rentable' and 'appreciation of the base land' (which is usually what is rising in value).
Land can be subdivided as lifestyles change. A house can be extended or rebuilt with a second storey. An apartment can generally be updated internally on the same footprint, but not much more. Institutional buyers would be well positioned to redevelop a house to semi-detached dwellings, or apartments, or retirement facility.
Here, over 30 years to mid-2022, houses rose 453%, units 306%. In the last ten years only, that same change was 82% for houses, 47% for units.
I know multiple people who have secured their life doing that, though with smaller homes (and of course, they prefer duplexes, but the right SFR works).
Because gambling on single family appreciation has been a great winning move for decades now, but if you factor out that almost all SFRs have negative cash-flow.
Well, they have negative cash flow but people endure that because of the leveraged appreciation.
The people I know that are doing this seem to do well.
I do not know if that is because of the low mortgage rates up until last year or if they have some other secret, like only buying houses they can get a positive cash flow from.
It's doing all the legwork - SFRs are negative cash flow, and the only reason to hold negative cash flow properties at the absolutely horrendous cap rates they have is because of appreciation.
But appreciation cannot go on forever or each property will be infinitely expensive and nobody will be able to afford them. It is a dance that will end at some point.
It can certainly go a lot longer than people will expect, and it will have weird side-effects (California also gives some hints, what with huge appreciation and prop 13).
The biggest hurdle now is the jump from renter (or living with parents) to homeowner; there used to be "starter homes" that could get you on the treadmill but even those are quite high.
Once you're on the treadmill it's not that bad as house prices in an area tend to be in lockstep, but that first step can be a big one.
And this article was written when rates were still stupidly low.