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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` IN ('Play/Rest Mats','Beds/Cots','Play Tables')) 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 MATCH(`desc_short`) AGAINST ('ClassroomFurniture' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ClassroomFurniture' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ClassroomFurniture"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ClassroomFurniture"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ClassroomFurniture"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ClassroomFurniture"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ClassroomFurniture' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ClassroomFurniture',`category_4` ='ClassroomFurniture') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ClassroomFurniture,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ClassroomFurniture', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Classroom Furniture

Refine Search

  GO
Brand

ECR4KIDS(70)

Rainbow Accents(33)

Children's Factory(19)

Jonti-Craft(10)

young Time(10)

Scholastic(5)

TrueModern(5)

Early Childhood Resources(3)

Learning Resources(1)

Color

Blue(32)

Gray(23)

Red(17)

Baltic(16)

Yellow(6)

Wood Grain(6)

Green(4)

Navy(4)

Black(4)

Purple(4)

Teal(4)

Orange(3)

White(3)

Assorted(3)

Natural Birch(2)

Green - Edgeband(2)

Sand(2)

Multicolor(2)

Red - Pull(2)

Orange - Edgeband(1)

Multi(1)

Gray Laminated(1)

Size

21.75" Width x 48" Length(1)

21.75" Width x 40" Length(1)

Recycled

No(114)

Manufacturer Part Number

0208JCWW004(1)

0208JCWW005(1)

0208JCWW007(1)

0208JCWW003(1)

0208JC(1)

0207JCWW114(1)

0207JCWW119(1)

0207JCWW180(1)

0208JCWW008(1)

0208JCWW112(1)

0209JCWW004(1)

0209JCWW005(1)

0209JCWW007(1)

0209JCWW003(1)

0209JC(1)

0208JCWW114(1)

0208JCWW119(1)

0208JCWW180(1)

0207JCWW112(1)

0207JCWW008(1)

ELR-16126-YE(1)

ELR-16127-GN(1)

ELR-16127-RD(1)

ELR-16126-SD(1)

ELR-16126-RD(1)

ELR-16121(1)

ELR-16122(1)

ELR-16126-GN(1)

ELR-16127-SD(1)

ELR-16127-YE(1)

0207JCWW004(1)

0207JCWW005(1)

0207JCWW007(1)

0207JCWW003(1)

0207JC(1)

ELR-16128-AS(1)

ELR-16129-AS(1)

ELR-16202(1)

0209JCWW008(1)

0209JCWW112(1)

7081YT441(1)

7082YR441(1)

7082YT441(1)

7081YR441(1)

7080YT441(1)

2035JC(1)

2061JC(1)

7080YR441(1)

7083YR441(1)

7083YT441(1)

0545302072(1)

0545302153(1)

054530217X(1)

0545302021(1)

0545301920(1)

7084YR441(1)

7084YT441(1)

LER6651(1)

2030JCWW180(1)

2030JCWW119(1)

1708JC(1)

1709JC(1)

1710JC(1)

1707JC(1)

0473JC(1)

0209JCWW114(1)

0209JCWW119(1)

0209JCWW180(1)

1711JC(1)

2030JC(1)

2030JCWW008(1)

2030JCWW112(1)

2030JCWW114(1)

2030JCWW007(1)

2030JCWW005(1)

2030JCWW003(1)

2030JCWW004(1)

ELR-16120(1)

ELR-16119(1)

ELR-0576(1)

ELR-0649(1)

ELR-0651(1)

ELR-0575(1)

ELR-0574(1)

ELR-024(1)

ELR-028(1)

ELR-031(1)

ELR-12629(1)

ELR-12671-BL(1)

ELR-12675(1)

12693BL(1)

ELR-14807-GBKSS(1)

ELR-12674-RD(1)

ELR-12674-BL(1)

ELR-12671-RD(1)

ELR-12672-BL(1)

ELR-12672-RD(1)

ELR-0234(1)

705558(1)

1134(1)

113524(1)

113824(1)

113324(1)

1132(1)

005002(1)

1130(1)

1131(1)

321290(1)

362120(1)

400513RB(1)

705137PT(1)

705557(1)

400509RB(1)

400503RB(1)

400501(1)

400502RB(1)

ELR-14807-GBKTB(1)

ELR-14807-GBLSS(1)

ELR-14810-MMBKTB(1)

ELR-14810-MMBLTB(1)

ELR-14810-MMNVTB(1)

ELR-14810-MBLTB(1)

ELR-14810-GRDTB(1)

ELR-14810-GBKTB(1)

ELR-14810-GBLTB(1)

ELR-14810-GNVTB(1)

ELR-14810-MMRDTB(1)

ELR-14810-MMSDTB(1)

ELR-16114(1)

ELR-16117(1)

ELR-16118(1)

ELR-16113(1)

ELR-16112-BL(1)

ELR-14810-MNVTB(1)

ELR-14810-MRDTB(1)

ELR-16111-BL(1)

ELR-14807-MRDTB(1)

ELR-14807-MNVTB(1)

ELR-14807-MBBKSS(1)

ELR-14807-MBLS(1)

ELR-14807-MBLTB(1)

ELR-14807-GRDTB(1)

ELR-14807-GRDS(1)

ELR-14807-GBLTB(1)

ELR-14807-GNVSS(1)

ELR-14807-GNVTB(1)

ELR-14807-MMBKSS(1)

ELR-14807-MMBKTB(1)

ELR-14807-MMRDSS(1)

ELR-14807-MMRDTB(1)

ELR-14807-MMSDTB(1)

ELR-14807-MMNVTB(1)

ELR-14807-MMNVSS(1)

ELR-14807-MMBLSS(1)

ELR-14807-MMBLTB(1)

005001(1)

Material

Wood(46)

Vinyl(25)

Polyester(24)

Fabric(20)

Plastic - Corner(16)

Foam(14)

Steel - Pole(12)

Plastic(10)

Anodized Aluminum - Feet(5)

Steel - Frame(4)

Steel(4)

Polyurethane Foam(4)

Birch(3)

Cotton - Sheet(2)

Nylon(2)

Steel - Side(2)

Polyester - Sheet(2)

35% Polyester(2)

65% Cotton(2)

Woven(1)

Polyurethane(1)

Cotton(1)

Base Material

Tubular Steel(17)

Width

20"(33)

52"(10)

23"(5)

24"(4)

18.5"(2)

11"(1)

4"(1)

22"(1)

20.5"(1)

40"(1)

21.5"(1)

58"(1)

30"(1)

Height

27"(20)

5"(17)

35"(10)

23.5"(3)

2"(2)

25"(2)

34.5"(2)

9"(1)

31"(1)

Depth

15"(35)

23"(11)

12.5"(2)

1"(1)

11"(1)

Shape

Rectangle(10)

Square(8)

Rectangular(2)

Length

48"(3)

58"(1)

36"(1)

28.5"(1)

Number of Pieces

60(1)

20(1)

91(1)

Thickness

1.5"(1)

Color/Finish

Blue(5)

Red(2)

White(2)

Yellow(1)

Textured(1)

Assorted(1)

Top Material

Thermofused Melamine (TFM)(17)

Frame Material

Steel(5)

Folded Height

6"(1)

Choking Hazard

Yes(1)

Maximum Load Capacity

50 lb(1)

25 lb(1)

Height Adjustment

8" to 24" of Leg(1)

Folded Width

24"(1)

Frame Color/Finish

Chrome(4)

Country of Origin

United States(75)

Mexico(40)

China(21)

Taiwan(20)

Price Range

$0-$499.99(145)

$500-$999.99(1)

$1000-$1499.99(13)

$1500-$1999.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2018-2019 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved