That's the only bummer about Iowa, your all so far from the ocean. I can get to the ocean in 5 different states, any one in 3 hrs. Maine, NH, Mass, RI and Conn. And I do all the time. Plus lake Ontario. Good luck finding a place.
What about the dams(lakes) on the Missouri River going up...