Maerose | Herreshoff 21' 1983

Longboat Key, FL


Print Yacht Specs



Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Maerose
Builder: Herreshoff
Model: Golden Era Petrel
Year: 1983
Location: Longboat Key, FL
Designer: Nathanael G.
Hull Material: Fiberglass
 

 

Maerose is a classic Herreshoff daysailer with only a few seasons use in Bristol condition following comprehensive overhaul and upgrades including electric inboard power.

The Petrel 21’s are fiberglass-hulled replicas of Capt. Nat’s legendary Fish Class design whose graceful appearance and sweet sailing characteristics remain unsurpassed. The 9’ cockpit has high contoured backrests and is comfortable for a crowd, while the cuddy cabin offers shelter and dry storage plus a V-berth for two.

The ultra-quiet, turn-key inboard electric propulsion adds immensely to the convenience and full-day enjoyment of each outing. An added convenience for storage or launching is the freshly painted and updated Triad trailer. The sails (Hood mainsail and self-tacking jib) and a full complement of Sunbrella canvas (sails covers, tent cockpit cover, cockpit and cabin cushions and mast boot) all show minimal wear.

Outfit is extensive and includes unique Herreshoff details such as the graceful teak toe rail/rub rail/sheer strake and handy fold-down tiller comb for anchoring and self-steering. All brightwork including spruce spars and teak trim and all bronze hardware is original. House electrical including AC & DC panels was new in 2018.

Beautiful to look at, delightful to sail or motor, and ready to launch!

Construction

  • Fiberglass hull has 3/8’ Airex core above waterline
  • Deck, cockpit and cabin top are marine plywood covered with fiberglass cloth
  • Bulkheads are 1/2” marine plywood
  • Rub rails, cockpit coamings & trim are vanished teak
  • Varnished teak trim
  • 4’ Ash tiller

Finish
  • Decks: Cream Awlgrip Topcoat with nonskid
  • Topsides: White original gelcoat buffed & waxed
  • Bootstripe: Red Interlux Brightside
  • Bulkheads, hull interior and cockpit: White Interlux Brightside
  • Brightwork: Interlux Schooner varnish
  • Forepeak, bilges & lazarette : White Interlux BilgeKote
  • Bottom: Green Interlux Micron CSC

Deck
  • Bow plate: polished bronze casting with integral bow chocks
  • 3” Flexible PVC cowl vent to forepeak with bronze base
  • 8” Bronze Herreshoff open-base bow cleat
  • (2) 5 1/2” Bronze open open-base, stern cleats
  • Jib boom and mailsail travelers
  • Teak and brass Herreshoff tiller comb
  • Split-hinged (readily removable) and louvered cuddy cabin doors
  • (2) Cockpit lockers
  • Louvered lazarette door
  • Bronze door, locker and running rigging hardware
  • (4) 1/2" Dock lines
  • (3) 6” Diameter fenders

Engine & Mechanical
  • Advanced DC Motors FB1-4001A motor at 36VDC with 3:1 reduction
  • 1204-018 Curtis Controller
  • ET-Marine throttle with F/R capability & custom bronze handle
  • Albright contactors
  • Aircraft-style voltmeter and ammeter
  • PSS self-aligning shaft seal
  • Stainless steel propeller shaft
  • Streamlined zinc shaft collar      
  • 12” 2-blade bronze propeller

Electrical
  • Blue Seas Systems 120VAC/60Hz power distribution panel
  • Blue Seas 12VDC Power Distribution Panel
  • (6) Trojan T-105 deep-cycle batteries wired in series.
  • Newmar 36V to 12V DC-DC Converter
  • ProMariner waterproof 36V battery charger
  • Voltmeter and ammeter
  • 30 Amp shore power service with nonmetalic boat inlet
  • 50’ 30 Amp 120VAC Marinco shore power cable
  • 30 Amp 120VAC adapter for charging with house current
  • (1) Cabin light
  • 1 GFCI interrupter duplex outlet
  • Rule automatic bilge pump with in-cabin shut-off

Spars & Rigging
  • Sitka spruce mast, boom and jib boom
  • Teak sheer strake and trim
  • Teak boom crutch
  • Stainless steel wire rope rigging and turnbuckles
  • Dacron running rigging

Sails & Canvas
  • Hood mainsail and club-footed jib
  • Green Sunbrella tent cockpit cover
  • Green Sunbrella jib & mainsail covers
  • Green Sunbrella cockpit seat and V-berth cushions
  • Green Sunbrella mast boot skirt
  • Tyvek full deck cover

