Since SFH owners tend to view living next to a 4-plex as a disaster, it doesn't seem to happen the way you envision. Almost all apartment here in Silicon Valley are built on boulevards, often displacing low end retail. Nice apartment, too bad you have to drive four miles to the nearest dry cleaner.