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

Development

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.