Not from my experience. I lived in a neighborhood that was previously dominated by SFH and has since transitioned to mostly townhomes/apartments. It's lucrativ

Not from my experience. I lived in a neighborhood that was previously dominated by SFH and has since transitioned to mostly townhomes/apartments. It's lucrative for a select few (i.e. early sellers) but once it passes an equilibrium point (i.e. too many apartment buildings, townhomes, etc.), developers move onto more lucrative areas and would-be SFH buyers no longer find the area desirable out of fear that a giant apartment or townhome will go up right next to them. In my city, SFH-zoned homes are skyrocketing whereas SFH in non-SFH zones have still grown in value but at a far lower rate.