Retrieve Distinct meta field values from Custom Post Type in WordPress

Retrieve Distinct meta field values from Custom Post Type in WordPress

SELECT DISTINCT pm.meta_value AS your_meta_field_name
FROM wpd8_posts AS p
INNER JOIN wpd8_postmeta AS pm ON p.ID = pm.post_id
WHERE p.post_type = 'your_post_type_name' AND pm.meta_key = 'your_meta_field_name';

Example 

SELECT DISTINCT pm.meta_value AS property_name
FROM wpd8_posts AS p
INNER JOIN wpd8_postmeta AS pm ON p.ID = pm.post_id
WHERE p.post_type = 'owner-data' AND pm.meta_key = 'property-name';