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

Currently Filtered by

Category

Classroom Decorations

Refine Search

  GO
 
Brand

TREND(33)

Carson-Dellosa Publishing(24)

Smart-Fab(22)

Pacon(14)

Chartpak(13)

Scholastic(9)

Identity Group(3)

Teacher Created Resources(2)

Baumgartens(1)

 
Height

40 ft.(15)

48"(14)

31"(7)

22"(7)

3"(5)

7.88"(5)

18"(4)

6 1/4"(3)

12"(3)

1"(3)

2"(3)

6"(2)

0.05"(2)

4"(2)

0.06"(1)

1 1/2"(1)

3/4"(1)

1/2"(1)

1/4"(1)

5"(1)

24 1/2"(1)

5 1/2"(1)

24"(1)

2 7/8"(1)

17 1/2"(1)

23"(1)

8 1/2"(1)

26 1/2"(1)

 
Color(s)

Assorted(18)

Black/Purple/White(3)

White(3)

Black(3)

Blue/Clear(2)

Blue;Green;Orange;Red;Violet;Yellow(2)

Multi(1)

Red(1)

Green; Yellow; Red; Blue; Purple(1)

Yellow(1)

Cranberry(1)

Dark Pink(1)

Orange(1)

Dark Purple(1)

Apple Green(1)

Grass Green(1)

Sky Blue(1)

Dark Blue(1)

Blue(1)

Cream(1)

Brown(1)

Blue; Green; Red; Yellow(1)

 
Manufacturer Part Number

22018(1)

0439492815(1)

T10662(1)

T10660(1)

8341(1)

8305(1)

4757(1)

4114(1)

SC553562(1)

SC553125(1)

SC553079(1)

SC553078(1)

SC553072(1)

0545417449(1)

0439152917(1)

T10664(1)

0439152852(1)

23812184599(1)

23812184520(1)

23812184510(1)

238121827099(1)

23809124520(1)

23809124510(1)

238091227099(1)

1U384804070(1)

1U384804065(1)

1U384804064(1)

1U384804061(1)

T10663(1)

T10996(1)

1U384804056(1)

T8302(1)

6147(1)

6146(1)

T8393(1)

T8392(1)

T8391(1)

T8390(1)

T8364(1)

T8363(1)

T8360(1)

T8350(1)

T8306(1)

T8304(1)

T8299(1)

T10998(1)

T8219(1)

T8201(1)

T8182(1)

T8176(1)

T8173(1)

T8156(1)

T8096(1)

T8077(1)

T69912(1)

T38964(1)

T38963(1)

T38934(1)

T38913(1)

1U384804060(1)

1U384804050(1)

110014(1)

119004(1)

01020(1)

01010(1)

01000(1)

CD-5652(1)

CD-5638(1)

144156(1)

144154(1)

122013(1)

122012(1)

122006(1)

119017(1)

119005(1)

119003(1)

01040(1)

119001(1)

119000(1)

110232(1)

110205(1)

110202(1)

110199(1)

110143(1)

110142(1)

110119(1)

110115(1)

110114(1)

110079(1)

01030(1)

01050(1)

1U384804043(1)

56465(1)

1U384804042(1)

1U384804041(1)

1U384804040(1)

1U384804031(1)

1U384804030(1)

1U384804020(1)

1U384804010(1)

78930(1)

78920(1)

78840(1)

56525(1)

56475(1)

56385(1)

01070(1)

56225(1)

0057705(1)

0057425(1)

0057405(1)

0056255(1)

0055855(1)

0055805(1)

01198(1)

01193(1)

01184(1)

01175(1)

01170(1)

01130(1)

6148(1)

 
Country of Origin

US(86)

IL(22)

CN(12)

TW(1)

 
Width

48"(15)

50 ft(11)

18 1/4"(8)

17"(7)

6"(5)

9 1/2"(4)

18"(4)

12"(4)

9"(3)

3 1/2"(3)

72"(3)

17 1/2"(1)

5 1/2"(1)

30 ft(1)

6 1/4"(1)

41"(1)

30"(1)

12 3/4"(1)

 
Material(s)

Vinyl(13)

Polypropylene(3)

 
Theme

Black(3)

Assorted Colors(3)

Sea Buddies(3)

White(3)

Blue/Clear(2)

Jingle Jungle Animals(2)

BoHo Birds(2)

Stars(2)

Monkey Mischief(2)

Alphabet(2)

Polka Dots(1)

Pennants(1)

Bold Strokes Arrows(1)

Pencils(1)

Monkey Mischief, Birthday(1)

Sea Buddies, Happy Birthday(1)

Black & White Stripes(1)

Paw Prints(1)

My Name(1)

Our Bully Free Classroom(1)

Number Line(1)

My Food Plate(1)

Our Birthday Graph!(1)

Extra, Extra, Read All About Me(1)

Read All About Me(1)

Owl-Stars!(1)

Weather Extremes(1)

The Human Body(1)

Owl Stars!(1)

Bold Strokes(1)

Phrases(1)

Calendar(1)

Owl Stars Alphabet Line(1)

Owl-Stars Calendar(1)

Owl-Stars Job Chart(1)

Happy Birthday Bake Shop(1)

Monthly Calendar(1)

Place Values(1)

Life Cycles(1)

Giraffe Growth.(1)

USDA's MyPyramid(1)

Fractions(1)

"Year Around" Calendar(1)

Busy Bees(1)

Sock Monkeys(1)

Furry Friends Classroom Basics(1)

Cranberry(1)

Yellow(1)

Apple Green(1)

Dark Pink(1)

Grade 1(1)

Chic Chevron Yellow(1)

Math(1)

Language Arts(1)

Monkeys(1)

Colors and Shapes(1)

Numbers 0-30(1)

Grade 3(1)

Kindergarten(1)

Tropical Foliage(1)

FUNky Frog Calendar(1)

Measure Man(1)

Shooting Stars & Rainbow Bursts(1)

Rocket Ship(1)

Photographic Welcome(1)

Morning Meetings -Kindergarten(1)

Morning Meeting Solution for Grades 1-2(1)

Weather Frog(1)

Classic Moroccan Black(1)

Classic Dots Red(1)

Orange(1)

Brown(1)

Red(1)

The Writing Process(1)

Grass Green(1)

Dark Purple(1)

Sky Blue(1)

Dark Blue(1)

Blue(1)

Cream(1)

African Safari(1)

Classic Dots Aqua(1)

Insects(1)

Rain Forest(1)

Under the Sea(1)

Brick(1)

Clouds(1)

Winter Time(1)

Night Sky(1)

Chic Chevron Pink(1)

Celebration Signs(1)

 
Choking Hazard

Warning 1(8)

No(7)

 
Character Color

Black(15)

White(1)

 
Mounting Type

Self Adhesive(16)

 
Character Types

Letters;Numbers(7)

Numbers(4)

Uppercase Letters(3)

Letters;Numbers;Symbols(2)

 
Character Style

Helvetica(13)

Hobo(3)

 
 
 

© 2020-2021 Horizon Business Products, All Rights Reserved