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(25)

deflecto(22)

Durable(15)

COSCO(11)

NuDell(10)

Advantus(9)

Rubbermaid Commercial(7)

Quartet(7)

Universal(6)

People Pointer(4)

C-Line(3)

Identity Group(2)

DAX(2)

Newon(1)

Impact(1)

Tatco(1)

 
Height

9"(18)

12"(12)

11"(9)

3"(7)

2"(7)

10"(4)

8 1/2"(4)

9 1/2"(3)

23 1/2"(2)

25 1/2"(2)

8 3/4"(2)

11 1/4"(2)

7"(2)

13"(2)

6"(2)

4"(2)

20.8"(1)

54"(1)

26 1/10"(1)

44" - 73"(1)

52"(1)

59"(1)

8"(1)

42"(1)

26"(1)

5"(1)

14"(1)

2 1/2"(1)

12 3/8"(1)

4 3/8"(1)

8 1/2(1)

13 in(1)

38"(1)

13 5/16"(1)

5 1/8"(1)

Adjustable 40-60"(1)

10 7/8"(1)

19"(1)

43" - 50"(1)

18"(1)

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

5 1/4(1)

4 1/4"(1)

12 5/8"(1)

9 7/16"(1)

3 7/8"(1)

56"(1)

11 3/16"(1)

8 7/16"(1)

11 3/4"(1)

40"(1)

 
Depth

1/2"(12)

1/8"(7)

3 1/2"(5)

2 5/8"(3)

6/100"(3)

3"(3)

1 1/8"(3)

5/8"(3)

1/4"(3)

3 3/8"(2)

13 1/4"(1)

4 3/4"(1)

1"(1)

1/16"(1)

2 1/2"(1)

1 1/4"(1)

1 in(1)

3 11/16"(1)

3 11/32"(1)

3 13/16"(1)

4 1/2"(1)

0.22"(1)

3/8"(1)

3 7/16"(1)

13"(1)

0.31"(1)

2 3/8"(1)

 
Size

8 1/2" x 11"(14)

6 x 9(12)

8 1/2 x 11(8)

3 x 9(7)

9 x 3(4)

10 x 14(3)

11 x 8 1/2(3)

11 x 17(2)

8 x 12(2)

4 x 13(2)

9 x 2(2)

50 x 1 x 13(2)

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

11" x 8 1/2"(2)

15 x 23 1/2(2)

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

44 to 73(1)

28 1/2 x 42(1)

4 x 6(1)

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

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

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

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

14 3/4 x 40(1)

14 x 11(1)

24 x 18(1)

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

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

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

2 x 10(1)

13 x 5(1)

13 x 14(1)

7 1/2 x 9(1)

13 x 21(1)

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

8" x 10"(1)

13 x 13 1/4 x 26(1)

11 9/10 x 38(1)

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

4" x 6"(1)

1 1/2" x 2"(1)

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

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

4 dia(1)

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

5 x 6(1)

15 x 19(1)

11 x 3 1/2 x 4(1)

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

2" x 3 1/2"(1)

4 1/4" x 11"(1)

8.5 x 3.75(1)

8.5 x 2(1)

9 3/8 x 2(1)

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

8" x 9"(1)

8" x 8"(1)

15 x 46 1/2(1)

15 x 50(1)

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

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

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

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

13" x 13" x 56"(1)

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

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

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

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

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

40" to 60"(1)

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

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

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

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

 
Manufacturer Part Number

1867505(1)

1867507(1)

LCF2418(1)

CF8511(1)

AF32(1)

CF1711(1)

1867508(1)

1867509(1)

76859(1)

76861(1)

07230(1)

9S1600YL(1)

9S0900YEL(1)

9S15 YEL(1)

7923(1)

7922(1)

35485DR(1)

35485SFG(1)

35446(1)

9140(1)

89105(1)

899102(1)

35485Z(1)

37085Z(1)

38020Z(1)

3655(1)

38020(1)

38017Z(1)

38008Z(1)

38011Z(1)

76863(1)

76864(1)

4815(1)

4816(1)

4814(1)

4812(1)

4793(1)

4811(1)

4817(1)

5484(1)

5694(1)

9382(1)

5693(1)

5583(1)

5494(1)

5498(1)

4792(1)

4782(1)

3727(1)

4246(1)

10807(1)

10801(1)

76882(1)

76883(1)

4247(1)

4726(1)

4762(1)

4763(1)

4761(1)

4760(1)

4757(1)

4758(1)

89102(1)

799693(1)

098068(1)

098099(1)

098063(1)

098055(1)

090249(1)

098010(1)

098205(1)

098207(1)

476801(1)

476803(1)

N2709N4T(1)

N270985HT(1)

098208(1)

098211(1)

090244(1)

87537(1)

83701(1)

91096(1)

83700(1)

75390(1)

75329(1)

