Seki II | Alden 56 2002

Florida


Print Yacht Specs



Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Seki II
Builder: Alden
Model: Hardtop Express
Year: 2002
Location: Florida
 

Seki II is one of the handsomest Alden express yachts built. Its deck house was refined to enhance it's profile. Each interior space was refined with extensive use of curved surfaces to soften the feel of it's living areas. She is equipped for comfortable coastal cruising and would make an excellent choice to do the Great Loop. It's hull shape and custom tabbing enables the captain to choose the proper running angle for safe and efficient operation in all sea conditions. A very special yacht for the discerning owner.

Dimensions
LOA: 56 ft 9 in
Beam: 15 ft 8 in
LWL: 50 ft 5 in
Maximum Draft: 4 ft 6 in
Bridge Clearance: 15 ft 6 in
Dry Weight: 42000 lbs
Engines
Engine 1:
Engine Brand: Caterpillar
Year Built: 2002
Engine Model: 3196E
Engine Type: Inboard
Engine/Fuel Type: Diesel
Engine Hours: 1000
Drive Type: Direct Drive
Engine Power: 660 HP

Engine 2:
Engine Brand: Caterpillar
Year Built: 2002
Engine Model: 3196E
Engine Type: Inboard
Engine/Fuel Type: Diesel
Engine Hours: 1000
Drive Type: Direct Drive
Engine Power: 660 HP
Tanks
Fresh Water Tanks: (470 Gallons)
Fuel Tanks: 1 (615 Gallons)
Holding Tanks: (70 Gallons)
Accommodations
Number of double berths: 2
Number of cabins: 2
Number of heads: 2
Outside Equipment/Extras
Electric windlass

Accommodations

There is an extensive use of curved surfaces to soften the appearance of a cabin, to provide more space in the cabin and facilitate better communication between cabins.

  • See "Layout"
  • Interior woodwork is finely detailed cherry.
  • Floors are solid teak and rock maple.
  • Bridge deck / upper salon overhead is ash with cherry battens.
  • Master stateroom has a center line queen berth.
  • Guest stateroom has a double berth.
  • There are two heads with a shared shower. 
  • Stereo system with speakers through out the boat. Independent volume control in each room and cockpit.
  • Comprehensive lighting options to provide many moods in each cabin.
  • Hancock chairs and Baker sofa in main Salon.
  • TV and DVR. TV retracts out of view when not in use.
  • Helm and companion seating rotate to add to salon seating.
  • Window heights in the main salon allow for easy viewing of surroundings while seated and an enhanced open feel to the boat. 
  • Marine Air Air conditioning systems through out. (3) Zones with Passport II displays. Updated 2017

Navigation & Electronics
  • GPS: Raymarine Raystar 120LP WAAS
  • Radar: Furuno Navnet 1943 plotter; 4 years old, last production series
  • ARP 11 Radar Autopilot 
  • Depth: Furuno Netwiork sounder ETR 6/10N; 2 EA
  • Autopilot: Robertson AP20 Pilot
  • Raymarine ST60 Tridata speed and depth.
  • RF300 rudder reference
  • RFC35 Compass
  • RPU80 Pump
  • J300X Junction Unit
  • Gyro Compass: KVH Gyro Trac Sensor
  • KVH advanced digital control unit 
  • Analog Compass: Richie navigator compass
  • Raymarine STSO wind system analog vane
  • VHF: Standard spectrum VHF DSC
  • Inclinometer: US digital CA-8 inclinometer
  • ED-2 readout

Engines/Mechanical
  • Twin Caterpillar 3196E diesel engines (660 hp each). ZF transmissions.
  • After coolers were replaced as part of a program by Caterpillar to remedy a manufacturing defect.
  • Northern Lights generator (16kw).
  • Dual Racor fuel filters.
  • Oil change system.
  • Auto fire extinguisher system.
  • Bow Thruster.
  • Custom trim tab system.
  • Engine power switch: common ground
  • Toggle switch panel
  • Level 1- EVD Panel
  • ZF gearbox 2000017012
  • AF oil filter 3213308019
  • ZF MC2000 control head
  • ZF handheld micro commander/clear command
  • Packless sealing system
  • Racor 75/900 Max (180gal)
  • Large engine room with easy access to all sides of the engines. 
  • (4) bilge pumps with condition indicators at the helm.

