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_2` 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','out_of_stock') 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

Accuform(35)

Headline Sign(28)

deflecto(23)

Durable(20)

COSCO(14)

Advantus(9)

NuDell(8)

Universal(6)

Quartet(5)

Rubbermaid Commercial(5)

Tabbies(5)

People Pointer(4)

C-Line(3)

Impact(2)

Identity Group(2)

DAX(1)

Safco(1)

Tatco(1)

Newon(1)

 
Height

12"(29)

9"(18)

10"(12)

17"(12)

3"(8)

11"(8)

2"(7)

14"(6)

9.5"(5)

7"(4)

8.5"(3)

18"(3)

40"(2)

8 3/4"(2)

11 1/4"(2)

25 1/2"(2)

4"(2)

13"(2)

19"(2)

6"(2)

8"(2)

8 1/2"(1)

54"(1)

52"(1)

59"(1)

42"(1)

20.8"(1)

13 in(1)

26 1/10"(1)

23 1/2"(1)

38"(1)

64"(1)

12 3/8"(1)

5"(1)

4 3/8"(1)

13.31"(1)

11.75"(1)

40.5" - 46.5"(1)

3 7/8"(1)

9 7/16"(1)

12 5/8"(1)

4.25"(1)

56"(1)

11.19"(1)

5 1/4(1)

2.5"(1)

10.88"(1)

Adjustable 40-60"(1)

5 1/8"(1)

43" - 50"(1)

8.44"(1)

 
Depth

0.03"(22)

0.06"(14)

1/2"(13)

6/100"(5)

3.5"(4)

5/8"(3)

1.13"(3)

0.13"(3)

2.63"(3)

3"(3)

0.008"(3)

1"(2)

1/4"(2)

1/8"(2)

1 1/4"(1)

2 1/2"(1)

15"(1)

1 in(1)

12.7"(1)

4.75"(1)

0.63"(1)

2 3/8"(1)

3 7/16"(1)

3 3/8"(1)

13"(1)

0.31"(1)

0.38"(1)

0.22"(1)

0.25"(1)

3 11/32"(1)

3 13/16"(1)

4.5"(1)

3.38"(1)

3.69"(1)

 
Size

8.5 x 11(17)

12" dia(12)

6 x 9(12)

10 x 14(10)

17" dia(9)

3 x 9(8)

9.5 x 12(4)

9 x 3(4)

7 x 10(4)

12 x 18(3)

11 x 8.5(3)

10 x 7(2)

14 x 10(2)

12 x 12(2)

14.75 x 40(2)

4 x 6(2)

11 x 17(2)

6.5 x 9.5(2)

17 x 17(2)

9 x 2(2)

50 x 1 x 13(2)

15 x 19(2)

8 x 12(2)

4 x 13(2)

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

10.88" x 0.06" x 13.31"(1)

13 x 21(1)

13 x 14(1)

13 x 5(1)

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

2 x 10(1)

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

8 x 10(1)

1.5 x 2(1)

8 1/2 x 11(1)

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

11 9/10 x 38(1)

14 x 11(1)

8.5 x 11; 11 x 17(1)

28.5 x 42(1)

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

24 x 18(1)

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

15 x 23 1/2(1)

15 x 15 x 64(1)

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

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

5 x 3.5 x 7(1)

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

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

11 x 8 1/2(1)

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

6 x 17(1)

12 x 8(1)

5 x 6(1)

4 dia(1)

2 x 3.5(1)

15 x 50(1)

4.25 x 11(1)

8" x 9"(1)

8" x 8"(1)

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

9 3/8 x 2(1)

8.75 x 4(1)

15 x 46.5(1)

5.5 x 8.5(1)

8.56 x 2.63 x 11(1)

11.13" x 2.63" x 8.44"(1)

11 x 3.5 x 8.5(1)

13" x 13" x 56"(1)

8.5 x 3.5 x 11(1)

8.5 x 2(1)

11 x 0.38 x 9.5(1)

8.5 x 0.25 x 12(1)

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

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

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

8.5 x 4.5 x 11(1)

8.94 x 3.38 x 10.78(1)

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

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

3" x 1" x 4"(1)

40" to 60"(1)

7 1/2 x 9(1)

 
Manufacturer Part Number

75318(1)

38020Z(1)

35446(1)

35485Z(1)

37085Z(1)

38008Z(1)

38011Z(1)

38017Z(1)

38020(1)

3655(1)

9140(1)

7922(1)

AF32(1)

CF1711(1)

LCF2418(1)

1867505(1)

1867507(1)

1867509(1)

9S15 YEL(1)

9140PU(1)

MGNG909VPESP(1)

4174GR(1)

MGNF542VPESP(1)

MFS427ESP(1)

MFS428ESP(1)

MFS429ESP(1)

MFS464ESP(1)

MFS465ESP(1)

MFS466ESP(1)

MFS467ESP(1)

MGNF540VPESP(1)

MGNF544VPESP(1)

MGNG908VPESP(1)

MGNF546VPESP(1)

MGNF547VPESP(1)

MGNF549VPESP(1)

MGNG901VPESP(1)

MGNG903VPESP(1)

MGNG905VPESP(1)

MGNG906VPESP(1)

MGNG907VPESP(1)

9S1600YL(1)

29201(1)

MFS425ESP(1)

4816(1)

4763(1)

4782(1)

4792(1)

4793(1)

4811(1)

4812(1)

4814(1)

4815(1)

4817(1)

4761(1)

5484(1)

5491(1)

5492(1)

5494(1)

5498(1)

5583(1)

5693(1)

5694(1)

4762(1)

4760(1)

29203(1)

76882(1)

29507(1)

29512(1)

29513(1)

07230(1)

76859(1)

76861(1)

76863(1)

76864(1)

76883(1)

4759(1)

10801(1)

10807(1)

3727(1)

4246(1)

4247(1)

4726(1)

4757(1)

4758(1)

MFS426ESP(1)

MFS424ESP(1)

75329(1)

400023(1)

098072(1)

098099(1)

098205(1)

098206(1)

098207(1)

098208(1)

N270985HT(1)

400123(1)

098063(1)

400423(1)

472101(1)

472123(1)

476801(1)

476803(1)

476823(1)

476901(1)

477101(1)

098068(1)

098056(1)

4772130(1)

91100(1)

75334(1)

75390(1)

83700(1)

83701(1)

91096(1)

91097(1)

91098(1)

91099(1)

97079(1)

098055(1)

97080(1)

36911(1)

87507(1)

87537(1)

090244(1)

090249(1)

098010(1)

098052(1)

477123(1)

4772131(1)

MFS423ESP(1)

MFS347ESP(1)

69301(1)

69701(1)

69701VP(1)

799693(1)

89102(1)

89105(1)

899102(1)

MFS345ESP(1)

MFS380ESP(1)

69201VP(1)

MFS382ESP(1)

MFS384ESP(1)

MFS386ESP(1)

MFS388ESP(1)

MFS390ESP(1)

MFS420ESP(1)

MFS421ESP(1)

MFS422ESP(1)

692056(1)

69201(1)

4772132(1)

588601(1)

477323(1)

481423(1)

481523(1)

491301(1)

4977-37(1)

558957(1)

20007(1)

587501(1)

590101(1)

69101(1)

590801(1)

5991790(1)

5991890(1)

66701(1)

68201(1)

68201VP(1)

68301(1)

68301VP(1)

9382(1)

 
Country of Origin

CN(80)

US(65)

PL(17)

TW(8)

DE(3)

 
Width

12"(18)

6"(13)

9.5"(12)

9"(11)

17"(11)

10"(8)

8.5"(8)

14"(7)

11"(6)

15"(6)

3"(5)

8 1/2"(5)

7"(4)

8"(4)

13"(3)

4"(3)

6.5"(3)

10 1/2"(2)

5"(2)

14.75"(2)

50"(1)

14 3/8"(1)

50 in(1)

11 9/10"(1)

12 1/4"(1)

10 9/10"(1)

14 7/8"(1)

28.5"(1)

1.5"(1)

8 3/4"(1)

11.13"(1)

10.88"(1)

10 3/8"(1)

10 1/16"(1)

8.56"(1)

8.75"(1)

11 1/16"(1)

8.94"(1)

6 3/4"(1)

18"(1)

5 1/4(1)

3.5"(1)

11.7"(1)

4 3/8"(1)

9 3/8"(1)

7 1/2"(1)

 
Material(s)

Plastic(57)

Slip-Gard Adhesive Vinyl(22)

PVC(16)

Molded Plastic(15)

Styrene Plastic/PS(7)

Styrene(5)

Vinyl(5)

Heavy-Duty Plastic(4)

Metal(4)

Aluminum(4)

Acrylic(3)

Plastic/Metal(3)

Durable Plastic(2)

ABS/PETG/Acrylic/Plastic(2)

Styrene Plastic(2)

PMMA(2)

PS/Plastic(2)

Rigid Heavyweight Plastic(2)

Die-Cut Paper(2)

Alumnium/Acrylic/Cast Iron Base(2)

Lightweight Aluminum(1)

Polypropylene(1)

Rugged Polycarbonate(1)

Fabric(1)

Steel(1)

Brass/Wood/Rubber(1)

ABS Plastic(1)

Acrylic/Metal(1)

Plastic/Steel(1)

PMMA/Metal(1)

PMMA/Iron(1)

Thick Plastic(1)

 
Shape

Rectangular(85)

Circle(19)

Rectangle(18)

Radius Corner Rectangular(7)

Round(3)

Square(2)

Arrow(2)

Octagon(2)

Oval(1)

Pyramid(1)

Arrow; Rectangle(1)

 
For Use With

Letter-Size Inserts(13)

Tabloid-Size Inserts(3)

C-Line Tent Cards(2)

Half Letter-Size Inserts(2)

N/A(2)

Half-Letter Size Inserts(1)

 
Base Material

Plastic(32)

PVC(16)

Styrene(5)

Metal(3)

Removable Acrylic Pressure Sensitive Adhesive(3)

Cast Iron(2)

PMMA(2)

Acrylic/Plastic(2)

Aluminum(2)

Lightweight Aluminum(1)

ABS Plastic(1)

Iron(1)

Acrylic(1)

Rubber(1)

Steel(1)

 
Orientation

Portrait(51)

Landscape(24)

Vertical(19)

Landscape; Portrait(16)

Horizontal/Vertical(8)

Horizontal(7)

Horizontal; Vertical(1)

Landscape;Portrait(1)

Vertical/Horizontal(1)

Portrait; Landscape(1)

 
Placement

Floor(38)

Wall(29)

Desktop(17)

Flat Surface(8)

Metal Surface(5)

Door;Wall(3)

Wall; Flat Surface; Glass(3)

Door; Wall(3)

Fabric Panel(2)

Desktop; Wall; Cubicle(2)

Cubicle; Wall(2)

Desktop; Wall(2)

Wall;Flat Surface(2)

Glass(2)

Restroom Door(2)

Cubicle Panel Top(1)

Countertop; Desktop(1)

Door;Wall;Window(1)

Glass or Other Non-porous Materials(1)

Indoor/Outdoor(1)

Outdoor(1)

Countertop;Desktop;Table(1)

Magnetic Surfaces;Wall(1)

Door;Hallway(1)

Floor; Wall(1)

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

 
Mounting

Self-Adhesive(25)

Double-Sided Adhesive Tape(15)

Corner Holes(13)

Predrilled Holes(6)

Pressure Sensitive Adhesive(5)

Magnetic(5)

Adhesive Backing(5)

Free Standing(4)

Adhesive Pads(4)

Adhesive Tape(4)

Clips;Double Stick Foam Tape(3)

Suction Cups(3)

Stake(2)

Static Cling(2)

Double Stick Foam Tape(2)

NO(2)

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

Screws(2)

Screws; Cubicle Clips; Tabletop Support(2)

Suction Cups for Glass or Acrylic(1)

Ceiling Hardware;Wall Hardware(1)

Adjustable Clamp(1)

Torsion Action Pole(1)

Door(1)

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

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

Clips(1)

Adhesive Tabs; Screws; Panel Pin(1)

Mounting Chain(1)

Punched Hole(1)

 
Message(s)

Customizable(20)

Thank You For Practicing Social Distancing Please Keep At Least 6 Ft Apart(10)

Social Distance Maintain 6 Ft(10)

Caution(3)

Exit(3)

Men(2)

Closed; Open(2)

Women(2)

Attention for the Safety and Health of Our Patients and Staff this Facility Practices Social Distancing Please Maintain Distance Between Yourself and Others We Appreciate Your Cooperation!(2)

Attention for the Safety and Health of Our Customers and Employees this Facility Practices Social Distancing Please Maintain Distance Between Yourself and Others We Appreciate Your Cooperation!(2)

Wrong Way Do Not Enter(2)

One Way Aisle(2)

Stop Here Maintain 6 Ft(2)

Keep Your Distance Maintain 6 Ft(2)

Safety First for the Safety and Health of Our Customers and Employees this Business Practices Social Distancing We Are Committed to a Safe Workplace and Regularly Disinfect to Maintain a Healthy and Clean Environment(2)

No Soliciting(2)

Employees Only(2)

Employees Must Wash Hands(2)

Open(2)

Business Hours(2)

Fire Extinguisher(2)

No Smoking(2)

Gender Neutral(2)

Restroom (Man/Woman)(1)

Private(1)

Office(1)

Visitors Must Sign In(1)

Restroom (Man/Woman/Wheelchair)(1)

Danger Keep Out(1)

Women (with Wheelchair)(1)

Men (with Wheelchair)(1)

Danger No Smoking(1)

Employees Must Wash Hands Before Returning to Work(1)

Notice Authorized Personnel Only(1)

Caution Slippery When Wet(1)

Warning Biohazard(1)

Turn Off Cell Phone(1)

"Follow The Arrows For Your Safety"(1)

Restroom(1)

"Be Safe"; "Stand 6 Ft Apart"(1)

"Leave Some Space"; "Stay At Arms Length"; "Be Safe"(1)

"New Traffic Pattern For Your Safety"; "Please Follow The Signs"(1)

"Stay 6 Feet Apart"; "Be Safe"(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Closed For Cleaning(1)

Wheelchair(1)

Curbside Pickup Here(1)

Caution Wet Floor(1)

Wash Hands(1)

Attention for the Safety and Health of Our Visitors and Employees this Facility Practices Social Distancing Please Maintain Distance Between Yourself and Others We Appreciate Your Cooperation!(1)

Will Return Later(1)

No Smoking/No Fumar(1)

Come In; Open; Will Return(1)

 
Maximum Height

12"(10)

11"(8)

8.5"(3)

2"(2)

N/A(2)

9.5"(2)

40 in(1)

50.2"(1)

56 in(1)

52"(1)

13 in(1)

64 in(1)

13.31"(1)

3 7/8"(1)

9 7/16"(1)

12 5/8"(1)

59"(1)

8(1)

7"(1)

9(1)

8 3/4"(1)

11 1/4"(1)

10.88"(1)

60"(1)

6 3/4"(1)

50"(1)

46.5"(1)

18"(1)

8 1/2"(1)

8.44"(1)

 
Write-On/Wipe Off Surface

No(103)

Yes(20)

 
Graphics Color(s)

Black(13)

Black/Red(13)

White(11)

Silver(10)

Gray/White(5)

White/Red/Black(2)

Red Glow(2)

N/A(2)

White/Gray(2)

Red(1)

Gray/Brown(1)

Bold Orange; Bold White(1)

White/Blue(1)

Blue; Red(1)

White/Blue/Black(1)

Yellow/Black(1)

Orange/Black(1)

Black; Red; White(1)

 
Loading

Front(16)

Top(15)

Side(15)

Hinged Front(5)

Bottom; Side(5)

Front Loading(1)

 
Graphics

Human and Arrows(13)

International Symbol(10)

Footprint and Arrows(4)

OPEN(2)

X(2)

3 Humans and Arrows(2)

2 Humans and Arrows(2)

Man, Woman & Wheelchair(1)

Snap-Out Directionals(1)

Arrow(1)

NO(1)

n/a(1)

Bag(1)

Boy/Girl(1)

Elephants(1)

Arrows(1)

Man & Woman(1)

Slip-and-Fall Wet Floor Image(1)

Clock with Movable Hands(1)

 
Lettering

Block(17)

Black, Swiss721(16)

White, Swiss721(12)

Black/White, Swiss721(7)

Braille(2)

White/Gray(2)

"Caution Wet Floor"(1)

Curbside Pickup Here(1)

Black/Blue(1)

White/Black(1)

White(1)

N/A(1)

NO(1)

 
Frame Color

Clear(41)

Black(19)

Silver(12)

Gray(10)

Black/Silver(9)

Red(7)

Gray/White(5)

White(5)

Yellow(4)

Silver/Black(2)

Silver/Red(2)

Assorted(2)

Brown(1)

Orange(1)

Silvertone(1)

Fluorescent Green(1)

Fluorescent Yellow/Green(1)

Green/White(1)

Clear w/Green Tinted Edges(1)

Black Stand / Clear Panels(1)

Red/White(1)

Yellow/Black(1)

White/Red(1)

Blue(1)

Blue/White(1)

 
Frame Material

Plastic(37)

PVC(16)

PS(9)

Acrylic(4)

PMMA(4)

Aluminum(4)

Rigid Heavyweight Plastic(2)

Aluminum; Acrylic(2)

ABS/PETG(2)

Polypropylene(1)

ABS Plastic(1)

Styrene Plastic(1)

Wood(1)

Steel(1)

 
Insert Size

8.5 x 11(29)

11 x 8.5(6)

11 x 17(6)

8 1/2 x 11(5)

5.5 x 8.5(3)

4 x 6(2)

8 1/2 x 2(2)

5 x 7(2)

9 x 2(2)

11 x 8 1/2(2)

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

2 x 3.5(1)

8.5 x 2(1)

4.25 x 11(1)

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

8.5 x 3.75(1)

14 x 11(1)

8.5 x 11; 11 x 17(1)

24 x 36(1)

24 x 18(1)

1.5 x 2(1)

8 x 10(1)

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

2 x 10(1)

 
Face Color(s)

Clear(51)

Black(16)

White(8)

Red/White(8)

Silver(7)

Blue(6)

Orange(6)

Gray(5)

Red(5)

Translucent(4)

Yellow(4)

White/Blue(3)

Green/White(3)

Blue/White(2)

White/Gray(2)

Green(2)

Yellow/Black(1)

Fluorescent Yellow/Green(1)

Fluorescent Green(1)

Crystal Clear(1)

Clear; Frosted(1)

Brown/Brass(1)

 
Display

Easel(8)

LED(3)

2-Sides(1)

N/A(1)

NO(1)

 
 
 

© 2020-2021 ISEOP, All Rights Reserved