Any property in low-lying areas will require flood insurance before you purchase the property. For example, Mamaroneck, Larchmont, Rye. Agents can't tell you to stay away from a home (but they are required to tell you if a property is in a flood zone). Also, lenders will require flood insurance before you buy. It is a good idea to check the link (from the answer below) to ease your mind.
Keller Williams Realty Group