query: SELECT post.post_name FROM wp_posts post LEFT JOIN wp_postmeta meta ON meta.post_id = post.id WHERE meta.meta_key = 'mls' and meta.meta_value like '%100134' AND post.post_type = 'estate_property' LIMIT 1This listing is no longer active, we may have similar listings currently on the market, please search on www.coldwellbankerbermuda.com for our active listing inventory.