2023 Yamaha Cruiser FX HO sale- Waverunner jet skis

2023 Yamaha Cruiser FX HO sale- Waverunner jet skis
$14,000.00  $9,000.00
Save: 36% off

2023 Sea DOO WAKE 170-Jet skis for sale

2023 Sea DOO WAKE 170-Jet skis for sale
$13,000.00  $8,200.00
Save: 37% off

2023 SeaDOO GTI SE 130-Jet skis for sale

2023 SeaDOO GTI SE 130-Jet skis for sale
$9,000.00  $6,600.00
Save: 27% off

2023 Sea Doo SPARK 2 UP ROTAX 900 ACE 90-Jet skis sale

2023 Sea Doo SPARK 2 UP ROTAX 900 ACE 90-Jet skis sale
$5,400.00  $3,600.00
Save: 33% off

2023 KAWASAKI Ultra 310X-Jet skis for sale

2023 KAWASAKI Ultra 310X-Jet skis for sale
$19,800.00  $12,000.00
Save: 39% off

2023 SeaDoo TRIXX 3UP-Jet skis for sale

2023 SeaDoo TRIXX 3UP-Jet skis for sale
$7,800.00  $4,300.00
Save: 45% off

2023 SeaDOO GTX LIMITED 300-Jet skis for sale

2023 SeaDOO GTX LIMITED 300-Jet skis for sale
$17,800.00  $11,000.00
Save: 38% off

2023 SEA-DOO GTX 170 jet skis sale

2023 SEA-DOO GTX 170 jet skis sale
$12,500.00  $8,000.00
Save: 36% off

2023 KAWASAKI Ultra 310LX-Jet skis for sale

2023 KAWASAKI Ultra 310LX-Jet skis for sale
$17,800.00  $12,000.00
Save: 33% off

2023 SEA-DOO GTX 230 jet skis for sale

2023 SEA-DOO GTX 230 jet skis for sale
$13,500.00  $9,800.00
Save: 27% off

2023 Yamaha FX Limited SVHO-jet skis for sale

2023 Yamaha FX Limited SVHO-jet skis for sale
$16,000.00  $11,000.00
Save: 31% off

2023 Yamaha VX CRUISER HO-jet skis for sale

$11,800.00  $7,900.00
Save: 33% off

Add to Cart:


 ENGINE TYPE  Longitudinal In-Line

CYLINDERS  4
ENGINE STROKE  4-Stroke
DISPLACEMENT (CC/CI)  1812 / 110.6
CARBURETION TYPE  Fuel Injected
STEERING:  
STEERING ASSIST SYSTEM  Yes
TECHNICAL SPECIFICATIONS:  
LENGTH (FT)  11
WIDTH (IN/MM)  48 / 1219.2
HEIGHT (IN/MM)  47 / 1193.8
DRY WEIGHT (LBS/KG)  767 / 347.9
FUEL CAPACITY (GAL/L)  18.5 / 70
STORAGE CAPACITY (CUFT/GAL/L)  3.8 / 24.6 / 108.4
SEATS:  
NUMBER OF SEATS  3
EXTERIOR:  
BODY MATERIAL  NanoXcel™
HULL MATERIAL  NanoXcel™
HULL TYPE  Progressive Stepped V
SPONSONS  Standard
BOARDING STEP  Standard
INSTRUMENTATION:  
DIGITAL INSTRUMENTATION  Standard
CONVENIENCE:  
BILGE SYSTEM TYPE  Automatic Siphon
STORAGE:  
UNDERSEAT STORAGE  Standard
GLOVE BOX / DASH STORAGE  Standard
FRONT STORAGE WELL  Standard
GLASS:  
REARVIEW MIRRORS  Standard

  • Model: 314
  • 48 Units in Stock


1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'yamaha_motor.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '497' and opa.orders_id = opb.orders_id and opb.products_id != '497' 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]