facebook
 
 
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_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)

Lorell(3)

DAX(2)

Impact Products(2)

Royal Sovereign(2)

Trend(2)

Buddy(2)

C-Line(1)

Miller's Creek(1)

Scotch(1)

 
Color

Clear(15)

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

 
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)

 
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)

 
Manufacturer Part Number

10077(1)

4118BL(1)

69013(1)

68103(1)

68102(1)

68101(1)

21700(1)

21600(1)

21400(1)

4173BL(1)

4117BL(1)

4248(1)

RSB-1342E(1)

RSB-1340E(1)

995(1)

59660(1)

3655(1)

WL854C(1)

151833(1)

80669(1)

69040(1)

4760(1)

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

49206(1)

906093(1)

10079(1)

96094(1)

N270985HT(1)

41902(1)

122029(1)

122013(1)

122006(1)

6323-4(1)

6323-3(1)

96095(1)

83700(1)

476801(1)

83636(1)

75390(1)

75334(1)

75329(1)

10405(1)

10132(1)

10118(1)

10080(1)

N270985VT(1)

497637(1)

905907(1)

69701(1)

905903(1)

905899(1)

799311CT(1)

26401(1)

899102(1)

879701(1)

879301(1)

799693(1)

693704(1)

497737(1)

69301(1)

692056(1)

69201(1)

69101(1)

68301(1)

68201(1)

66701(1)

590601(1)

558957(1)

W37(1)

 
Country of Origin

China(46)

United States(33)

Canada(4)

Poland(2)

Germany(2)

Taiwan(1)

 
Width

8.5"(10)

10"(8)

8"(7)

9"(5)

11"(5)

12"(3)

3.5"(3)

9.5"(3)

2.8"(3)

6.8"(2)

18"(2)

11.5"(2)

2.88"(2)

4"(2)

16"(1)

6"(1)

9.50"(1)

10.5"(1)

22.5"(1)

2.5"(1)

9.4"(1)

24.4"(1)

15.5"(1)

0.9"(1)

3.3"(1)

8.8"(1)

11.2"(1)

12.9"(1)

5"(1)

9.3"(1)

3"(1)

0.7"(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)

 
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)

 
Shape

Rectangular(32)

Rectangle(3)

30 x Rectangle(2)

L-shaped(2)

Alphabet(1)

36 x Star(1)

Octagonal(1)

Arrow(1)

 
Length

9.50"(2)

 
Sheet Size

9" Width x 11" Length(1)

 
Media Size Supported

13" x 8.50"(1)

 
Orientation

Horizontal(1)

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

 
Skill Learning

Letter Recognition(2)

 
Total Number of Compartments

3(1)

 
Power Source

AC Supply(1)

 
Input Voltage

110 V AC(1)

220 V AC(1)

 
Language

English(9)

Braille(1)

 
Theme/Subject

Learning(2)

 
Mount Type

Magnetic(5)

 
Display Screen Type

LED(2)

 
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)

 
Number of Tiers

3(1)

 
Insert Height

11"(1)

 
Insert Width

8.50"(1)

 
Frame Height

14"(1)

 
Frame Width

9"(1)

 
Printed Design/Pattern/Texture

Dotted(3)

Chevron(2)

Gel Star(1)

 
Print/Message Color

White(2)

Silver(2)

Red(1)

 
Maximum Adjustable Stand Height

60"(1)

 
Product Type

Name Plate(26)

Sign Holder(24)

Information Sign(15)

Indication Sign(10)

Wall Signage Kit(3)

LED Sign(2)

Decorative Magnet(1)

License Plate Holder(1)

Document Frame(1)

Banner Stand(1)

Literature Rack(1)

Desk Signage Kit(1)

File Pocket(1)

Swivel Base(1)

Conference Room Sign(1)

 
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)

2 / Set(1)

 
Assembly Required

No(10)

 
Product Model

59660(1)

RSB-1340E(1)

RSB-1342E(1)

 
Product Line

Classic Image(6)

Write Way(3)

CLICK SIGN(2)

Desk Toppers(2)

Duraframe(1)