select * from state where State_Id in (select State_Id from community where Status_Id=1 and Property_Type_Id = 5 ) order by State asc

Office Buildings

Uniprop has developed several large tracts of land for residential, commercial
and mixed use projects around the country.

To view Uniprop’s properties, select a state.