In order to get $500 a month is net cash flow it will take you 2 multi unit properties, unless you are creative, put down a large sum of money, or are in an undesired (war zone) area.

I have no intent to do anything unethical but do not wish to be caught in an undesirable situation should I tell the lender that I WILL take possession and for some reason be unable to.

They also wanted to pinch every penny in regards to amenities and maintenance and ended up with a mostly undesirable property especially when compared to competition. 

Other than that, there are a few outdated properties visible from my place but nothing distressed or with undesirables lurking around.

I tried to hint/ask about Bakersfield's undesirables, but no bites. 

Overall, I worry the demand will weaken for the peripheral markets around Bend if the overall market softens.  

Tossing out undesirable tenants, tearing down encampments on a Sunday morning and middle of the night.

(The hope is that by 2021, that remedies for this virus, will have been created; however, creating viable vaccines can be a long process, given that many vaccines are defective, due to they create what is called disease enhancement, that is that they also have the undesirable effect, of making a virus worse, while designed to precipitate human immune response to a virus.

Should this be considered a show stopper, or is this, while undesirable, not uncommon (especially in a 100% investor owned complex)?

For example, they had the wrong year for one of the houses, listing it as built 10 years newer (1962 vs 1952)2nd, the appraiser has a limited percentage amount they can reduce or change a property's value, and he/she can only manipulate certain variables and cannot take into account other unusual or undesirable circumstances (ie - you showing them that the neighborhood has many registered sex offenders living there (the appraiser's words exactly). ) The appraisers need evidence; show them any costs, expenditures, etc., numerical or photographic evidence in your favor to bolster your protestation.