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 ('20092')) 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

deflecto(16)

Headline Sign(12)

Durable(6)

NuDell(5)

Tarifold, Inc.(4)

People Pointer(3)

Quartet(3)

Advantus(2)

C-Line(2)

DAX(2)

Rubbermaid Commercial(2)

COSCO(1)

Safco(1)

Tatco(1)

Newon(1)

 
Size

8 1/2 x 11(6)

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

3 x 9(3)

9 x 2(2)

6 x 9(2)

11 x 17(2)

15 x 15 x 64(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 x 11(1)

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

44 to 73(1)

15 x 23 1/2(1)

50 x 1 x 13(1)

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

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

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

13 x 5(1)

13 x 14(1)

8 x 12(1)

4 x 13(1)

13 x 21(1)

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

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

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

13" x 13" x 56"(1)

40" to 60"(1)

8.5 x 3.75(1)

9 3/8 x 2(1)

8 1/2" x 11"(1)

4 1/4" x 11"(1)

9 x 3(1)

11 x 8 1/2(1)

15 x 46 1/2(1)

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

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

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

8.5 x 2(1)

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

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

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

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

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

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

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

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

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

7 1/2 x 9(1)

 
Warranty

Manufacturer's limited one-year warranty.(2)

Manufacturer's limited lifetime warranty.(1)

Manufacturer's 10-year warranty.(1)

Manufacturer's limited three-year warranty.(1)

 
Special Features

Classic Image-Loads from the bottom.(3)

Magnetic Back(3)

Slanted Sign Holder(2)

Classic Image-Literature slides in from the side.(2)

Includes pin connector for fabric walls(1)

Superior Image-Loads from the top. Polished rounded edges for safety in handling. Sealed on three sides to protect inserts.(1)

Superior Image(1)

Superior Image-Loads from the top. Rounded, polished edges and sealed on three sides to prevent slipping.(1)

Stand-Up Slanted-Side-loading. Ideal for retailers, restaurants, trade shows and hospitals.(1)

Multi-Surface Wall Mount-Self-stick hook & loop piece mounts to fabric wall; Optional magnet back for mounting to metal surfaces.(1)

Portrait Wall Mount-Pre-drilled holes make mounting easy. Change inserts without removing from wall.(1)

T-Frame Base(1)

Stand-Up Vertical-Free-standing, bottom-load design. Viewable from both directions, front and back.(1)

Multi-Lingual-Imprinted with "Closed for Cleaning" in English and Spanish.(1)

Adhesive Back(1)

 
For Use With

Letter-Size Inserts(3)

C-Line Tent Cards(1)

Tabloid-Size Inserts(1)

Half-Letter Size Inserts(1)

 
Message(s)

Customizable(16)

Employees Only(2)

Exit(2)

Closed; Open(2)

Caution(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Business Hours(1)

Employees Must Wash Hands Before Returning to Work(1)

No Soliciting(1)

Visitors Must Sign In(1)

Fire Extinguisher(1)

Restroom (Man/Woman/Wheelchair)(1)

Open(1)

Come In; Open; Will Return(1)

 
Manufacturer Part Number

75318(1)

P194944(1)

37085Z(1)

38017Z(1)

38020(1)

38020Z(1)

3655(1)

7922(1)

7923(1)

1867507(1)

9S1600YL(1)

4174GR(1)

07230(1)

P194943(1)

P194945(1)

899102(1)

P194993(1)

3727(1)

4246(1)

4247(1)

4726(1)

4758(1)

4760(1)

4763(1)

4792(1)

4793(1)

4811(1)

5583(1)

5694(1)

35485Z(1)

799693(1)

75329(1)

4977-37(1)

75334(1)

75390(1)

83700(1)

36911(1)

87507(1)

098206(1)

N270985HT(1)

N270985VT(1)

476801(1)

476901(1)

481423(1)

491301(1)

558957(1)

69701(1)

590101(1)

590301(1)

590801(1)

5991790(1)

5991890(1)

66701(1)

68201(1)

68301(1)

69101(1)

691590(1)

69201(1)

692056(1)

69301(1)

9382(1)

 
Country of Origin

CN(39)

US(7)

TW(5)

PL(4)

DK(4)

DE(2)

 
Height

11"(5)

0.12"(4)

9"(4)

2"(3)

3"(3)

8 1/2"(2)

12"(2)

9 1/2"(2)

8 3/4"(2)

5"(1)

14"(1)

12 3/8"(1)

12 5/8"(1)

64"(1)

13"(1)

23 1/2"(1)

44" - 73"(1)

59"(1)

52"(1)

13 5/16"(1)

8 7/16"(1)

56"(1)

12 1/8"(1)

7"(1)

2 1/2"(1)

11 1/4"(1)

7 5/16"(1)

10 7/8"(1)

Adjustable 40-60"(1)

5 1/8"(1)

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

18"(1)

4 1/4"(1)

11 3/4"(1)

4"(1)

25 1/2"(1)

 
Width

9"(6)

8 1/2"(6)

10 1/4"(4)

11"(3)

15"(3)

13"(3)

9 1/2"(2)

6"(2)

8 5/8"(1)

10 1/2"(1)

14 3/8"(1)

12 1/4"(1)

50"(1)

10 7/8"(1)

10 1/16"(1)

8 9/16"(1)

11 1/16"(1)

5"(1)

11 1/8"(1)

8 3/4"(1)

5.438(1)

8.938(1)

6 3/4"(1)

6 1/2"(1)

12"(1)

3"(1)

11 1/6"(1)

9 3/8"(1)

7 1/2"(1)

 
Depth

14 1/2"(4)

1/8"(3)

3 1/2"(3)

1/2"(3)

2 5/8"(2)

2 1/2"(2)

3 3/8"(2)

4 1/2"(1)

3 13/16"(1)

3 11/32"(1)

1/4"(1)

5/8"(1)

2 1/16"(1)

13"(1)

1/16"(1)

1"(1)

15"(1)

1 1/4"(1)

3/8"(1)

 
Material(s)

Plastic(11)

Styrene Plastic/PS(6)

Molded Plastic(5)

PVC(4)

Acrylic(3)

Heavy-Duty Plastic(3)

PVC/Magnetic Material(3)

Styrene Plastic(2)

Durable Plastic(2)

Metal(2)

PS/Plastic(2)

PMMA(2)

Fabric(1)

Rugged Polycarbonate(1)

Steel(1)

Aluminum(1)

Brass/Wood/Rubber(1)

PMMA/ABS(1)

Plastic/Metal(1)

PMMA/Metal(1)

PMMA/Iron(1)

Acrylic/Metal(1)

ABS Plastic(1)

Alumnium/Acrylic/Cast Iron Base(1)

Rigid Heavyweight Plastic(1)

Polypropylene(1)

Lightweight Aluminum(1)

Thick Plastic(1)

 
Shape

Rectangular(41)

Rectangle(2)

Radius Corner Rectangular(2)

 
Frame Color

Clear(26)

Black(11)

Gray(5)

Black/Silver(4)

Silver(3)

Red/White(2)

Red(2)

Black Stand / Clear Panels(1)

Clear w/Green Tinted Edges(1)

Brown(1)

Yellow(1)

White(1)

Yellow/Black(1)

Green/White(1)

Blue/White(1)

 
Frame Material

Plastic(12)

PS(8)

PMMA(5)

Acrylic(4)

PVC(3)

Polypropylene(1)

Rigid Heavyweight Plastic(1)

Aluminum; Acrylic(1)

ABS Plastic(1)

Styrene Plastic(1)

Aluminum(1)

Metal(1)

Wood(1)

Steel(1)

 
Base Material

Plastic(12)

Metal(4)

PVC(3)

PMMA(2)

Lightweight Aluminum(1)

Cast Iron(1)

ABS Plastic(1)

ABS(1)

Iron(1)

Acrylic(1)

Aluminum(1)

Rubber(1)

Steel(1)

 
Placement

Desktop(14)

Floor(8)

Wall; Flat Surface; Glass(3)

Wall(3)

Any Metal Surface(3)

Fabric Panel(2)

Door;Wall(2)

Flat Surface(2)

Countertop; Desktop(2)

Wall;Flat Surface(2)

Cubicle Panel Top(1)

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

Glass or Other Non-porous Materials(1)

Magnetic Surfaces;Wall(1)

Non Porous Clean Surface(1)

 
Orientation

Portrait(16)

Landscape(9)

Landscape; Portrait(7)

Portrait; Landscape(4)

Horizontal(3)

Vertical(2)

Horizontal; Vertical(1)

Landscape;Portrait(1)

 
Mounting

Double-Sided Adhesive Tape(5)

Suction Cups(3)

Self-Adhesive(3)

Any Metal Surface(3)

Predrilled Holes(2)

Clips;Double Stick Foam Tape(2)

Torsion Action Pole(1)

Suction Cups for Glass or Acrylic(1)

Non Porous Clean Surface(1)

Ceiling Hardware;Wall Hardware(1)

Adjustable Clamp(1)

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

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

Adhesive Tabs; Screws; Panel Pin(1)

Adhesive Pads(1)

Free Standing(1)

Adhesive Tape(1)

Punched Hole(1)

 
Insert Size

8 1/2 x 11(22)

11 x 8 1/2(5)

11 x 17(3)

9" x 2"(2)

5 x 7(2)

8.5" x 2"(1)

8.5" x 3.75"(1)

8 1/2" x 11"(1)

4 1/4" x 11"(1)

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

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

14 x 11(1)

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

8 1/2 x 11 - 40(1)

 
Display

Easel(3)

2-Sides(2)

LED(2)

 
Maximum Height

11"(4)

8 1/2"(2)

7"(2)

73"(1)

59"(1)

52 in(1)

13 5/16"(1)

12 5/8"(1)

56 in(1)

8 7/16"(1)

12 1/8"(1)

8 3/4"(1)

11 1/4"(1)

10 7/8"(1)

60"(1)

6 3/4"(1)

46 1/2"(1)

64 in(1)

 
Face Color(s)

Clear(36)

Black(6)

Translucent(3)

White(2)

Crystal Clear(1)

Brown/Brass(1)

 
Write-On/Wipe Off Surface

No(24)

Yes(16)

 
Graphics Color(s)

Silver(5)

Red/White Striped Border(2)

White(2)

Red Glow(2)

Black(1)

Red(1)

Yellow/Black Striped Border(1)

Green/White Striped Border(1)

Bold Orange; Bold White(1)

Black; Red; White(1)

 
Graphics

Bi-Color Frame(4)

International Symbol(3)

Snap-Out Directionals(1)

Arrow(1)

OPEN(1)

Clock with Movable Hands(1)

 
Lettering

Block(4)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved