ISA EXTRA 76

2020
Italy
VAT not paid
Viewing and sea-trial is possible in accordance with the terms of MYBA
0
8 000 000
Цена по запросу
2020 Italy
4
Shipyard
Material
GRP
Gross tonnage
t
Length overall
23.99 m
Hull length
0.00 m
Waterline length
0.00 m
Beam
0.00 m
Beam overall
6.80 m
Height
0.00 m
Height above waterline
0 m
Draft
1.75 m
Draft on keel
0.00 m
Engine
2 x Volvo IPS 1350 hp
Hours
m/h
Fuel capacity
7000 l
Water capacity
1500 l
Maxspeed
21.00 knot
Speed
0.00 knot
Gray water tank
600 l
Holding tank capacity
400 l
Range
0.00 mm
Factory ballast capacity
0.00 l
Dry displacement
0.00 t
Displacement
0.00 t
Passenger capacity
0
Berths
8 + 3 crew
Cabines
4 + 2
Head compartments
4 + 1
Keel
Interior design
Exterior styling & concept

About yacht

The EXTRA 76ft lets the Owner enjoy super-size superyacht amenities and experiences on a more manageable scale. With a beam of 6.8 meters (22,3ft), the EXTRA 76 turns heads for the largest aft and salon spaces in her category.

The fly decks offer a second helm station, an area where guests can maximize socializing, enjoy a long cruise or dine together, from a privileged point of view on the world.


Equipment

Подробная техническая спецификация, список опционального оборудования и другая информация коммерческого характера может быть предоставлена по запросу.
Подробная техническая спецификация, список установленного оборудования, информация о проведенных сезонных и сервисных работах могут быть предоставлены по запросу.
Подробная техническая спецификация, список доступного опционального оборудования, данные о сроках и возможности внесения изменений в отношении планировок, опционального оборудования, дизайна интерьеров и другая информация коммерческого характера могут быть предоставлены по запросу.
Остались вопросы по яхте?
Мы сможем предоставить максимум актуальной информации о судне по указанным Вами контактным данным Мы сможем предоставить максимум актуальной информации о судне по указанным Вами контактным данным Для проведения развернутой и исчерпывающей консультации по вопросу строительства нам необходим
всесторонний диалог с заказчиком
Мы оказываем полное содействие в вопросах юридического оформления сделки, технической приемки судна у завода-производителя, регистрации Aberton Yachts оказывает полное содействие в вопросах юридического оформления сделки, технического сюрвея, перерегистрации судна Мы оказываем полное содействие в вопросах юридического оформления сделки, строительного надзора и технической приемки судна у завода-производителя
Igor Cherentaev
Yacht Broker
Информация, которую Вы предоставите в данной форме запроса, будет отправлена напрямую в отдел продаж.
Мы не предоставляем эту информацию третьим лицам или сторонним компаниям.

Similar offers

Ошибка SQL: Column 'boat_enm_sale' in where clause is ambiguous
SQL: [SELECT COALESCE(a.boat_ref_link, a.boat_uid_id) AS boat_uid_id, a.boat_cnt_account AS boat_cnt_account, a.boat_hld_holder AS boat_hld_holder, a.boat_mbr_member AS boat_mbr_member, a.boat_lng_language AS boat_lng_language, a.boat_ref_link AS boat_ref_link, a.boat_chr_link AS boat_chr_link, COALESCE(b.boat_ind_index,a.boat_ind_index) AS boat_ind_index, COALESCE(b.boat_int_year,a.boat_int_year) AS boat_int_year, COALESCE(b.boat_set_country,a.boat_set_country) AS boat_set_country, IF(LENGTH(COALESCE(b.boat_chr_name,a.boat_chr_name)) > 23, CONCAT(SUBSTRING(COALESCE(b.boat_chr_name,a.boat_chr_name), 1, 23), '...'), COALESCE(b.boat_chr_name,a.boat_chr_name)) AS boat_chr_name, (CASE WHEN 'en' IS NULL THEN IF(COALESCE(b.boat_chr_nick,a.boat_chr_nick) IS NULL OR COALESCE(b.boat_chr_nick,a.boat_chr_nick) = '', (CASE WHEN (a.boat_chk_stock & 16384 AND a.boat_chk_build & 4) THEN 'Новая яхта в постройке' WHEN a.boat_chk_stock & 16384 AND NOT(a.boat_chk_build & 4) THEN 'Новая яхта' ELSE 'M/Y По запросу' END), CONCAT('M/Y ', IF(LENGTH(COALESCE(b.boat_chr_nick,a.boat_chr_nick)) > 13, CONCAT(SUBSTRING(COALESCE(b.boat_chr_nick,a.boat_chr_nick), 1, 13), '...'), COALESCE(b.boat_chr_nick,a.boat_chr_nick)) )) ELSE IF(COALESCE(b.boat_chr_nick,a.boat_chr_nick) IS NULL OR COALESCE(b.boat_chr_nick,a.boat_chr_nick) = '', (CASE WHEN a.boat_chk_stock & 16384 AND a.boat_chk_build & 4 THEN 'New Yacht Build' WHEN a.boat_chk_stock & 16384 AND NOT(a.boat_chk_build & 4) THEN 'New Yacht' ELSE 'M/Y By request' END), CONCAT('M/Y ', IF(LENGTH(COALESCE(b.boat_chr_nick,a.boat_chr_nick)) > 13, CONCAT(SUBSTRING(COALESCE(b.boat_chr_nick,a.boat_chr_nick), 1, 13), '...'), COALESCE(b.boat_chr_nick,a.boat_chr_nick)) )) END) AS boat_nickname, IF(COALESCE(b.boat_chr_nick,a.boat_chr_nick) IS NOT NULL AND COALESCE(b.boat_chr_nick,a.boat_chr_nick) <> '', 'large_size', '') AS boat_nickname_class, COALESCE(COALESCE(b.boat_img_image4,a.boat_img_image4), COALESCE(b.boat_img_image,a.boat_img_image), COALESCE(b.boat_img_image5,a.boat_img_image5)) AS boat_img_image, (CASE WHEN COALESCE(COALESCE(b.boat_wth_image5,a.boat_wth_image5), COALESCE(b.boat_wth_image,a.boat_wth_image), COALESCE(b.boat_wth_image4,a.boat_wth_image4)) >= 1500 THEN 'cc1500x720' ELSE CONCAT('cc', COALESCE(COALESCE(b.boat_wth_image5,a.boat_wth_image5), COALESCE(b.boat_wth_image,a.boat_wth_image), COALESCE(b.boat_wth_image4,a.boat_wth_image4)), 'x', ROUND(COALESCE(COALESCE(b.boat_wth_image5,a.boat_wth_image5), COALESCE(b.boat_wth_image,a.boat_wth_image), COALESCE(b.boat_wth_image4,a.boat_wth_image4)) * (720/1500), 0)) END) AS crop_rate, GREATEST(COALESCE(COALESCE(b.boat_int_length,a.boat_int_length), 0), COALESCE(COALESCE(b.boat_int_length2,a.boat_int_length2), 0), COALESCE(COALESCE(b.boat_int_length3,a.boat_int_length3), 0)) AS boat_max_length, (CASE WHEN COALESCE(IF(NULLIF(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7),0), COALESCE(b.boat_val_cost7,a.boat_val_cost7), NULL),IF(NULLIF(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8),0), COALESCE(b.boat_val_cost8,a.boat_val_cost8), NULL)) = 'EUR' THEN '€' WHEN COALESCE(IF(NULLIF(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7),0), COALESCE(b.boat_val_cost7,a.boat_val_cost7), NULL),IF(NULLIF(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8),0), COALESCE(b.boat_val_cost8,a.boat_val_cost8), NULL)) = 'USD' THEN '$' WHEN COALESCE(IF(NULLIF(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7),0), COALESCE(b.boat_val_cost7,a.boat_val_cost7), NULL),IF(NULLIF(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8),0), COALESCE(b.boat_val_cost8,a.boat_val_cost8), NULL)) = 'RUR' THEN '₽' END) AS UnitValuta, (CASE WHEN COALESCE(b.boat_enm_request,a.boat_enm_request) = 'YES' THEN '' WHEN COALESCE(IF(NULLIF(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7),0), COALESCE(b.boat_val_cost7,a.boat_val_cost7), NULL),IF(NULLIF(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8),0), COALESCE(b.boat_val_cost8,a.boat_val_cost8), NULL)) = 'EUR' THEN 'EUR' WHEN COALESCE(IF(NULLIF(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7),0), COALESCE(b.boat_val_cost7,a.boat_val_cost7), NULL),IF(NULLIF(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8),0), COALESCE(b.boat_val_cost8,a.boat_val_cost8), NULL)) = 'USD' THEN 'USD' WHEN COALESCE(IF(NULLIF(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7),0), COALESCE(b.boat_val_cost7,a.boat_val_cost7), NULL),IF(NULLIF(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8),0), COALESCE(b.boat_val_cost8,a.boat_val_cost8), NULL)) = 'RUR' THEN 'RUB' ELSE 'EUR' END) AS Valuta, (CASE WHEN IFNULL(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8), 0) <> 0 THEN 'display_old_price' ELSE 'hide_old_price' END) AS display_old, IF(IFNULL(ROUND(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7)), 0) = 0, '-', ROUND(COALESCE(b.boat_cur_cost7,a.boat_cur_cost7))) AS boat_dec_cost, ROUND(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8)) AS boat_dec_oldcost, (CASE WHEN COALESCE(b.boat_enm_request,a.boat_enm_request) = 'YES' THEN (CASE WHEN 'en' IS NULL THEN 'Цена по запросу' ELSE 'By request' END) ELSE '' END) AS boat_request, IFNULL(a.boat_enm_flag, 'NO') AS boat_enm_flag, IF(a.boat_enm_request = 'YES', 'hide', '') AS hide_price, IF(a.boat_enm_request = 'YES', 'hide_new_price', '') AS hide_new_price, IF(COALESCE(b.boat_enm_request,a.boat_enm_request) = 'YES', '', 'price_to_change') AS ptc_class, IF(IFNULL(a.boat_enm_sale,'NO') = 'YES', 'sold', '') AS sold_class, (CASE WHEN COALESCE(b.boat_cur_cost8,a.boat_cur_cost8) = '' OR ROUND(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8)) = 0 THEN '' ELSE ROUND(COALESCE(b.boat_cur_cost8,a.boat_cur_cost8)) END) AS boat_dec_old, for_favorite.basket_uid_id AS favorite_id, IF(for_favorite.basket_uid_id IS NOT NULL, 'filled-star', 'empty-star') AS check_favorite_class, IF(COALESCE(b.boat_chk_enlarge,a.boat_chk_enlarge) & 16384, 'top-offer', '') AS offer_class, ( SELECT COUNT(*) FROM reestr_join WHERE join_account=975 AND join_holder=8809 AND join_this_holder=5531 AND join_this=COALESCE(b.boat_uid_id,a.boat_uid_id) AND join_this_table='account_boat' AND join_that_table='account_list' AND join_that IN(NULL) ) AS categories_matches_count FROM account_boat a # Для избранного LEFT JOIN ( SELECT for_favorite.basket_uid_id, for_favorite.basket_lnk_link FROM account_basket for_favorite WHERE for_favorite.basket_cnt_account = 926 AND for_favorite.basket_hld_holder = 14075 AND for_favorite.basket_mbr_member = 0 AND for_favorite.basket_usr_user IN (315620952) AND for_favorite.basket_int_amount1 > 0 AND for_favorite.basket_int_flag = 2 ) AS for_favorite ON for_favorite.basket_lnk_link = boat_uid_id LEFT JOIN account_boat b ON b.boat_ref_link=a.boat_uid_id AND b.boat_lng_language = 'en' WHERE a.boat_cnt_account=975 AND a.boat_hld_holder IN(5531) # 5531 AND a.boat_uid_id IN ( SELECT b.boat_uid_id FROM account_boat AS b WHERE b.boat_cnt_account = 975 AND b.boat_hld_holder IN(5531) AND b.boat_mbr_member = 0 AND b.boat_chr_article != '' AND b.boat_chr_article = IFNULL('','без артикула') #AND b.boat_lng_language = NULL UNION SELECT c.boat_uid_id FROM account_boat AS c WHERE c.boat_cnt_account = 975 AND c.boat_hld_holder IN(5531) AND c.boat_mbr_member = 0 #AND c.boat_lng_language = NULL AND (CASE # Условие на длину ОТ WHEN c.boat_int_length > 0 AND c.boat_int_length2 > 0 THEN (CASE WHEN c.boat_int_length <= c.boat_int_length2 THEN c.boat_int_length2 WHEN c.boat_int_length > c.boat_int_length2 THEN c.boat_int_length END) WHEN c.boat_int_length > 0 AND ( c.boat_int_length2 = 0 OR c.boat_int_length2 IS NULL ) THEN c.boat_int_length WHEN c.boat_int_length2 > 0 AND ( c.boat_int_length = 0 OR c.boat_int_length IS NULL ) THEN c.boat_int_length2 END) >= (23.99 * 0.87) # Это коэффицент, так же можно записать в процентах. Длина в пределах 13% AND (CASE # Условие на длину ДО WHEN c.boat_int_length > 0 AND c.boat_int_length2 > 0 THEN (CASE WHEN c.boat_int_length <= c.boat_int_length2 THEN c.boat_int_length2 WHEN c.boat_int_length > c.boat_int_length2 THEN c.boat_int_length END) WHEN c.boat_int_length > 0 AND ( c.boat_int_length2 = 0 OR c.boat_int_length2 IS NULL ) THEN c.boat_int_length WHEN c.boat_int_length2 > 0 AND ( c.boat_int_length = 0 OR c.boat_int_length IS NULL ) THEN c.boat_int_length2 END) <= (23.99 * 1.13) # Это коэффицент, так же можно записать в процентах. Длина в пределах 13% AND c.boat_int_year <= (2020 + 3) # Условие на год ОТ AND c.boat_int_year >= (2020 - 3) # Условие на год ДО ) # Убираем из списка похожих лодку, в который находимся в данный момент AND a.boat_uid_id <> 6414 # Если стоит галочка выключить для стран не из СНГ, то проверяем страну (берётся из body), иначе TRUE AND IF(a.boat_enm_hide = 'YES', 0, TRUE) AND boat_enm_sale <> 'YES' AND a.boat_lng_language IS NULL /* объединение языков, всегда выбираем сначала основной */ AND a.boat_chr_link LIKE ? ORDER BY boat_uid_id LIMIT 1 /* module_id:333801 URN */]