Retailers 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=3) AND (show_dir=1) AND (bill_state='WV')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
Appalachian Gallery |
270 Walnut St, Morgantown, WV, 26505, Phone: 304-296-0163, Fax: |
|
Brainerd Gallery |
500 Bland St, Bluefield, WV, 24701, Phone: 304-327-9330, Fax: |
|
Picture It Framed/WV |
202 Hale St., Charleston, WV, 25301, Phone: 304-342-7525, Fax: |
|
The Bridge Gallery |
8566 Shepherdstown Pike, Shepherdstown, WV, 25443, Phone: 3048762300, Fax: 3048768181 |
|
|
|