If this was a good deal then it wouldn't last that long- The description doesn't mention anything about the property needing work or TLCEssentially what I'm asking is, what am I missing?

add “Exhibit A” with Contingencies.Within 10 Days of execution, Seller shell provide Buyer with any document related to the property, which sell include but not limited to:1.Leases, amendments, modifications2.Current or future lease concessions3.Security deposits4.Current rent rolls5.Current rent arrears6.All maintenance, utility, management, service, and other contracts.7.Financial statements for the past three years and a year-to-date financial statement.8.A description of all capital expenditures performed in the last 3 years.

well your description of the situation is not complete.. do you know its landlocked.. somehow if there is a home there I suspect it is not.. but it does happen I am in a landlocked case right now been two years fighting it thankfully I have title insurance and they are paying the lawyers.. first thing you do is not rely on your own due diligence if your not a surveyor or familiar with maps etc.you do one thing first .. you order a title report.. you may have to pay for it.. say 200 to 250.. your probably in a title abstract state. ( not sure but most of the NE is)  the title company hires an abstractor to do the court house work they will then write you a title commitment.. if your TRULY landlocked there will be an exception IE they wont insure access.. if this is missing then you ask them to clearly denote on the plat map where the legal access is.. you then take that map and see if it works on the ground.. 

Also why do many houses on a MLS only have one of the two in the description.

They are NEVER true service animals.Our property description always indicates no pets yet nearly all applicants have a pet and then state they are ESA or 'assistance'.  

Does anyone have a finish carpenter who is detail oriented and fits the above description?

Under that same description you will also find lenders that will approve you based on bank cash in flow, if you are self employed, rather than your net income on your tax returns. 

Based on my interpretation of the description, It appears that the property is divided by percent between the two entities.

Slightly worried with the listing description saying "(Property is being sold in as-is condition, buyer is responsible for the use and occupancy permit)". 

In NJ and PA, I am very aggressive with my marketing (local letters, weekly open houses, free staging, professional photos, great descriptions.)