| Distributors in Utah |
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=1) AND (show_dir=1) AND (bill_state='UT')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
| Artistic Wholesale |
| 6898 South 400 West, Midvale, UT, 84047, Phone: 1-801-561-2604, Fax: 801-561-2648 |
|
| Stylecraft |
| 1650 South Redwood Rd, Salt Lake City, UT, 84104, Phone: 1-801-972-4154, Fax: 801-974-0252 |
|
|
|
