My suggestion: Run, not walk, from any property that is mapped in an AE zone, particularly if the low floor is barely above the 100 year flood elevation.
And I say that as a Water Resources Engineer who is the guy who creates the floodplain maps, and enforces the regulations.
The idea that just because our modeling is better in the past few years is going to save anyone from a flood is a joke. Is it correcting some inaccuracies in old mapping? Sure. Does that mean they take into account every little thing and that no rainstorm or flood event bigger than what is modeled is ever going to happen? Not in a million years...
Everything in the floodplain insurance program is based on risk. It is commonly accepted that protecting people from a 100 year flood is an acceptable level of risk. The dirty secret is that storms can, and often do, exceed the 100 year storm size (or put another way, flooding events can and do occur that are greater than the 100 year event.).
Living in a 100 year floodplain, you have a 26% chance of having a 100 year flood or greater during a typical 30 year mortgage. Yes - 1 in 4 odds. Not what I'd gamble my house on.
I've been practicing in this area for the last 20+ years. We've updated our rainfall data once, and it still doesn't get at all we are seeing in precipitation data for this area. Call it climate change, call it what you want, but we are seeing more intense storms, more frequently. And as a result, I get to help communities deal with the aftermath. I've been doing this for 20 years, and I've dealt with and responded to 5 storm events greater than a 100 year storm used in the floodplain modeling.
That's my take on it - the law says otherwise and allows stuff like this to be developed and to give people the idea that they are protected. They are - to a point - but that point is a lot lower than people realize.