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

Headline Sign(28)

deflecto(25)

COSCO(15)

Durable(15)

NuDell(10)

Advantus(9)

Quartet(7)

Rubbermaid Commercial(7)

Universal(6)

Identity Group(4)

People Pointer(4)

C-Line(3)

DAX(2)

Newon(2)

Tatco(1)

Safco(1)

Impact®(1)

 
Height

9"(19)

12"(13)

11"(9)

3"(8)

2"(7)

10"(6)

8 1/2"(4)

9 1/2"(3)

4"(3)

23 1/2"(3)

18"(2)

11 1/4"(2)

8 3/4"(2)

7"(2)

13"(2)

8"(2)

25 1/2"(2)

19"(2)

6"(2)

42"(1)

44" - 73"(1)

8 1/2(1)

52"(1)

54"(1)

59"(1)

20.8"(1)

13 in(1)

12 3/8"(1)

5"(1)

14"(1)

64"(1)

40"(1)

38"(1)

26"(1)

26 1/10"(1)

7 3/4"(1)

17"(1)

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

43" - 50"(1)

5 1/4(1)

4 1/4"(1)

2 1/2"(1)

4 3/8"(1)

11 3/4"(1)

5 1/8"(1)

Adjustable 40-60"(1)

12 5/8"(1)

9 7/16"(1)

3 7/8"(1)

56"(1)

11 3/16"(1)

10 7/8"(1)

8 7/16"(1)

11 7/8"(1)

13 5/16"(1)

 
Depth

1/2"(13)

6/100"(7)

1/8"(7)

3 1/2"(5)

2 5/8"(3)

3"(3)

1 1/8"(3)

5/8"(3)

1/4"(3)

1 1/4"(2)

1"(2)

3 3/8"(2)

4 3/4"(1)

13 1/4"(1)

1/16"(1)

15"(1)

2 3/8"(1)

2 1/2"(1)

1 in(1)

4"(1)

0.22"(1)

3 11/32"(1)

3 13/16"(1)

4 1/2"(1)

3/8"(1)

0.31"(1)

13"(1)

3 11/16"(1)

3 5/16"(1)

3 7/16"(1)

 
Size

8 1/2" x 11"(14)

6 x 9(12)

3 x 9(8)

8 1/2 x 11(8)

9 x 3(5)

10 x 14(5)

11 x 8 1/2(3)

8 x 12(2)

11 x 17(2)

24 x 18(2)

10 1/2 x 25 1/2(2)

50 x 1 x 13(2)

15 x 23 1/2(2)

4 x 13(2)

9 x 2(2)

11" x 8 1/2"(2)

15 x 19(2)

8" x 8"(1)

10 9/10 x 26 1/10(1)

8" x 9"(1)

11 9/10 x 38(1)

13 x 13 1/4 x 26(1)

15 x 15 x 64(1)

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

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

28 1/2 x 42(1)

14 3/4 x 40(1)

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

4 x 6(1)

14 x 11(1)

44 to 73(1)

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

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

4" x 6"(1)

8 3/4 x 4(1)

9 3/8 x 2(1)

13 x 21(1)

9 x 2 1/2(1)

7 1/2 x 9(1)

20 1/2 x 1 1/4 x 23 1/2(1)

13 x 14(1)

13 x 5(1)

8" x 10"(1)

1 1/2" x 2"(1)

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

2 x 10(1)

18 x 12(1)

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

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

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

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

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

15 x 50(1)

40" to 60"(1)

3" x 1" x 4"(1)

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

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

15 x 46 1/2(1)

2" x 3 1/2"(1)

10 1/2 x 20 1/8(1)

12 x 8(1)

5 x 6(1)

4 dia(1)

5 1/4 x 5 1/4(1)

11 x 3 1/2 x 4(1)

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

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

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

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

13" x 13" x 56"(1)

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

6 x 17(1)

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

5 1/16" x 3 5/16" x 7 3/4"(1)

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

11 1/16" x 3 11/32" x 8 3/4"(1)

8 1/2" x 3 13/16" x 11 1/4"(1)

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

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

4 1/4" x 11"(1)

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

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

 
Manufacturer Part Number

