I won't discuss the value of using a financial advisor or not, but I will say this. If you are hiring this person to advise you, then you should consider his advice.
Also, consider commercial real estate. Look into TICs, and you might find his reaction warming up. Also, it might prove to be a safer investment, with more income coming in.
Alternatively, look into REITs. Same deal as above.
I am not a big fan of residential real estate investments right now. I don't like the market, and I think things are really going to just get worse before they get better. Rents are going up in apartment buildings and complexes, but house rents are going to have to stay high to cover mortgages. All in all, the residential market just looks like it's going to be ugly for a couple of years.
All that being said, they aren't making any more land. House prices will go up again. It's just how much of an up and down are you willing to risk.
-Justin