I was not familiar with this theory until a few days ago, when someone here on HN linked to an online version (edited and abridged) of Henry George's Progress and Poverty [0]. I've been reading it since; its clarity is stunning: I feel as if a great veil has been lifted from my eyes. Whether I'll still feel that way in a few days, months, or years remains to be seen, but for the moment, Henry George has me eating out of the palm of his hand.
Whatever the general validity of his theory, it certainly seems to explain the SF Bay Area extremely well. Salaries here sound incredible to people outside the area, but then it costs so much more to live here as to deny the wage earner much of the benefit. Broadly, we can break the population into three groups. Renters, obviously, have to pay the market rents, which seem to rise inexorably. Those who bought houses here years ago, before the big increases in property values, and are still living in them, are the ones who can really enjoy the high salaries they can earn here. Those who bought property here more recently, on the other hand, have large mortgages, because someone who previously owned the property made a pile of money when they sold it. In effect, the mortgage is like rent being paid to whichever previous owner or owners saw the property appreciate.
George's theory starts with Ricardo's law of rent [1], which is a truism of classical economics (and another idea I was not aware of until just recently). One could say it takes that law to its logical conclusion.
EDITED to add: while George's theory has not been fully embraced by mainstream economics, it hasn't been completely rejected by any means. Joseph Stiglitz, Herbert Simon, and to some extent Milton Friedman are some of its adherents, and Hayek credits George with awakening his interest in economics. [2]
[0] http://www.henrygeorge.org/pcontents.htm