The sponsor said retail drag was the risk. It was also the reason the deal penciled.

The LOI is the thing that changes the analysis entirely, and it was sitting in the sponsor's back pocket while the offering doc described a generic lease-up risk. That is a material fact. The fact that you had to surface it through a Q&A question rather than find it disclosed in the document is worth naming directly, because it points to a structural habit in how crowdfunding deals get presented: the risk section describes the category of risk, and the sponsor's mitigation of that specific risk lives somewhere else, often nowhere in writing unless you ask.

The assumption doing the most work in your original hesitation was treating retail vacancy as a static condition rather than a pipeline problem. A seven-year NNN to a regional healthcare tenant is a fundamentally different underwriting input than "retail TBD." The 38% debt service coverage from that one tenant before CO is not a rounding error, it restructures the whole deal's loss scenario.

The thing you did not mention: what your basis for the 7.5% pref was, and whether the sponsor's debt structure gave the preferred return any real protection if the residential stabilization had taken eighteen months instead of eight. Your cash return is running ahead of pref right now, but the LP position in a mixed-use crowdfunding deal usually sits behind construction debt, any mezzanine, and the operating reserve before distributions flow. If the residential had dragged, the retail NNN would have softened that, but you would want to know exactly where in the waterfall your pref sits and whether it accrues or is simply deferred.

The portable lesson here is not that retail is fine. It is that the offering document describes the risk and the Q&A is where you find the sponsor's actual read on probability and mitigation. Every deal has a version of that gap.

What does the waterfall look like on this one specifically, and did the sponsor's debt structure include a personal guarantee on the construction loan?

The urgent care tenant changes the credit picture in a way that goes beyond lease-up risk, and that part is worth slowing down on. NNN from a regional operator on a seven-year term is not the same as NNN from a national covenant, and the spread between those two matters the moment you think about what happens at refinance or sale. A regional urgent care group with three or four locations has a different probability of renewal, a different probability of bankruptcy, and a different cap rate applied to that income stream by an appraiser than a national brand would. If the sponsor gets to a disposition in year five or six and the urgent care is in year two of that seven-year term with five years remaining, a buyer's lender will look hard at whether that tenant can actually perform through the back half of the lease. The 38% of debt service figure is the number doing the most work in your underwrite, and how bulletproof that figure is depends almost entirely on how well-capitalized that specific operator is.

What I do not see in your post is the tenant's lease guarantee structure. Whether that seven-year NNN is backed by a corporate guarantee from an entity with auditable financials, a personal guarantee from the operator, or just the operating LLC is the number I would want before I got comfortable with that 9.1% holding through a re-leasing event. A personal guarantee on a seven-year term from a small regional operator means your 38% of debt service coverage disappears if that tenant closes two locations and starts missing rent in year four, and the workout on a commercial ground floor in Shreveport is not a quick one. Did the sponsor provide any financials on the operator when you asked that direct question, or did the answer stop at confirming the LOI existed?