I have a business oriented connection in Honolulu that I plan on visiting once I relocate to SoCal.

If you feel you must worry, worry instead that your all-cash offers are as low as possible (because you'd be paying cash), and, that your juggling with your relatives' HELOCs will proceed smoothly, in a timely fashion.

Can not be connected to the ground, it must be personal property.2.  

@Seth Nadreau My appraiser must be doing the wrong job I guess!  

A visit to the local zoning office, and a title search will help you identify these problems.

I think the reason a lot of investors go high end in single family homes could be because you only have one unit, so the profit margins are squeezed, in order to turn a nice profit, you must command higher rents.

@Patrick Costello, It's perfectly fine to move from commercial investment real estate to Single family with your 1031.But the taxpayer for this property is the LLC so the LLC must do the 1031. 

There are 2 Closings you must account for.6.  

My father and I are visiting my brother in the Salt Lake/Park City area.

You can't flip a price quote from the state because the entity that requests the quote must be the entity that pays the money and that receives the tax deed or certificate.