...its mostly impossible to buy a turn key house off the MLS and actually make money from cashflow AND appreciation.
Maybe this is all we need to know about buying a rental property in the US right now. The deal on offer is a 6.5% or 7% mortgage at best, to finance a house selling for way more than the median wage earner in the area can afford, AFTER a bubble-resembling 18% increase in home prices in 2021, which was followed by another 5.6% in 2022, with a cap rate in the low single digits, and failing the 1% rule. For all this you get an illiquid, physically depreciating, and risky asset that is less affordable than it was prior to the 2008 housing correction.
It's THE investment everyone is talking about in the media / social media because it recently got expensive. But why do we want expensive investments with low returns? Why join the herds of dumb money at the bidding wars, when that kind of behavior has historically meant you should run for cover? We can't go back in time to capture the gains of 2021-2022, so why get involved in something that screams "bubble" and seems to all but promise low returns?
Hey, maybe it'll work out and houses will continue to appreciate at twice the rate of inflation for the next decade. But that's the speculative bet you'd be making in a world where 5% returns are risk-free and hands-off. I've lived through the dot-com bubble, the original real estate bubble, and the crypto bubble. I can tell you this one looks exactly the same.
No argument that RE is a less attractive investment now than it was before the Fed raised rates. Bonds and fixed-income nominal yields are more attractive, but remember it is the real yields that matter and that right now it is 0% 5% yield -5% inflation, and if you have the bonds in a taxable account your fed+state marginal rate is likely is 30%, making your effective return -1.5%, hardly a path to FIRE.
Now if you believe that fed will get inflation under control, and interest will start to decrease then by all means go heavy in fixed income, maybe even go for longer duration bonds.
If on the other hand you think that 5%+ inflation is here to stay then real estate actually be your best choice (Or perhaps more accurately least worst) of still overpriced assets.
My crystal ball is rather cloudy, so that's why I advocated diversification; some stocks, some bonds, some real estate. I think diversification is especially valuable for those in or near the withdrawal phase.
If you own your home then maybe you don't need any additional real estate. Your home is almost certainly the best real estate investment. If you don't or RE is say under 20% of your net worth, I think buying more RE make sense.
Which gets us back to OPs original question, where to buy?
IMHO, single-family homes in LCOLarea , offer the best risk-adjusted returns. That doesn't mean you can't make money in HCOL like California, or New York. I literally have been hearing that CA RE is due for a crash for over 50 years, and I've believed it and even posted about a few times in the last 25 years. The pundits have been wrong, and by not buying any real estate in CA or Hawaii other than my house, I've left a lot of money on the table.
On the other hand, if I wanted to buy a rental property here in Honolulu it is a $1 million dollars. That's obviously a big chunk of change and even if you are doing a fat FIRE at $3 million, 1/3 of your asset in RE, which is probably not prudent. I can get 3 properties in Vegas for $1 million or 5 houses in Kansas City for $1 million. The house in Honolulu will be negative cash flow for many years, in Vegas pretty much break even, and slightly positive for Kansas City. So while there are definitely negatives for buying out of state. In my opinion, the positives outweigh the negatives.