I've been told Cash for keys is a good method but how do you go about doing that?

If those do not work then go buy a rental that does not cash flow. :) 

But the idea of solving the water problem in a way that generates cash flow intrigues me. 

@Mohamad Guene  Simple answer - you will be cash flow negative, and your appreciation will be limited.We did a new build once for a rental - it performed miserably cash flow wise despite a great location and property - we ended up selling it 3 years later.There are very few new builds in Huntsville proper - are you referring to an outlying area like New Market or Meridianville?

First a cash snowball approach to build up your cash.  

Rentometer provided a rent range of $1,852 to $2,258, which is a very wide range.Below is the cash flow for this property based on the low, median, and high Rentometer rent projections.Depending on the Rentometer rent estimate you choose, you will either incur a loss of $94 per month or make a profit of $312 per month.

My primary goal is long term appreciation and I'll accept a property that breaks even on cash flow.

And all the duplexes that would be big enough is way too expensive and wouldn't allow us to cash flow and still would cause us to not qualify for another loan. 

The pros: - not having to do a major renovation from out of state- easier to get a conventional loan since the house is livable vs. a distressed property (would need to pay cash, do a hard money loan, some other type of financing)- can get a tenant in quicklyThe cons: - you don't know how good the renovation is, could be cosmetic without addressing underlying safety issues (plumbing, electrical, foundation, etc). - a home can pass an inspection but once someone is living in it and putting daily stress on the house (turning faucets on, light switches, turning on heat/AC etc), things can start to malfunction.

But the headache: CPA said need to file tax of the SDIRA ; Lawyer who helped to setup LLC said you need not to file tax when you didn't get cash from SDIRA.Do we need to file tax for SDIRA or not?