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

Currently Filtered by

Category

Early Learning Furniture

Refine Search

  GO
Brand

Jonti-Craft(50)

Color

Birch(22)

White(14)

Green(3)

Birch; Blue; Green; Red; Yellow(3)

Blue(2)

Clear(2)

Red(1)

Yellow(1)

Flannel(1)

Natural Birch(1)

Overall Width

48"(18)

8.63"(6)

20"(4)

24"(4)

24.5"(4)

30"(2)

37"(2)

42"(2)

36"(2)

57"(2)

42.5"(1)

19.5"(1)

25.5"(1)

12"(1)

Overall Depth

15"(24)

13.5"(7)

28.5"(3)

16"(2)

29"(2)

23"(2)

24"(1)

20"(1)

22.5"(1)

19.5"(1)

11.5"(1)

9"(1)

16.5"(1)

Country of Origin

US(50)

Material(s)

KYDZStrong Construction(21)

Russian Baltic Birch(6)

Birch(4)

Plywood(3)

Edge Detail Profile

KYDZSafe Edge(29)

Fully Rounded Top; KYDZSafe Edge(1)

Shelf Count

1(8)

2(4)

3(2)

4(2)

5(1)

Shelf Type

Fixed(4)

Stationary(4)

Adjustable(3)

Storage(2)

1 Fixed; 2 Adjustable(1)

Compartment Quantity

1(4)

25(2)

10(2)

2(2)

20(2)

30(2)

8(1)

6(1)

16(1)

3(1)

5(1)

Shelf Depth

15"(4)

13.5"(3)

13.75"(3)

1"(1)

19.5"(1)

1.5"(1)

Shelf Width

48"(6)

18.38"(4)

25.5"(1)

Overall Height

29.5"(8)

35.5"(8)

5.25"(6)

20"(5)

24.5"(4)

24"(3)

27.5"(2)

30"(2)

27"(2)

72"(1)

13.5"(1)

18.5"(1)

9.5"(1)

45"(1)

25"(1)

33.5"(1)

35"(1)

24 1/2"(1)

Compartment Depth

14"(6)

15"(4)

13.75"(3)

13.5"(3)

10"(2)

Compartment Width

8.75"(6)

18.38"(4)

48"(3)

14.5"(3)

11.25"(2)

Compartment Height

5.5"(6)

9.5"(5)

8.25"(2)

11.13"(1)

12"(1)

Open Width

48"(7)

20"(4)

8 ft(3)

24"(3)

42.5"(1)

25.5"(1)

36"(1)

Series Name

Jonti-Craft(4)

Special Features

Trays(6)

Without Trays(3)

Toddler(2)

Low(2)

Super-Sized(2)

See-Thru Sensory Table-Ultimate splash control with 9" deep clear acrylic tub. Matching see-thru acrylic activity cover. Four locking casters.(2)

With Colored Trays-Red, blue, yellow, green and orange.(2)

Pick-a-Book Stand with Flush Back-Fully rounded top. Five display shelves, approximately 1" deep. Stores flush against walls. No storage in back.(1)

Six-Section(1)

Pick-a-Book Stand-Plenty of display area with four shelves. Approximate 1" shelf depth. Write-n-Wipe back features added storage below.(1)

Microwave-Kitchen helpers can pretend to use this microwave to heat up meals in a hurry.(1)

Whiteboard(1)

Super-Sized Single Mobile Storage Unit-For general purpose use. 48w x 35 1/2h.(1)

Eight-Section(1)

Clear Acrylic(1)

Super-Sized Fold-n-Lock-Solve the worst storage problems with this super-sized storage unit. Each section is 48w x 35 1/2h.(1)

Low Single Mobile Storage Unit-Designed with smaller children in mind. 48w x 29 1/2h.(1)

Toddler Fold-n-Lock-Storage at a toddler's height. Each wing is 48w x 24 1/2h.(1)

Toddler Single Mobile Storage Unit-Perfect for nursery and daycare use. 48w x 24 1/2h.(1)

Low Fold-n-Lock-Generous shelf space at a youngster's height. Each section is 48w x 29 1/2h.(1)

With Colored Tray-Red, blue, yellow, green and orange.(1)

Green Chalkboard(1)

Toddler Pick-a-Book Stand-Beginner books at a toddler's height. Three Shelves approximately 1 1/2" deep. Added storage below slotted shelves. Write-n-Wipe back.(1)

Flannel Easel(1)

White Magnetic Write-n-Wipe Easel(1)

White Write-n-Wipe Easel(1)

Chalkboard(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved