These guys give really good points but im going to touch on debt alittle more. ERAU and UND are both very good and very expensive schools. Tuition alone at ERAU is enough to leave you suffering for years and thats not even including the flight fees and housing. UND can be affordable IF you are paying the in-state tuition price.
One thing you dont want is to walk away from college with a student loan. As an entry level pilot there will not be enough room to survive makeing a crap wage and paying student loans. If you are set on an Aviation Degree then I would recommend getting an Associates Degree from a small community college. Do your 4 semesters and go from there. Community college are usually affordable and you wont be paying an outragous tuition. After your Associates you can decide if you want to transfer to a University to get the bachelors or if you want to major in something else. Majoring in something else is something most would recommend. You'll have your Associates in Aviation and a Degree in a field of your choice. This would also allow you as a CFI-II to build hours while you attend school.
Never EVER get a loan from a private party bank like sallie mae.