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.

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:

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.