Directory  >  Distributors  >  Pennsylvania
Distributors in Pennsylvania
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='PA')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
Marquis Art & Frame
122 S. Main St, Wilkes-Barre, PA, 18701, Phone: 570-823-0518, Fax: 570-823-7182




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