The insurance angle does not stop the due-on-sale clock. The clause is triggered by the deed transfer, and the deed has to be recorded in the public land records. Any title search pulls that up. The lender does not need a flag from the insurer; they can find the transfer themselves whenever they look.
That said, lenders calling loans that are current is genuinely rare. The guide covers this directly: in practice, as long as payments arrive on time, most lenders leave the loan alone. The risk is real but it has not been common, and experienced subject-to operators plan for it rather than trying to prevent the trigger.
What you actually need is a Plan B. If the lender does call the loan, meaning they demand the full balance back at once, you need a path: refinance the property into your own name, sell it, or find another exit. Can you qualify for a refinance at today's rates and still make the numbers work? That question matters more than the insurance policy name.
The separate insurance problem is worth knowing about. If you own the property and a claim comes in on a policy held in the seller's name, the insurer may deny it, since the named insured no longer has an insurable interest in the property. You would typically want to add yourself as an additional insured or get your own landlord policy, and talk through the overlap with an insurance broker who handles investment properties.
A real estate attorney in Massachusetts should review the deed structure before you close. This is not a step to skip.
What does your exit look like if the lender calls the loan in year one? That shapes how much risk you are actually taking on with this Cape.