To me, mid-tier houses are likely one of the best long-term appreciation investments because they are sought after by so many people in that market, a smaller percentage of people can afford luxury houses and also they may be more volatile but there's always demand for the mid tier price range for the average Joe.I consider myself a serious investor, my LTR's are in a place I would otherwise never travel to, my own preferences and opinions on the location are meaningless as this is purely a long-term investment decision for me and I won't allow personal preference for a location to impact my decisions.

Or a pure rental property?

If you want passive just invest in VNQ and withdraw x% in addition to the dividend vs getting pure distributions from a private reit, much safer. 

As far as limiting risk, I am going to aggressively pay off  leverage to maximize my pure cash flow and not pull any money out any money. 

Never had a pure wholesaler approach me for this service ..

She is the epitome of pure entitlement.

@Olivier ChaineIn all trust deed or mortgage documents written by instructional lenders that I’ve come across, a change in ownership/manager structure of an LLC holding title to a property is a violation of the “due on sale” clause, so from a purely covenant violation sense purchasing the LLC doesn’t help you.  

On a pure investment scale a mid term or short term in the midwest (omaha, KC, etc..) may net you better returns.

I don't believe you should necessarily invest purely for appreciation.

The only nonrecourse loans out there are pure commercial, which carry a higher rate than DSCR.