And...this is exactly why I love this site. Not just timely, but wise and encouraging response! Thank you gentlemen! First off, @Alex Hamilton, I appreciate the tip. I have noticed that zillow's information does lag significantly behind MLS. I'll do my research on where and when to find local foreclosure info from the primary source.
And @Tom Mole , hugely helpful! So, this is what led me to my initial question...I've been scouring the local real estate market(stanislaus county) , looking for either a multi family unit in an area safe enough for my family to live in a portion of and that the #s make sense on, or a well/priced SFR that needs a reasonable bit of work that we would live in for 2 years and either sell or rent when that time came. In my quest for such property, I stumbled upon that filter on zillow and realized that there were several(not many) homes whose market value exceeded the amount owed on the loan and the amount of $ needed to bring them current is available to me without the sale of my current residence <$45k. So, in my head, I imagined: narrowing this search to neighborhoods I could eventually live in. Doing research on the titles of these homes to find out if they had leins, making contact with he owner to see if they were interested in avoiding the foreclosure, and finally following up with the bank to ensure everyone was on board. Now, I understand there are quite a few variables and MOST of the homes on that list are, in fact, upside down. I'm willing to hunt for the gems that make sense though ;)