Shared walls aren’t ideal, but they aren’t necessarily a con. We lived in an 80’s townhouse in Carmel Valley for a couple years, with neighbors on both sides, and we NEVER heard them. We also had a crying baby for a good stretch of that time and they never heard him. Some condos are better insulated than others.
That said, I wouldn’t personally consider any coastal condo to be a good investment right now.
