SELECT p.product_id, (SELECT AVG(rating) AS total FROM mm_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM mm_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM mm_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM mm_product_to_category p2c LEFT JOIN mm_product p ON (p2c.product_id = p.product_id) LEFT JOIN mm_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN mm_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '2966' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 ADC Diagnostic Wall Sets
  • Your shopping cart is empty!

ADC Diagnostic Wall Sets

ADC Diagnostic Wall Sets 

Product Compare (0)
ADC Adstation 3.5v Wall Ophthalmoscope

ADC Adstation 3.5v Wall Ophthalmoscope

Product Code: 5612

Complete instrument includes your choice of our 3.5v Coax or Coax PLUS Ophthalmoscope head and wall ..

Price:  $449.99
ADC Adstation 3.5v Wall Otoscope

ADC Adstation 3.5v Wall Otoscope

Product Code: 5611

This complete 3.5v Otoscope instrument includes a 3.5v Otoscope head and wall transformer power supp..

Price:  $394.99
ADC Adstation Diagnostic Wall Set with Clock Aneroid

ADC Adstation Diagnostic Wall Set with Clock Aneroid

Product Code: 5610xx-7

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $651.56
ADC Adstation Diagnostic Wall Set with DermaScope

ADC Adstation Diagnostic Wall Set with DermaScope

Product Code: 5610xx-5

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $778.64
ADC Adstation Diagnostic Wall Set with DermaScope and Clock Aneroid

ADC Adstation Diagnostic Wall Set with DermaScope and Clock Aneroid

Product Code: 5610xx-57

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $879.10
ADC Adstation Diagnostic Wall Set with DermaScope and Clock Aneroid plus Specula Dispenser

ADC Adstation Diagnostic Wall Set with DermaScope and Clock Aneroid plus Specula Dispenser

Product Code: 5610xx-357

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $896.15
ADC Adstation Diagnostic Wall Set with Dermascope and Specula Dispenser

ADC Adstation Diagnostic Wall Set with Dermascope and Specula Dispenser

Product Code: 5610xx-35

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $790.41
ADC Adstation Diagnostic Wall Set with DermaScope and Throat Illuminator

ADC Adstation Diagnostic Wall Set with DermaScope and Throat Illuminator

Product Code: 5610xx-56

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $852.59
ADC Adstation Diagnostic Wall Set with DermaScope and Throat Illuminator plus Specula Dispenser

ADC Adstation Diagnostic Wall Set with DermaScope and Throat Illuminator plus Specula Dispenser

Product Code: 5610xx-356

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $868.25
ADC Adstation Diagnostic Wall Set with Specula Dispenser

ADC Adstation Diagnostic Wall Set with Specula Dispenser

Product Code: 5610xx-3

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $550.89
ADC Adstation Diagnostic Wall Set with Specula Dispenser and Clock Aneroid

ADC Adstation Diagnostic Wall Set with Specula Dispenser and Clock Aneroid

Product Code: 5610xx-37

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $656.63
ADC Adstation Diagnostic Wall Set with Throat Illuminator

ADC Adstation Diagnostic Wall Set with Throat Illuminator

Product Code: 5610xx-6

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $625.05
ADC Adstation Diagnostic Wall Set with Throat Illuminator and Clock Aneroid

ADC Adstation Diagnostic Wall Set with Throat Illuminator and Clock Aneroid

Product Code: 5610xx-67

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $725.50
ADC Adstation Diagnostic Wall Set with Throat Illuminator and Clock Aneroid plus Specula Dispenser

ADC Adstation Diagnostic Wall Set with Throat Illuminator and Clock Aneroid plus Specula Dispenser

Product Code: 5610xx-367

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $734.48
ADC Adstation Diagnostic Wall Set with Throat Illuminator and Specula Dispenser

ADC Adstation Diagnostic Wall Set with Throat Illuminator and Specula Dispenser

Product Code: 5610xx-36

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $628.73
ADC Adstation Otoscope Ophthalmoscope Diagnostic Wall Set

ADC Adstation Otoscope Ophthalmoscope Diagnostic Wall Set

Product Code: 5610

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $599.99
Showing 1 to 16 of 16 (1 Pages)