SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 (`pinfo`.`sku` IN ('SVRCBK','SNIP18','SCT18','S14GVRBK','RBA18','MST18','MPFWHT','MPFRED','MPFPPL','MPFGRN','MPFBLU','MPFB','MPEN3','MPEN','HMCVIP6C2','HECSVRG1','HECPZZL2450','HECPZZL2425','HECPZZL1250','HECPZZL1225','HECMRT3','HECINVBOT','HECHMCVR8','HECHMCMPEN6','HECGRNKIT','HECGLITE','HECEDIBOT30','HECEDIBOT20','HECEDIBOT2','HECEDIBOT10','HECEDIBOT1','HECCQTUBE','HECBRUBOT','HECARRUG','HECANIKIT','HECAIRORG','HEC3DGV6','HEC3DGV12','HEC3DGV','EDIBOTC','DR24MDG','3DGV','STEM4E','STEM4D','STEM3E','STEM3D','STEM2E','STEM2D','STEM1E','STEM1D','STRIPPED SKU','MTT42003','SPR01490','BSN32365','BSN32361','CKC707','LRNLER45761','LEO77120','ACM12975','LEO39100ST','SPR38277','TEPT53105','MTTBJV44','EII7881','MTTDKD47','LRNLER0056','LRNLER6366','TEPT6068','LRNLER6644','MTTW4729','LRNLER0176','LRNLER2831','TEP38913','LRNLER2629','LRNLER0360','LRNLER2202','LRNLER9164','MTTN1387','EII4112','LRNLER2102','LRNLER9209','LRNLER2841','CKC4468','TEPT53101','LRN2821','CDP0768223199','LRN2509','LRN0786','LRN2064','EII5210','MTT42050','LRNLER2774','MTTT5931','LRNLER5052','TEPT53106','LRNLER0930','EII8476','LRNLER2344','LRNLER4335','CDP0768218624','TEPT1670','LRNLER3372','TEPT53103','TCR6434','LRNLER0615','LRNLER9162','CDP0768223202','LRNLER2075','CDP140314','TEP23040','LRNLER0139','LRNLER2834','LRNLER0047','LRNLER2046','LRN2784','LRNLER2690','LRN1207','LRNLER2884','TEP53203','RYLR6085','LRNLER2434','LRN1772','TCR7817','SHS0545015987','LRNLER4963','LRNLER2415','MTT78857','LRNLER2442','TEP6136','RYLR5910','SHS0545015979','LRNLER2420','LRNLER1963','TEPT6071','TEPT6069','LRN0790','LRNLER0264','LRNLER6380','TCR6175','LRN2094','LRNLER1100','LRNLER0306','LRN4429','LRNLER2450','LRN5080','LRNLER0389','SHS0545578140','TEPT6135','LRNLER2427','LRN2830','RYLR5804','LRNLER2394','RYLR5815','TEP6072','CKC95172','TCR7819','RYLR5823','TCR7818','RYLR5911','LRN2822','LRN2783','LRNLER1764','LRNLER2779','LRNLER2430','LRN2833','ASH10066','RYLR5843','RYLR5837','LRN2827','RYLR5842','LRNLER1900','RYLR5914','TCR3025','LRNLER2145','LRNLER1901','CKC4398','TCR7858','TCR7859','TCR3027','RYLR5803','TCR2221','CDP104909','TCR3024','TEP38929','TCR3897','TCR7857','TCR3869','LRNLER2725','TCR3664','CDP104907','TCR7856','CDP104908','CDP104906','CDP104904','CDP104905','LRNLER7734','','','LER0047','LER0056','LER0139','LER0176','LER0264','LER0306','LER0360','LER0389','LER0615','LER0786','LER0790','LER0930','LER1100','LER1207','LER1764','LER1772','LER1900','LER1901','LER1963','LER2046','LER2064','LER2075','LER2094','LER2102','LER2145','LER2202','LER2344','LER2394','LER2415','LER2420','LER2427','LER2430','LER2434','LER2442','LER2450','LER2509','LER2629','LER2690','LER2725','LER2774','LER2779','LER2783','LER2784','LER2821','LER2822','LER2827','LER2830','LER2831','LER2833','LER2834','LER2841','LER2884','LER3372','LER4335','LER4429','LER45761','LER4963','LER5052','LER5080','LER6366','LER6380','LER6644','LER7734','LER9162','LER9164','LER9209','MAT42003','MAT42050','MAT78857','MATBJV44','MATDKD47','MATN1387','MATT5931','MATW4729','ACM12975','ASH10066','BSN32361','BSN32365','CDP0768218624','CDP0768223199','CDP0768223202','CDP104904','CDP104905','CDP104906','CDP104907','CDP104908','CDP104909','CDP140314','CKC4398','CKC4468','CKC707','CKC95172','EII4112','EII5210','EII7881','EII8476','LEO39100ST','LEO77120','RYLR5803','RYLR5804','RYLR5815','RYLR5823','RYLR5837','RYLR5842','RYLR5843','RYLR5910','RYLR5911','RYLR5914','RYLR6085','SHS0545015979','SHS0545015987','SHS0545578140','SPR01490','SPR38277','TCR2221','TCR3024','TCR3025','TCR3027','TCR3664','TCR3869','TCR3897','TCR6175','TCR6434','TCR7817','TCR7818','TCR7819','TCR7856','TCR7857','TCR7858','TCR7859','TEP23040','TEP38913','TEP38929','TEP53203','TEP6072','TEP6136','TEPT1670','TEPT53101','TEPT53103','TEPT53105','TEPT53106','TEPT6068','TEPT6069','TEPT6071','TEPT6135','')) 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_cost`=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 MATCH(`desc_short`) AGAINST ('STEM' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+STEM' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"STEM"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"STEM"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"STEM"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"STEM"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+STEM' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='STEM',`category_4` ='STEM') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'STEM,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('STEM', `pinfo`.`desc_title`)) DESC

Currently Filtered by

STEM

STEM

Refine Search

  GO
Category Filter

Creative Learning(27)

Robot(16)

Magic Pen(9)

Accessories(8)

Camcorders(5)

Flash Cards(5)

Pocket Charts(4)

Puzzles(4)

Instruments(3)

Activity Books & Kits(2)

Counting(2)

Time(2)

Rulers(2)

Magnifiers(2)

Shopping(2)

Math(2)

Classics(2)

Lab Equipment(2)

Energy(1)

Experiments(1)

Games/Manipulatives(1)

Mobile Device Accessories(1)

Blocks & Construction Play(1)

Addition & Subtraction(1)

Magnetism(1)

Astronomy(1)

Animal Studies(1)

Lacing(1)

Teaching Flash Cards(1)

Flashlights(1)

Rugs(1)

Software(1)

Fractions & Decimals(1)

Mats(1)

Thermometers/Probe Covers(1)

Microscopes(1)

Plant Studies(1)

Place Value(1)

Measurement(1)

Brand

HamiltonBuhl(31)

TREND(5)

Learning Resources(3)

Gears!Gears!Gears!(1)

Charles Leonard(1)

Westcott(1)

Color

Multi(24)

White(7)

Black(6)

Blue(3)

Brown(3)

Red(1)

White,Blac(1)

Purple(1)

Orange, bl(1)

Orange(1)

Green(1)

Recycled

No(3)

Height

6"(4)

5 1/2"(1)

Color(s)

Black and White(4)

White(1)

Natural(1)

Width

3"(4)

5 1/2"(1)

Features

Colorful(1)

Global Product Type

Flash Cards-Arithmetic Flash Cards(5)

Rulers-Standard/Metric Rule(2)

Games/Manipulatives-Math Manipulatives(1)

Magnifier Diameter

4.50"(1)

Manufacturer Website Address

www.trendenterprises.com(5)

http://www.learningresources.com(3)

www.learningresources.com(1)

www.charlesleonard.com(1)

www.acmeunited.com(1)

Marketing Information

Lights and action building set takes creativity to a whole new level with bright lights and moving parts to keep your students engaged as they build their creations. Durable plastic gears easily snap together and pull apart with no wrong way to build. Universal design is compatible with all Learning Resources Gears Gears Gears sets (sold separately) for even more imagination and fun. 121-piece set includes a power motor, flashing lights with included battery, glow-in-the-dark stickers, springs, gears and more in a handy storage tub. Battery-operated motor requires three AA batteries (sold separately). Building set is designed for children ages 5 and above.

(1)

STEM classroom bundle features four comprehensive STEM products including the force and motion activity set, simple machines activity set, magnets activity set, and sink or float activity set. Children will have the opportunity to explore the wonders of magnetism and engineering, why things sink and float, all six simple machines, and the science of "how things go" with engaging tools, hands-on activities and experiments. Classroom set provides the perfect introduction to building key science, technology, engineering and math skills. All sets include a comprehensive activity guide with reproducible materials. Classroom bundle is designed for children ages 5 and above.

(1)

Let your students observe items on a grand scale with these plastic magnifiers. Extra-large design is sized perfectly for small hands to help them maintain a secure grip. Flip-out stand on each magnifier provides a hands-free viewing experience. 4.5X magnification is perfect for taking a closer look at critters, rocks, fabrics and more. Magnifiers with plastic lenses are designed for children ages 3 and up.

(1)

Post-Consumer Recycled Content Percent

0%(8)

Post-consumer-waste%

0%(3)

Pre-Consumer Recycled Content Percent

0%(8)

Product Name

Gears Lights/Action Builiding Set(1)

STEM Classroom Bundle(1)

Primary Science Jumbo Magnifiers Set(1)

Recycled Content

0%(3)

Special Features

Fraction Tower Deluxe Activity Set(1)

Total Recycled Content Percent

0%(8)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor Wildcard SSL Certificates

© 2019-2020 United Supply Corp, All Rights Reserved