Here are a couple of links for you
Academic Performance Index in Alameda County --to see the school scores by school, by city
And crime mapping (you can change the search by zooming in, out, moving the map
Not knowing what's "affordable" by your definition, it will be difficult for anyone to point you in any direction.
So first, determine what you can afford...if you haven't spoken with a lender yet, that's the first step to know what your budget range is.
Then select a realtor who can help you focus your search to find suitable properties, and then to guide you on writing a winning offer.