I know we're in a good position because the sellers will now have to disclose some of the crap-ton of problems their place has and the foundation expert said that by refusing to fix the foundation they may end up having to be in a "sold AS IS" position which will drop the value significantly. 

What is our best course of action to put her in a position where she can sell the property?

We pride ourselves in keeping the forums positive, helpful, and focused on real estate (please, no politics, religion, etc.).

The person, not company, you hire for SEO, or any internet marketing program, needs to understand your business operation, geographical area, target market, marketing position, competition md any other relevant information in order to design a program that will work.  

There are some positive signs on the horizon.

Your success and satisfaction are our top priorities, and we want to ensure you have a positive experience with our program.Thank you for your feedback, and I look forward to helping you further.Best,Julie MuseVisit my BiggerPockets profile for more information and to see our successful deals. 

Also, if you're not necessarily looking for the cash in hand, we can always have the title attorney draw up a first position lien to your other LLC.

While I can't speak to Oklahoma City or Pittsburgh specifically, I’d suggest taking your time to explore potential opportunities in the three others.Also, @Andrew Roth may be a great resource, as he was in your position a years ago and is now looking for a second for his portfolio. good luck! 

My Question: How do I quickly position "what I do" to focus on "I'm looking for houses in this area."

I’ll just start out by saying I’m not a fan of syndications and own a number of single family rentals just to mark my position from the outset;  but the answers as to “why” may provide enlightenment to you, so I will throw a few out for your consideration.., some of which you mention, so it seems you must be aware of them.As an investor, your goal is typically  to maximize your return and minimize your risk.