When he purchased federal flood insurance, he was shocked to learn there was actually nine inches of water inside the house .