In considering an investment property, we need to be clear about what you consider to be good, since there's a very broad spectrum of investors and investment goals. If you're looking for appreciation potential, you're generally looking at locations with the highest variation or volatility in price. Professional investors consider price volatility to be an indicator of risk or what they like to call beta. For example, tech stocks typically have high beta since their earnings can fluctuate dramatically. But, consumer products companies like P&G have low beta since people generally buy the same amount of detergent every month and those companies give high dividends.
This means the risk adverse investors like to buy P&G and happily collect regular dividends. The stock isn't likely to double in a year, but that's not their goal. In the property world, this would be a strong cash flow rental unit in a prime location. You'll make good rent but the price is not likely to move much. That's more typical of Fremont. If you want to bet on appreciation, you'll have to accept higher risk. Right now, there are many condos in San Jose which have just dropped 65% in the last 3-4 years. While that's a wild ride, the current rent is supporting a bottom for the price and the price appreciations are more likely to outperform Fremont. For many investors we work with, that's a good investment.
So, what you should do is to work with somebody who can properly assess and match your investment goals with the right property. You should always make sure the investment makes sense for you and your portfolio.