Obsession | Hylas 44 1987

York, VA


Print Yacht Specs



Bernie Jakits & Kate Christensen

View Broker Bio Contact Broker


Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Obsession
Builder: Hylas
Model: 44
Year: 1987
Location: York, VA
Hull Material: Fiberglass
 

You are certainly familiar with the Hylas 46, 49 and 54 as they are among the most sought after boats in our times. But, you may not be as familiar with the Hylas 44 that started it all. The Hylas 44 was designed by German Frers and built by Queen Long Marine in Taiwan from 1984 to 1992. This is a center cockpit offshore cruiser was built with the charter trade in mind as a comfortable ocean going cruiser that was easily sailed by a couple. They became very popular as a commodious two stateroom vessel with a beautiful center cockpit and scooped transom for enjoying the Islands. The Hylas 44 was indeed the predecessor of the 46 and 54 with the beam carried well aft to provide that beautiful aft stateroom..

The interior is one of the lovely features of the Hulas 44 because it was really designed as a perfect charter boat for two couples or a family. They have an offset double berth forward that has a small settee and a private head and shower. The main salon has a lovely rounded dinette arrangement to port with a classic straight settee to starboard. The master stateroom aft has its own ensuite head and shower. The dual walk-throughs proved to be a popular feature so one can access the aft stateroom without disturbing the galley slave. The galley is laid out on the starboard side with the master head and shower on the port side. The master stateroom has a centerline queen on all except the first thirteen hulls which had a berth offset starboard side.

The build quality is there with a solid hand laid fiberglass hull and a network of full length fore and aft stringers and transverse flooring. The deck is a fiberglass sandwich cored with balsa in the eighties, fastened to the hull with 5200 and though-bolted with stainless bolts. The chainplates are massive and they tie into glassed over stainless steel I-beams.

It is with pleasure that we offer you our latest offering the Hylas 44 “Obsession”. This 1987 Hylas 44 is very special as she was never in charter. She also had an extended sugar scoop transom added making her more like the popular Hylas 46. Her first owner’s kept her in the Caribbean where she was on the hard during each hurricane season. They enjoyed many winters cruising in the Caribbean. The second owners purchased the boat in 1999.

The first owners had her shipped to Ft Lauderdale and then spent winters in the Caribbean! They stored the boat on the hard in summers. The current owners purchased their Obsession in January of 1999 and sailed to the Chesapeake Bay. At 12 years old, she was due for a refit and Hartge’s Yard in Galesville was the perfect yard for the job. The new owners had the transom extended in 2000. The mold for the transom extension was actually created by Queen Long Marine for the Hylas 46. The popularity of the Hylas 46 made this a sought after feature. The new owners also had the topsides painted a beautiful Flag Blue.

The current owners have enjoyed the Chesapeake Bay and East Coast. They have maintained the boat in good order giving her what she needed to be a beautiful comfortable and safe home. H

Highlights include:

  • Extended sugar scoop transom in 2000

  • Repowered in 2006 with a new Yanmar diesel engine. new transmission

  • Upgraded running gear with engine

  • Flex O Fold three-blade prop

  • Line cutter installed for New England cruising

  • Custom full cockpit enclosure 2015

  • Custom cockpit cushions by CCushions

  • New interior upholstery

  • Recent sails from 2014 to 2016

  • In mast furling mainsail

  • Removable inner forestay for cutter rig

  • New epoxy bottom in 2012

  • Single side band radio!

  • AIS

  • Coach roof repainted (2018)

  • New UK Genoa (2016)

  • Mast, boom, spinnaker pole repainted (2014)

Dimensions

Length: 44
Beam: 13' 4
Draft: 6'
Water Tank Capacity: 35 Gallons
Fuel Tank Capacity: 33 Gallons
Holding Tank Capacity: 20 Gallons
Engine Manufacturer: Yanmar
Engine Model: 4JHAE
Power: 54 HP
Number of Engines: 1
Fuel Type: Diesel

Accommodations

Hylas accommodations are among their most attractive feature. The Hylas 44 is the predecessor of the Hylas 46 which is sought after for her lovely interior. The Hylas  44 is a similar two stateroom layout center cockpit boat with a lovely salon and walk through galley. Up forward, there is an offset berth and settee as well as a hanging locker, four overhead lockers, and three large drawers for more stowage. This guest cabin is a real stateroom with a private head and shower. The main salon includes a dinette arrangement to port and a starboard settee. The beautiful sought after aft master stateroom is accessed either through the galley or the owners aft head. The dual walk-throughs were a tremendously popular feature and still are. In the aft stateroom there is a fabulous centerline queen berth. The owner's stateroom has plenty of stowage in two hanging lockers, many wall lockers and also under berth drawers. The owner's aft stateroom has it's own ensuite head and stall shower. The galley is loved and it is a safe and secure galley at anchor or in a seaway.

The main salon is lovely with a dinette arrangement to port and a straight settee to starboard that also makes a good sea berth. The dining table is a traditional drop leaf table that extends port and starboard to seat six easily and maybe more. There is lovely cabinetry outboard including a nice liquor cabinet and shelves. The headroom is huge and it is a big plus for tall sailors. Some say it is seven feet. I'd say it is likely easily 6'6'. It accommondates! The interior is lovely of teak with a beautiful teak and holly cabin sole. The Ultrasuade upholstery is teal and looks pretty with the teak. The lighting is nice with a combination  of LED, halogen and fluorescent (some dimmable). It's very nice. You'll be pleased.

Create comforts include the entertainment the flat screen TV and Sirius Radio with the speaker system. You just need your subscription.

 

Galley

The walkthrough galley is on starboard just aft of the salon. It is a complete galley to please any cookie.

  • Mariner 3 burner propane stove w/oven and broiler
  • Microwave oven
  • 12V Frigoboat Refrigeration system w/keel cooler – 2 x 6 cubic feet boxes
  • Double stainless-steel sink w/pressure H&C water, and Whale hand pump
  • Filtered water system
  • Formica countertops, ample storage in 4 cupboards and designated dish, flatware, knife, liquor and trash storage

 

Navigation & Sailing Instruments

  • Standard Horizon Chart Plotter at Nav Station & Cockpit
  • B&G Horizon speed, depth & wind – repeaters in cockpit
  • Sea 322 Single side band radio with Dynoplate
  • Standard Horizon VHF - cockpit
  • Masthead Windex
  • Sunto D-165 6” compass
  • Weems & Plath clock

 

Mechanical Systems

  • Yanmar 4JHAE 54HP new in 2006 in midships engine room w/ access on all sides
  • Approx 925 Engine hours
  • Electric fuel pump – Fuel consumption average 1.33 g.p.h.
  • Single Racor fuel filter
  • Straight drive shaft .. 1-1/2” SS shaft w/Flex o Fold prop
  • PSS Dripless shaft seal
  • Cruising Speed @ 2700 RPM = 7.2 knots
  • Max Speed @ 3100 RPM = 8.3 knots
  • Maintenance log available
  • Single Edson cable, pull/pull steering system
  • Emergency tiller – under aft bunk
  • Edson 32” destroyer wheel
  • 2 zone Air-conditioning 15 & 6 BTU
  • Water heater – 10 gal
  • Electric and manual bilge pumps (4 total)

 

Tankage

  • Fuel – 3 stainless steel –100 gal total
  • Wate 3 stainless steel – 110 gal total
  • Holding – 2 steel – 30 gal total
  • Propane – 2 steel – 40 lbs total

 

Electrical Systems

110 & 12V

  • House bank batteries: 2ea 4D Decca Gel -under Nav seat
  • Starting battery: 1 Group 27
  • 80 Amp Engine alternator w/internal regulator
  • Link System battery monitor
  • DC and AC Breaker panels at Nav
  • Xantrex Battery charger
  • 2 x 30 Amp shore power inlets and cords
  • 4 AC outlets
  • 2000 Watt Inverter

 

Sails & Rigging

  • Keel stepped Norseman mast – Bridge clearance 63’
  • Repainted 2011
  • Rigging inspected 2011
  • Fixed backstays (Port side running backstay replaced )
  • SailtecHydraulic backstay adjusters
  • Sloop rig w/removeable inner forestay
  • Inboard jib car tracks
  • Mainsheet at end-boom and traveler
  • Manual boom vang
  • Spinnaker pole on mast w/traveler
  • Internal spinnaker, genoa, & staysail halyards
  • Total Sail area = 864
  • Mainsail Kappa crosscut w/ in-mast furling
  • UK Tri-Radial 135 (new 2016) on ProFurl furling system
  • Storm Jib on removeable inner forestay
  • Asymmetrical Tri-radial spinnaker in sock
  • Hank-on staysail
  • Winches – all serviced annually
  • Jib Sheet winches – (2) Barient 35 ST
  • Staysail winches – (2) Barient 27
  • Mainsheet winch – Barient 27 ST
  • Halyard winches – (2) Barient 24 ST on mast
  • Genoa furling line winch – Barient 27

 

Hull & Deck

  • Hull -Hand laminated reinforced fiberglass hull w/lead keel
  • Pettit Hydrocoat SR 2018
  • Atkins & Hoyle opening ports (12)
  • Opening hatches w/screens (4)
  • Deck - Airex cored deck covered in teak
  • Dual companionway aft
  • Cockpit table and cushions
  • Cockpit shower (cold)
  • Teak cockpit sole and settee
  • Cockpit lockers (3)
  • Skeg Rudder – High density foam blade w/skeg & stainless post
  • Double bow rollers
  • Maxwell 1000 windlass w/rope & chain gypsy
  • Anchor washdown system
  • 45lb CQR w/300’ 5/16 HT chain
  • 35lb CQR w/ 20’ chain & 300’ nylon rode
  • Danforth stern anchor

 

Dinghy

  • 2006 AB 290 VL 9’6” RIB
  • Nissan 8 hp outboard

 

Canvas

  • Full cockpit enclosure (2015)
  • Dodger, bimini w/grabrail
  • Sun awning – 2 covers from mast to stern; mast to bow w/side curtains
  • Instrument covers
  • Cockpit cushions & 2 Sport-a-seats

 

Safety Equipment

  • Man overboard pole attached to horseshoe and lifesling
  • ACR EPIRB
  • 6 man Avon life raft in hand valise (2003 last inspection)
    • Teak holder on aft deck
  • Misc. PFDs, fenders, dock lines, fire extinguishers, horn, etc.
  • Propane detector
  • Jack lines
  • GFI outlets (2)

 

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 13.41 [empty string] [empty string] [empty string] Hylas 44 1987 13' 4 6' 22,320 lbs Fiberglass [empty string] 2006 Yanmar 4JHAE 54 HP Sail Obsession $129,000 York, VA [empty string] Diesel https://www.davidwaltersyachts.com/yacht-details.cfm?y=6914956 [empty string] 1 4JHAE Yanmar 20 Gallons 33 Gallons 35 Gallons 44 [empty string] [empty string] June 19, 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 style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">You are certainly familiar with the Hylas 46, 49 and 54 as they are among the most sought after boats in our times. But, you may not be as familiar with the Hylas 44 that started it all. The Hylas 44 was designed by German Frers and built by Queen Long Marine in Taiwan from 1984 to 1992. This is a center cockpit offshore cruiser was built with the charter trade in mind as a comfortable ocean going cruiser that was easily sailed by a couple. They became very popular as a commodious two stateroom vessel with a beautiful center cockpit and scooped transom for enjoying the Islands. The Hylas 44 was indeed the predecessor of the 46 and 54 with the beam carried well aft to provide that beautiful aft stateroom..</p> <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">The interior is one of the lovely features of the Hulas 44 because it was really designed as a perfect charter boat for two couples or a family. They have an offset double berth forward that has a small settee and a private head and shower. The main salon has a lovely rounded dinette arrangement to port with a classic straight settee to starboard. The master stateroom aft has its own ensuite head and shower. The dual walk-throughs proved to be a popular feature so one can access the aft stateroom without disturbing the galley slave. The galley is laid out on the starboard side with the master head and shower on the port side. The master stateroom has a centerline queen on all except the first thirteen hulls which had a berth offset starboard side.</p> <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">The build quality is there with a solid hand laid fiberglass hull and a network of full length fore and aft stringers and transverse flooring. The deck is a fiberglass sandwich cored with balsa in the eighties, fastened to the hull with 5200 and though-bolted with stainless bolts. The chainplates are massive and they tie into glassed over stainless steel I-beams.</p> <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">It is with pleasure that we offer you our latest offering the Hylas 44 &ldquo;Obsession&rdquo;. This 1987 Hylas 44 is very special as she was never in charter. She also had an extended sugar scoop transom added making her more like the popular Hylas 46. Her first owner&rsquo;s kept her in the Caribbean where she was on the hard during each hurricane season. They enjoyed many winters cruising in the Caribbean. The second owners purchased the boat in 1999.</p> <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">The first owners had her shipped to Ft Lauderdale and then spent winters in the Caribbean! They stored the boat on the hard in summers. The current owners purchased their Obsession in January of 1999 and sailed to the Chesapeake Bay. At 12 years old, she was due for a refit and Hartge&rsquo;s Yard in Galesville was the perfect yard for the job. The new owners had the transom extended in 2000. The mold for the transom extension was actually created by Queen Long Marine for the Hylas 46. The popularity of the Hylas 46 made this a sought after feature. The new owners also had the topsides painted a beautiful Flag Blue.</p> <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">The current owners have enjoyed the Chesapeake Bay and East Coast. They have maintained the boat in good order giving her what she needed to be a beautiful comfortable and safe home. H</p> <p style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;">Highlights include:</p> <ul style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;"> <li> <p>Extended sugar scoop transom in 2000</p> </li> <li> <p>Repowered in 2006 with a new Yanmar diesel engine. new transmission</p> </li> <li> <p>Upgraded running gear with engine</p> </li> <li> <p>Flex O Fold three-blade prop</p> </li> <li> <p>Line cutter installed for New England cruising</p> </li> <li> <p>Custom full cockpit enclosure 2015</p> </li> <li> <p>Custom cockpit cushions by CCushions</p> </li> <li> <p>New interior upholstery</p> </li> <li> <p>Recent sails from 2014 to 2016</p> </li> <li> <p>In mast furling mainsail</p> </li> <li> <p>Removable inner forestay for cutter rig</p> </li> <li> <p>New epoxy bottom in 2012</p> </li> <li> <p>Single side band radio!</p> </li> <li> <p>AIS</p> </li> </ul> <ul style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;"> <li> <p>Coach roof repainted (2018)</p> </li> <li> <p>New UK Genoa (2016)</p> </li> </ul> <ul style="font-family: Verdana, Helvetica, sans-serif; font-size: 13.3333px;"> <li>Mast, boom, spinnaker pole repainted (2014)</li> </ul> [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] 9240 [empty string] [empty string] 62C3C1AD-A3C6-821D-130D5BF51CA5F9C1 [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/44-Hylas-1987/685 12 The default yacht template for David Walters Yachts 1 Brokerage 1 Bernie Jakits Bernie Jakits & Kate Christensen & Kate Christensen, Bernie Jakits & Kate Christensen (443) 742-1792 685 [empty string]
CACHED false
EXECUTIONTIME 50
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 = 685 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID