Frank Diaz

Good question. I would call the local title companies:
http://local.sanfrancisco.com/Pleasanton/Title+Companies.zq.html

Ask them for a list of "Lis Pendens". Not sure if that's what you're looking for, but I hope it gets you started.
Good luck. - A few minutes ago

How have you been searching? I would trying call the Property Managment companies for the homes that have the HOAs and ask them your question. They may know.
http://schertz.com/documents/HomeownersAssociationRevised-1-…

Have you talked to any local agents? Most will talk to you without any obligation. I do that all the time. I don't even ask for a name unless they want to offer it. I know people value confidentiality.
Yahoo has a decent search engine:
http://realestate.yahoo.com/Texas/Schertz/Homes_for_sale/res…

You may want to consider a land purchase and build your own.

Tried Trulia as well?
http://www.trulia.com/TX/Selma/

Good luck and happy hunting! - A few minutes ago

There is little risk to you in listing it for sale. Since you don't pay unless it is sold, you have the option of waiting for your target price. Think of all the pros and cons.
Is it a tax shelter?
Is it high maintenance?
Do you have another more important goal in mind?
Is it causing negative or positive cash flow?
If it's in top shape, do you want to continue doing maintenance or is it time to move on?
You may want to interview a few agents and discuss the pros and cons. They can help you think of the benefits and drawbacks. If you decide to sell, be realisitic and look closely at recent sales. I'm sure you don't want to go through all of the motions with a 10% likelihood of getting a sale. It would be getter to price it right with a 50%+ chance of a sale, otherwise why list it all?
I hope it all goes well for you Karen. - A few minutes ago

Home purchases are generally confidential as to price and terms until they are recorded with the city and/or county. Your public tax assessor or tax department will have a record of the sale as of the day it closes. In a foreclosure it may take several days or weeks to clear up the legal matters, such as a judgment, bankruptcy, stay, etc. In our county, they appear online (County website) approximately 1-2 weeks after they are recorded. - A few minutes ago

There are many ways to select an agent. A simple way, that I have found to be effective is to do a search for schools or any other important informaitn you want to find, and wee what websites pop up. You will generally get a few to several Realtor's websites.
My simple test:
Send an email and see who replies first, who replies within 24 and 48 hours. I would lean heavily towards an agent that answers within 24 hours. Agents need to be responsive. If they answer you promptly, then they will most likely be motivated and will handle discussions with other agents promptly as well, when you are negotiating your purchase.
Another way is to have a Realtor do a search for you and "interview" a few agents. Good luck. - A few minutes ago