.), I'd recommend that the residential units fully cash flow the loan as my experience is that mixed use properties are tougher to finance as most lenders tend to prefer one or the other and something in the middle gets more difficult.For example, and granted I don't know anything about the area/neighborhood, I would expect this property (https://www.realtor.com/realestateandhomes-detail/111-NW-Har...) to be easier to finance than the mixed-use property you mentioned. 

Shop LTV (or cLTV which is combined Loan To Value, basically your first mortgage and 2nd mortgage combined loan to value), rates, payment terms, time to close,  and draw period (how long you can go into and out of your heloc). 

I just don't want to keep waiting but waiting for nicer property that is B to A neighborhood may be better.

The picture they have on Zillow vs one of the several I have with the same view:Go to Redfin.com for your neighborhood.

The quality of available tenant varies drastically depending on the neighborhood.

Try looking into zillow/Redfin and see what your potential rents you can get near the neighborhood by filtering the bedrooms/bathrooms of the intentional property that you are planning to buy.

Let's assume that the neighborhood is a C class and the median income of the city is greater than 3X of the market rent.Here are some of the considerations I've come up with so far:- Units are in need of renovation and capex is too high or not available- Unit quality is not the same as market - Seller is worried about losing tenants due to increase- Vacancy rates are high or filling units have been difficult- Rent increase would take multiple increases over multiple lease periods to get to market rate if seller is trying to retain the same tenant- Seller inherited property and just want to liquidate- Seller needs to liquidate quickly (financial burden, sickness, quick exit from land-lording)It seems like I might be missing a warning sign about a deal if they are selling with current rents that are under market; but again, this seems to be most of the properties I've underwritten.And in the same vein, what should I be worried about when purchasing a deal with under market rent with the intention of raising them after purchase. 

Shop around and find something that works for you.

What you can't do remote is get a sense for the neighborhood and asset quality.

It's a small place so I'd guess it won't rent for enough to cover your expenses anyway so I'd probably sell, especially if the loss is small, it unless it's in a great neighborhood that you think will do well over time.