Am I going at this the wrong way?

[Account Closed]

I made a goal to buy a duplex by screening for ones that follow the 1% rule. However, I've looked around at the Bay Area and Sacramento using redfin, and I'm not finding anything that really meets this criteria. Even in places in Oakland it's more like the 0.5% rule. 

Is there a better way to screen for places in CA than this rule? Does appreciation play a larger part?