Directory  >  Distributors  >  New York
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




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