I checked MLS Alliance, and it doesn't show as for sale either. So it's quite possible the owner is trying to resolve the situation.
187 Sycamore, Fremont was issued a Notice of Default in Aug, 2008, and a Notice of Trustee Sale in December. Unless the owner is successful in coming up with a resolution to save his property, it is scheduled to go on auction on May 12, 2009 at the Alameda County Courthouse at 12:30 pm.
The current value is $446,976 with loans of $275K. The published bid is set at $296,767
If ownership reverts to the lender, it may be another 2-3 months before it is offered for sale