The very best way to find what is really listed for sale is to talk to a real estate agent. An agent can give you the latest information on any neighborhood, whether the homes for sale are foreclosures, short sales or not. The best thing about working with an agent is that there is no cost and you will get accurate information..
Best of luck.
Russ Boyd 650 325 7877
I am not sure which unit this is, but it will not be the asking price.The amount could be a second mortgage in default. 501 Starboard Dr, San Mateo which is a 4 bed/2.5bath 1860sqft home is currently pending. The asking price was $ 672,500. I believe it sold for a little under that which is a fantastic price. I saw the unit...beautiful!