| Distributors in Texas |
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='TX')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
| Monarch Moulding |
| 10909 Grissom Ln, Dallas, TX, 75229, Phone: 972-243-4599, Fax: 972-243-5244 |
|
| Singleton Moulding |
| 1895 US Hwy. 180 E., Breckenridge, TX, 76424, Phone: 1-254-559-7542, Fax: 1-254-559-7551 |
|
|
|
