Given the tax risks though (which would take that $220k down by 35-40%; and that's assuming I can quickly sell the home to a [paying] buyer willing to transport it which is far from certain), it seems like the as-is offer is the best thing on the table at the moment.

What programs/tools/resources have you found helpful for things like:Finding areas that are most likely to increaseFinding the best size or room numbers to optimize profitAny other areas that would be good to knowThanks in advance

As @Scott Runyan mentioned, the size of this deal seems better suited for a JV or partnership than a traditional syndication. 

You are fully correct in that those expenses should be a flat number depending on the size of the home, vintage, and how well you capitalize the property up front.

We were actually able to purchase both new properties using only the cash from the property we sold and in addition to that we received a check back for $10,000 at the closing table. 

At the closing table just sign the deed over to your LLC.

I have heard walk-ins alone can be 30-40k, depending on the size.  

Selling the existing SFR sounds like a pretty sub-optimal idea now :) @Austin Largusa investing out of state is absolutely on the table!

My initial thoughts are coffee shop and hotel, then watch the entire area take off.I'm curious if anyone has any insight on whom to target, how to go about targeting them, and what other metrics and information I should have on hand when the discussion is brought to the table.

Thanks for the table included in your response.