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('Performance Series Treadmill (T-PS-F) - TM538 - 2020') ) OR TRIM(equipments.mpn1) IN('Performance Series Treadmill (T-PS-F) - TM538 - 2020') AND TRIM(equipments.manufacturer) = 'Johnson Health Technologies' ORDER BY brands.manufacturer_name ASC Known Part References 1000433966 Handlebar Set;;;;TM538;
Phone : 847-309-2818 M-F 10am-5pm
x

Notify

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.