Since you will be the guarantor for the construction loan, the lender will expect you to have ownership interest in the real estate. 

I have purchased the following books:ABCs of Buying Rental Property The ABCs of Property Management The ABCs of Real Estate Investing The Advanced Guide to Real Estate InvestingThe Book on Investing in Real Estate with No (and Low) Money DownWhat order do you recommend reading them in?

The couches and other furnature are outside on the porch, trash piled up, broken floor tiles and unkept yard. 

It had 22 of the 25 lots occupied but we'll be fixing it up, filling it up, billing back water and raising rent up to market.

Then pick up the blue in the window coverings.

You have to make payments on the borrowed funds, which is then deducted from the money you are making on the investment.

They do not take into consideration the revenue from the STR business as part of the selling price.So if comps say the duplex is worth 500k, then it is worth 500k.

Here is some info: SF STR FAQAssuming the info is up-to-date, it must be your permanent residence (you must live at the property for a minimum 275 days a year), you can rent unhosted a max of 90 nights a year, you need a business license, and you need to pay the city $925 for a STR certificate.

You can also use the CPA Finder here on BiggerPockets to get started too.

However, the studio unit was only rented for $800, which is affecting the overall cash flow.