Right now, the best offers around me are for some 1.3-4 million, that only generated around 100k per year gross, so there would be a high chance of not cash flowing, and paying money, especially with a commercial loan (these buildings have more than 4 units).I was thinking that although the rental itself does not generate money, I would be able to deduct the mortgage interest, and depreciation from my personal w2 income and would be net positive.

We financed this deal using a residential VA Loan.

Consider using an FHA loan to secure a 1–4 unit property with just 3.5% down and take advantage of tax benefits by living there for at least two years.

I would suggest reaching out to owners of multi family who have no loan on the property.

Most 1-4 unit real estate investors are using DSCR loans right now for any buy and holds while flippers lean on higher leverage bridge/fix and flip loan options with higher interest rates.

The expense tracker, reports and rental sheets (useful if you are planning to do the BRRRR method and need to calculate 2 different sets of loans).I used to have my own custom spreadsheets that I built but this one does everything mine did plus much more. 

I recently came across 1 acre asking for 314k in a very good residential and growing location, so the current owner has added 4 manufactured homes with 4 electrical meters, 4 septic tanks and only 1 water meter for all 4 homes, the homes are sitting on partial slab and partial pier & beam, he also added 2 storage sheds approx. 380sqft with the intention to make them ADUs they are still only the shell so I would have to get those ready to live in, so currently the 4 manufactured homes are being rented and bringing in 2800k a month, 3 of the homes are needing some TLC which could increment rents and possibly get me at 3600k a month, also being a 1ac lot this still leaves about 12,000sqft of raw land where you could build etc.So that is on the good side now the things I did not like so much, the lay out is poorly executed to where it makes it looked crammed up and not professional but it could be fixed.Another is that in reality there is only 4 livable units so that qualifies under a conventional loan but since they're are 6 units on the property the banks are wanting to take it as a commercial so we would have to move out the 2 storage sheds out in order to close as conventional.Another concern, technically you are only allowed to have one manufactured house or single wide in your property according to what I know but I know it could change according to zoning which I will investigate, so my question is has all this been accounted for and if so how can I verify it so it wont leave me in a bind further down the road, I currently asked my agent for the appraisal of the property to see if that might verify.Any recommendations?

FHA and Conventional loans will allow schooling to count as work history.

You could build a new one every 2-3 years and move into it as a primary so the bank would be more friendly with your loan.

I've never done any Sacramento STR loans and only been hit up for one potential financing opportunity there.