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_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') 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(9)

Lorell(3)

Medline(3)

Health o Meter(3)

Infinite Divider Systems(3)

Genuine Joe(2)

Cottage(2)

Safco(1)

MMF(1)

PhysiciansCare(1)

 
Color

Black(5)

Clear(4)

Gray(3)

Silver(3)

Red(1)

Sand(1)

Slate Blue(1)

Oak(1)

Blue(1)

Translucent(1)

White(1)

 
Recycled

No(14)

Yes(1)

 
Packaged Quantity

1 Each(21)

1(5)

2(1)

12 / Carton(1)

 
Assembly Required

No(18)

Yes(4)

 
Limited Warranty

3 Year(9)

5 Year(3)

Lifetime(1)

 
Weight (Approximate)

5 lb(1)

19 lb(1)

3 lb(1)

120 lb(1)

7 lb(1)

30 lb(1)

16 lb(1)

7.20 lb(1)

 
Compatibility

Hausmann Maximum Value Exam Table

(3)

Safco Uber Series Chair(1)

 
Dimensions

35.50" Diameter(1)

33" Height(1)

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

31" Height(1)

45" Height(1)

 
Number of Casters

4(2)

 
Total Number of Drawers

1(2)

 
Number of Legs

4(1)

 
Table Top Shape

Round(2)

Rectangle(1)

 
Edge Style

Banded(3)

 
Table Top Width

30"(2)

26"(1)

72"(1)

 
Base Included

Yes(4)

No(2)

 
Table Top Thickness

1"(2)

2"(1)

 
Exterior Material

Polypropylene(2)

Polyethylene(1)

 
Base Style

Round(1)

Four Leg(1)

 
Case Style

Box(3)

 
Table Top Length

33"(1)

27"(1)

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

Kilogram(3)

Pound(3)

 
Battery Size Supported

AA(2)

 
Number of Batteries Supported

6(2)

 
Maximum Adjustable Height

35"(1)

79.20"(1)

 
Minimum Adjustable Height

31"(1)

55.20"(1)

 
Maximum Weight Capacity (SI)

220 kg(1)

180 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)

 
Handle-to-Handle Distance

17.32"(1)

 
Manufacturer Part Number

97(1)

59657(1)

91(1)

8728927(1)

4423SP(1)

8728-346(1)

59658(1)

59659(1)

2019065D03(1)

3489NC(1)

MDS86850ES(1)

MDS806150EE(1)

MDS80542(1)

4416SP(1)

4002027BE(1)

T6ID118719(1)

T9ID118725(1)

FIDS118992(1)

CPPS061001(1)

CPPS061000(1)

85121(1)

85121CT(1)

15(1)

3400(1)

500KL(1)

498KL(1)

402KL(1)

90794(1)

 
Country of Origin

United States(17)

China(10)

Taiwan(1)

 
Material

Steel(6)

Acrylic(2)

Steel Pivot(1)

Aluminum Platform(1)

 
Height

30"(2)

17.1"(2)

10"(1)

20.5"(1)

2.2"(1)

16.7"(1)

7"(1)

84.3"(1)

 
Width

14"(2)

16"(2)

12.8"(1)

18"(1)

10.5"(1)

6.8"(1)

19.5"(1)

23.8"(1)

13.5"(1)

9.5"(1)

 
Depth

30"(2)

4.8"(2)

15.5"(1)

3.1"(1)

14"(1)

2.2"(1)

9.5"(1)

1.8"(1)

3.3"(1)

 
Color/Finish

Laminated(2)

Slate Blue(2)

Oak(1)

 
Seat Width

18"(1)

 
Seat Depth

16"(1)

 
Maximum Load Capacity

350 lb(3)

250 lb(1)

600 lb(1)

399.04 lb(1)

 
Length

13.5"(1)

11"(1)

 
Frame Material

Steel(1)

 
Base Material

Powder Coated Steel(1)

Steel(1)

 
Placement

Wall Mountable(2)

 
Height Adjustment

12.50" to 20.50"(1)

55" to 71"(1)

54" to 72" of Table(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)

 
Seat Height

20.50"(1)

 
Number of Characters

2(1)

 
Number of Drawers

5(2)

 
Frame Color/Finish

Walnut(1)

 
 
 

© 2019-2020 Browns Office Centre, All Rights Reserved