SELECT p.products_model, p.sub_products_type, pd.products_name, m.manufacturers_name, pd.products_quantity as products_quantity , p.products_image, p.products_weight,pd.products_url,pd.is_new_window,p.customer_id,pd.outofstock_status,pd.free_shipping,p.is_kit, p.products_id, p.manufacturers_id, p.is_variant, p.variant_parent_id, p.products_parent_id, pd.products_price, p.passover, p.passover_only, p.products_tax_class_id,pd.min_buy_qty,pd.purchase_in,pd.purchase_in_unit,pd.products_blurb,pd.min_case_pack,pd.video_types,pd.video_embeded_code,pd.products_grp_permission,p.products_weight,pd.products_deafult_category_id,p.products_model, IF(pd.special_status, pd.special_price, NULL) as specials_new_products_price, IF(pd.special_status, pd.special_price, pd.products_price) as final_price FROM products p LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c WHERE p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.web_id='1' and pd.enable_in_site=1 and (pd.products_group_access like "%,G,%" or pd.products_group_access like "G,%" or pd.products_group_access like "%,G" or pd.products_group_access = "G") and pd.language_id = 1 and p2c.categories_id = 315 and pd.products_quantity >= IF(pd.min_buy_qty > 1,pd.min_buy_qty, 1) and p.products_carrot != 1 and (IF(p.sub_products_type != 'Parent', pd.products_price > 0, 1) OR IF(p.sub_products_type != 'Parent Product', pd.products_price > 0, 1) ) ORDER BY p.products_model, pd.products_name 99-06 Electra & Street Glide

har2.png

99-06 Electra & Street Glide

1999-2006 Electra & Street Glide

  2. Home
  3. Harley Davidson
  4. TOURING
  5. 99-06 Electra & Street Glide

Copyright © 2025 - Riley's Motorcycle Parts All Rights Reserved Powered By: NetzCart eCommerce