75334(1)

91097(1)

91098(1)

36911(1)

87507(1)

97080(1)

97079(1)

91099(1)

91100(1)

476823(1)

476901(1)

68201VP(1)

68301(1)

68201(1)

66701(1)

5991790(1)

5991890(1)

68301VP(1)

69101(1)

69701(1)

69701VP(1)

69301(1)

692056(1)

69201(1)

69201VP(1)

590801(1)

590101(1)

4772132(1)

477323(1)

4772131(1)

4772130(1)

477101(1)

477123(1)

4814-23(1)

4815-23(1)

587501(1)

588601(1)

558957(1)

4977-37(1)

491301(1)

75318(1)

 
Country of Origin

CN(79)

US(24)

PL(12)

TW(8)

DE(3)

 
Width

8 1/2"(14)

6"(12)

9"(10)

9 1/2"(10)

11"(8)

15"(5)

3"(4)

8"(4)

13"(4)

4"(3)

14"(3)

5"(2)

10 1/2"(2)

8 3/4"(2)

11 9/10"(1)

7 1/2"(1)

14 7/8"(1)

10 9/10"(1)

28 1/2"(1)

50"(1)

14 3/4"(1)

10"(1)

14 3/8"(1)

1 1/2"(1)

12 1/4"(1)

50 in(1)

11 1/16"(1)

5 1/4(1)

12"(1)

3 1/2"(1)

11 1/6"(1)

9 3/8"(1)

4 3/8"(1)

6 1/2"(1)

6 3/4"(1)

10 1/16"(1)

10 3/8"(1)

8 9/16"(1)

11 1/8"(1)

8.938(1)

10 7/8"(1)

 
Material(s)

Plastic(43)

Molded Plastic(14)

PVC(11)

Styrene Plastic/PS(7)

Metal(5)

Acrylic(5)

Aluminum(5)

Heavy-Duty Plastic(4)

Styrene(3)

Durable Plastic(2)

ABS/PETG/Acrylic/Plastic(2)

PS/Plastic(2)

Styrene Plastic(2)

PMMA(2)

Plastic/Metal(2)

Rigid Heavyweight Plastic(2)

Die-Cut Paper(2)

Alumnium/Acrylic/Cast Iron Base(2)

Polypropylene(1)

Thick Plastic(1)

Lightweight Aluminum(1)

Rugged Polycarbonate(1)

Stainless Steel/Wood/Rubber(1)

PMMA/Iron(1)

ABS Plastic(1)

PMMA/Metal(1)

Brass/Wood/Rubber(1)

Acrylic/Metal(1)

Fabric(1)

 
Shape

Rectangular(78)

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(32)

PVC(11)

Metal(4)

Acrylic(3)

Styrene(3)

Acrylic/Plastic(2)

Aluminum(2)

Rubber(2)

PMMA(2)

Cast Iron(2)

ABS Plastic(1)

Lightweight Aluminum(1)

Iron(1)

 
Orientation

Portrait(20)

Vertical(20)

Landscape(19)

Landscape; Portrait(11)

Horizontal(8)

Horizontal/Vertical(8)

Portrait; Landscape(1)

Horizontal; Vertical(1)

Vertical/Horizontal(1)

 
Placement

Desktop(17)

Wall(16)

Floor(14)

Flat Surface(8)

Door; Wall(3)

Door;Wall(3)

Wall; Flat Surface; Glass(3)

Desktop; Wall; Cubicle(2)

Desktop; Wall(2)

Wall;Flat Surface(2)

Countertop; Desktop; Table(2)

Cubicle; Wall(2)

Countertop; Desktop(2)

Restroom Door(2)

Metal Surface(2)

Fabric Panel(2)

Magnetic Surfaces;Wall(1)

Door;Hallway(1)

Door;Wall;Window(1)

Indoor/Outdoor(1)

Cubicle Panel Top(1)

Glass or Other Non-porous Materials(1)

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

Countertop;Desktop;Table(1)

 
Mounting

Double-Sided Adhesive Tape(14)

Predrilled Holes(6)

Adhesive Backing(5)

Free Standing(4)

Adhesive Tape(4)

Adhesive Pads(4)

Self-Adhesive(3)

Suction Cups(3)

Clips;Double Stick Foam Tape(3)

Screws(2)

NO(2)

Screws; Cubicle Clips; Tabletop Support(2)

Magnetic(2)

Double Stick Foam Tape(2)

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

Torsion Action Pole(1)

Ceiling Hardware;Wall Hardware(1)

Punched Hole(1)

Suction Cups for Glass or Acrylic(1)

Door(1)

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

Mounting Chain(1)

Stake(1)

Adhesive Tabs; Screws; Panel Pin(1)

Adjustable Clamp(1)

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

Self-Standing L-Shaped(1)

Floor(1)

 
Message(s)

Customizable(19)

Caution(5)

No Smoking(2)

Employees Must Wash Hands(2)

Women(2)

Men(2)

Closed; Open(2)

Exit(2)

Open(2)

No Soliciting(2)

Gender Neutral(2)

Fire Extinguisher(2)

Office(1)

Visitors Must Sign In(1)

Come In; Open; Will Return(1)

Private(1)

Warning Biohazard(1)

Restroom (Man/Woman)(1)

Men (with Wheelchair)(1)

Employees Only(1)

Caution Slippery When Wet(1)

Women (with Wheelchair)(1)

Danger No Smoking(1)

Restroom (Man/Woman/Wheelchair)(1)

Closed For Cleaning(1)

No Smoking/No Fumar(1)

Turn Off Cell Phone(1)

Will Return Later(1)

Wash Hands(1)

Wheelchair(1)

Caution Wet Floor(1)

Danger(1)

Business Hours(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Restroom(1)

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

Employees Must Wash Hands Before Returning to Work(1)

 
Maximum Height

11"(8)

12"(8)

8 1/2"(4)

N/A(2)

2"(2)

59"(1)

52 in(1)

3 7/8"(1)

9 7/16"(1)

13 5/16"(1)

50.20 in(1)

13 in(1)

26 in(1)

40 in(1)

12 5/8"(1)

73"(1)

8 7/16"(1)

50"(1)

6 3/4"(1)

46 1/2"(1)

4"(1)

9(1)

60"(1)

10 7/8"(1)

7"(1)

8(1)

8 3/4"(1)

11 1/4"(1)

56 in(1)

 
Write-On/Wipe Off Surface

No(54)

Yes(20)

 
Graphics Color(s)

Silver(9)

White(9)

Gray/White(5)

Black(4)

Red Glow(2)

N/A(2)

Yellow/Black(1)

Orange/Black(1)

Black; Red; White(1)

White/Red/Black(1)

Blue; Red(1)

Green/White(1)

Bold Orange; Bold White(1)

Red/Black/White(1)

Red(1)

 
Loading

Side(18)

Top(15)

Front(11)

Hinged Front(6)

Bottom; Side(5)

Front Loading(1)

 
Graphics

International Symbol(12)

OPEN(2)

n/a(1)

NO(1)

Arrow(1)

Clock with Movable Hands(1)

Snap-Out Directionals(1)

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

Man & Woman(1)

Slip-and-Fall Wet Floor Image(1)

Danger(1)

Man, Woman & Wheelchair(1)

 
Lettering

Block(18)

Braille(2)

N/A(1)

NO(1)

Black(1)

"Caution Wet Floor"(1)

Green/White(1)

 
Frame Color

Clear(41)

Black(18)

Gray(9)

Silver(8)

Black/Silver(8)

Red(5)

Gray/White(5)

Yellow(5)

Silver/Red(3)

White(3)

Brown(2)

Silver/Black(2)

Silvertone(2)

Assorted(2)

Green/White/Clear(1)

Orange(1)

Blue/White(1)

Red/Black/Clear(1)

Red/White(1)

Yellow/Black(1)

Blue(1)

Green/White(1)

Black Stand / Clear Panels(1)

Clear w/Green Tinted Edges(1)

Fluorescent Yellow/Green(1)

 
Frame Material

Plastic(38)

PVC(11)

PS(9)

Acrylic(6)

Aluminum(5)

PMMA(4)

ABS/PETG(2)

Aluminum; Acrylic(2)

Rigid Heavyweight Plastic(2)

Wood(2)

Metal(1)

ABS Plastic(1)

Polypropylene(1)

Styrene Plastic(1)

 
Insert Size

8 1/2 x 11(22)

8 1/2" x 11"(12)

11 x 8 1/2(8)

11 x 17(4)

9" x 2"(2)

4 x 6(2)

8 1/2 x 2(2)

24 x 36(1)

8 1/2 x 11 - 40(1)

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

24 x 18(1)

1 1/2 x 2(1)

2 x 10(1)

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

8 x 10(1)

14 x 11(1)

8.5" x 2"(1)

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

4 1/4" x 11"(1)

2" x 3 1/2"(1)

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

8.5" x 3.75"(1)

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

5 x 7(1)

11" x 8 1/2"(1)

4 x 11(1)

 
Face Color(s)

Clear(55)

Black(14)

Gray(5)

Translucent(4)

Yellow(3)

Silver(3)

White(2)

Blue(2)

Brown/Brass(1)

Brown/Steel(1)

Clear; Frosted(1)

Green/White(1)

Red(1)

Yellow/Black(1)

Red/White(1)

Fluorescent Yellow/Green(1)

Crystal Clear(1)

 
Display

Easel(7)

LED(3)

2-Sides(2)

N/A(1)

NO(1)

 
 
 
 
 

© 2019-2020 Office 8, All Rights Reserved