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_26` 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 ('Exam Room Organizers','Exam Stools & Tray Stands','Medical Scales','Exam Tables','Medical Cabinets','Wheelchair','Bath Seats','Toilet Seats','Accessories','Walkers & Crutches')) 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 '%ExamRoomFurnitureandAccessories' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ExamRoomFurnitureandAccessories' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ExamRoomFurnitureandAccessories' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ExamRoomFurnitureandAccessories"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ExamRoomFurnitureandAccessories"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ExamRoomFurnitureandAccessories"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ExamRoomFurnitureandAccessories"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ExamRoomFurnitureandAccessories' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ExamRoomFurnitureandAccessories',`category_4` ='ExamRoomFurnitureandAccessories') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ExamRoomFurnitureandAccessories,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ExamRoomFurnitureandAccessories', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Exam Room Furniture And Accessories

Refine Search

  GO
 
Brand

Hausmann(10)

Infinite Divider Systems(3)

Health o Meter(3)

Lorell(3)

Medline(3)

Cottage(2)

Genuine Joe(2)

PhysiciansCare(1)

MooreCo(1)

MMF(1)

Safco(1)

 
Color

Black(5)

Gray(4)

Clear(4)

Silver(3)

Blue(1)

Wood(1)

Translucent(1)

White(1)

Oak(1)

Slate Blue(1)

Red(1)

Sand(1)

 
Recycled

No(14)

Yes(1)

 
Packaged Quantity

1 Each(22)

1(5)

12 / Carton(1)

2(1)

 
Assembly Required

No(19)

Yes(5)

 
Limited Warranty

3 Year(9)

5 Year(3)

Lifetime(1)

 
Weight (Approximate)

7.20 lb(1)

30 lb(1)

16 lb(1)

7 lb(1)

120 lb(1)

5 lb(1)

19 lb(1)

3 lb(1)

 
Compatibility

Hausmann Maximum Value Exam Table

(3)

Balt Lab Stool(1)

Safco Uber Series Chair(1)

 
Dimensions

45" Height(2)

31" Height(1)

33" Height x 19.50" Width x 17" Depth(1)

33" Height(1)

35.50" Diameter(1)

 
Number of Casters

4(3)

 
Total Number of Drawers

1(2)

 
Number of Legs

4(2)

 
Table Top Shape

Rectangle(2)

Round(2)

 
Edge Style

Banded(3)

 
Table Top Width

30"(3)

72"(1)

26"(1)

 
Base Included

Yes(5)

No(2)

 
Table Top Thickness

1"(2)

2"(1)

 
Exterior Material

Polypropylene(2)

Polyethylene(1)

 
Base Style

Four Leg(2)

Round(1)

 
Case Style

Box(3)

 
Table Top Length

15"(1)

27"(1)

33"(1)

 
Table Top Depth

15"(1)

 
Total Number of Shelves

1(2)

4(1)

 
Diameter

2"(1)

 
Table Top Diameter

35.50"(2)

 
Display Screen Type

LCD(2)

 
Caster Size

6"(1)

 
Measurement Type

Pound(3)

Kilogram(3)

 
Battery Size Supported

AA(2)

 
Number of Batteries Supported

6(2)

 
Maximum Weight Capacity (SI)

180 kg(1)

220 kg(1)

 
Maximum Weight Capacity (Imperial)

500 lb(2)

390 lb(1)

 
Weight Increment (SI)

100 g(1)

 
Weight Increment (Imperial)

3.20 oz(2)

4 oz(1)

 
Manufacturer Part Number

90794(1)

4416SP(1)

2019065D03(1)

MDS86850ES(1)

MDS806150EE(1)

MDS80542(1)

59659(1)

59658(1)

59657(1)

97(1)

91(1)

8728927(1)

8728-346(1)

4423SP(1)

4002027BE(1)

34450(1)

340099(1)

3400(1)

15(1)

500KL(1)

498KL(1)

402KL(1)

85121CT(1)

85121(1)

T9ID118725(1)

T6ID118719(1)

FIDS118992(1)

CPPS061001(1)

CPPS061000(1)

3489NC(1)

 
Country of Origin

United States(17)

China(11)

Taiwan(1)

 
Material

Steel(7)

Acrylic(2)

Veneer(1)

Steel Pivot(1)

Aluminum Platform(1)

 
Height

30"(2)

17.1"(2)

7"(1)

6.3"(1)

16.7"(1)

2.2"(1)

3.3"(1)

84.3"(1)

10"(1)

20.5"(1)

 
Width

16"(2)

14"(2)

12"(1)

19.5"(1)

23.8"(1)

13.5"(1)

6.8"(1)

9.5"(1)

10.5"(1)

12.8"(1)

18"(1)

 
Depth

4.8"(2)

30"(2)

3.3"(1)

9.5"(1)

1.8"(1)

2.2"(1)

14"(1)

15.5"(1)

3.1"(1)

 
Color/Finish

Laminated(2)

Slate Blue(2)

Oak(1)

 
Seat Width

18"(1)

 
Maximum Load Capacity

350 lb(3)

600 lb(1)

399.04 lb(1)

250 lb(1)

 
Length

11"(1)

13.5"(1)

 
Frame Material

Steel(2)

 
Base Material

Steel(1)

Powder Coated Steel(1)

 
Placement

Wall Mountable(2)

 
Height Adjustment

28" to 45"(1)

54" to 72" of Table(1)

55" to 71"(1)

12.50" to 20.50"(1)

 
Closure Type

Snap-tight(2)

 
Power Source

Battery(2)

AC Adapter(1)

 
Top Material

Vinyl(2)

Urethane Foam(1)

 
Number of Dividers

16(2)

10(1)

 
Strength

Heavy Duty(2)

 
Number of Characters

2(1)

 
Number of Drawers

5(2)

 
Frame Color/Finish

Walnut(1)

 
 
 

© 2020-2021 Browns Office Centre, All Rights Reserved