SELECT equipments.id,equipments.slug,equipments.model_name,equipments.mpn1,equipments.version, brands.manufacturer_name FROM equipments LEFT JOIN brands ON(equipments.manufacturer_id=brands.id) WHERE 1 AND equipments.is_duplicate = 0 AND ( TRIM(equipments.model_name) IN('Lifestyle Series Recumbent Cycle (R-LS-F) - RB210 - 2020') ) OR TRIM(equipments.mpn1) IN('Lifestyle Series Recumbent Cycle (R-LS-F) - RB210 - 2020') AND TRIM(equipments.manufacturer) = 'Johnson Health Technologies' ORDER BY brands.manufacturer_name ASC
Qty Out Of Stock
Catalog Number: 970839
Provide an email address, and we will notify you as soon as the part is available, you will get a notification if we receive either a new or used condition version of the part you seek.