Showerdome^® West Coast

Array
(
    [posts_per_page] => -1
    [paged] => 1
    [post_status] => publish
    [post_type] => stockists
    [tax_query] => Array
        (
            [0] => Array
                (
                    [taxonomy] => stockists_regions
                    [field] => slug
                    [terms] => showerdome-west-coast
                )

        )

)
string(389) "SELECT   i9ma8a33f_posts.* FROM i9ma8a33f_posts  LEFT JOIN i9ma8a33f_term_relationships ON (i9ma8a33f_posts.ID = i9ma8a33f_term_relationships.object_id) WHERE 1=1  AND ( 
  i9ma8a33f_term_relationships.term_taxonomy_id IN (43)
) AND i9ma8a33f_posts.post_type = 'stockists' AND ((i9ma8a33f_posts.post_status = 'publish')) GROUP BY i9ma8a33f_posts.ID ORDER BY i9ma8a33f_posts.menu_order ASC "

• The Plumbing Shop Ltd

  Hokitika

  03 755 8068

  Retailer
• Total Glass

  Greymouth

  03 768 5792

  Installer
• Paddy & Karen Byrne

  Greymouth

  03 768 5338

  Installer
• Mico Bathrooms (Greymouth)

  West Coast

  03 768 5114

  Retailer