RESULTSET |
query |
|
BROKERREF |
CALC_1 |
CALC_2 |
CALC_3 |
CALC_4 |
DATA01 |
DATA02 |
DATA03 |
DATA04 |
DATA05 |
DATA06 |
DATA07 |
DATA08 |
DATA09 |
DATA10 |
DATA11 |
DATA12 |
DATA13 |
DATA14 |
DATA15 |
DATA16 |
DATA17 |
DATA18 |
DATA19 |
DATA20 |
DATA21 |
DATA22 |
DATA23 |
DATA24 |
DATA25 |
DATA26 |
DATA27 |
DATA28 |
DATA29 |
DATA30 |
DATA31 |
DATA32 |
DATA33 |
DATA34 |
DATA35 |
DATA36 |
DATA37 |
DATA38 |
DATA39 |
DATA40 |
DATA41 |
DATA42 |
DATA43 |
DATA44 |
DATA45 |
DEC01 |
DEC02 |
DEC03 |
DEC04 |
DEC05 |
DEC06 |
DEC07 |
DEC08 |
DEC09 |
DEC10 |
DEFAULTSORT |
FERRETTIMODELID |
FIELDORDER |
INCLUDEOFFICE |
INCLUDEUSER |
INT01 |
INT02 |
INT03 |
INT04 |
INT05 |
INT06 |
INT07 |
INT08 |
INT09 |
INT10 |
ISARCHIVED |
ISFEATURED |
ISINSTOCK |
ISNEWUSED |
KEYWORDS |
LAB01DEC |
LAB01INT |
LAB01MEM |
LAB01STR |
LAB02DEC |
LAB02INT |
LAB02MEM |
LAB02STR |
LAB03DEC |
LAB03INT |
LAB03MEM |
LAB03STR |
LAB04DEC |
LAB04INT |
LAB04MEM |
LAB04STR |
LAB05DEC |
LAB05INT |
LAB05MEM |
LAB05STR |
LAB06DEC |
LAB06INT |
LAB06MEM |
LAB06STR |
LAB07DEC |
LAB07INT |
LAB07MEM |
LAB07STR |
LAB08DEC |
LAB08INT |
LAB08MEM |
LAB08STR |
LAB09DEC |
LAB09INT |
LAB09MEM |
LAB09STR |
LAB10DEC |
LAB10INT |
LAB10MEM |
LAB10STR |
LAB11MEM |
LAB11STR |
LAB12MEM |
LAB12STR |
LAB13MEM |
LAB13STR |
LAB14MEM |
LAB14STR |
LAB15MEM |
LAB15STR |
LAB16MEM |
LAB16STR |
LAB17MEM |
LAB17STR |
LAB18MEM |
LAB18STR |
LAB19MEM |
LAB19STR |
LAB20MEM |
LAB20STR |
LAB21STR |
LAB22STR |
LAB23STR |
LAB24STR |
LAB25STR |
LAB26STR |
LAB27STR |
LAB28STR |
LAB29STR |
LAB30STR |
LAB31STR |
LAB32STR |
LAB33STR |
LAB34STR |
LAB35STR |
LAB36STR |
LAB37STR |
LAB38STR |
LAB39STR |
LAB40STR |
LAB41STR |
LAB42STR |
LAB43STR |
LAB44STR |
LAB45STR |
MEM01STATE |
MEM02STATE |
MEM03STATE |
MEM04STATE |
MEM05STATE |
MEM06STATE |
MEM07STATE |
MEM08STATE |
MEM09STATE |
MEM10STATE |
MEM11STATE |
MEM12STATE |
MEM13STATE |
MEM14STATE |
MEM15STATE |
MEM16STATE |
MEM17STATE |
MEM18STATE |
MEM19STATE |
MEM20STATE |
MEMO01 |
MEMO02 |
MEMO03 |
MEMO04 |
MEMO05 |
MEMO06 |
MEMO07 |
MEMO08 |
MEMO09 |
MEMO10 |
MEMO11 |
MEMO12 |
MEMO13 |
MEMO14 |
MEMO15 |
MEMO16 |
MEMO17 |
MEMO18 |
MEMO19 |
MEMO20 |
METADESCRIPTION |
MFRNAME |
MFRREF |
MODELNAME |
MODELREF |
NAME_FIRST |
NAME_FULL1 |
NAME_FULL2 |
NAME_FULL3 |
NAME_LAST |
OFFICEREF |
PHOTOCAPTION |
PHOTOFILENAME |
PHOTOID |
PRIORITY |
RANDOMSEED |
SEOHANDCRAFTEDURL |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TEMPLATEDESC |
TEMPLATEID |
TEMPLATENAME |
TEMPLATEREF |
USERFIRSTNAME |
USERFULLNAME |
USERFULLNAME2 |
USERLASTNAME |
YACHTID |
YATCOREF |
1 |
[empty string] |
32.84 |
[empty string] |
[empty string] |
[empty string] |
Custom Line 106' |
[empty string] |
107 ft 9 in |
32.83 m - 107 ft 9 in |
7.41 m - 24 ft 4 in |
2.03 m - 6 ft 8 in |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
5 |
6 |
3 |
MTU 16V 2000 M86 |
2217 |
Shaft line |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Custom Line |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
273 |
LAB01STR,LAB30STR,LAB03STR,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB09STR,LAB10STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB15STR,LAB16STR,LAB17STR,LAB18STR,LAB19STR,LAB20STR,LAB21STR,LAB22STR,LAB23STR,LAB24STR,LAB25STR,LAB26STR,LAB27STR,LAB28STR,LAB29STR,LAB31STR,LAB32STR,LAB33STR,LAB34STR,LAB35STR,LAB36STR,LAB37STR,LAB38STR,LAB39STR,LAB41STR,LAB40STR,LAB42STR,LAB01MEM,LAB02MEM,LAB03MEM |
0 |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Description Block |
Page Title |
[empty string] |
[empty string] |
Virtual Tour URL |
[empty string] |
[empty string] |
[empty string] |
Video Embed Code |
Length Overall (NN ft N in) |
[empty string] |
[empty string] |
[empty string] |
Length Of Hull (String) |
[empty string] |
[empty string] |
[empty string] |
Load Waterline Length (String) |
[empty string] |
[empty string] |
[empty string] |
Max Beam (String) |
[empty string] |
[empty string] |
[empty string] |
Draft (String) |
[empty string] |
[empty string] |
[empty string] |
Unladen Displacement (String) |
[empty string] |
[empty string] |
[empty string] |
Laden Displacement (String) |
[empty string] |
[empty string] |
[empty string] |
Fuel |
[empty string] |
Water |
[empty string] |
Material |
[empty string] |
People on Board |
[empty string] |
Cabins |
[empty string] |
Bathrooms |
[empty string] |
Bathrooms in crew quarter |
[empty string] |
Engine 1 |
[empty string] |
Engine 1 HP |
[empty string] |
Engine 1 Transmission |
[empty string] |
Engine 1 Max Speed (kn) |
Engine 1 Cruise Speed (kn) |
Engine 1 Range |
Engine 2 |
Engine 2 HP |
Engine 2 Transmission |
Engine 2 Max Speed (kn) |
Engine 2 Cruise Speed (kn) |
Engine 2 Range |
Engine 3 |
Brand |
Engine 3 HP |
Engine 3 Transmission |
Engine 3 Max Speed (kn) |
Engine 3 Cruise Speed (kn) |
Engine 3 Range |
Engine 4 |
Engine 4 HP |
Engine 4 Max Speed (kn) |
Engine 4 Cruise Speed (kn) |
Engine 4 Range |
Engine 4 Transmission |
VRCloud Link |
[empty string] |
[empty string] |
[empty string] |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<p class="MsoNormal"><strong>CONSUMMATE ELEGANCE</strong><br />Custom Line 106' is one of the stars of the Custom Line planing range. A new horizon in yachting excellence, with clean, crisp lines and palatial spaces of essential sophistication, she offers unsurpassable comfort for her owner.</p>
<p class="MsoNormal"><strong>A FLUID HARMONY</strong><br />Custom Line 106' is the epitome of pure Italian excellence. The succinct lines of the bottom and hull maintain the exemplary hydrodynamic performance of the latest models in the brand’s planing range. The minimalist design melds interior and exterior into a single elegant whole, as the surfaces dovetail in an architectural harmony that breaks down the boundaries between the spaces.</p>
<p class="MsoNormal"><strong>A MASTERPIECE OF BEAUTY AND COMFORT</strong><br />The surfaces are interconnected like a sculpture, crafting a fluid sequence of volumes running the length of the yacht. The stern vaunts a refined, clean-cut aesthetic, while the designers have dreamed up some larger, complementary spaces to relax and rest in further forward. The bow is linked to the flybridge, protected by two side windows and featuring a standard hard top with paired skylights – an exclusive area for admiring the wonders of the sea stretching out in all directions.</p>
<p class="MsoNormal"><strong>RESPLENDENT IN THE LIGHT</strong><br />Natural illumination adds an extra dimension to the space, magnifying the pleasure of cruising. The generous floor-to-ceiling windows on the main deck let the sun filter through so that you can revel in every ripple.</p>
<p class="MsoNormal"><strong>LUMINOUS BEAUTY</strong><br />The Custom Line 106' lower-deck layout features 2 VIP cabins and 2 twins, where light is king once again, courtesy of the ample built-in glazing. Every space is a work of art, a unique story of infinite nuance.</p>
<p class="MsoNormal"><strong>SIGNATURE STYLE</strong><br />Uniqueness leaves an indelible impression, an unmistakable hallmark of exquisite style. The on-board décor is fully personalisable, with vivid colour contrasts and supreme harmony of form, as elegance finds expression in a select handful of distinctive, essential elements.</p>
<p class="MsoNormal"><strong>NATURAL TECHNOLOGY</strong><br />Advanced technology makes the cruising experience even more natural. The Dual Mode Transom (DMT) system is implemented with two hatches that cover the stairs when the vessel is under way, for complete aesthetic clarity; when moored or at anchor, they vanish into the middle of the door. The garage can accommodate a tender and three-seater jet ski. Electro-hydraulic stabilising fins with under-way and zero-speed modes plus gyroscopic stabilisers on request offer even greater comfort while at rest.</p>
<p class="MsoNormal"><strong>PRIVATE SHOWINGS<br /></strong>Visit The Ferretti Group Showroom in Ft. Lauderdale, the largest covered, in-water marina in the US, featuring new and used Pershing, Riva, and Ferretti Yachts. Allied Marine is the exclusive dealer for these premier brands in the US, and an authorized dealer for CRN and Custom Line yachts.</p>
<p class="MsoNormal"><strong><a href="../../../../used-yachts-for-sale?allyachts_length_desc%5Btoggle%5D%5B_tags%5D=true&allyachts_length_desc%5Bmenu%5D%5BBuilder%5D=CUSTOM+LINE&allyachts_length_desc%5Brange%5D%5Bcalc_FT%5D=10:600&%5BsortBy%5D=allyachts_length_desc">See the new Custom Line yachts in stock and available now.</a></strong></p> |
[empty string] |
<a href="https://www.customline-yacht.com/en-us/The-Fleet/Video/8-273-414-PUB/Custom-Line-106'-Project">Watch video!<InvalidTag>var w=window,d=document,e;w._fpes||(w._fpes=[],w.addEventListener("load",function(){var s=d.createElement("script");s.src="//embed.flowplayer.org/6.0.4/embed.min.js",d.body.appendChild(s)})),e=[].slice.call(d.getElementsByTagName("script"),-1)[0].parentNode,w._fpes.push({e:e,l:"",c:{"ratio":0.5625,"rtmp":0,"live":false,"origin":"https://www.customline-yacht.com/en-us/The-Fleet/Video/8-273-414-PUB/Custom-Line-106'-Project","swf":"//releases.flowplayer.org/6.0.4/flowplayer.swf","swfHls":"//releases.flowplayer.org/6.0.4/flowplayerhls.swf","adaptiveRatio":false,"clip":{"title":"","subtitles":[],"sources":[{"src":"https://www.customline-yacht.com/uploadB2B/videos/CL106rendering_v1.1-1200p.mp4","suffix":"mp4","type":"video/mp4"}]}}});</script></a> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
The 106' is one of the stars of Custom Line's planing range. Allied Marine is the exclusive U.S. dealer of new Custom Line motor yachts. |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
1514.jpg |
1514 |
[empty string] |
83F87E8E-F7FD-6111-7F6BBCF7708B20DB |
Custom-Line-106 |
New Custom Line 106' Yacht for Sale | Allied Marine |
[empty string] |
https://www.alliedmarine.com/new-yachts-for-sale/Custom-Line-yachts/Custom-Line-106 |
[empty string] |
[empty string] |
1 |
New Yacht Models |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
46 |
[empty string] |
|
SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
yacht_data.isFeatured,
yacht_data.isInStock,
yacht_data.isNewUsed,
yacht_data.ferrettiModelID,
yacht_data.brokerREF,
yacht_data.staffREF,
yacht_data.officeREF,
yacht_data.yatcoREF,
yacht_data.modelREF,
yacht_data.calc_1,
yacht_data.calc_2,
yacht_data.calc_3,
yacht_data.calc_4,
yacht_data.yachtID,
yacht_data.priority,
yacht_data.data01,
yacht_data.data02,
yacht_data.data03,
yacht_data.data04,
yacht_data.data05,
yacht_data.data06,
yacht_data.data07,
yacht_data.data08,
yacht_data.data09,
yacht_data.data10,
yacht_data.data11,
yacht_data.data12,
yacht_data.data13,
yacht_data.data14,
yacht_data.data15,
yacht_data.data16,
yacht_data.data17,
yacht_data.data18,
yacht_data.data19,
yacht_data.data20,
yacht_data.data21,
yacht_data.data22,
yacht_data.data23,
yacht_data.data24,
yacht_data.data25,
yacht_data.data26,
yacht_data.data27,
yacht_data.data28,
yacht_data.data29,
yacht_data.data30,
yacht_data.data31,
yacht_data.data32,
yacht_data.data33,
yacht_data.data34,
yacht_data.data35,
yacht_data.data36,
yacht_data.data37,
yacht_data.data38,
yacht_data.data39,
yacht_data.data40,
yacht_data.data41,
yacht_data.data42,
yacht_data.data43,
yacht_data.data44,
yacht_data.data45,
yacht_data.int01,
yacht_data.int02,
yacht_data.int03,
yacht_data.int04,
yacht_data.int05,
yacht_data.int06,
yacht_data.int07,
yacht_data.int08,
yacht_data.int09,
yacht_data.int10,
yacht_data.dec01,
yacht_data.dec02,
yacht_data.dec03,
yacht_data.dec04,
yacht_data.dec05,
yacht_data.dec06,
yacht_data.dec07,
yacht_data.dec08,
yacht_data.dec09,
yacht_data.dec10,
yacht_data.memo01,
yacht_data.memo02,
yacht_data.memo03,
yacht_data.memo04,
yacht_data.memo05,
yacht_data.memo06,
yacht_data.memo07,
yacht_data.memo08,
yacht_data.memo09,
yacht_data.memo10,
yacht_data.memo11,
yacht_data.memo12,
yacht_data.memo13,
yacht_data.memo14,
yacht_data.memo15,
yacht_data.memo16,
yacht_data.memo17,
yacht_data.memo18,
yacht_data.memo19,
yacht_data.memo20,
yacht_data.randomSeed,
yacht_data.metaDescription,
yacht_data.keywords,
yacht_data.seoPreviewText,
yacht_data.seoPageTitle,
yacht_data.seoURL,
yacht_data.seoHandCraftedURL,
yacht_templates.templateID,
yacht_templates.fieldOrder,
yacht_templates.mem01state,
yacht_templates.mem02state,
yacht_templates.mem03state,
yacht_templates.mem04state,
yacht_templates.mem05state,
yacht_templates.mem06state,
yacht_templates.mem07state,
yacht_templates.mem08state,
yacht_templates.mem09state,
yacht_templates.mem10state,
yacht_templates.mem11state,
yacht_templates.mem12state,
yacht_templates.mem13state,
yacht_templates.mem14state,
yacht_templates.mem15state,
yacht_templates.mem16state,
yacht_templates.mem17state,
yacht_templates.mem18state,
yacht_templates.mem19state,
yacht_templates.mem20state,
yacht_templates.templateDesc,
yacht_templates.templateName,
yacht_templates.lab01str,
yacht_templates.lab02str,
yacht_templates.lab03str,
yacht_templates.lab04str,
yacht_templates.lab05str,
yacht_templates.lab06str,
yacht_templates.lab07str,
yacht_templates.lab08str,
yacht_templates.lab09str,
yacht_templates.lab10str,
yacht_templates.lab11str,
yacht_templates.lab12str,
yacht_templates.lab13str,
yacht_templates.lab14str,
yacht_templates.lab15str,
yacht_templates.lab16str,
yacht_templates.lab17str,
yacht_templates.lab18str,
yacht_templates.lab19str,
yacht_templates.lab20str,
yacht_templates.lab21str,
yacht_templates.lab22str,
yacht_templates.lab23str,
yacht_templates.lab24str,
yacht_templates.lab25str,
yacht_templates.lab26str,
yacht_templates.lab27str,
yacht_templates.lab28str,
yacht_templates.lab29str,
yacht_templates.lab30str,
yacht_templates.lab31str,
yacht_templates.lab32str,
yacht_templates.lab33str,
yacht_templates.lab34str,
yacht_templates.lab35str,
yacht_templates.lab36str,
yacht_templates.lab37str,
yacht_templates.lab38str,
yacht_templates.lab39str,
yacht_templates.lab40str,
yacht_templates.lab41str,
yacht_templates.lab42str,
yacht_templates.lab43str,
yacht_templates.lab44str,
yacht_templates.lab45str,
yacht_templates.lab01int,
yacht_templates.lab02int,
yacht_templates.lab03int,
yacht_templates.lab04int,
yacht_templates.lab05int,
yacht_templates.lab06int,
yacht_templates.lab07int,
yacht_templates.lab08int,
yacht_templates.lab09int,
yacht_templates.lab10int,
yacht_templates.lab01dec,
yacht_templates.lab02dec,
yacht_templates.lab03dec,
yacht_templates.lab04dec,
yacht_templates.lab05dec,
yacht_templates.lab06dec,
yacht_templates.lab07dec,
yacht_templates.lab08dec,
yacht_templates.lab09dec,
yacht_templates.lab10dec,
yacht_templates.lab01mem,
yacht_templates.lab02mem,
yacht_templates.lab03mem,
yacht_templates.lab04mem,
yacht_templates.lab05mem,
yacht_templates.lab06mem,
yacht_templates.lab07mem,
yacht_templates.lab08mem,
yacht_templates.lab09mem,
yacht_templates.lab10mem,
yacht_templates.lab11mem,
yacht_templates.lab12mem,
yacht_templates.lab13mem,
yacht_templates.lab14mem,
yacht_templates.lab15mem,
yacht_templates.lab16mem,
yacht_templates.lab17mem,
yacht_templates.lab18mem,
yacht_templates.lab19mem,
yacht_templates.lab20mem,
yacht_templates.defaultSort,
yacht_templates.includeUser,
yacht_templates.includeOffice,
users.userLastName,
users.userFirstName,
users.userFirstName + ' ' + users.userLastName AS userFullName,
users.userLastName + ', ' + users.userFirstName AS userFullName2,
brokers.name_last,
brokers.name_first,
brokers.name_first + ' ' + brokers.name_last AS name_full1,
brokers.name_last + ', ' + brokers.name_first AS name_full2,
brokers.name_last + ', ' + brokers.name_first + ' (' + brokers.email + ')' AS name_full3,
yacht_photos.photoID,
yacht_photos.photoFileName,
yacht_photos.photoCaption,
yacht_model.mfrRef,
yacht_model.modelName,
yacht_mfr.mfrName
FROM
yacht_data
LEFT JOIN yacht_templates ON yacht_data.templateREF = yacht_templates.templateID
LEFT JOIN users ON yacht_data.staffREF = users.userID
LEFT JOIN brokers ON yacht_data.brokerREF = brokers.brokerID
LEFT JOIN yacht_photos ON yacht_data.yachtID = yacht_photos.yachtREF
LEFT JOIN yacht_model ON yacht_data.modelREF = yacht_model.modelID
LEFT JOIN yacht_mfr ON yacht_model.mfrREF = yacht_mfr.mfrID
WHERE ( templateREF = 1 AND ( isArchived != 1 OR isArchived IS NULL ) AND seoHandCraftedURL = 'Custom-Line-106' ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |