Well, the sensible option is for people to not buy or build/rebuild a house in a known disaster zone in the first place. But apparently this is OPs “dream” house or “dream” renovation, so they’re not interested in being sensible, but they still want a magical solution. 🙄