It would be an excellent short and long term investment. The stunning TPC golf course, clubhouse and proposed new 30,000 square foot clubhouse, dramatic views, permanent open space and peace and quiet in a safe gated community should satisfy your long term investment goals.
Now, as far as the area being a good long term investment.. I can tell you that this area is among one of the nicest in Hayward, it is quiet, the neighborhoods (and neighbors) are very nice, and generally homes up here tend to keep their value over time. Of course, in our current economic climate we are seeing and will continue to see price fluctuations in the market - however, if you're in for the long haul and don't plan to sell in the near future you should be OK. Have you looked at any homes yet? Are you only looking in the Stonebrae area or are you open to other neighboring communities?
If you have any other questions feel free to contact me at (415) 235-7650 and I'm happy to help.