At this point I’m interested in local active investing and more mature/geographically broad syndication.  

Pay a fraction of the cost quoted to have him/her review the legal description and confirm the existing park lies well within the boundaries of the land.

But based on the website description, and the fact they provide 80LTV on owner-occupied, it is very unlikely that they provide the same LTV for OO primary and NOO Multi

From your description, it would appear that your husband and you know what works for yourselves better than your advisor.

As Ed mentioned they only lend in their geographic target area.

Some sponsors invest in a single apartment complex, while others invest in a fund/portfolio of apartment complexes in a specific geographic region.

A few days before you take possession of the property you could list the property on Furnished Finder and include “pics coming soon” in the description until you get the furniture assembled and pictures taken.

Base on the deal description thus far, it is all very speculative.

Inspector's opinion is that foundation showing signs of movement that exceeds normal tolerances and changes in floor elevation of house greater than would normally be expected.Not only does that sound like a red flag to me, but also the following::- Soil levels against exterior grade beam appear to be too low- interior sheetrock cracks and/or stress indicators (multiple areas photographed; about 20)- floor slopes and/or unlevel areas (bathrooms, living space)- misalignment of exterior doors due to foundation movement (very obvious)- deflection cracks in exterior veneer (a few I wouldn't be too concerned, but there are pictures of about 20 areas that show more than a hand's width of defect with signs of poor "band-aid" repair)Not sure if I can post pictures but figured the description is enough to determine yes or no.Is this a good or bad investment stepping into?

The agent had no idea about the Point of Sale requirements in Alameda nor were they familiar with geographic issues that potentially affected the home.