If it’s not too late, I would suggest you identify the unit you want to live in and make the contract contingent on the seller giving notice to that one once all your contingencies lift. 

Hello- We just got our home inspection done for our first time home and here are the major issues that our inspector identified.

I pose those questions so you can be realistic in identifying and analyzing properties.

Totally identify with this plight, I have spent years of my adult life trying to find the best solutions to that exact problem.My best suggestion on this front stems from a series of books by the Founder of “The Table Group” Patrick Lencioni.He is a proponent of choosing “The Single Most Important Goal” for the next 6-9 months and specific actionable categories to focus on, while also creating the categories that are absolutely required to keep the rest of your life on track.If that sounds valuable to your current predicament I recommend “The 3 Questions of a Frantic Family” in his series, it personally really helped me with this same problem.All the best!

@David M.The lender can exercise the "due on sale" clause if the name(s) of the buyer are not the same name(s) as the members identified as the owners of the LLC.

Unlike a conventional IRA where everything is publicly traded and easily identified, the holdings of the LLC are only known to you.

It seems like you identified an outstanding value add.Did you have any issues obtaining financing? 

@Nnamdi Okwerekwu  You've correctly identified some of the risks.I would first go in to see the property with an experienced Realtor from your office or maybe your broker. 

Give each room it’s own identifying name.

However, I'm having trouble identifying a market.