I was looking for someone I can count on to help me no matter what and I thought he was up for the task.

Cross the bridges if/when you come to them.  

I don't want to be a cold rag, but count your costs before you commit.

I was totally counting my chickens here, all well before they were hatched and my contract was signed. 

Account Closed Yes you could have lowered it to 92K, if you count the option as part of the purchase price.

I reluctantly agreed, and Brian immediately shifted gears and insisted that I go to the bank right then and wire his money, almost crossing the line into 'pushy' (red flag #1).

HE hadn't been cited on either count. 

I have, however, phoned the police non-emergency number, advised them I'm looking at an investment property in X neighborhood or near X cross streets that I'm about to attend alone and asked if there has been any recent violent criminal activity I should be concerned about.

From the description you gave it could make a good STR with the bedroom count and the pool.

Can't really count the sq ftg of the finished bsmt.3 - Price history is scary to a buyer.