California.
The economics simply work different in parts of California. I grew up there and my parents still live there. I had to figure out why my parents rather middle class house was worth well over a million dollars. California, it turns out, is the most difficult state in the Union to build new housing stock. The results of this are a crimped supply of housing stock that results in very high prices. And unfortunately, the worst homeless situation in the country.
For cash flow, you're not going to find much in coastal California. There has been an appreciation run that has been incredible the last 15 years. Too bad you didn't buy back then. Matter of fact, I'll take appreciation of high priced properties over cash flow. People made lots of money.
Can prices go up forever? Aren't middle class people leaving California? Is the gravy train over?
Anything can happen in the short term. In the long run, California is still an attractive place to live, it has one of the most creative economies in the world, and a large supply of new housing stock is not on the horizon.
Turns out that attractive places are just more expensive. And people have made a lot of money with expensive real estate.