I also like that it has so many units which reduces your risk of heavy vacancy and losses.Let us know how it goes!

As a fiduciary, the limited/managed risk actually limits their options.I THINK at least a fee based advisor won't be "pushing" in certain securities/funds that (s)/he gets a commission. 

I have been wanting to begin real estate investing fast several years.

Several of them have been shut down thank goodness.  

Sell.I am really concerned about trends I have seen in Florida where condos are being shut down due to unpayable costs/assessments, the building gets torn down and then a new one rebuilt and the condo owners simply lose everything.The idea of an HOA on sterroids makes me want to avoid them but then the added risk of shady tear downs makes me avoid condos like the plague.

check out this spec home we are doing in newark. we got the land for 10k and 110k build cost. should do fine. we listed it one day and have calls already. don't be afraid to take the risk https://www.redfin.com/OH/Newark/147-S-3rd-St-43055/home/773...

Are you risk averse?

....if not, I strongly suggest studying up on that topic.I'd also definitely suggest reading up on the risks of funding a rehab with credit cards--especially  if you've never done a rehab using credit cards, and especially if you don't have the cash reserves to stay afloat if things don't go according to plan. 

Like other asset classes, the home appreciation has been a savior for poorly managed NPL's because your downside risk was being protected.

A duplex/multifamily could work but the tenant friendly laws in the bay area have me concerned that an extended eviction process would kill any reserves and risk losing the property.