Electrical
  • Xantrex Freedom SW 
  • Sine Wave inverter/charger SW 3012
  • Xanbus system control panel SCP
  • Xantrex Link 10 meter
  • Xintex CMD- 3M marine carbon monoxide detector
  • 50 amp shore power chords with fore and aft retrievers.
  • 16kW Generator (Northern Lights)
  • 12 volt system. (4) 8D AGM house batteries, (2) 8D GPL engine batteries, (1) GPL -27 AGM Generator battery.
  • Dedicated Alternators for Engine, House and Generator battery charging.
  • 120volt, 50 Amp service.
  • Wired for KVH antenna.

Hull and deck

Hunt designed deep V hull with pocketed props. A modest beam to length ratio gives Seki impressive performance figures and ride, not found on her wide beam counter parts.

  • Fully enclosed bridge deck and salon, with 360 degree visibility at speed and at the dock. 
  • Beautiful deep cockpit with removable awning.
  • Wide side decks with contrasting non-skid and teak toe rails.
  • Transom door leading to TNT submerging dinghy platform.
  • Hot and Cold cockpit shower. (Atwood)
  • Bow pulpit with Ocean Concert Capstan windlass.
  • Deck wash down system (Atwood).
  • Stainless railings with custom stainless safety lattice.
  • ACR remote spot light.
  • Kahlenberg air horn.
  • Exalto windshield wipers and electronic controls.
  • Thru hulls, valves and strainers are bronze. (Groco)
  • Teak decking on cockpit sole. 
  • Flag Blue Awl Grip hull. (Clear coated)

Galley

Beautiful C-shaped galley with cherry cabinets and corian counter tops. Abundant storage and counter space. Opening port and circular hatch for ventilation.

  • Sub-zero Refrigerator and freezer Model 249.
  • Gaggenau Oven model HLE- B27 3700W
  • Gaggenau Glass/ceramic HOB (Cook top) with super quick cooking zones.
  • Gaggenau HOB Ventilator.
  • Icer-ette Ice cube maker.
  • Franke Little Butler Waste Disposal.
  • Raritan 20 gal. water heater.
  • Groco Paragon Senior water pressure system.
  • Washer/Dryer (under companionway steps)

Heads

Dual heads with full size shower accessible from each head. Cherry cabinetry with curved Corian counter tops and gold fixtures. Large beveled mirrors.

  • Two Wilcox Tecma electric heads with holding tank and by pass valve for offshore discharge outside US waters.
  • Molded sinks integral to the

Dimensions

Length: 56
Beam: 15' 8
Draft: 4' 6
Power: 660HP
Engine Hours: John Osetek
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 17.07 [empty string] [empty string] [empty string] Alden 56 2002 15' 8 4' 6 [empty string] [empty string] [empty string] (2) Caterpillar 660HP Power Seki II $450,000 Florida [empty string] [empty string] http://www.davidwaltersyachts.com/yacht-details.cfm?y=5775315 John Osetek [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Hardtop Express [empty string] [empty string] September 5, 2017 $440,000 John Osetek & George Eberhard [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] 0 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>Seki II is one of the handsomest Alden express yachts built. Its deck house was refined to enhance it's profile. Each interior space was refined with extensive use of curved surfaces to soften the feel of it's living areas. She is equipped for comfortable coastal cruising and would make an excellent choice to do the Great Loop. It's hull shape and custom tabbing enables the captain to choose the proper running angle for safe and efficient operation in all sea conditions. A very special yacht for the discerning owner.</p> <div class="two-col"> <dl> <dt>Dimensions</dt> <dd>LOA: 56 ft 9 in<br />Beam: 15 ft 8 in<br />LWL: 50 ft 5 in<br />Maximum Draft: 4 ft 6 in<br />Bridge Clearance: 15 ft 6 in<br />Dry Weight: 42000 lbs</dd> </dl> <dl> <dt>Engines</dt> <dd>Engine 1:<br />Engine Brand: Caterpillar<br />Year Built: 2002<br />Engine Model: 3196E<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 1000<br />Drive Type: Direct Drive<br />Engine Power: 660 HP<br /><br />Engine 2:<br />Engine Brand: Caterpillar<br />Year Built: 2002<br />Engine Model: 3196E<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 1000<br />Drive Type: Direct Drive<br />Engine Power: 660 HP</dd> </dl> <dl> <dt>Tanks</dt> <dd>Fresh Water Tanks: (470 Gallons)<br />Fuel Tanks: 1 (615 Gallons)<br />Holding Tanks: (70 Gallons)</dd> </dl> <dl> <dt>Accommodations</dt> <dd>Number of double berths: 2<br />Number of cabins: 2<br />Number of heads: 2</dd> </dl> <dl> <dt>Outside Equipment/Extras</dt> <dd>Electric windlass</dd> </dl> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Accommodations</strong><br /> <p>There is an extensive use of curved surfaces to soften the appearance of a cabin, to provide more space in the cabin and facilitate better communication between cabins.</p> <ul> <li>See "Layout"</li> <li>Interior woodwork is finely detailed cherry.</li> <li>Floors are solid teak and rock maple.</li> <li>Bridge deck / upper salon overhead is ash with cherry battens.</li> <li>Master stateroom has a center line queen berth.</li> <li>Guest stateroom has a double berth.</li> <li>There are two heads with a shared shower.&nbsp;</li> <li>Stereo system with speakers through out the boat. Independent volume control in each room and cockpit.</li> <li>Comprehensive lighting options to provide many moods in each cabin.</li> <li>Hancock chairs and Baker sofa in main Salon.</li> <li>TV and DVR. TV retracts out of view when not in use.</li> <li>Helm and companion seating rotate to add to salon seating.</li> <li>Window heights in the main salon allow for easy viewing of surroundings while seated and an enhanced open feel to the boat.&nbsp;</li> <li>Marine Air Air conditioning systems through out. (3) Zones with Passport II displays. Updated 2017</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Navigation &amp; Electronics</strong><br /> <ul> <li>GPS: Raymarine Raystar 120LP WAAS</li> <li>Radar: Furuno Navnet 1943 plotter;&nbsp;4 years old, last production series</li> <li>ARP 11 Radar Autopilot&nbsp;</li> <li>Depth: Furuno Netwiork sounder ETR 6/10N; 2 EA</li> <li>Autopilot: Robertson AP20 Pilot</li> <li>Raymarine ST60 Tridata speed and depth.</li> <li>RF300 rudder reference</li> <li>RFC35 Compass</li> <li>RPU80 Pump</li> <li>J300X Junction Unit</li> <li>Gyro Compass: KVH Gyro Trac Sensor</li> <li>KVH advanced digital control unit&nbsp;</li> <li>Analog Compass: Richie navigator compass</li> <li>Raymarine STSO wind system analog vane</li> <li>VHF: Standard spectrum VHF DSC</li> <li>Inclinometer: US digital CA-8 inclinometer</li> <li>ED-2 readout</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Engines/Mechanical</strong><br /> <ul> <li>Twin Caterpillar 3196E diesel engines (660 hp each). ZF transmissions.</li> <li>After coolers were replaced as part of a program by Caterpillar to remedy a manufacturing defect.</li> <li>Northern Lights generator (16kw).</li> <li>Dual Racor fuel filters.</li> <li>Oil change system.</li> <li>Auto fire extinguisher system.</li> <li>Bow Thruster.</li> <li>Custom trim tab system.</li> <li>Engine power switch: common ground</li> <li>Toggle switch panel</li> <li>Level 1- EVD Panel</li> <li>ZF gearbox 2000017012</li> <li>AF oil filter 3213308019</li> <li>ZF MC2000 control head</li> <li>ZF handheld micro commander/clear command</li> <li>Packless sealing system</li> <li>Racor 75/900 Max (180gal)</li> <li>Large engine room with easy access to all sides of the engines.&nbsp;</li> <li>(4) bilge pumps with condition indicators at the helm.</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Electrical</strong><br /> <ul> <li>Xantrex Freedom SW&nbsp;</li> <li>Sine Wave inverter/charger SW 3012</li> <li>Xanbus system control panel SCP</li> <li>Xantrex Link 10 meter</li> <li>Xintex CMD- 3M marine carbon monoxide detector</li> <li>50 amp shore power chords with fore and aft retrievers.</li> <li>16kW Generator (Northern Lights)</li> <li>12 volt system. (4) 8D AGM house batteries, (2) 8D GPL engine batteries, (1) GPL -27 AGM Generator battery.</li> <li>Dedicated Alternators for Engine, House and Generator battery charging.</li> <li>120volt, 50 Amp service.</li> <li>Wired for KVH antenna.</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Hull and deck</strong><br /> <p>Hunt designed deep V hull with pocketed props. A modest beam to length ratio gives Seki impressive performance figures and ride, not found on her wide beam counter parts.</p> <ul> <li>Fully enclosed bridge deck and salon, with 360 degree visibility at speed and at the dock.&nbsp;</li> <li>Beautiful deep cockpit with removable awning.</li> <li>Wide side decks with contrasting non-skid and teak toe rails.</li> <li>Transom door leading to TNT submerging dinghy platform.</li> <li>Hot and Cold cockpit shower. (Atwood)</li> <li>Bow pulpit with Ocean Concert Capstan windlass.</li> <li>Deck wash down system (Atwood).</li> <li>Stainless railings with custom stainless safety lattice.</li> <li>ACR remote spot light.</li> <li>Kahlenberg air horn.</li> <li>Exalto windshield wipers and electronic controls.</li> <li>Thru hulls, valves and strainers are bronze. (Groco)</li> <li>Teak decking on cockpit sole.&nbsp;</li> <li>Flag Blue Awl Grip hull. (Clear coated)</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Galley</strong><br /> <p>Beautiful C-shaped galley with cherry cabinets and corian counter tops. Abundant storage and counter space. Opening port and circular hatch for ventilation.</p> <ul> <li>Sub-zero Refrigerator and freezer Model 249.</li> <li>Gaggenau Oven model HLE- B27 3700W</li> <li>Gaggenau Glass/ceramic HOB (Cook top) with super quick cooking zones.</li> <li>Gaggenau HOB Ventilator.</li> <li>Icer-ette Ice cube maker.</li> <li>Franke Little Butler Waste Disposal.</li> <li>Raritan 20 gal. water heater.</li> <li>Groco Paragon Senior water pressure system.</li> <li>Washer/Dryer (under companionway steps)</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Heads</strong><br /> <p>Dual heads with full size shower accessible from each head. Cherry cabinetry with curved Corian counter tops and gold fixtures. Large beveled mirrors.</p> <ul> <li>Two Wilcox Tecma electric heads with holding tank and by pass valve for offshore discharge outside US waters.</li> <li>Molded sinks integral to the</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] 4993 [empty string] [empty string] B8B91AC9-D05B-5C90-0F32B802A0BD681B [empty string] [empty string] https://www.davidwaltersyachts.com/Power/56-Alden-2002/478 10 The default yacht template for David Walters Yachts 1 Brokerage 1 John John Osetek Osetek, John Osetek (401) 465-8634 478 [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 = 478 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID