Retailers in Idaho |
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='ID')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
3-D Framing |
6982 W State St, Northgate Mall, Boise, ID, 83703, Phone: 208-853-3316, Fax: |
|
Blue Heron Workshop |
P.O. Box 24, Hailey, ID, 83333, Phone: 1-208-788-5030, Fax: 208-788-5030 |
|
Creative Indoor Advertising |
1841 N. Wildwood St., Boise, ID, 83713, Phone: 208-629-0047, Fax: 208-629-0048 |
|
Elegance In Art |
367 W. Broadway, Idaho Falls, ID, 83402, Phone: 208-523-7765, Fax: 208-523-2171 |
|
Fast Frame #358 |
489 N. Milwaukee, Boise, ID, 83704, Phone: 208-378-0700, Fax: 208-378-0707 |
|
Finishing Touch Frame Shop |
944 Vista Ave, Boise, ID, 83705, Phone: 1-208-344-2277, Fax: |
|
Flahertys Framing |
2951 Government Way, Coeur D'Alene, ID, 83815, Phone: 208-664-5566, Fax: |
|
Frame Works/Boise |
10418 Overland Rd, Boise, ID, 83709, Phone: 208-375-8150, Fax: |
|
Gallery 601 |
211 N. 10th Street, Boise, ID, 83702, Phone: 208-336-5899, Fax: 208-345-9763 |
|
Holden Photography |
7236 W. Usick Rd, Boise, ID, 83704, Phone: 1-208-322-1980, Fax: |
|
KC Framing |
551 South Woodfruff Avenue, Idaho Falls, ID, 83401, Phone: 1-208-522-7004, Fax: (208)522-0043 |
|
Kuma Stove Inc |
50145 N Old Hwy 95, Rathdrum, ID, 83858, Phone: 1-208-762-8002, Fax: 888-714-5862 |
|
Marv's Framing & Gallery |
5901 Overland, Boise, ID, 83709, Phone: 208-375-4229, Fax: |
|
Mountain House Gallery |
402 S. 3rd Street, McCall, ID, 83638, Phone: 208-634-7710, Fax: |
|
Myhre's Custom Framing |
213 W. Appleway, Ste. 4, Coeur d Alene, ID, 83814, Phone: 208-667-7827, Fax: |
|
Prints Plus |
1780 West State Street, Boise, ID, 83702, Phone: 208-345-7882, Fax: 208-345-7882 |
|
Rockebys Custom Framing |
501 W. Appleway Ave, Ste L, Coeur D' Alene, ID, 83814, Phone: 208-676-1330, Fax: |
|
The Frame of Mind Gallery |
119 N Second, Coeur D alene, ID, 83814, Phone: 208-667-6889, Fax: |
|
The Gallery at Finer Frames |
164 E. State St, Ste B, Eagle, ID, 83616, Phone: 208-888-9898, Fax: |
|
The Gallows/ID |
150 S. 4th, Pocatello, ID, 83204, Phone: 1-208-234-2544, Fax: 208-234-7610 |
|
Wildlife Watercolors |
11415 South Greenbrier Dr, Idaho Falls, ID, 83404, Phone: 208 522 5258, Fax: |
|
Willow Tree Gallery |
210 Cliff Street, Idaho Falls, ID, 83402, Phone: 1-208-524-4464, Fax: 208-552-5558 |
|
|
|