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_16` 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_name` IN ('Signs & Sign Holders','Nameplates')) 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 '%SignsandNameplates' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('SignsandNameplates' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+SignsandNameplates' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"SignsandNameplates"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"SignsandNameplates"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"SignsandNameplates"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"SignsandNameplates"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+SignsandNameplates' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='SignsandNameplates',`category_4` ='SignsandNameplates') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'SignsandNameplates,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('SignsandNameplates', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Signs And Nameplates

Refine Search

  GO
 
Brand

Xstamper(14)

Deflecto(14)

HeadLine(9)

Advantus(7)

Tatco(6)

Ashley(6)

DURABLE(4)

Mighty Badge(4)

Quartet(3)

Safco(3)

Carson-Dellosa(3)

Trend(3)

Lorell(3)

DAX(2)

Impact Products(2)

Royal Sovereign(2)

Buddy(2)

C-Line(1)

Miller's Creek(1)

Scotch(1)

 
Color

Black(16)

Clear(15)

Multicolor(6)

Silver(6)

White(5)

Red(5)

Clear Frame(4)

Gold(4)

Black Base(3)

Graphite(3)

Clear Background(3)

White Print(3)

Blue(2)

Clear Front(2)

Black Frame(2)

Red Background(2)

Black Background(2)

Blue Background(2)

White Lettering(1)

Assorted(1)

Fluorescent Yellow(1)

Fluorescent Green(1)

Black Back(1)

Fluorescent Pink(1)

Black Edge(1)

Red Lettering(1)

Black Panel(1)

Yellow(1)

Black Plastic(1)

Tinted Edges(1)

Panel(1)

Gray(1)

Frame(1)

 
Recycled

No(70)

Yes(2)

 
Packaged Quantity

1 Each(59)

50 / Pack(6)

36 / Pack(5)

1 / Each(5)

1 Pack(4)

6 / Kit(3)

10 / Pack(2)

12 / Pack(1)

6 / Box(1)

2 / Pack(1)

5 / Carton(1)

106 / Pack(1)

2 / Set(1)

 
Assembly Required

No(11)

 
Limited Warranty

Lifetime(3)

90 Day(2)

1 Year(2)

 
Weight (Approximate)

1.44 oz(14)

10.72 oz(3)

11 lb(2)

1.50 lb(2)

14 lb(2)

12 oz(2)

12.64 oz(1)

4.64 oz(1)

11.68 oz(1)

10.40 oz(1)

0.48 oz(1)

3.20 oz(1)

2.16 lb(1)

12 lb(1)

2.80 lb(1)

5 lb(1)

10 lb(1)

3.52 lb(1)

1 lb(1)

 
Media Size Supported

13" x 8.50"(1)

 
Skill Learning

Letter Recognition(2)

 
Total Number of Compartments

3(1)

 
Input Voltage

110 V AC(1)

220 V AC(1)

 
Theme/Subject

Learning(2)

 
Language

English(9)

Braille(1)

 
Mount Type

Magnetic(5)

 
Print/Message

Open(3)

Will Return(2)

Fire Extinguisher(2)

No Smoking(2)

Please Call Again(2)

Open/Closed(1)

Please Order Here(1)

NO FOOD OR DRINKS(1)

CLOSED(1)

Exit(1)

Employees Only(1)

Women(1)

Men(1)

Business Hour(1)

Occupied(1)

Please Wait To Be Seated(1)

Section Closed(1)

Please Seat Yourself(1)

Smoking Permitted In This Area Only(1)

Smoking In Designated Areas Only(1)

Caution Wet Floor(1)

Please Watch Your Step(1)

Authorized Personnel Only(1)

Welcome Please Register(1)

Meeting In Progress(1)

SDS(1)

Come in, we're open(1)

No Soliciting(1)

 
Display Screen Type

LED(2)

 
Frame Width

9"(1)

 
Frame Height

14"(1)

 
Printed Design/Pattern/Texture

Dotted(3)

Chevron(2)

Gel Star(1)

 
Maximum Adjustable Stand Height

60"(1)

 
Print/Message Color

White(2)

Silver(2)

Red(1)

 
Holding Height

11"(4)

1.38"(2)

14.50"(2)

 
Holding Width

8.50"(3)

8.25"(2)

11"(2)

