Database: real_estate_properties
Question: Show the property type descriptions of properties belonging to that code.
SQL:
SELECT T2.property_type_description FROM Properties AS T1 JOIN Ref_Property_Types AS T2 ON T1.property_type_code  =  T2.property_type_code GROUP BY T1.property_type_code