1867508(1)

1867509(1)

9S0900YEL(1)

1867507(1)

1867505(1)

CF8511(1)

LCF2418(1)

9S15 YEL(1)

9S1600YL(1)

76863(1)

76864(1)

76882(1)

76861(1)

76859(1)

4174GR(1)

07230(1)

CF1711(1)

AF32(1)

35485DR(1)

35485SFG(1)

35485Z(1)

35446(1)

9140(1)

89105(1)

899102(1)

37085Z(1)

38008Z(1)

3655(1)

7922(1)

7923(1)

38020Z(1)

38020(1)

38011Z(1)

38017Z(1)

76883(1)

10801(1)

4816(1)

4817(1)

5484(1)

4815(1)

4814(1)

4811(1)

4812(1)

5491(1)

5492(1)

5694(1)

6093(1)

9382(1)

5693(1)

5583(1)

5494(1)

5498(1)

4793(1)

4792(1)

4246(1)

4247(1)

4726(1)

3850(1)

3849(1)

10807(1)

3727(1)

4757(1)

4758(1)

4763(1)

4782(1)

4762(1)

4761(1)

4759(1)

4760(1)

89102(1)

799693(1)

098063(1)

098068(1)

098072(1)

098056(1)

098055(1)

098010(1)

098052(1)

098099(1)

098205(1)

N270985HT(1)

N2709N4T(1)

476801(1)

098211(1)

098208(1)

098206(1)

098207(1)

090249(1)

090244(1)

83701(1)

91096(1)

91097(1)

83700(1)

75390(1)

75329(1)

75334(1)

91098(1)

91099(1)

87507(1)

87537(1)

36911(1)

97080(1)

91100(1)

97079(1)

476803(1)

476823(1)

68201VP(1)

68301(1)

68301VP(1)

68201(1)

66701(1)

5991790(1)

5991890(1)

690175(1)

690275(1)

69301(1)

69701(1)

69701VP(1)

692056(1)

69201VP(1)

69101(1)

69201(1)

590801(1)

590101(1)

4772131(1)

4772132(1)

477323(1)

4772130(1)

477123(1)

476901(1)

477101(1)

4814-23(1)

4815-23(1)

587501(1)

588601(1)

20007(1)

558957(1)

491301(1)

4977-37(1)

75318(1)

 
Country of Origin

CN(91)

US(26)

PL(12)

TW(8)

DE(3)

 
Width

8 1/2"(15)

6"(13)

9"(11)

9 1/2"(10)

11"(8)

15"(7)

3"(6)

14"(5)

13"(4)

8"(4)

4"(3)

12"(2)

10 1/2"(2)

8 3/4"(2)

5"(2)

50"(1)

14 7/8"(1)

11 9/10"(1)

12 1/4"(1)

10 9/10"(1)

50 in(1)

14 3/8"(1)

28 1/2"(1)

24"(1)

20 1/2"(1)

18"(1)

10"(1)

7 1/2"(1)

1 1/2"(1)

5 1/16"(1)

5 1/4(1)

6 1/2"(1)

3 1/2"(1)

11 1/6"(1)

9 3/8"(1)

4 3/8"(1)

6 3/4"(1)

8.938(1)

10 3/8"(1)

10 7/8"(1)

10 1/16"(1)

8 9/16"(1)

11 1/16"(1)

11 1/8"(1)

14 3/4"(1)

 
Material(s)

Plastic(46)

Molded Plastic(15)

PVC(11)

Styrene Plastic/PS(7)

Metal(6)

Acrylic(5)

Aluminum(5)

Styrene(5)

Heavy-Duty Plastic(4)

PMMA(4)

Plastic/Metal(3)

ABS/PETG/Acrylic/Plastic(2)

4mm Corrugated Plastic(2)

Rigid Heavyweight Plastic(2)

Durable Plastic(2)

Styrene Plastic(2)

Die-Cut Paper(2)

PS/Plastic(2)

Alumnium/Acrylic/Cast Iron Base(2)

Plastic/Steel(1)

Polypropylene(1)

Lightweight Aluminum(1)

Thick Plastic(1)

