Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_36` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('748')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%SignsandSignHolders' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('SignsandSignHolders' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+SignsandSignHolders' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"SignsandSignHolders"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"SignsandSignHolders"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"SignsandSignHolders"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"SignsandSignHolders"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+SignsandSignHolders' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='SignsandSignHolders',`category_4` ='SignsandSignHolders') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'SignsandSignHolders,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('SignsandSignHolders', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Signs And Sign Holders

Refine Search

  GO
 
Brand

deflecto(21)

Headline Sign(13)

Advantus(11)

NuDell(10)

Durable(7)

Quartet(7)

Tarifold, Inc.(7)

Universal(5)

DAX(3)

People Pointer(2)

Newon(2)

Identity Group(2)

C-Line(2)

 
Height

9"(14)

11"(9)

2"(6)

0.12"(6)

8 1/2"(4)

4"(2)

11 1/4"(2)

12"(2)

9 1/2"(2)

13 5/16"(1)

8 1/2(1)

52"(1)

3"(1)

3 7/8"(1)

8 3/4"(1)

6 3/4"(1)

59"(1)

44" - 73"(1)

9 7/16"(1)

12 3/8"(1)

4 1/2"(1)

54"(1)

14"(1)

42"(1)

20.8"(1)

10"(1)

51"(1)

18"(1)

40 1/2" - 46 1/2"(1)

43" - 50"(1)

4 1/4"(1)

11 3/4"(1)

2 1/2"(1)

4 3/8"(1)

8"(1)

5 1/8"(1)

Adjustable 40-60"(1)

56"(1)

48"(1)

12 5/8"(1)

12 1/8"(1)

6 5/16"(1)

10 7/8"(1)

7 5/16"(1)

12 3/16"(1)

 
Depth

1/8"(10)

1/2"(6)

14 1/2"(6)

1 1/8"(3)

13"(3)

1/4"(3)

3 1/2"(3)

5/8"(3)

2 1/16"(2)

3 7/16"(2)

3 3/8"(2)

3"(1)

1 1/4"(1)

1 7/8"(1)

1/16"(1)

2 7/8"(1)

3/8"(1)

4 1/2"(1)

2 1/2"(1)

2 5/8"(1)

2 7/16"(1)

2 3/8"(1)

 
Size

6 x 9(12)

8 1/2 x 11(9)

10 1/4 x 14 1/2(6)

11 x 8 1/2(4)

8 1/2" x 11"(3)

9 x 2(2)

11 x 17(2)

8 3/4 x 11 1/4(2)

8 1/2 x 11; 11 x 17(1)

28 1/2 x 42(1)

14 4/5 x 20 4/5(1)

44 to 73(1)

10 7/8" x 1/16" x 13 5/16"(1)

10 3/8" x 3 7/16" x 9 7/16"(1)

7 5/8" x 3 7/16" x 12 3/16"(1)

5" x 2 7/8" x 8 3/4"(1)

7" x 2 7/16" x 6 3/4"(1)

24 x 18(1)

8 1/2" x 2 3/8" x 3 7/8"(1)

14 x 11(1)

8" x 10"(1)

8 x 12(1)

3 x 9(1)

4 x 13(1)

13 x 21(1)

7 1/2 x 9(1)

13 x 14(1)

14 3/8 x 12 3/8(1)

10 1/16" x 3 3/8" x 12 5/8"(1)

11" x 8 1/2"(1)

2 x 10(1)

39 1/2 x 1 7/8 x 4 1/2(1)

1 1/2" x 2"(1)

13" x 13" x 56"(1)

15 x 46 1/2(1)

11 x 3 1/2 x 4(1)

15 x 50(1)

5 1/2 x 8 1/2(1)

6 3/4 x 5/8 x 5 1/8(1)

4 1/4" x 11"(1)

8" x 9"(1)

8 3/4 x 4(1)

9 x 2 1/2(1)

9 3/8 x 2(1)

4 3/8 x 4 3/8(1)

8" x 8"(1)

40" to 60"(1)

8 1/2" x 1/4" x 2"(1)

8 5/8" x 2 1/2" x 12 1/8"(1)

11" x 3/8" x 9 1/2"(1)

8 1/2" x 3 1/2" x 11"(1)

8 9/16" x 2 5/8" x 11"(1)

18 3/4 x 13 x 51(1)

8 1/2" x 1/4" x 12"(1)

8 1/2" x 4 1/2" x 11"(1)

8 1/2" x 1/4" x 11"(1)

8 15/16" x 3 3/8" x 10 7/8"(1)

5 7/16" x 2 1/16" x 7 5/16"(1)

4 7/16" x 2 1/16" x 6 5/16"(1)

13 x 13 x 48(1)

 
Manufacturer Part Number

LCF2418(1)

CF8511(1)

CF1711(1)

AF32(1)

P194943(1)

P194944(1)

P194995(1)

P194994(1)

P194993(1)

P194945(1)

7923(1)

7922(1)

37085SFG(1)

37085DR(1)

35485Z(1)

35485SFG(1)

37085Z(1)

38008Z(1)

3655(1)

38020Z(1)

38017Z(1)

38011Z(1)

P1949TA(1)

76861(1)

4812(1)

4811(1)

4793(1)

4792(1)

4814(1)

4815(1)

9382(1)

5583(1)

4817(1)

4816(1)

4760(1)

4726(1)

76883(1)

76882(1)

76864(1)

76863(1)

10801(1)

10807(1)

4247(1)

3727(1)

3527(1)

35485DR(1)

899102(1)

N270985HT(1)

87507(1)

36911(1)

97080(1)

N270985VT(1)

N2709N4T(1)

4815-23(1)

4814-23(1)

476901(1)

476801(1)

97079(1)

91100(1)

83700(1)

75390(1)

75334(1)

75329(1)

83701(1)

91096(1)

91099(1)

91098(1)

91097(1)

491301(1)

4977-37(1)

790804(1)

790704(1)

69701(1)

692056(1)

799693(1)

89101(1)

89105(1)

89104(1)

89103(1)

89102(1)

69201(1)

691590(1)

590101(1)

588601(1)

587501(1)

558957(1)

590301(1)

590401(1)

68301(1)

68201(1)

590801(1)

75318(1)

 
Country of Origin

CN(57)

US(16)

DK(6)

TW(6)

PL(4)

DE(3)

 
Width

6"(12)

8 1/2"(11)

11"(7)

10 1/4"(6)

9"(4)

13"(3)

8"(3)

8 3/4"(3)

15"(2)

9 1/2"(2)

10 7/8"(1)

7"(1)

10 3/8"(1)

5"(1)

28 1/2"(1)

10"(1)

14 3/8"(1)

7 1/2"(1)

39 1/2"(1)

7 5/8"(1)

1 1/2"(1)

14 7/8"(1)

8 5/8"(1)

12"(1)

6 1/2"(1)

11 1/6"(1)

4 3/8"(1)

9 3/8"(1)

6 3/4"(1)

8.938(1)

18 3/4"(1)

8 9/16"(1)

4 7/16"(1)

5.438(1)

10 1/16"(1)

 
Material(s)

Plastic(30)

Molded Plastic(8)

Styrene Plastic/PS(7)

PVC(6)

Acrylic(6)

Aluminum(5)

ABS/PETG/Acrylic/Plastic(5)

PVC/Magnetic Material(3)

Styrene Plastic(2)

Alumnium/Acrylic/Cast Iron Base(2)

Steel(2)

Durable Plastic(2)

Metal(1)

EndurACE 10 pt. Waterproof, Tear-Resistant Paper(1)

Thick Plastic(1)

Heavy-Duty Plastic(1)

Plastic/Metal(1)

PMMA/ABS(1)

Rigid Heavyweight Plastic(1)

Polypropylene(1)

Lightweight Aluminum(1)

ABS Plastic(1)

Acrylic/Metal(1)

PMMA/Iron(1)

PS/Plastic(1)

PMMA/Metal(1)

 
Shape

Rectangular(57)

Radius Corner Rectangular(7)

Rectangle(6)

Square(1)

 
For Use With

Letter-Size Inserts(3)

N/A(2)

Tabloid-Size Inserts(2)

C-Line Tent Cards(1)

Magneto Safety Frame Display Pockets(1)

Half-Letter Size Inserts(1)

 
Base Material

Plastic(25)

Acrylic/Plastic(5)

Acrylic(4)

Metal(4)

PVC(3)

Cast Iron(2)

Aluminum(2)

Steel(2)

Iron(1)

Lightweight Aluminum(1)

ABS(1)

ABS Plastic(1)

 
Orientation

Portrait(21)

Landscape(14)

Landscape; Portrait(13)

Vertical(11)

Portrait; Landscape(8)

Horizontal(5)

Horizontal/Vertical(1)

Horizontal; Vertical(1)

 
Placement

Wall(16)

Desktop(12)

Floor(11)

Desktop; Wall; Cubicle(5)

Wall; Flat Surface; Glass(3)

Countertop; Desktop(3)

Any Metal Surface(3)

Non Porous Clean Surface(3)

Door;Wall(3)

Wall;Flat Surface(2)

Desktop; Wall(2)

Countertop; Desktop; Table(2)

Cubicle; Wall(2)

Restroom Door(2)

Fabric Panel(2)

Flat Surface(2)

Cubicle Panel Top(1)

Non Porous Clean Surface; Metal Surface(1)

Door; Fabric Panel; Flat Surface; Wall(1)

Magnetic Surfaces;Wall(1)

Glass or Other Non-porous Materials(1)

 
Mounting

Double-Sided Adhesive Tape(8)

Adhesive Backing(5)

Screws; Cubicle Clips; Tabletop Support(5)

Predrilled Holes(4)

Any Metal Surface(3)

Non Porous Clean Surface(3)

Self-Adhesive(3)

Clips;Double Stick Foam Tape(3)

NO(2)

Double Stick Foam Tape(2)

Screws(2)

Suction Cups(2)

Clips; Magnets; Hook and Loop; Adhesive Pads(2)

Free Standing(1)

Suction Cups for Glass or Acrylic(1)

Adhesive Tape(1)

Punched Hole(1)

Adhesive Tabs; Screws; Panel Pin(1)

Adjustable Clamp(1)

Magnetic or Hook & Loop Self-Stick Tape(1)

Velcro;Velcro Backed Magnet(1)

Predrilled Holes (8 1/4" from center of hole to next)(1)

Self-Standing L-Shaped(1)

 
Message(s)

Customizable(19)

Women(2)

Safety First; Be Safe. Be Careful. Be Aware(2)

Men(2)

Gender Neutral(2)

Danger(2)

Restroom (Man/Woman)(1)

Restroom (Man/Woman/Wheelchair)(1)

Fire Extinguisher(1)

Come In; Open; Will Return(1)

Women (with Wheelchair)(1)

Men (with Wheelchair)(1)

Open(1)

Exit(1)

Closed; Open(1)

Wheelchair(1)

Restroom(1)

Wash Hands(1)

Fire Extinguisher; No Smoking; Exit; Danger Keep Out; Do Not Enter; Slippery When Wet(1)

Employees Must Wash Hands Before Returning to Work(1)

Business Hours(1)

Employees Only(1)

 
Maximum Height

11"(6)

2"(2)

6 3/4"(2)

8 1/2"(2)

N/A(2)

3 7/8"(1)

8 3/4"(1)

9 7/16"(1)

12 3/16"(1)

13 5/16"(1)

52 in(1)

73"(1)

12 5/8"(1)

59"(1)

40 in(1)

50.20 in(1)

56 in(1)

50"(1)

60"(1)

46 1/2"(1)

4"(1)

9(1)

10 7/8"(1)

7"(1)

51"(1)

8(1)

12 1/8"(1)

6"(1)

48"(1)

 
Write-On/Wipe Off Surface

No(42)

Yes(16)

 
Graphics Color(s)

White(9)

Gray/White(5)

N/A(2)

Red Glow(2)

Silver(2)

Green/White Striped Border(2)

Red/Black/White(2)

Yellow/Black Striped Border(2)

Red/White Striped Border(2)

Green/White(2)

Black; Red; White(1)

16-Color(1)

Assorted(1)

Bold Orange; Bold White(1)

 
Loading

Top(17)

Side(16)

Top; Side(7)

Hinged Front(6)

Front(3)

Magnetic(2)

Front Loading(1)

Bottom; Side(1)

 
Graphics

International Symbol(7)

Bi-Color Frame(6)

Safety First; Be Safe. Be Careful. Be Aware(2)

Danger(2)

Arrow(1)

Clock with Movable Hands(1)

OPEN(1)

Assorted Sign Inserts(1)

Man & Woman(1)

Man, Woman & Wheelchair(1)

n/a(1)

NO(1)

 
Lettering

Block(6)

Green/White(2)

Black(2)

Braille(2)

NO(1)

N/A(1)

 
Frame Color

Clear(32)

Black(15)

Gray(9)

Gray/White(5)

Silver/Black(5)

Silver(4)

Red/White(2)

Green/White(2)

Red(2)

Silvertone(2)

Yellow/Black(2)

Red/Black/Clear(2)

Black/Silver(2)

Green/White/Clear(2)

Blue/White(1)

Black Stand / Clear Panels(1)

Clear w/Green Tinted Edges(1)

Assorted(1)

 
Frame Material

Plastic(28)

PS(8)

Acrylic(7)

ABS/PETG(5)

Aluminum(5)

PMMA(3)

PVC(3)

Aluminum; Acrylic(2)

Steel(2)

Metal(1)

ABS Plastic(1)

Polypropylene(1)

Rigid Heavyweight Plastic(1)

Styrene Plastic(1)

 
Insert Size

8 1/2 x 11(30)

11 x 8 1/2(6)

11 x 17(5)

8 1/2 x 2(2)

5 x 7(2)

8 3/4 x 11 1/4(2)

8 1/2 x 11 - 40(1)

8 1/2 x 11;11 x 17(1)

24 x 18(1)

24 x 36(1)

1 1/2 x 2(1)

2 x 10(1)

8 x 10(1)

14 x 11(1)

7 5/8 x 10 3/8(1)

5 1/2 x 8 1/2(1)

4 x 11(1)

4 1/4" x 11"(1)

5 7/8 x 4 1/8(1)

4 x 6(1)

10 3/8 x 7 5/8(1)

8 1/2" x 11"(1)

7 x 5(1)

 
Face Color(s)

Clear(60)

Gray(5)

Translucent(4)

Black(3)

White(2)

Blue(2)

Clear; Frosted(1)

Assorted(1)

 
Display

2-Sides(3)

LED(1)

Easel(1)

NO(1)

N/A(1)

24-Character Scrolling LED;7 x 120 Pixels(1)

 
 
 

© 2018-2019 Legal Name, All Rights Reserved