There are some homeowner endorsements that will cover a back-up or overflow of sewers or drains or a sump-pump. These type losses sometimes do occur during flooding events. These endorsements will often have dollar limits substantially less than the flood policy
90% of all natural disasters have some form of flooding.
If a house is destroyed due to the collapse of the land it is built on, and the collapse is due to waves or currents of water, that would be considered a flood and would be covered.
Floods can happen anywhere and without warning. 25% of homes with flood claims each year are in low risk zones just like yours. Give yourself and your family the peace of mind of knowing that they are protected should a flood happen. It will take a full 30 days from the time your policy is purchased to be valid so waiting to make this decision is a serious risk.
Voluntary flood insurance policies are not enforced until 30 days after purchase.