Flutterby™! : Housing macroeconomics?

Following yet another analysis that suggests that, yes, housing costs follow a supply and demand curve, even if the supply comes in at the high end (which ties to my observation that "affordable housing isn't what you build now, it's what you built 50 years ago" with a gesture around...), I've gotten to wondering: Does anyone have good resources that look at local induced demand creating housing shortages?

For instance: The story being told about Healdsburg is that the new condos, where a sub 600 sq.ft. studio is over a million bucks plus condo fees, are being bought by people wanting weekend/getaway places for whom the price is no object, and this is driving up the desirability of the Healdsburg core and thus bringing in more housing demand.

(How the multi-family is outpacing the impacting single-family homes just out of town nearly is also one of the things I'd like to read more on, though I know that the glamor of the single family home propaganda is wearing off).

So, yeah, I realize that macroeconomics has more in common with reading tea leaves than with science, but I'd love some good reading on the topic of local demand.