Directory  >  Retailers  >  Hawaii
Retailers in Hawaii
SELECT bill_name, IsNull(NullIf(company, ''), bill_name) AS company, bill_addr1, bill_addr2, bill_city, bill_zip, bill_phone, comp_fax, comp_desc, comp_url FROM eframe_shopper WHERE ((comp_type=3) AND (show_dir=1) AND (bill_state='HI')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
Metropolitan Fine Art & Framing
910 Honoapiilani HWY WH2A, Lahaina, HI, 96761, Phone: 808-667-5885, Fax:
Viewpoints Gallery
1010 E Kuiaha Rd, Haiku, HI, 96708, Phone: 808-572-1828, Fax:
West Side Art and Frame Inc/HI
1000 Limahana Place #B, Lahaina Maui, HI, 96761, Phone: 808-661-0853, Fax:




[products ]   [ order ]   [ search ]   [ line item order entry ]   [ shopping cart ]