Have you tried Landscape Architecture, or Urban planning majors? What was your second major choice?
Construction science average transfer GPA is 3.45+, non Blinn/TAMU colleges may require even higher GPA.
Landscape or Urban planning is about 3.0 GPA. If you apply again, focus on your essay to prove that you are prepared for the classes. On the surface, transfer admission is based on GPA, but overall they look for students who are most capable of graduating on time. (for the sake of college metrics and public funds/taxpayers accountability)
As for job prospect, all three majors are about the same unless students get advance degrees. We have seen students from each major working on others’ field so graduating on which exact major is not really that important.