2023 Yamaha Waverunner Superjet-jet skis sale

2023 Yamaha Waverunner Superjet-jet skis sale
$8,800.00  $5,000.00
Save: 43% off

2023 SEA-DOO GTI 130 jet skis for sale

2023 SEA-DOO GTI 130 jet skis for sale
$9,500.00  $6,400.00
Save: 33% off

2023 Yamaha Waverunner EX DELUXE-jet skis for sale

2023 Yamaha Waverunner EX DELUXE-jet skis for sale
$10,500.00  $5,800.00
Save: 45% off

2023 Sea Doo SPARK TRIXX 3 UP-Jet skis for sale

2023 Sea Doo SPARK TRIXX 3 UP-Jet skis for sale
$88,000.00  $4,200.00
Save: 95% 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 Fish Pro 170-Jet skis for sale

2023 Sea DOO Fish Pro 170-Jet skis for sale
$13,800.00  $9,500.00
Save: 31% 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 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 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 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 SeaDOO RXT-X 300-Jet skis for sale

2023 SeaDOO RXT-X 300-Jet skis for sale
$17,800.00  $10,500.00
Save: 41% off

2023 KAWASAKI Ultra LX-Jet skis for sale

2023 KAWASAKI Ultra LX-Jet skis for sale
$13,800.00  $8,400.00
Save: 39% 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]