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 |
FIELDORDER |
INCLUDEOFFICE |
INCLUDEUSER |
INT01 |
INT02 |
INT03 |
INT04 |
INT05 |
INT06 |
INT07 |
INT08 |
INT09 |
INT10 |
ISARCHIVED |
ISFEATURED |
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] |
22.66 |
[empty string] |
[empty string] |
[empty string] |
Pershing 74 |
[empty string] |
74 ft 4 in |
21.61 m - 70 ft 11 in |
16.65 m - 54 ft 8 in |
5.50 m - 18 ft 1 in |
1.45 m - 4 ft 9 in |
46.260 kg - 101,986 lbs |
53.970 kg - 118,983 lbs |
4.500 l - 1,189 US gal |
990 l - 262 US gal |
GRP |
16 |
3 |
3 |
1 |
MTU 12V 2000 M96L |
1948 |
Surface Drives |
44 kn |
40 kn |
280 nm |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Pershing |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
https://vrcloud.com/?pv=ma992 |
[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] |
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 |
[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 |
[empty string] |
[empty string] |
[empty string] |
Length Of Hull |
[empty string] |
[empty string] |
[empty string] |
Load Waterline Length |
[empty string] |
[empty string] |
[empty string] |
Max Beam |
[empty string] |
[empty string] |
[empty string] |
Draft |
[empty string] |
[empty string] |
[empty string] |
Unladen Displacement |
[empty string] |
[empty string] |
[empty string] |
Laden Displacement |
[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><strong>WE CALL IT EVOLUTION. NATURALLY.</strong></p>
<p><strong>Concept</strong></p>
<p>All the stylistic features that made the fleet’s various models so unmistakable find their natural evolution in the Pershing 74: The superstructure window, the large windows in the bulwarks, the large retractable door that divides the cockpit from the lounge, and of course, the inimitable performance of all <a href="../../../../new-yachts-for-sale/pershing-yachts-for-sale">Pershing yachts</a>.</p>
<p><strong>Design</strong></p>
<p>The design of the Pershing 74 enhances life onboard and the concept of total comfort. The Pershing 74 gives expression to its distinctly open personality in its large volumes and immense luminosity, generated by the large side windows and culminating in the magnificent sun deck, accessible through an automated hatch and through the fully retractable central carbon staircase.</p>
<p><strong>Performance</strong></p>
<p>The twin 1,950 HP MTU Common Rail engines let you sail at up to 44 knots in utmost comfort. The spacious and functional garage at the stern allows for the storing and the handling of a 3.25 m tender and a jet ski. Pershing 74 comes with the innovative Autotrim system, which automatically optimizes performance when load and speed vary.</p>
<p><strong>Comfort</strong></p>
<p>Utmost comfort and livability are provided by the retractable glass door that can separate or join the cockpit and lounge. The optimization of the environments and spaces all over the three decks yields unparalleled enjoyment of the floor areas, while the indirect LED lighting system gives the rooms a contemporary style. With an owner's cabin and two guest cabins, the boat can accommodate up to 6 guests.</p>
<p> </p>
<p><strong style="color: #0000ff;"><a style="color: #0000ff;" title="New Pershing Yachts In Stock Now" href="../../../../used-yachts-for-sale#q=&hPP=9&idx=allyachts_length_asc&p=0&dFR%5B_tags%5D%5B1%5D=New%20Ferretti%20Group%20Inventory&hFR%5BBuilder%5D%5B0%5D=Pershing&nR%5Bcalc_FT%5D%5B%3C%3D%5D%5B0%5D=600&nR%5Bcalc_FT%5D%5B%3E%3D%5D%5B0%5D=10">See the New Pershing Yachts In Stock and Available Now.</a></strong></p> |
https://dealer.ferrettigroup.com/UploadB2B/Models/Zips/Staging/VT_dec/12353/embed.html |
<a href="https://www.pershing-yacht.com/en-us/models/Video/6-40-64-PUB/Pershing-74">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.pershing-yacht.com/en-us/models/Video/6-40-64-PUB/Pershing-74","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.pershing-yacht.com/uploadB2B/videos/P74Duesseldorf2017-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] |
New Pershing 74 Luxury Yacht for Sale. Contact Allied Marine for additional information. |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
610.jpg |
610 |
[empty string] |
E159951E-AFFB-900D-A8CB46E106F77C31 |
Pershing-74 |
New Pershing 74 Yacht for Sale | Allied Marine |
[empty string] |
https://www.alliedmarine.com/new-yachts-for-sale/Pershing-yachts/Pershing-74 |
[empty string] |
[empty string] |
1 |
New Yacht Models |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
19 |
[empty string] |
|
SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
yacht_data.brokerREF,
yacht_data.staffREF,
yacht_data.officeREF,
yacht_data.yatcoREF,
yacht_data.modelREF,
yacht_data.isFeatured,
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 = 'Pershing-74' ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |