Distributors in New Mexico |
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='NM')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
Frontier Frames |
P.O. Box 5215, Santa Fe, NM, 87502, Phone: 1-505-473-1901, Fax: 505-473-7806 |
|
H & H Distributors, LLC |
9670 Eagle Ranch Rd NW, #4, Albuquerque, NM, 87114, Phone: 505-501-8560, Fax: 505-501-8561 |
Servicing Albuquerque, Santa Fe, Taos and Surrounding area |
|
|
|
|