Appraisal denied due to "structural" issues

[Ryan Pleasant]

Attempting to buy a duplex. Planned on signing papers on the 26th of February. Appraisal just came in and they denied it because in one of the units the livingroom ceiling is sagging and crack slightly (just the drywall material not joist) and is missing a oven/range. The other unit is ready to move in. I am buying the duplex as my primary residence to house hack. Currently waiting on a response from the seller, what are my other options? Can I go with another mortgage officer; or will all appraisers deny the loan based on a 3 foot crack and an oven/range missing in one unit? Thanks for advise.