Hi,
You need a four-year plan on how to pay for college. Knowing that Flagler is not a financially feasible option and trying to solve it would be taking a HELOC, what is the plan for repaying the $160k of debt that you are talking about taking on?
A dream school should not be a financial nightmare.
There is more than one way to fund college, but how will you fund your retirement if you are exhausting all of your resources for one college?
It is time to move on from Flagler, they do not have enough money to make the school affordable. You need to sit down with your daughter and tell her realistically how much you can afford to pay or borrow for school.
If you have a house in Florida, that is going to throw a wrench into any need-based aid you are going to receive. Schools are not going to give you need-based aid so that you can keep your Florida home.
Your daughter is a solid B student. You are fortunate that you have SUNY, which can be an affordable option. There are 64 schools in the SUNY system (the second-largest public university system in the country) and I am sure that she will have more than one option.
If you are in the city, you also have CUNY (the 3rd-largest public university system in the country and the largest urban public university system in the country).
Your 2 favorite words may be articulation agreement.
While New Paltz is not on the table at this time, she can look into attending SUNY Dutchess, and transfer to New Paltz or any other SUNY.
SUNY Has made it easier to move from school to school within the SUNY system through the SUNY transfer paths
https://www.suny.edu/attend/get-started/transfer-students/suny-transfer-paths/
Don’t look down your nose at the SUNY CC’s as they have articulation agreements with all of the 4 year SUNYs and the land grant colleges at Cornell
https://www.human.cornell.edu/admissions/transfer/articulationagreements
Even the CUNY CC’s have articulation agreements with the 4 year SUNY schools, Cornell and NYU (through the CCTOP)
The Corning Express: Corning CC to SUNY Bing
https://www.corning-cc.edu/academics/transfer-agreements/binghamton-university.php
I would recommend looking at Mount St Vincent, that can be affordable with merit money (she could probably get about 21K with an additional 5K as a residential student). She would need to maintain a 2.75 gpa to keep her merit.
You are going to have to take a bottoms-up approach and start trying to find a true safety; a school where your D can be admitted, a school that is a financially feasible option, and when the dust settles will be a school that your D will be happy to attend.