Top » Catalog » ACCESSORIES » Lift Kits » Yamaha » 6264

  2. Yamaha Long Travel Lift Kit Yamaha Gas/Electric G2-G9
    [6264]

    Our Price:  $1,048.00

    Adjustable Long Travel Lift for Yamaha G2/G9 Gas/Electric

    The ultimate off-roading lift kit

    Independent front suspension provides the softest and most comfortable ride

    Adjustable height settings

    DOM tubing, same tubing required in auto racing sanctions

    Lengthens and widens wheelbase for superior stability

    Fully adjustable caster/camber

    No cutting or welding

    Built-in 2" receiver hitch

    Patented design

    Made in the U.S.A.

    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 = '24233' and opa.orders_id = opb.orders_id and opb.products_id != '24233' 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]