When is Flood Insurance Required?

So you finally did it.  You saved up enough money to put a down payment on your first home, and pay closing costs.  You spent hours completing paperwork, and gathering documents for your mortgage lender.