Are you a photographer? We need your help!
Pahoa, Hawaii Zip Codes: 96778
select cat from directory where is_archived=0 and site_url != '' and (city='pahoa' OR city='pahoa') and (state='HI' OR state='Hawaii') and com_name='ACE Hardware'
...
    select id,site_url,local_address,com_name,city,state,zip from directory where is_archived=0 and site_url != '' and (city='pahoa' OR city='pahoa') and (state='HI' OR state='Hawaii') and cat='197' and sub_cat='332' and (sub_sub IS NULL OR sub_sub=0 ) and com_name='ACE Hardware' order by com_name asc
  • Hardware Stores