Rugged Polycarbonate(1)

Acrylic/Metal(1)

Steel(1)

ABS Plastic(1)

PMMA/Metal(1)

Brass/Wood/Rubber(1)

Stainless Steel/Wood/Rubber(1)

Fabric(1)

PMMA/Iron(1)

 
Shape

Rectangular(88)

Radius Corner Rectangular(7)

Rectangle(5)

Square(2)

Rectangular;Triangular(1)

Round(1)

Oval(1)

 
For Use With

Letter-Size Inserts(11)

N/A(2)

Tabloid-Size Inserts(2)

C-Line Tent Cards(2)

Half-Letter Size Inserts(1)

 
Base Material

Plastic(34)

PVC(11)

Styrene(5)

Metal(4)

PMMA(4)

Acrylic(3)

Aluminum(2)

Rubber(2)

Acrylic/Plastic(2)

Cast Iron(2)

Steel(1)

ABS Plastic(1)

Iron(1)

Lightweight Aluminum(1)

 
Orientation

Landscape(24)

Portrait(22)

Vertical(20)

Landscape; Portrait(12)

Horizontal(8)

Horizontal/Vertical(8)

Portrait; Landscape(1)

Vertical/Horizontal(1)

Horizontal; Vertical(1)

Landscape;Portrait(1)

 
Placement

Desktop(19)

Wall(16)

Floor(15)

Flat Surface(8)

Desktop; Wall(3)

Wall; Flat Surface; Glass(3)

Door; Wall(3)

Door;Wall(3)

Cubicle; Wall(2)

Desktop; Wall; Cubicle(2)

Countertop; Desktop(2)

Fabric Panel(2)

Wall;Flat Surface(2)

Restroom Door(2)

Countertop; Desktop; Table(2)

Metal Surface(2)

Magnetic Surfaces;Wall(1)

Window; Wall(1)

Door;Hallway(1)

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

Cubicle Panel Top(1)

Door;Wall;Window(1)

Glass or Other Non-porous Materials(1)

Indoor/Outdoor(1)

Countertop;Desktop;Table(1)

 
Mounting

Double-Sided Adhesive Tape(15)

Predrilled Holes(6)

Adhesive Backing(5)

Adhesive Pads(5)

Free Standing(4)

Adhesive Tape(4)

Self-Adhesive(3)

Clips;Double Stick Foam Tape(3)

Suction Cups(3)

Countertop(2)

NO(2)

Screws(2)

Screws; Cubicle Clips; Tabletop Support(2)

Magnetic(2)

Double Stick Foam Tape(2)

Stake(2)

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

Ceiling Hardware;Wall Hardware(1)

Torsion Action Pole(1)

Suction Cups for Glass or Acrylic(1)

Hanging Hardware(1)

Punched Hole(1)

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

Clips(1)

Adhesive Tabs; Screws; Panel Pin(1)

Mounting Chain(1)

Adjustable Clamp(1)

Self-Standing L-Shaped(1)

Floor(1)

Magnetic; Self-stick Hook & Loop Tape(1)

Door(1)

 
Message(s)

Customizable(22)

Caution(5)

Exit(3)

No Smoking(2)

Employees Must Wash Hands(2)

No Soliciting(2)

Turn Off Cell Phone(2)

Men(2)

Open(2)

Closed; Open(2)

Employees Only(2)

Gender Neutral(2)

Business Hours(2)

Fire Extinguisher(2)

Women(2)

Men (with Wheelchair)(1)

Restroom (Man/Woman/Wheelchair)(1)

Women (with Wheelchair)(1)

Restroom (Man/Woman)(1)

Come In; Open; Will Return(1)

Danger Keep Out(1)

Visitors Must Sign In(1)

Notice Authorized Personnel Only(1)

Caution Slippery When Wet(1)

Warning Biohazard(1)

OPEN with Business Hours(1)

Danger No Smoking(1)

Danger(1)

Will Return Later(1)

No Smoking/No Fumar(1)

Wash Hands(1)

Wheelchair(1)

Restroom(1)

Caution Wet Floor(1)

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

Private(1)

