Search Keyword

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 0) as Price FROM jos_boat_boatdetails as i left join jos_boat_images as b on ' at line 1 SQL=SELECT i.*, "EUR" as NewPriceCurrency,b.BoatID,b.ImageURL,b.ImageRanking,b.ImageTitle , round((i.Price*), 0) as Price FROM jos_boat_boatdetails as i left join jos_boat_images as b on i.id=b.BoatID where i.published=1 and i.id=6075195

  •  0 exc Vat  
  • 1 / 18
    Year: 
    Location: 

    Overview

    Description


    General Information

    • Year Built:
    • Hull Material:
    • Builder:
    • Designer:

    Technical Info

    Measurements

    • Length: m
    • Beam:
    • Max Draft: m
    • Displacement: kgs

    Engines

    • Number of Engines: 0
    • Drive Type:

    Tanks

    • Fuel Tankage:  
    • Water Tankage:  

    Full Specs

    Features





      Enquire About this Boat

      To find out more about this boat please contact at

      Can We Help?

      Can't find what you're looking for?


      Call our teams on:

       

      Dublin
      Tel: +353 (1) 280 2020
       
      Cork
      Tel: +353 (0) 21 470 9600
       

      Belfast         Tel: +44 (0)7801 228805

       

      Hamble UK   Tel: +44 (0)2380 456318

       

      Have a general question about our brokerage service? Click here to contact us and we will get back to you as soon as possible.