2023 Sea DOO GTR 230-Jet skis for sale

2023 Sea DOO GTR 230-Jet skis for sale
$11,800.00  $8,000.00
Save: 32% 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 YAMAHA WAVERUNNER FX HO-jet skis for sale

2023 YAMAHA WAVERUNNER FX HO-jet skis for sale
$14,800.00  $90,000.00
Save: -508% 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 Yamaha VX Cruiser-jet skis for sale

2023 Yamaha VX Cruiser-jet skis for sale
$11,800.00  $6,800.00
Save: 42% off

2023 Yamaha Waverunner FX Cruiser SVHO-jet skis for sale

2023 Yamaha Waverunner FX Cruiser SVHO-jet skis for sale
$17,800.00  $10,500.00
Save: 41% off

2023 Yamaha Waverunner EX Sport-jet skis for sale

2023 Yamaha Waverunner EX Sport-jet skis for sale
$8,800.00  $4,800.00
Save: 45% off

2023 Sea DOO GTI SE 170-Jet skis for sale

2023 Sea DOO GTI SE 170-Jet skis for sale
$11,800.00  $6,600.00
Save: 44% 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 GP 1800R SVHO-jet skis for sale

2023 Yamaha GP 1800R SVHO-jet skis for sale
$14,800.00  $9,000.00
Save: 39% 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 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]