There's also the tangible property regulations and dozens of revenue procedures and private letter rulings addressing depreciation. 

The appraiser has to go out to find comps similar to yours within 1/4, 1/2, 3/4, and 1 Mile and there are procedures they must use if they want to expand their search from 1/4 to 1/2 and so on plus explanations they must make in order to justify doing so.

The internal bureaucracy and lending procedures in place at such banks tend to bog everything down on all but the most vanilla and straight forward deals.

What I am looking to do is invest in property for the same reason renting it out as airbnb but I need to guarantee that I'll have a good return at the same time, also more information in the procedure in buying a unit.

Will try the new procedure this time.

So, why don't you do what you have to do according to their procedure and then deny the modification based on the millions of reasons you already have, and then proceed to FC in court?

The owner could file an objection or motion to set aside the sale... or there could be a procedural issue with the foreclosure itself.

the procedures will be different and cost for the money will be more than a typical hml. 

---So, ask about their standard operating procedures and make sure your management contract has an easy termination clause.What are your options if you experience one of the above?

The plan specifies "Participants and beneficiaries can obtain, from the plan administrator, without charge, a copy of the plan's procedures governing Qualified Domestic Relations Orders."