After Hurricane Sandy: What flood insurance does and does not cover

Hurricane Sandy has put the spotlight on flood insurance. But how much does it cost and what exactly does it cover?