Retailers in South Carolina |
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='SC')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASC
Accent Framing & Gallery |
1303 Ben Sawyer Blvd., Suite 1, Mt. Pleasant, SC, 29464, Phone: 1-843-884-5828, Fax: |
|
Art & Frame Gallery @ Bay 3 |
110 Federal Street, Anderson, SC, 29625, Phone: 1-864-226-1858, Fax: |
|
Art & Frame Outlet |
204 George Bishop Pkwy., Myrtle Beach, SC, 29579, Phone: 1-843-236-4370, Fax: |
|
Artists View Creations |
108 N. Main Street, Bishopville, SC, 29010, Phone: 1-803-483-2060, Fax: |
|
Art Shoppe |
607 W Carolina Avenue, Harstville, SC, 29550, Phone: 843-332-0881, Fax: |
|
A Simple Tree Framing |
1304 Erckmann Dr, Ste D, Mt. Pleasant, SC, 29464, Phone: 843-345-6605, Fax: |
|
Bella Vista Art & Framing |
324 State Street, W Columbia, SC, 29169, Phone: 803-791-6060, Fax: |
|
Bennett's Frame & Art Gallery |
2100 Laurens Road, Greenville, SC, 29607, Phone: 1-864-288-6430, Fax: 800-286-9037 |
|
Carolina Fine Art Framing |
2360 Parsonage Woods Lane, Mount. Pleasent, SC, 29466, Phone: 1-843-723-2266, Fax: |
|
Carolina Sports |
932 Broad Street, Camden, SC, 29020, Phone: 1-803-432-3515, Fax: |
|
Charles Street Gallery |
914 Charles Street, Beaufort, SC, 29902, Phone: 1-843-521-9054, Fax: |
|
Charleston Frame Works & Gallery |
738 St. Andrews Blvd., Charleston, SC, 29407, Phone: 843-556-9373, Fax: 843-769-0525 |
|
Cheryl M. Newby, Inc. |
11096 N. Ocean Hwy., Pawleys Island, SC, 29585, Phone: 843-979-0149, Fax: 843-979-0151 |
|
Coastal Art and Framing |
109 Tenth Avenue, Bluffton, SC, 29910, Phone: 1-843-368-4919, Fax: |
|
Connie's Framing |
118 Park Avenue SE, Aiken, SC, 29801, Phone: 1-803-643-3696, Fax: 1-803-643-3696 |
|
Doug Shealeys Stadium Art |
129 S. Bull Street, Columbia, SC, 29250, Phone: 803-765-0928, Fax: |
|
Dutch Door Inc. dba City Art |
1224 Lincoln Street, Columbia, SC, 29201, Phone: 803-252-3613, Fax: 803-252-3595 |
|
Elite Framing |
2119 College Street, Columbia, SC, 29205, Phone: 1-803-951-4600, Fax: |
|
Fast Frame #305 |
135 Mall Connector Rd, Ste A, Greenville, SC, 29607, Phone: 1-864-627-8164, Fax: 864-627-7914 |
|
Fast Frame #395 |
616-F Long Pointe Road, Mt. Pleasant, SC, 29464, Phone: 1-843-216-0552, Fax: |
|
Fast Frame #447 |
Lexington Place II, 5454-B Sunset Blvd., Lexington, SC, 29072, Phone: 1-803-996-4808, Fax: 803-996-4809 |
|
Four Corners Fine Art & Framing |
P.O. Box 1871, Bluffton, SC, 29910, Phone: 843-757-8185, Fax: 843 757-8570 |
|
Frame Design & Gallery |
800 South Main Street, Summerville, SC, 29483, Phone: 1-843-871-6373, Fax: 843-871-6490 |
|
Frame Designs, LTD |
1322 E. Washington B-1, Greenville, SC, 29607, Phone: 864-242-2255, Fax: 864-242-0360 |
|
Frame It |
140 Maxwell Ave, Studio 3, Greenwood, SC, 29646, Phone: 864-980-0401, Fax: |
|
Frametastic |
1649-F Savannah Highway, Charleston, SC, 29407, Phone: 1-843-556-9416, Fax: |
|
Frame World |
114 N. Church Street, Lexington, SC, 29072, Phone: 1-803-359-0668, Fax: |
|
Gallery at Grove |
1312 Augusta Street, Greenville, SC, 29605, Phone: 864-235-4935, Fax: 864-235-9625 |
|
GB Framing |
215 Zimmerman Drive, Inman, SC, 29349, Phone: 864-599-9674, Fax: |
|
Havens Framemakers & Gallery |
1616 Gervai Street, Columbia, SC, 29201, Phone: 803-256-1616, Fax: |
|
Havens Picture Framing/Mt. Pleasant |
1070 Johnnie Dodds Blvd., Mt. Pleasant, SC, 29464, Phone: 843-881-1543, Fax: 843-849-7790 |
|
House of Frames & Paintings, Inc. |
2828 Devine Street, Columbia, SC, 29205, Phone: 1-803-799-7405, Fax: 803-799-8879 |
|
Jim Harrison Gallery |
One South Main Street, Denmark, SC, 29042, Phone: 1-800-793-5796, Fax: |
|
Karen's Korner |
1405 Ben Sawyer Blvd, Bldg 2 Ste 101, Mt. Pleasant, SC, 29464, Phone: 843-971-4110, Fax: |
|
Kit N Kabootle |
712 W. Carolina Avenue, Hartsville, SC, 29550, Phone: 1-843-332-0370, Fax: |
|
Laurel Creek Fine Art Framing |
121 Cleveland Street, Greenville, SC, 29601, Phone: 1-864-271-7723, Fax: 864-271-7723 |
|
Market Street Frame Shop |
146 Market Street, Cheraw, SC, 29520, Phone: 843-865-9002, Fax: |
|
Martin Art & Frame, Inc. |
1033 Oakland Avenue, Rock Hill, SC, 29732, Phone: 803-328-6103, Fax: |
|
M Smart Custom Framing |
131 Laurens Street SW, Aiken, SC, 29801, Phone: 1-803-642-4235, Fax: |
|
Picture This Frame & Art |
111 W. Public Square, Laurens, SC, 29360, Phone: 864-223-0697, Fax: |
|
Prince George Framing, Co. |
718 Front Street, Georgetown, SC, 29440, Phone: 1-843-527-8413, Fax: 843-545-1292 |
|
R & CC Framers |
9683 Hemingway Hwy, Kingstree, SC, 29556, Phone: 1-843-382-2580, Fax: |
|
Reel Life Creations |
PO Box 181, McClenanville, SC, 29458, Phone: 1-843-424-4052, Fax: |
|
Royal Hospitality Group |
200 Smith Road, Greenville, SC, 29615, Phone: 1-864-254-9090, Fax: |
|
Smart Art Framing |
2604 Main Street, Newberry, SC, 29108, Phone: 1-803-321-3060, Fax: |
|
Stine Gallery |
2202 Cobbs Way, Anderson, SC, 29621, Phone: 1-864-226-7035, Fax: |
|
The Beveled Edge |
526 Georgia Avenue, N. Augusta, SC, 29841, Phone: 1-803-441-0144, Fax: |
|
The Calabash Gallery |
4281 Parkway Lane, Little River, SC, 29566, Phone: 1-910-338-0763, Fax: |
|
The Finishing Touch |
140A West Richardson Avenue, Summerville, SC, 29483, Phone: 1-843-873-8212, Fax: |
|
The Frame Depot |
206 Chesnee Ave, Ste E, Gaffeney, SC, 29341, Phone: 864-489-0004, Fax: |
|
The Frame House |
28 Mill St, Inman, SC, 29349, Phone: 1-864-472-4270, Fax: |
|
The Frame Makers |
1941- A Hoffmeyer Road, Florence, SC, 29501, Phone: 1-843-665-4897, Fax: 843-396-4345 |
|
The Frame Up |
451 E Henry Street, Spartanburg, SC, 29302, Phone: 1-864-583-9281, Fax: |
|
The Great Frame Up |
22 Plantation park Dr., Suite 108, Bluffton, SC, 29910, Phone: 843-815-4661, Fax: |
|
The Picture Place |
4711-09 Forest Dr, Columbia, SC, 29206, Phone: 1-803-782-6138, Fax: |
|
Z Art Group |
2310 Cannons Campground Rd., Spartanburg, SC, 29307, Phone: 1-864-583-3008, Fax: 888-675-4462 |
|
|
|