Jumping into a venture is a great thing, however the first thing I would do is verify these numbers for myself. Realtor and zillow are the last 2 places I would pull my information unfortunately, these sites are very skewed as well as the information from the person "pitching" the deal. If there is only one house in the market at $259k and everything else has sold $200ish that is also a read flag. You want to be in and out with your money, not sit on property for a long time and let your money do nothing for you. In a position with many other investors is also a red flag for me. First position is preferred, it sounds like there is a lot of risk without a whole lot of assurances in the deal.
That was the bad, now the good. There is money to be made if the CMA is correct, and the return sounds like something that would be very good for the short period of time you are in the deal. Experience is something needed and 25 years is a good amount of time, claims may be the best choice for their experience.
Overall I would approach with caution and eyes wide open. For the partnership this is a good idea, the ownership and deeds of trust for the property should also be held in the partnership and not with this individual doing the deal. There is no guarantee when investing but you should protect yourself. Maybe a smaller deal where you are in first position would be a better first deal then something like this, give them time to prove their worth and if they hold true and return the money for everyone then maybe give them a shot next time. Ask around the group about them and do your research. Not every deal is a good deal, and as much as it is no fun to be left out, there is no reason to rush into anything either.