Rank and number of dependents?
Assuming, like most people in your situation, that you're an O-3 with a normal number of children (pretty much any number less than 5), then on post housing is really a non-starter.
First of all, the amount of on post housing available for company grade officers is extraordinarily small. There will almost certainly be at least a several month wait.
Secondly, the housing really isn't worth waiting for. The housing they offered me was only slightly larger than the tiny condos I lived in during medical school and residency. And most of the options involve a duplex or even a quad, so you're still sharing walls with your neighbors.
Lastly, SA has a low cost of living but is large enough to offer plenty of off post options. You won't have to exceed your BAH by too much in order to get something much nicer and larger than quarters. Considering its size, the traffic isn't horrible (people who think it is need to be reassigned to DC to get some perspective), so many people are willing to commute a decent distance to live in some of the nicer, more affordable areas.
I know of only one person who lives on post, and he's a senior NCO. His quarters are relatively new and probably a better deal than what he could get on the economy. I do not know a single officer who lives on post.