Assuming that your housing budget is a fixed fraction of your income, and assuming your income is basically stable, then as interest rates drop, you can afford to pay more for a house. Assuming that you are competing against other people in the same circumstance in an auction market, lower interest rates will tend to push up prices, while higher interest rates will depress them.
Part of the author's point seems to be that this is even more true in areas that are housing-constrained, like the Bay Area, where people push their purchasing power to the limit to buy a house that still doesn't meet their needs (space, schools, commute). As people devote more and more of their income, as a percentage, to housing, they are effectively doubling down on real estate as an investment.
From my calculations, you get a drop of 10% in house prices.
My logic: Higher interest rates -> Fewer people can afford the more expensive houses -> More competition for (interest in) lower-priced homes -> Lower-priced homes might actually see a price increase (bidding wars, etc.) while higher-end segment suffers from lack of interest/smaller pool of buyers.
We bought a smaller and cheaper house than we could afford based on that logic… :-)
Lots of strange market things happen around those caps.