Safety
  • Type A/B fire extinguisher
  • (4) Type I PFDs
  • Air horn

Trailer
  • 1984 Triad tandem axel with 4-wheel hydraulic surge brakes
  • 9’ Extendable tongue plus the bow stop and ladder
  • Radial tires, new 2013
  • Wiring, lights and hydraulic lines, new 2018
  • Painted 2018

Dimensions

Length: 21'
Beam: 7' 2
Draft: 3' 2
Power: 5 HP
query
RESULTSET
query
  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 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 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 OFFICEREF PHOTOCAPTION PHOTOID PRIORITY PRIORITY RANDOMSEED SEOPAGETITLE SEOPREVIEWTEXT SEOURL STAFFREF TEMPLATEDESC TEMPLATEID TEMPLATENAME TEMPLATEREF USERFIRSTNAME USERFULLNAME USERFULLNAME2 USERLASTNAME USERPHONE YACHTID YATCOREF
1 6.40 [empty string] [empty string] [empty string] Herreshoff 21' 1983 7' 2 3' 2 [empty string] Fiberglass Nathanael G. Advanced DC Motors electric 5 HP Sail Maerose $33,500 Longboat Key, FL [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Golden Era Petrel [empty string] [empty string] July 13, 2020 [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] LAB03INT,LAB28STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB02STR,LAB03STR,LAB15STR,LAB01STR,LAB25STR,LAB01MEM,LAB03MEM,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB19STR,LAB21STR,LAB20STR,LAB10STR,LAB18STR,LAB16STR,LAB22STR,LAB23STR,LAB24STR 0 1 [empty string] [empty string] 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 0 [empty string] [empty string] [empty string] Link to Virtual Tour Builder [empty string] [empty string] [empty string] Length [empty string] Sold Yacht Additional Info Year Built [empty string] [empty string] [empty string] Beam [empty string] [empty string] [empty string] Draft [empty string] [empty string] [empty string] Displacement [empty string] [empty string] [empty string] Hull [empty string] [empty string] [empty string] Designer [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Power [empty string] Type (Sail or Power) [empty string] Yacht Name [empty string] Yacht Price [empty string] Location [empty string] Year Refit [empty string] Fuel Type [empty string] [empty string] [empty string] Engine Hours [empty string] Number of Engines [empty string] Engine Model Engine Manufacturer Holding Tank Capacity Fuel Tank Capacity Water Tank Capacity Model [empty string] [empty string] Selling Date [empty string] [empty string] 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [empty string] [empty string] <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">&nbsp;</p> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <p>Maerose&nbsp;is a classic Herreshoff daysailer with only a few seasons use in Bristol condition following comprehensive overhaul and upgrades including electric inboard power.</p> <p>The Petrel 21&rsquo;s are fiberglass-hulled replicas of Capt. Nat&rsquo;s legendary Fish Class design whose graceful appearance and sweet sailing characteristics remain unsurpassed. The 9&rsquo; cockpit has high contoured backrests and is comfortable for a crowd, while the cuddy cabin offers shelter and dry storage plus a V-berth for two.</p> <p>The ultra-quiet, turn-key inboard electric propulsion adds immensely to the convenience and full-day enjoyment of each outing. An added convenience for storage or launching is the freshly painted and updated Triad trailer. The sails (Hood mainsail and self-tacking jib) and a full complement of Sunbrella canvas (sails covers, tent cockpit cover, cockpit and cabin cushions and mast boot) all show minimal wear.</p> <p>Outfit is extensive and includes unique Herreshoff details such as the graceful teak toe rail/rub rail/sheer strake and handy fold-down tiller comb for anchoring and self-steering. All brightwork including spruce spars and teak trim and all bronze hardware is original. House electrical including AC &amp; DC panels was new in 2018.</p> <p>Beautiful to look at, delightful to sail or motor, and ready to launch!</p> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"> <p><strong>Construction</strong></p> <ul> <li>Fiberglass hull has 3/8&rsquo; Airex core above waterline</li> <li>Deck, cockpit and cabin top are marine plywood covered with fiberglass cloth</li> <li>Bulkheads are 1/2&rdquo; marine plywood</li> <li>Rub rails, cockpit coamings &amp; trim are vanished teak</li> <li>Varnished teak trim</li> <li>4&rsquo; Ash tiller</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Finish</strong><br /> <ul> <li>Decks: Cream Awlgrip Topcoat with nonskid</li> <li>Topsides: White original gelcoat buffed &amp; waxed</li> <li>Bootstripe: Red Interlux Brightside</li> <li>Bulkheads, hull interior and cockpit: White Interlux Brightside</li> <li>Brightwork: Interlux Schooner varnish</li> <li>Forepeak, bilges &amp; lazarette : White Interlux BilgeKote</li> <li>Bottom: Green Interlux Micron CSC</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Deck</strong><br /> <ul> <li>Bow plate: polished bronze casting with integral bow chocks</li> <li>3&rdquo; Flexible PVC cowl vent to forepeak with bronze base</li> <li>8&rdquo; Bronze Herreshoff open-base bow cleat</li> <li>(2) 5 1/2&rdquo; Bronze open open-base, stern cleats</li> <li>Jib boom and mailsail travelers</li> <li>Teak and brass Herreshoff tiller comb</li> <li>Split-hinged (readily removable) and louvered cuddy cabin doors</li> <li>(2) Cockpit lockers</li> <li>Louvered lazarette door</li> <li>Bronze door, locker and running rigging hardware</li> <li>(4) 1/2" Dock lines</li> <li>(3) 6&rdquo; Diameter fenders</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Engine &amp; Mechanical</strong><br /> <ul> <li>Advanced DC Motors FB1-4001A motor at 36VDC with 3:1 reduction</li> <li>1204-018 Curtis Controller</li> <li>ET-Marine throttle with F/R capability &amp; custom bronze handle</li> <li>Albright contactors</li> <li>Aircraft-style voltmeter and ammeter</li> <li>PSS self-aligning shaft seal</li> <li>Stainless steel propeller shaft</li> <li>Streamlined zinc shaft collar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</li> <li>12&rdquo; 2-blade bronze propeller</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Electrical</strong><br /> <ul> <li>Blue Seas Systems 120VAC/60Hz power distribution panel</li> <li>Blue Seas 12VDC Power Distribution Panel</li> <li>(6) Trojan T-105 deep-cycle batteries wired in series.</li> <li>Newmar 36V to 12V DC-DC Converter</li> <li>ProMariner waterproof 36V battery charger</li> <li>Voltmeter and ammeter</li> <li>30 Amp shore power service with nonmetalic boat inlet</li> <li>50&rsquo; 30 Amp 120VAC Marinco shore power cable</li> <li>30 Amp 120VAC adapter for charging with house current</li> <li>(1) Cabin light</li> <li>1 GFCI interrupter duplex outlet</li> <li>Rule automatic bilge pump with in-cabin shut-off</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Spars &amp; Rigging</strong><br /> <ul> <li>Sitka spruce mast, boom and jib boom</li> <li>Teak sheer strake and trim</li> <li>Teak boom crutch</li> <li>Stainless steel wire rope rigging and turnbuckles</li> <li>Dacron running rigging</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Sails &amp; Canvas</strong><br /> <ul> <li>Hood mainsail and club-footed jib</li> <li>Green Sunbrella tent cockpit cover</li> <li>Green Sunbrella jib &amp; mainsail covers</li> <li>Green Sunbrella cockpit seat and V-berth cushions</li> <li>Green Sunbrella mast boot skirt</li> <li>Tyvek full deck cover</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Safety</strong><br /> <ul> <li>Type A/B fire extinguisher</li> <li>(4) Type I PFDs</li> <li>Air horn</li> </ul> </td> </tr> </tbody> </table> </div> <div style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> <table style="font-size: 10pt;" border="0"> <tbody> <tr> <td style="font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><br /><strong>Trailer</strong><br /> <ul> <li>1984 Triad tandem axel with 4-wheel hydraulic surge brakes</li> <li>9&rsquo; Extendable tongue plus the bow stop and ladder</li> <li>Radial tires, new 2013</li> <li>Wiring, lights and hydraulic lines, new 2018</li> <li>Painted 2018</li> </ul> </td> </tr> </tbody> </table> </div> [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] 7993 [empty string] [empty string] E2227022-038E-3453-7B3F86922B6C71BE [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/21-Herreshoff-1983/667 8 The default yacht template for David Walters Yachts 1 Brokerage 1 George George Eberhard Eberhard, George Eberhard (317) 517-4666 667 [empty string]
CACHED false
EXECUTIONTIME 0
SQL SELECT yacht_data.templateREF, yacht_data.isArchived, 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.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_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.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.userPhone, users.userFirstName + ' ' + users.userLastName AS userFullName, users.userLastName + ', ' + users.userFirstName AS userFullName2, yacht_photos.photoID, yacht_photos.photoCaption, yacht_photos.priority, 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 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 ( yachtID = 667 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID