Here is the simple truth: nationwide, many, many students in your situation start at their local CCs then transfer to in-state public universities. My own kid did. Our EFC was not affordable. What we saved with those two years at CC helped pay for the last two at the state U.
Would you consider studying in one of the other countries where your family owns property? Would that be more affordable for you?