Any book recommendation on these topics?

[Patricio Acosta]

Hello!
I am starting to invest large sums of my net worth into real estate (SFR, or single family homes) in a city in California. I am investing for the long run, looking for safety and long term appreciation. This got me thinking about the economics and history of real estate prices in general, more specifically:

1. What drives the values of properties in the long run in certain cities and why?
2. What are some cautionary tales of large price declines in certain some cities and how to avoid that?
3. What metrics are used evaluate if a SFR considered overvalued and undervalued by historical standards?
4. And, most importantly, what books do you recommend that can answer the questions above and talk about related subjects.