Control Module Gentex Corp.

Sort by:

Sorting

Best Selling

On Sale

Color

Red (1)

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products AS p INNER JOIN products_to_groups pg ON pg.products_id = p.products_id AND pg.group_code = 'G' LEFT JOIN products_to_products_extra_fields AS p2pef ON p2pef.products_id = p.products_id LEFT JOIN products_extra_fields AS pef ON p2pef.products_extra_fields_id = pef.products_extra_fields_id AND pef.products_extra_fields_status = 1 AND pef.products_extra_fields_facet = 1 AND pef.languages_id IN (0, 1) INNER JOIN products_to_categories AS ptc ON ptc.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id AND pd.language_id = 1 left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on (s.products_id = p.products_id and s.status = 1) LEFT JOIN ( SELECT DISTINCT products_id, 1 AS is_featured_match FROM featured WHERE status = 1 AND featured_group_id = 6 ) feat ON feat.products_id = p.products_id WHERE p.is_active = 1 AND ptc.categories_id = '208' AND p.manufacturers_id = '4988' group by p.products_id ORDER BY CASE WHEN feat.is_featured_match = 1 THEN 0 ELSE 1 END, p.products_sort_order, p.products_date_available DESC, p.products_last_views DESC, pd.products_name

1 items

Gentex Corp. AVSM-R Red Synchronization Control Module
# AVSM-R

Gentex Corp.

1 items

Control Module Gentex Corp.

Sorting

Category

Color

About Us

Customer Care

Our Policies

How do you want to process the order?
Pickup from Local Warehouse Ship from Miami via UPS

Language:
English Spanish
Don't show again