I love my Berryessa home location in a trio of exceptional schools. I would look carefully at the schools if you are seeking to have a long term solid investment. Berryessa is stronger now than it has been in a few years, and rents are climbing with low inventory and low crime.
I moved here in 1995, and my kids are happy here. We can walk to Piedmont Hills High School, it feels safe here. It is probably among the lowest priced areas for 875-925 API schools.
I also like the area of Santa Clara with Cupertino schools (95050) but that's about $300K more for the same size. Evergreen also has strong trios of schools, also about $200K more for the same size home.
Two down sides: the homes here run small with about 1500 SF very "normal" even on a 4BR 2BA. The 2500SF home is more rare...also the homes run older, we don't have a lot of new construction. So homes here you normally might want to roll up your sleeves -- unless the home has been remodeled top to bottom. You see a lot of partial remodels, where a 1959 home has been given a new kitchen and baths but still has work to be done to be "easy" to maintain.
Milpitas (nearby) has newer construction in some areas, with more shopping ops than Berryessa, but the high school isn't quite as strong as Piedmont Hills High School by test scores. You can find very strong elementary and middle schools in Milpitas and homes run in similar pricing to Berryessa.