My husband has a rental property currently in downtown SF but his father has managed on his own and has barely raised the rent over the past 5-6 years.  

He cannot afford the water bill due to excess water usage and is barely able to cover the payment plan he has setup with the city.

I am used to dealing with homes that were barely priced under the Freddie, Fannie price guidelines to being in small town KY.

Nope i barely had rent at the time because it kept going up.

-What I would like to do is fix it up (bare minimum), sub lease for a year as an MMJ friendly rental (higher price tag), then buy it at the end of the contract with conventional financing or something creative.

Apparently they are barely used in the business.

As far as what to look for, the taxes there are way higher than here in Georgia, especially in Shaker, I barely factor them in around here, got clobbered with them on one that went long up there at $8k/yr. 

So the fact that the market would not bare any more than $375K upon ARV didn't matter to us, except in negotiations.

My struggle is being in debt and barely getting by how do I obtain funds.

Given that I'm looking to buy a home to live in anyway, and the mortgage on a single family home (or a condo with HOA fees) seems only just barely in reach and unnecessarily expensive, do you think there's still value in buying a place in LA if I can find something that's roughly zero cash flow—excluding tax benefits, and assuming I'm paying $1,500-$1,800 in "rent" for my unit in the building?