Call the brokerage team today on 0844 463 65 24

Yacht Details





Warning: extract() expects parameter 1 to be array, null given in /home2/yachtpro/public_html/leboatbrokerage.com/wp-content/plugins/yacht-details/yacht_details.php on line 405

Warning: extract() expects parameter 1 to be array, null given in /home2/yachtpro/public_html/leboatbrokerage.com/wp-content/plugins/yacht-details/yacht_details.php on line 185

Warning: Invalid argument supplied for foreach() in /home2/yachtpro/public_html/leboatbrokerage.com/wp-content/plugins/yacht-details/yacht_details.php on line 446

-

Call for Pricing


Enquire about this yacht
{"data":[],"total":null,"sql":"SELECT SQL_CALC_FOUND_ROWS \n\t\t\t\t\n\t\t\t\t\t\t\t\t\t it.Brand,\n\t\t\t\t\t\t\t\t\t it.Cabins,\n\t\t\t\t\t\t\t\t\t it.`Year`,\n\t\t\t\t\t\t\t\t\t it.Model,\n\t\t\t\t\t\t\t\t\t it.`yacht-name`,\n\t\t\t\t\t\t\t\t\t it.`Length`,\n\t\t\t\t\t\t\t\t\t it.LengthType,\n\t\t\t\t\t\t\t\t\t it.`Type`,\n\t\t\t\t\t\t\t\t\t it.City,\n\t\t\t\t\t\t\t\t\t it.State,\n\t\t\t\t\t\t\t\t\t it.Country,\n\t\t\t\t\t\t\t\t\t it.Summary,\n\t\t\t\t\t\t\t\t\t it.`Status`,\n\t\t\t\t\t\t\t\t\t it.Price,\n\t\t\t\t\t\t\t\t\t it.PriceType,\n\t\t\t\t\t\t\t\t\t u.company,\n\t\t\t\t\t\t\t\t\t it.user_id,\n\t\t\t\t\t\t\t\t\t c.name,\n\t\t\t\t\t\t\t\t\t item_id,\n\t\t\t\t \t\t\t\t\t it.url FROM (\n\t\t\t\t\t\t\t\t\t\tSELECT image, max(item_id) AS item_id\n\t\t\t\t\t\t\t\t\t\tFROM item_images GROUP BY item_id\n\t\t\t\t\t\t\t\t\t\t) img\n\t\t\t\t\t\t\t\t\t\tINNER JOIN items it ON it.id = img.item_id\n\t\t\t\t\t\t\t\t\t\tINNER JOIN user u ON it.user_id = u.id\n\t\t\t\t\t\t\t\t\t\tINNER JOIN companies c ON u.company = c.id\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t(it.length BETWEEN AND ) AND\n\t\t\t\t\t\t\t\t\t\t(it.year BETWEEN AND ) AND\n\t\t\t\t\t\t\t\t\t\t(it.price BETWEEN AND ) AND\n\t\t\t\t\t\t\t\t\t\tit.state LIKE '' AND\n\t\t\t\t\t\t\t\t\t\tit.country LIKE '' AND\n\t\t\t\t\t\t\t\t\t\tit.allowcobroker LIKE '' AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 ORDER BY LIMIT , ","filters":{"brand":[],"cabins":[],"category":[],"type":[],"state":[""],"country":[""]}}

Romuald Leblanc

Email: romuald.leblanc@leboat.com


Warning: Invalid argument supplied for foreach() in /home2/yachtpro/public_html/leboatbrokerage.com/wp-content/plugins/yacht-details/yacht_details.php on line 369