| 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 |
|
|
|
