Looking at the same surface level information (which I have presented here regarding my own situation - it's all been surface level, like an iceberg if you will), there is not usually a solid consensus for one side or the other.

Wipe surface with TSP (1/4 handfull in 1 gallon bucket 3/4 filled water) using cotton rags (real cotton, not the non-absorbent stretchy stuff.)Dab latex (paintable) caulk or toothpaste into nail holes with finger (very tiny amount to just slightly fill the hole) wipe with dry finger, palm of hand or rag.When dry if there's still a sheen when viewed at angle then lightly "scuff-up" surface with 400 or 600 grit sandpaper wrapped around a 1x3x6" sanding block in long vertical sweeping motions.

What are common reasons a deal that looks good on the surface would sit on the market for so long? 

I read the book by Kiyosaki Rich Dad Prophecy, while I don't know if thats true, on the surface it sounds appealing with the semi hand off approach and click click sell if you need money. 

New information like the LLC has come to the surface. 

We all know this isn't going to happen, which is why concern is starting to surface in the forums. 

When buying properties - you cannot feel bad for passing on a project that is not profitable - it's a numbers game and you are going to look at a lot deals that don't make any sense - and you are going to see deals that look good on the surface but start to unravel when you peel back the layers - that's OK .

Yet another was actually the center of a local drainage wash (not noted on the latest topo). 

It’s program where they’re paying remote workers to come in and live for a year with several incentives to stay other than the money they pay for a year.On the surface it sounds desperate, paying people to move, which is what made us skeptical in the early days.

And it was a great start to a relationship that is still alive years later.On the other hand: I had a licensed broker recommended by an investor friend in Indianapolis, flew out there to look at the market and meet him, partnered with a local to me friend who had done local flips (that was my first flip, but I was no REI novice) and has an advanced accounting degree, also had the friend vet the broker and each property he brought to our consideration for a flip, finally agreed on a specific property after months of turning down others, signed a very specific (our attorney-drawn) contract that outlined project management responsibilities by the broker, kept in touch through the (delayed) process (and numerous excuses that - at that time - did not seem unreasonable,) flew out there again when the rehab was completed (and found a bunch of issues “on the surface” that he quickly addressed,) only to eventually lose a lot of money through the broker’s apparent negligence and downright fraud...