14"(1)

 
Manufacturer Part Number

10077(1)

4173BL(1)

69040(1)

69013(1)

68103(1)

68102(1)

68101(1)

21700(1)

21600(1)

21400(1)

4118BL(1)

4248(1)

4117BL(1)

RSB-1342E(1)

RSB-1340E(1)

995(1)

59660(1)

3655(1)

WL854C(1)

151833(1)

79411(1)

4760(1)

49206(1)

K32(1)

W36(1)

W35(1)

W32(1)

W31(1)

W30(1)

K37(1)

K36(1)

K35(1)

K31(1)

4792(1)

K30(1)

K02(1)

K01(1)

9435(1)

9434(1)

9432(1)

9395(1)

5694(1)

4793(1)

80669(1)

49205(1)

10079(1)

96095(1)

N270985VT(1)

N270985HT(1)

41902(1)

122029(1)

122013(1)

122006(1)

6323-4(1)

6323-3(1)

96094(1)

497637(1)

83700(1)

83636(1)

75390(1)

75334(1)

75329(1)

10405(1)

10132(1)

10118(1)

10080(1)

476801(1)

497737(1)

906093(1)

799693(1)

905907(1)

905903(1)

905899(1)

799311CT(1)

26401(1)

899102(1)

879701(1)

879301(1)

69701(1)

558957(1)

693704(1)

69301(1)

692056(1)

69201(1)

69101(1)

68301(1)

68201(1)

66701(1)

590601(1)

W37(1)

 
Country of Origin

China(46)

United States(34)

Canada(4)

Poland(2)

Germany(2)

Taiwan(1)

 
Material

Plastic(24)

Aluminum(12)

Steel(6)

Acrylic(4)

Foam(2)

Acrylic Frame(2)

Plastic Cover(1)

Aluminum Base(1)

Vinyl(1)

Metal Frame(1)

Plastic Panel(1)

Metal(1)

Melamine(1)

 
Height

2"(16)

11"(8)

8.5"(6)

3"(5)

2.5"(4)

12"(4)

5.5"(3)

65"(2)

6"(2)

0.31"(2)

2.9"(2)

14"(2)

64.3"(1)

2.25"(1)

2.88"(1)

9"(1)

13.4"(1)

8"(1)

13"(1)

24"(1)

13.3"(1)

14.3"(1)

59"(1)

52"(1)

16.8"(1)

2.7"(1)

56"(1)

7"(1)

5.1"(1)

1.9"(1)

4"(1)

25.5"(1)

 
Width

8.5"(10)

10"(8)

8"(7)

11"(5)

9"(5)

9.5"(3)

2.8"(3)

3.5"(3)

12"(3)

4"(2)

2.88"(2)

6.8"(2)

11.5"(2)

18"(2)

16"(1)

2.5"(1)

10.5"(1)

6"(1)

9.50"(1)

22.5"(1)

3"(1)

24.4"(1)

15.5"(1)

0.9"(1)

8.8"(1)

12.9"(1)

5"(1)

9.4"(1)

3.3"(1)

9.3"(1)

11.2"(1)

 
Depth

0.6"(4)

48"(2)

2.5"(2)

18"(2)

12.9"(1)

6.9"(1)

3.8"(1)

1"(1)

14"(1)

2.8"(1)

2"(1)

25"(1)

 
Sheet Size

9" Width x 11" Length(1)

 
Shape

Rectangular(32)

Rectangle(3)

30 x Rectangle(2)

L-shaped(2)

Alphabet(1)

36 x Star(1)

Octagonal(1)

Arrow(1)

66 x Uppercase Letters(1)

13 x Numbers(1)

19 x Punctuation Marks(1)

7 x Spanish Accent Mark(1)

 
Length

9.50"(2)

7"(1)

 
Placement

Wall Mountable(19)

Desktop(17)

Countertop(10)

Door-mountable(7)

Hanging(7)

Glass-mountable(5)

Floor Standing(4)

Window-mountable(4)

Cubicle-mountable(2)

Self Sticking(1)

Counter(1)

Wall(1)

Wood-mountable(1)

Door(1)

 
Orientation

Horizontal(1)

Vertical(1)

 
Power Source

AC Supply(1)

 
Number of Tiers

3(1)

 
Insert Width

8.50"(1)

 
Insert Height

11"(1)