Yes if the property sits in a FEMA flood zone or your lender requires it, otherwise it's a judgment call. Standard homeowners doesn't cover flood at all, so the real question is whether you can eat a total loss if water gets in. I'm a broker in Sacramento and I check the flood map before I write an offer, then price the premmium into the numbers. Hope this helps.
Worth pricing even outside a high-risk zone. Homeowners and landlord policies exclude flood, and FEMA says over 20% of flood claims come from outside high-risk areas. NFIP policies usually have a 30-day waiting period, so don't wait for a storm forecast. NFIP caps residential building coverage at $250,000, and private flood can offer higher limits.