Database: real_estate_rentals
Question: In which states are each of the the properties located?
SQL:
SELECT DISTINCT T1.county_state_province FROM Addresses AS T1 JOIN Properties AS T2 ON T1.address_id  =  T2.property_address_id;