Sold Listing
side deck
Cockpit
Entertainment
Salon

Lizzie | Hylas 54 1999

Fort Lauderdale, FL


Print Yacht Specs



George Eberhard

View Broker Bio Contact Broker


Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Lizzie
Builder: Hylas
Model: 54
Year: 1999
Location: Fort Lauderdale, FL
Hull Material: Fiberglass
 

“Lizzie” is a HYLAS RS Sailing Vessel designed by German Frers, fabricated by Queen Long Marine as Hull #8 and launched in 1999.

Hull #8 was exhibited by Hylas in the 2000 season boat shows on the East Coast.  Lizzie was purchased by Dr. and Mrs. Norman Bryan the summer of 2001 and move to their home port in Charlevoix, Michigan.  During 2002-2016, Lizzie was sailed exclusively in The Great Lakes from her berth in Charlevoix and stored in heated winter storage for 15 years beginning winter 2001.

Lizzie was refit Winter 2015/Spring 2016 by Torresen’s Marine Services in Muskegon, Michigan. The refit included all new electronics, new galley layout, roller reefing and winches, stern davits for dinghy transport, Diesel engine rebuild with a new transmission. A 6 man Winslow off shore life raft was added to the stern railing.

Lizzie is prepared for short handed, live aboard cruising in style, comfort and safety Recently she has sailed in the Bahamas, coastal waters of the eastern U.S. including Cape Cod and the Vineyard Sound Islands.

She is a special Hylas 54 with New standing rigging, Simpson davits, New Raymarine Electronics, New batteries, New offshore life raft, New sails, lifelines, cockpit cushions, convection microwave, Splendid Washer/dryer combo, ice maker and all new Entertainment equipment including 46’ and 24’ TV’s and blue ray disc players all within the last two years. She’s truly turn key ready for her next adventure.

Dimensions

Length: 54
Beam: 15' 9
Draft: 7'
Water Tank Capacity: 280 Gallons
Fuel Tank Capacity: 275 Gallons
Holding Tank Capacity: 64 Gallons
Engine Manufacturer: Yanmar
Engine Model: 4JH2-UTE
Power: 100 HP
Number of Engines: 1
Fuel Type: Diesel
Engine Hours: 3389 Hours

Walkthrough

LIZZIE is a traditional Raised Deck Salon featuring a beautiful spacious salon, great natural light and comfortable accommodations. To port is the oval dinning table with wrap around seating, to starboard a settee. Several opening ports and overhead hatches provide good light and ventilation. The new 46’ flat screen is mounted against the forward bulkhead. The large Nav. Station is aft and to port with forward facing desk, armed swivel seat, access to the main AC panel, all electronics, radios and excellent storage. The passageway galley to starboard includes a new Induction cook top and Convection microwave. The under counter Splendid Washer/Dryer is also located in the galley, keeping all work duties in one location. Continuing aft the Master suite is bright and well light with natural light.  Six opening port lights and an overhead hatch provide plenty of ventilation. The master suite has good storage everywhere you look.

Moving forward from the main salon the third cabin is to port with over/under bunks and a reasonable amount of storage.  Across from the third cabin is the second head with stand alone shower.  Access to this head is via two entry doors.  The one adjacent to the third cabin and the one from the forward VIP cabin.  The VIP cabin all the way forward has great storage, large hanging lockers, good ventilation and a centerline queen berth.  This layout provides perfect separation for additional cruising partners or weekend guests.

The overall condition of the interior is well above average due in part to her history of mainly fresh water sailing.

Image 9169: "Salon"

 

Electronics

  • 2016 Raymarine i60 Depth Sounder Display at Companion Way.
  • 2016 Raymarine i60 Speed Log Display at Companion Way.
  • 2016 Raymarine i60 Wind Speed and Direction Display at Companion Way.
  • 2016 Raymarine i70 Instrument Display in Nav Pod.
  • 2016 Raymarine P70R Autopilot Controller in Nav Pod.
  • 2016 Raymarine 12 Inch E Series Hybrid Touch Multifunction Display at Pod.
  • Radar - 24 Inch Raymarine Digital Color Radome Scanner on Radar Bracket.
  • DVD player
  • CD Player
  • Radar Deflector
  • Computer
  • Cockpit speakers
  • VHF

Image 9147: "Nav Station"

 

Mechanical

  • Air Conditioning with Reverse Cycle and 3 Zones
  • Onan Diesel Generator, engine Rebuilt in 2016 with 520 Hours
  • AGM generator Start Battery
  • Generator Racor Fuel Filters
  • Generator remote start panel at Navigation Station
  • Vetus Bow Thruster 130 KGF with Joystick at Helm
  • 2 Refrigerator Boxes and One Freezer Box with 2 110 Volt Compressors
  • 2016 Portable Ice Maker
  • Broan Electric Trash Compactor
  • 2016 Splendide Washer/Dryer in Galley
  • 2012 Domestic Vacuflush Toilets (2)
  • 2016 GE Advantuim Profile Microwave Convection Infrared Oven
  • 2016 GE Café 4 Burner Induction Cooktop
  • 2016 Simpson Davits Series 10 Electric Davits 300 KG
  • 2 Independent Freshwater Pumps 120 Volt
  • 2016 Tank Tender Fuel and Water Gauges
  • 18 Gallon Seaward Water Heater (AC and Engine Heated)
  • 2 Independent Bilge Pumps
  • Manual Bilge at Nav Station
  • Grey Water Sump with Macerator
  • 9 Hellaturbo Oscillating Fans
  • Back Up Fresh Water Foot Pump at Sink
  • 12 Volt Refrigerator Sump Pump

 

Electrical

  • Onan 9kW Generator with 520 Hours.
  • Xantrex 458 Inverter/Charger.
  • GI 50 Newmarket Galvanic Isolator.
  • Promariner 2430P 24 Volt Charger.
  • Promariner 1220P 12 Volt Charger.
  • Balmar AR5 Multistage 12 Volt Voltage Regulator.
  • Balmar 120 Amp 24 Volt Alternator.
  • Balmar 150 Amp 12 Bolt Alternator.
  • Balmar 24 Volt Multistage Marine Regulator.
  • All 2016 & 2017 Batteries are AGM, Self Contained & Strapped Down.
  • Shore Power 220V/50A with Mid Ship Connection.
  • 2 50 Foot Shore Power Cords, 1 25 Foot Shore Power Cord.
  • Telephone and Cable Shore Power Connectors.
  • LED Interior & Exterior Lighting.
  • 2 8D AGM 24 Volt Bow Thruster/Windlass Batteries.
  • 2 8D AGM 12 Volt House Batteries.
  • 2 8D AGM 12 Volt Engine/Generator Start Batteries.
  • 2 Gel Deep Cycle 31 24 Volt Electric Davit Batteries (New in Summer 2018).
  • All Wire is Tinned

 

Hull & Deck

  • Awlgrip in Flag Blue, Red Boot Stripes, Gold Cove Stripes.
  • 2018 New Red Bottom Paint and Epoxy Barrier Coat.
  • Twaron Hull, Carbon Aramide Fiber.
  • Balsa Core Deck.
  • Teak Rub Rails with Stainless Steel Striker Plates.
  • 2018 Varnished Teak Cap Rails.
  • Vetus Side Power Bow Thruster (130 KGF) Joystick at Helm.
  • Watertight Stern Sections, Access Aft Lazarette and Stern Locker.
  • Salt Water Wash Down Connection at Bow.
  • Fresh Water Wash Down Connection at Port Lazarette.
  • Hot and Cold Shower in Aft Lazarette.
  • Magma Marine BBQ Mounted on Aft Rail.
  • 2 Teak Stern Pushpit Seats.
  • Simpson Electric Davits (300KG).
  • Stern Pushpit Stainless Steel Life Cradle Winslow 6 Man Offshore Raft.
  • Closed Chocks at Bow, Midship, Stern.
  • Step Down Sail Locker.
  • Varnished Teak Cabin Top Handrails.
  • 32 Inch High Stanchions, 1.25 Inch in Diameter with Double Coated Life Lines.
  • Whisper Grey Molded Contrasting Non Skid Surface.
  • Transom Opening Ports.
  • Antenna Pole Aft with Intellium i4 TV Dish & AIS.
  • Fold Down Stainless Steel Transom Swim Ladder.
  • Port & Starboard Life Ring Brackets with Horseshoe Life Rings.
  • 2 Electric Lewmar 66ST Primary Winches.
  • 2 Electric Lewmar 48 Sheet Winches.
  • 2 Electric Lewmar 48S Staysail Sheet Winches.
  • Whitlock Royale Pedestal with Rope Whipped stainless steel Wheel.
  • Teak & stainless Side Boarding Ladder.
  • Varnished Teak Grates on Cockpit Floor.
  • 4 Stainless Dorade Vents.
  • Partial Skeg Rudder.
  • Solid Lead Keel with 35MM Stainless Steel Bolt

Image 9167: "side deck"

 

Cockpit

  • 2017 Custom Cockpit Cushions in Navy Sunbrella Stripe Over Varnished Teak Seats
  • 3 Removable Varnished Teak Grates
  • Whitlock Royale Pedestal
  • 34 Inch Rope Whipped Stainless Steel Wheel.
  • Nav Pod Instrument Pod
  • Varnished Teak Cockpit Table Extended with Teak 4 Drink Holder
  • Yanmar Engine Control at Pedestal
  • Companion Way Varnished Teak Louvered hatch Boards
  • 2 Waterproof Infinity 8 Inch Speakers with Controller Rheostat
  • ICOM VHF Radio Mic at Helm
  • Yanmar Engine Control Panel in Starboard Combing
  • Lighting Control Panel with Bilge Indicators in Port Combing.
  • Ritchie 5 Inch Compass with Stainless Steel Housing
  • 10 Electric Controllers for Winches and all Roller Furling in Cockpit
  • 2016 Raymarine i60 Depth Sounder Display at Companion Way
  • 2016 Raymarine i60 Speed Log Display at Companion Way
  • 2016 Raymarine i60 Wind Speed and Direction Display at Companion Way
  • 2016 Raymarine i70 Instrument Display in Nav Pod
  • 2016 Raymarine P70R Autopilot Controller in Nav Pod
  • 2016 Raymarine 12 Inch E Series Hybrid Touch Multifunction Display at Pod

Image 9168: "Cockpit"

 

Ground Tackle

  • Maxwell 3500 Windlass with Bow Controls, and Helm Controls
  • Windlass Canvas Cover in Captain Navy Sunbrella
  • Anchor Salt Water Wash Down in Anchor Well
  • 2017 Mantas Stainless Steel 115 Pound Primary Anchor
  • Spade Stainless Steel 65 Pound Secondary Anchor
  • 300 Foot Galvanized BBB Chain for Primary Anchor
  • 300 Foot Galvanized BBB Chain for Secondary Anchor
  • 2 150 Foot ¾ Inch Anchor Road
  • Para Sea Anchor
  • 2 extra Bow Cleats
  • Multiple Navy Blue Dock Lines
  • 4 Inflatable Fenders
  • 3 White Fenders with Navy Covers
  • 3 Assorted Size Fenders

 

Rigging

  • 2016 All Standing Rigging Replaced
  • 2017 All Double Coated Life Line Replaced
  • Selden Electric in Mast Furling Control in Cockpit
  • Selden Furlex Electronic Roller Furling Genoa
  • Selden Furlex Electric Roller Furling Staysail
  • Dyneema Running Back Stays
  • 78 Foot Selden Aluminum Mast wiyh Double Spreader Rig
  • LED Mast Head Light, Tricolor and Anchor Light
  • Fore Deck Light
  • Selden Compression Vang/Kicker
  • Stay Sail Cars
  • Genoa Cars
  • 2 Lewmar 48S Halyard Winches on Mast
  • Aluminum Mast Painted with Awlgrip White
  • Air TV Antenna and Bracket Mounted at First Spreader on Mast
  • Kahlenberg Compressed Air Horn Mounted Under Radar
  • 24 Inch Raymarine Digital Color Radome Scanner on Radar Bracket
  • 8 Mast Steps to Spreader
  • 2 Shakespeare VHF Antenna at Mast Top
  • Raymarine Wind Transducer at Mast Top
  • Visual Apparent Wind Indicator at Mast Top
  • Spinnaker Halyard
  • Boom Light
  • 2 Lewmar Electric Primary Winches #66 Winches
  • 2 Lewmar Electric Secondary Winches #48 Winches
  • 1 Lewmar Electric Mainsheet Winch
  • 1 Lewmar Electric Outhaul Winch

Image 8563: "Boom"

 

Sails

  • 2016 North Sails 135% Genoa in Dacron with UV Cover in Navy
  • 2016 North Sails Stay Sail in Dacron with UV Cover in Navy
  • 2014 North Sails Main Sail in Dacron with UV Cover in Navy
  • Refurbished Spare Doyle Main Sail Stored in Sail Locker

 

Canvas

  • Canvas Enclosure is in Sunbrella Captains Navy
  • Dodger Connects to Bimini with 6’2” Clearance
  • Full Cockpit Enclosure, 8 Panels, 3 Doors with Screens
  • 7 Hatch Cover
  • 2 Stern Seat Covers Protecting Teak Seats
  • 1 Fitted Windless Cover
  • 1 Flag Glove with U.S.A. Flag

 

Entertainment

  • 2016 46 Inch Samsung Smart TV in Main Salon. 2016 Bose TV Sound Bar in Main Salon
  • 2016 Samsung Blue Ray Disc Player in Main Salon
  • 2016 Intellium i4 Satellite TV Dish
  • 2016 24 Inch Samsung Flat Screen TV Mounted in V-Berth
  • 2016 Digix Blue Ray Disc Player Mounted in in V-Berth
  • 2016 Panasonic Digital Blue Tooth Stereo Radio with 4 Speakers
  • 2016 Shakespeare Sea Watch 19 Inch HDTV Antennae

 

Safety

  • 4 Fire Extinguishers
  • 2016 Winslow 6 Man Offshore Life Raft in Valise
  • 2 Horseshoe Life Rings
  • Life Sling
  • EPIRB 406MHZ
  • MOB Lights
  • 50 Foot Throw Rope
  • Flares, Parachute Flares, Day Smoke
  • 2017 Battery Operated LED Flare
  • Emergency Tiller
  • Kahlenberg Air Horn with Fog Response Encoded
  • Parachute Sea Anchor
  • 10 Life Jackets
  • All Systems Controlled Within Cockpit

 

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 16.46 [empty string] [empty string] [empty string] Hylas 54 1999 15' 9 7' 41,184 lbs Fiberglass [empty string] Yanmar 100 HP Sail Lizzie $549,000 Fort Lauderdale, FL [empty string] Diesel https://www.davidwaltersyachts.com/yacht-details.cfm?y=6921965 3389 Hours 1 4JH2-UTE Yanmar 64 Gallons 275 Gallons 280 Gallons 54 [empty string] [empty string] December 23, 2019 [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>&ldquo;Lizzie&rdquo; is a HYLAS RS Sailing Vessel designed by German Frers, fabricated by Queen Long Marine as Hull #8 and launched in 1999.</p> <p>Hull #8 was exhibited by Hylas in the 2000 season boat shows on the East Coast.&nbsp; Lizzie was purchased by Dr. and Mrs. Norman Bryan the summer of 2001 and move to their home port in Charlevoix, Michigan.&nbsp; During 2002-2016, Lizzie was sailed exclusively in The Great Lakes from her berth in Charlevoix and stored in heated winter storage for 15 years beginning winter 2001.</p> <p>Lizzie was refit Winter 2015/Spring 2016 by Torresen&rsquo;s Marine Services in Muskegon, Michigan. The refit included all new electronics, new galley layout, roller reefing and winches,&nbsp;stern davits for dinghy transport, Diesel engine rebuild with a new transmission. A 6 man Winslow off shore life raft was added to the stern railing.</p> <p>Lizzie is prepared for short handed, live aboard cruising in style, comfort and safety Recently she has sailed in the Bahamas, coastal waters of the eastern U.S. including Cape Cod and the Vineyard Sound Islands.</p> <p>She is a special Hylas 54 with New standing rigging, Simpson davits, New Raymarine Electronics, New&nbsp;batteries, New offshore life raft, New sails, lifelines, cockpit cushions, convection microwave, Splendid&nbsp;Washer/dryer combo, ice maker and all new Entertainment equipment including 46&rsquo; and 24&rsquo; TV&rsquo;s and&nbsp;blue ray disc players all within the last two years. She&rsquo;s truly turn key ready for her next adventure.</p> [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] 9214 [empty string] [empty string] 0FB7BD87-D1D1-9320-6D4AFA99447D9B32 [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/54-Hylas-1999/692 8 The default yacht template for David Walters Yachts 1 Brokerage 1 George George Eberhard Eberhard, George Eberhard (317) 517-4666 692 [empty string]
CACHED false
EXECUTIONTIME 37
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 = 692 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID