Not knowing what else to do, I ran next door to get the neighbors.
Here's more pictures of the damage.
We ended up calling a disaster recovery company that came out to assess and fix the damage. They had to pull up the carpet, rip out the carpet pad, suck the water out of the carpet, remove all the sheet rock and insulation and put down industrial fans to dry everything. We are now just waiting for everything to dry so they can come back and re-do the sheet rock, carpet, etc . Interestingly enough, when they removed the sheet rock, we found the actual main water valve shut-off. Looks like someone who lived in the house before sheet rocked in the valve, then either didn't want to redo it, or didn't know where it was, so they put in a the valve in the ceiling that we had shut off. Needless to say, the one in the ceiling turned off everything in the house except the one and only faucet we were working on. What a learning experience! Here's some more pictures of what it looks like without the sheet rock. Quite the interesting weekend! We're laughing about it a lot now, but hoping and praying we never have to experience something like this again!