Picking a place to live in the East Bay
My wife and I recently bought a house in the San Francisco bay area. Having no family in the area, and no real ties to any neighborhood, it was surprisingly difficult to simply pick a town. Initially we just went to open houses at random, often travelling to three or four completely different locales in the same Sunday.
Our experience buying a condo in Boston told us that you can spend months looking and not really getting excited about any of the places. But if all of a sudden you find the neighborhood that’s right for you, then every place starts looking pretty good. For us that was the South End in Boston. In the bay area, it turned out to be Alameda.
Picking a town
We made a spreadsheet. A glorious spreadsheet of the things that were important to us. Things like reasonable prices, good schools and low crime.
Name | $/sqft | Schools | Violent Crime | Other Crime | Public Trans | Driving | Walking | Weather | Earthquake | Score |
---|---|---|---|---|---|---|---|---|---|---|
Alameda | 413 | 8 | 0.31 | 2.6 | 44 | 25 | 69 | 9 | 5 | 97 |
Orinda | 509 | 10 | 0.06 | 1.79 | 49 | 24 | 22 | 7 | 1 | 96 |
Walnut Creek | 367 | 9 | 0.17 | 3.81 | 63 | 33 | 65 | 6 | 1 | 94 |
Rockridge | 599 | 8 | 0.4 | 4.5 | 38 | 21 | 81 | 7 | 1 | 93 |
Piedmonte | 623 | 10 | 0.18 | 2.84 | 65 | 22 | 50 | 8 | 1 | 93 |
Moraga | 398 | 10 | 0.09 | 1.26 | 66 | 33 | 20 | 7 | 1 | 92 |
Dublin | 341 | 9 | 0.21 | 1.82 | 61 | 38 | 42 | 6 | 1 | 90 |
Upper Rockridge | 501 | 8 | 0.3 | 2.65 | 60 | 22 | 50 | 8 | 1 | 89 |
Lafayette | 507 | 10 | 0.09 | 1.97 | 68 | 31 | 33 | 6 | 3 | 80 |
Potrero Hill | 756 | 2.2 | 0.32 | 2.7 | 28 | 7 | 88 | 9 | 1 | 80 |
San Mateo | 563 | 7 | 0.35 | 2.71 | 45 | 24 | 67 | 5 | 1 | 79 |
Albany | 494 | 9 | 0.33 | 4.9 | 64 | 23 | 86 | 4 | 5 | 74 |
Daly City | 447 | 6 | 0.29 | 2.32 | 50 | 11 | 63 | 2 | 1 | 71 |
Montclair | 450 | 6 | 0.2 | 3 | 69 | 25 | 64 | 7 | 5 | 70 |
San Bruno | 462 | 6 | 0.32 | 2.63 | 55 | 16 | 58 | 4 | 3 | 67 |
Palo Alto | 1028 | 10 | 0.11 | 3.25 | 94 | 36 | 63 | 9 | 1 | 67 |
Bernal Heights | 719 | 2.4 | 0.5 | 2.7 | 44 | 13 | 87 | 7 | 1 | 64 |
Pleasanton | 395 | 9 | 0.1 | 2.31 | 131 | 46 | 50 | 6 | 1 | 64 |
San Ramon | 354 | 9 | 0.13 | 1.8 | 116 | 40 | 32 | 6 | 3 | 63 |
San Leandro | 281 | 4 | 0.82 | 5.32 | 47 | 30 | 65 | 7 | 5 | 61 |
North Berkeley | 503 | 7 | 0.64 | 7.2 | 54 | 24 | 85 | 4 | 5 | 58 |
Berkeley Hills | 497 | 7 | 0.45 | 5.5 | 110 | 29 | 45 | 8 | 1 | 57 |
Berkeley | 508 | 7 | 0.64 | 7.2 | 48 | 23 | 82 | 3 | 5 | 56 |
Twin Peaks | 606 | 4.4 | 0.32 | 2.7 | 46 | 17 | 63 | 2 | 1 | 55 |
Sausalito | 575 | 5 | 0.12 | 2.35 | 57 | 29 | 20 | 4 | 1 | 52 |
Temescal | 468 | 8 | 1.91 | 6.1 | 46 | 19 | 87 | 5 | 5 | 51 |
Richmond | 198 | 3 | 1.19 | 5.33 | 62 | 26 | 55 | 4 | 5 | 35 |
Most of these values were based on objective third party data:
- trulia.com (prices per square foot, crime)
- greatschools.org (schools)
- maps.google.com (transit times) Note: this is to the SOMA area in SF
- walkscore.com (walk-ability)
- gis.abag.ca.gov (earthquake)
Weather I could not find excellent data for. I was interested in lots of sun and moderate temperature. In the end, I basically made up these numbers based on anecdotal evidence.
Some of the numbers are on different scales, so I normalized them around 1.0 and applied a crude heuristic to spread the scores out more evenly from 1-100.
=4*(-18+100*AVERAGE(B$33*(1-B2/1000), C$33*(C2/10), AVERAGE(D$33*(1-D2), E$33*(1-E2/10)), AVERAGE(F$33*(1-F2/60), G$33*(1-G2/60)), H$33*(H2/100), I$33*(I2/10),J$33*(1-J2/10)))
Picking a neighborhood
Of course particular neighborhoods inside a town can be as different from each other as particular towns in the same area. We started going to all the open houses in Alameda, which turned out to only be three to five new listings a week.
Even at that low volume, it’s easy to get a sense of the different neighborhoods. The small scale makes it possible to keep track of school districts, landmarks or even individual streets. It turned out that all the houses we liked best were in the same 10 block radius, so we started focusing exclusively on that neighborhood.
Once we decided on a particular neighborhood, we choose a local broker to work with. Knowing how competitive the housing market was, we selected a broker that specialized in winning bids. But it still took months of seeing houses to actually make our first bid.
Picking a house
As we had conversations at the open houses about what we did and did not like, we wrote those items down. Then we decided how important each item was to us individually. We also estimated the cost to “correct” a given factor. Many items, like distance to a movie theater, cannot be fixed for any cost.
Feature | Cost | Chase | Noel | Score |
---|---|---|---|---|
Outdoor space for grill | 10 | 10 | 8 | 9.3 |
Outdoor sunny space for garden boxes | 10 | 10 | 8 | 9.3 |
Walking distance to grocery store | 10 | 8 | 10 | 9.3 |
Lots of kitchen counter space | 9 | 8 | 9 | 8.7 |
Open floor plan | 10 | 8 | 8 | 8.7 |
Tree lined shady streets | 10 | 7 | 8 | 8.3 |
Tall ceilings (especially in stairway) | 10 | 7 | 8 | 8.3 |
Dining room can seat 12 | 9 | 8 | 8 | 8.3 |
Gas range | 4 | 10 | 8 | 7.3 |
Tub you can fit in | 9 | 7 | 6 | 7.3 |
Walking distance to movie theater | 10 | 6 | 5 | 7.0 |
Hardwood floors | 7 | 5 | 8 | 6.7 |
Walk-in closet | 5 | 6 | 8 | 6.3 |
Deck | 5 | 6 | 8 | 6.3 |
Dual vanity | 9 | 4 | 6 | 6.3 |
Central AC | 7 | 5 | 5 | 5.7 |
Shed/basement space for a work bench | 10 | 5 | 1 | 5.3 |
Walking distance to off-leash field | 10 | 3 | 3 | 5.3 |
Walking distance to basketball court | 10 | 2 | 1 | 4.3 |
Built-in bookcase | 8 | 2 | 2 | 4.0 |
This really helped us realistically evaluate homes that had high curb appeal, but which did not ultimately meed all our needs.
Picking an offer price
Having looked at around 100 homes, and paying attention to asking price and closing price on those, we knew that houses tended to go far over asking price. It turned out that this was a particular problem in Alameda; sellers were routinely listing their house one or two hundred thousand dollars bellow what they actually wanted for it.
After picking our own three to five open houses a weekend for more than six months, we finally found our house through our broker. It was not actually listed on MLS; the seller wanted to do a private sale. Not opening the house to public bids is great from a buyers perspective, but it did mean that we needed to feel confident in our bid price.
There was no substitute for paying close attention to closing prices over an extended period. That gave us a decent idea what the house would likely list for, and what it would likely close for on the open market. Luckily, we were able to quickly pick a price that both parties were happy with.