Top » Catalog » ACCESSORIES » Lift Kits » Yamaha » 6249-3

  2. Jakes 3 Spindle Lift for Yamaha 2007 & Up G29 The DRIVE Gas/Electric
    [6249-3]

    Our Price:  $470.00

    Jakes 3 Spindle Lift for Yamaha 2007 & Up G29 The DRIVE Gas/Electric

    Jake's spindles are the strongest, safest & easiest lift kits to install

    Cast from ductile iron, 3X stronger than gray iron

    Cast design gives superior strength compared to welded spindle kits

    Squares up the cart for added stability

    Lengthens wheelbase for added stability

    No cutting or welding

    Patented design

    Made in the U.S.A.

    Comes with detailed instructions and all necessary hardware

    Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'tntgolfc_oscom.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '24965' and opa.orders_id = opb.orders_id and opb.products_id != '24965' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]