Except "prestigious" (even "semi-prestigious") and "community college" are mutually exclusive. You may be able to get a satisfactory education at one, depending on the college and the field of study...but prestigious? No way.
i think the "semi-prestigious" refers to the fact that some bay area CCs are known as transfer feeders for Berkeley (which does not have TAG, so you have to be competitive among CC candidates).