Distributors in Ohio |
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='OH')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
Frame USA, Inc. |
225 Northland Blvd., Cincinnati, OH, 45246, Phone: 513-577-7107, Fax: 513-577-7110 |
|
West Shore Distributors |
P.O. Box 45460, Westlake, OH, 44145, Phone: 1-800-344-8141, Fax: 1-440-835-8654 |
Full line Designer Moulding METAL Distributor |
|
|
|
|