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 = '353' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 Summit Dopplers
  • Your shopping cart is empty!

Summit Dopplers

Welcome to the Summit Dopplers Department of the Mohawk Medical Mall Dopplers Store!
Product Compare (0)
Summit LifeDop 300 ABI Hand-Held Doppler

Summit LifeDop 300 ABI Hand-Held Doppler

Product Code: L300AC

Economical Hand-Held Doppler System with Faster ABI Calculation and Waveform Printout Perform the..

Price:  $3,356.91
Summit Lifedop ABI Label Paper Pk5

Summit Lifedop ABI Label Paper Pk5

Product Code: K180

A box of 5 rolls of adhesive-backed label paper for L250AB and L250AC (¡Ö30 waveforms per roll)...

Price:  $71.44
Summit Lifedop Doppler Probe for L150 L250 Systems

Summit Lifedop Doppler Probe for L150 L250 Systems

Product Code: SDx

Probes Description: 2 MHz Obstetrical Probe optimized for deep penetration 2W MHz Waterproof Ob..

Price:  $272.35
Summit LifeDop L250 ABI Doppler System

Summit LifeDop L250 ABI Doppler System

Product Code: L250AB

L250AB - LifeDop ABI Reimbursable Vascular System The LifeDop ABI system features a portable bi-..

Price:  $2,851.54
Summit Lifedop L250 Doppler with Digital Display

Summit Lifedop L250 Doppler with Digital Display

Product Code: L250

The L250 features a display unit with superior sound quality, extended battery life, enhanced probe ..

Price:  $942.35
Summit LifeDop L450VA Vista ABI Doppler System

Summit LifeDop L450VA Vista ABI Doppler System

Product Code: L450VA

L450VA - Vista ABI (Automated ABI System) The Vista ABI is a full-featured ABI system designed t..

Price:  $6,495.29
Summit Lifedop L500VA Vista AVS Doppler System

Summit Lifedop L500VA Vista AVS Doppler System

Product Code: L500VA

Vista AVS Model L500VA-(Version 2.0)Advanced Vascular System The Vista AVS is a full-featured AB..

Price:  $11,040.35
Showing 1 to 7 of 7 (1 Pages)