Employees Must Wash Hands Before Returning to Work(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Closed For Cleaning(1)

Office(1)

 
Maximum Height

12"(8)

11"(8)

8 1/2"(4)

2"(2)

N/A(2)

52 in(1)

13 5/16"(1)

9 7/16"(1)

12 5/8"(1)

59"(1)

3 7/8"(1)

50.20 in(1)

13 in(1)

64 in(1)

26 in(1)

40 in(1)

56 in(1)

73"(1)

11 7/8"(1)

50"(1)

6 3/4"(1)

46 1/2"(1)

4"(1)

9(1)

60"(1)

10 7/8"(1)

8(1)

7 3/4"(1)

8 7/16"(1)

8 3/4"(1)

11 1/4"(1)

7"(1)

 
Write-On/Wipe Off Surface

No(62)

Yes(22)

 
Graphics Color(s)

Silver(10)

White(9)

Gray/White(5)

Black(4)

Assorted(2)

White/Red/Black(2)

Red Glow(2)

Red(2)

N/A(2)

Black; Red; White(1)

Orange/Black(1)

Yellow/Black(1)

White/Blue/Black(1)

Bold Orange; Bold White(1)

Blue; Red(1)

Red/Black/White(1)

Green/White(1)

 
Loading

Side(20)

Top(16)

Front(11)

Hinged Front(6)

Bottom; Side(5)

Front Loading(1)

 
Graphics

International Symbol(12)

OPEN(2)

NO(1)

Arrow(1)

Clock with Movable Hands(1)

n/a(1)

OPEN; Digital Business Hours(1)

Man, Woman & Wheelchair(1)

Slip-and-Fall Wet Floor Image(1)

Danger(1)

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

Man & Woman(1)

Snap-Out Directionals(1)

 
Lettering

Block(19)

Braille(2)

N/A(1)

NO(1)

Black(1)

"Caution Wet Floor"(1)

Green/White(1)

 
Frame Color

Clear(44)

Black(18)

Gray(10)

Silver(9)

Black/Silver(9)

Red(7)

Yellow(5)

Gray/White(5)

White(5)

Silver/Red(3)

Assorted(2)

Silvertone(2)

Brown(2)

Silver/Black(2)

Green/White/Clear(1)

Orange(1)

Blue/White(1)

Black/Red/Blue(1)

Red/Black/Clear(1)

Red/White(1)

White/Red(1)

Blue(1)

Yellow/Black(1)

Green/White(1)

Clear w/Green Tinted Edges(1)

Black Stand / Clear Panels(1)

Fluorescent Yellow/Green(1)

 
Frame Material

Plastic(40)

PVC(11)

PS(9)

Acrylic(6)

PMMA(6)

Aluminum(5)

ABS/PETG(2)

Aluminum; Acrylic(2)

Rigid Heavyweight Plastic(2)

Metal(2)

Wood(2)

Steel(1)

Styrene Plastic(1)

ABS Plastic(1)

Polypropylene(1)

 
Insert Size

8 1/2 x 11(23)

8 1/2" x 11"(12)

11 x 8 1/2(8)

11 x 17(5)

5 x 7(3)

4 x 6(2)

8 1/2 x 2(2)

24 x 36(1)

8 1/2 x 11 - 40(1)

1 1/2 x 2(1)

2 x 10(1)

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

8 x 10(1)

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

24 x 18(1)

11" x 8 1/2"(1)

2" x 3 1/2"(1)

4 1/4" x 11"(1)

4 x 11(1)

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

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

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

14 x 11(1)

 
Face Color(s)

Clear(58)

Black(15)

Gray(5)

Translucent(4)

Silver(3)

Yellow(3)

White(2)

Blue(2)

Brown/Brass(1)

Brown/Steel(1)

Black/Red/Blue(1)

Clear; Frosted(1)

Green/White(1)

Red(1)

Yellow/Black(1)

Red/White(1)

Fluorescent Yellow/Green(1)

Crystal Clear(1)

 
Display

Easel(8)

LED(4)

2-Sides(2)

N/A(1)

NO(1)

 
 
 

© 2019-2020 BonTay, Inc., All Rights Reserved