That has got to be one of the most complicated queries I have tried to 
understand for a long time!  But I think if hunit is null then age will be 
null too - is that right?

If so, just change this bit:

       SUM(DECODE(sign(NVL(AGE,24) - 23), 1, UNITSQFT, 0)) AGE24