| Distributors in West Virginia |
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='WV')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
| International Moulding of WV- Mayne Framing |
| 121 E. 21st St., Huntington, WV, 25703, Phone: 304-525-6703, Fax: 304-525-6778 |
|
|
|
