And then can I buy right back into FHA after 1st duplex loan is transferred.Also what is needed for him to transfer his primary to a rental so he can also apply for FHA?

or is it still possible to transfer the home to an LLC for asset protection with a quit claim?   

Heres the numbers:  Borrower(s)Subject PropertyRate Not Locked 9/30/2024 Sales PriceDown PaymentLoan Amount30 Year FixedContract DepositSeller ConcessionNMLS#  $670,000.00$167,500.00$502,500.007.000% $0.00$0.00  Bank Origination Charges Estimated Title / County / State ChargesOrigination Points % $ - Owner's Title Insurance $ 4,415.00Discount Points % 1.500% $ 7,537.50 Lender's Title Insurance $ - Underwriting Fee Title Search $ - Appraisal Fee $ 650.00 Title Services $ - Credit Report Services (1) $ 299.00 Alta 8.1 $ - MERS Fee $ 25.00 Recording & Transfer $ - Flood Certification $ 8.00 Notary $ - Tax Service $ 85.00 Settement Fee $ - VOE Fee $ 150.00 Total $ 4,415.00 Total $ 8,254.50 Prepaid Interest / Items Potential Additional CostsPer Diem Interest 15 Days $ 1,465.63 Rental 1007 $ 250.00Home Insurance $ 1,800.00 New Survey (if applicable) $ -Flood Insurance $ - 2nd Appraisal / Reinspection $ - Total $ 3,265.63 Total $ 250.00 Escrow and/or Property Taxes Due Total Estimated Monthly PaymentsTotal Insurance(s) 3 Months $ 450.00 Principle and Interest $ 3,343.15Property Taxes 4 Months $ 2,868.64 Total Property Taxes $ 717.16Total $ 3,318.64 Total Insurance(s) $ 150.00 HOA / Maintenance $ - Monthly PMI $ - Total $ 4,210.31Total Estimated CostsEstimated Closing Costs $ 12,919.50 Estimated Escrow Prepaids $ 6,584.27 Estimated Funds To Closing $ 187,003.77

For Property 1: Should I sell this property and transfer the equity into another investment, or should I explore ways to lower the monthly payment and break even or slightly positive on cash flow?

I’m unsure if HEL or HELOC or selling the rental, doing 0% balance transfers makes more sense, or a combination.  

I don’t have an immediate need for the equity transfer but it seems like the right thing because mobiles are so hard to leverage and I don’t want this new property using up all my equity indefinitely. 

But my background and experience is in Business Development, and Marketing Strategy in close integration with sales, so I figure I at least have some transferable skills that'll allow me to make the most out of property as an asset class.

Lenders may or may not let you transfer the title over after your purchase.

Considering our options - if we opened a Delaware LLC could we purchase a property under or transfer under if the property is purchased in CA? 

I'm a huge spreadsheet nerd too :D You could even just take the line items from Deal Check and transfer it to your own spreadsheet just to make sure you're not forgetting anything.