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

Residential Properties

Uniprop owns and manages land lease manufactured home communities in cities that
are ranked highly for quality of life, including Boulder Colorado, Las Vegas Nevada and Fort Myers Florida.

To view Uniprop’s properties, select a state.