@Mike S.
Greetings again!
Just my perspective here :) I think it may help to adjust your expectations a little - hear me out --- while you may find what you're looking for, I think it will be harder to come by because of recent policy changes and the big picture of the policy landscape currently..
There are cash flow properties, and there are equity properties. When you can get both in one property, great! I got that 'breakdown' when talking to someone and hadn't been thinking of things that way. We have a couple properties that we currently think of as cash flow properties with limited prospects for appreciation, and we have some that I think we can reasonably hope/expect some decent appreciation over time. It sounds though like you are talking about something different when you speak of appreciation. When you are talking about a Boston, my assumption is that in certain areas there will be 200-500% appreciation when you look back over the last 20-40 years. My guess is that the combination of a lot of the drivers I listed in my other email, coupled with land scarcity, drives some crazy appreciation. San Fran and NYC I think fall under this. If this is what you are looking for I'd suggest looking for those combinations. But here's what I believe to be the macro drivers that are working against what you're saying you want.
My view and the WSJ view is that the property tax deduction will have a negative effect of 'top end' (ie: top quartile) type properties in MAJOR metros. Not a crazy effect but a solid effect, when we're talking for instance about the average 750k-1.5m USD home in say, Washington DC.
I'm hoping that same change in policy will have a dramatic effect on the 'bottom end' type properties in certain metros as well. As an example, the multitude of $30-50k properties in perceived bad areas of Chicago will hopefully get a new lease on life and attract capital given that literally those kinds of properties often have an effective tax rate currently of 10-20%. It's just silly and when you have a $5,000 property tax due every year eating into your bottom line, there's no justification for investing in those areas.
I think the key question on the 2 above points is going to be how the local policy makers adjust and if they make the RIGHT decisions. Local property taxes in say Chicago will not just suddenly and magicly change - there would need to be conscious choices by policy makers to do the right thing by operating more efficiently.
Effectively the property tax deduction has been a massive subsidy from the federal government to the local governments and SOME residents of these local markets. Inherent in this subsidy is a distortion of economic incentives and unfortunately there will be some corruption mixed in as well.
On balance these local markets were positively affected by the prop tax deduction however it came as the cost of the 'meat and potatoes' homes and homeowners being 'crowded out' by CRAZY high property taxes. Again, the 30-40k home in Chi town with an 15-20% effective prop tax rate is a good example. And there are probably HUNDREDS of THOUSANDS of these properties out there/available.
This is only possible in markets that have those $500k - 1.5m USD homes, and have quite a few of them. I can only think of maybe 5-8 markets like that around the US. It's unfortunate that there are often follow on consequences of well intended policies (which I assume the prop tax deduction was)
I guess you and others can draw your own conclusions from this but all this leads me to a possible investment strategy.
And hopefully, good things for the 'bottom end' of these major metros if the local policy makers make the right decisions.