@Rohan Attravanam - Sorry man.. Your post is riddled with tons of mistakes, but I think your number 1 mistake is not realizing what is your number 1 mistake. You have family in Tampa, FL, so you thought, just based on that and the fact that Tampa is a growing market, its a wise thing for a newbie to invest across the country? I know Bay area market is terrible for newbie and cost prohibitive, but you seriously couldn't find anything closer than Tampa, FL? In my case, I would run away from family, but that's just me. LOL.
Since you opened this can of worms, your second mistake, in my opinion, would be making offer based on videos? Thank God your contract fell through, and all you lost was rent + deposit (if you ask me). Who knows what else could have been wrong with property? And when exactly were you going to do your OWN due diligence? After closing? Unless you have a really good trusting relationship with the realtor, you should never even dream of that. And who is this genius realtor anyway who wrote a contract for you with that kind of contingency (1 month Deposit + Rent... seriously?) It never struck you to let the seller rent the place as is and fix it up later on. You would have inherited a tenant, and by extension cash flow.
I think the real mistake # 1 is that excitement got the best of you, and you made some really hasty decisions. I blame @Brandon Turner Just kidding Brandon...lol
I wouldn't even go through other mistakes. Good luck on next deal. Hopefully, you will look for something closer to home. How does Boston, MA sound?