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

Retail Properties

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

To view Uniprop’s properties, select a state.