I determined years ago, never buy a house in a subdivision that had “water” of any description in the title. We have “River Plantation” in this county and it floods when there is a lot of rain. I didn’t look there when I was looking for a house to buy because of its name and I was right not to look there.
There’s a community in Orange County, Calif. called Surfside which is prone to flooding during unusually high tides generated by winter storms. In 1953, 1963 and 1983, Surfsiders could go surfing in their own living rooms.