| Distributors in New York |
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='NY')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
| AMPF, INC |
| 105 Grandview Ave, Rye, NY, 10580, Phone: 914-921-5695, Fax: |
|
| New York Frame |
| 1800 Broadway, Bldg. 1A, Buffalo, NY, 14212, Phone: 1-716-894-3662, Fax: 716-894-3869 |
|
|
|
