@lexisxstar When you get the error trying to load your main household, if you try to load that same household a second time (without quitting or exiting to the Main Menu), are you able to load that household?
Separately, is there any pattern to the other lots this happens with? For example, perhaps they're all lots you created/modified/downloaded rather than EA lots, or even households you've played previously. I ask because I'm wondering whether some leftover custom content-related item is on these lots, for example a plate from a cc recipe. If so, you might be able to load the house in Build mode and delete the offending item.
If you're not sure what the answer is, make a second copy of your save by using "save as" to rename it, which will leave the original intact under its old name. In the new copy, try bulldozing one of the other lots where you get this error. If that prevents the error from happening again, then it's a matter of finding the object; you can create another new save from the original and try deleting the house/lot room by room instead.