Sold Listing

Solstice | Hylas 46' 2009

Annapolis, MD


Print Yacht Specs



Erik Haaland

View Broker Bio Contact Broker


Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Solstice
Builder: Hylas
Model: 46
Year: 2009
Location: Annapolis, MD
Designer: German Frers
Hull Material: Fiberglass
 

Since the early 1980's Queen Long Marine has been producing some of the world's most renowned sailing yachts. The Hylas 46 started life as the Hylas 44, introduced in 1985, and was so revered that the model was twice updated with the addition of a swim step transom in 1993 to become the Hylas 45.5, and finally a fresh redesign to form the Hylas 46 in 1996. For 24 years the Hylas 46 has been in constant production with 70 hulls delivered and is arguably one of the longest-running blue waters hulls produced. As the model was updated and improved each new hull off the line in Kaohsiung, Taiwan, became even more luxurious, fitted with the best gear available, and second-to-none build quality that rivals every competitor.

Being a semi-custom yacht builder gives owners much latitude in creating their special Hylas. As such no two are the same and you will find differences in every Hylas you see. There is a reason why a Hylas turns every head when it sails by. The lines are timeless, it is not a clumsy, high-freeboard cruising boat that has become all too common, boats where sailing ability and sea-keeping have taken a back seat to floating hotel rooms with sub-par equipment and build quality.

The Hylas 46 has a low-slung deck line and subtle sheer, a destroyer like bow that pierces through the waves and a deep, rounded bottom that cuts through ocean waves with ease. The foils are designed for stability and performance, not only does the H46 have a SA/D of 18.4 but she has almost half of her displacement as ballast. With a generous sail-plan and her Frer's designed hull, the Hylas 46 will take you safely and quickly to your destination. Many Hylas' participate in the Caribbean 1500 and ARC rallies and routinely take top position.

The object of the topic in question is presented before you. 'Solstice' is a 2009 Hylas 46, hull # 66. She is a late model Hylas that was delivered in a time where many yacht builders were found at a financial crossroads. Whereas many comparable listings would just list the specifications and equipment list allow me to tell you the story of 'Solstice' and why this Hylas 46 should be your yacht of choice.

'Solstice' started life being delivered to the Hylas commissioning facility in Riviera Beach, FL. The first owner named her 'Elise' and shortly after taking delivery began a journey of exploration that eventually found them in San Diego CA after cruising the west coast of Mexico and Baja. The boat was been lightly used and impeccably maintained, with the only major work being a repaint of the original Flag Blue gelcoat with the same color in Dupont Imron paint. Imron is a durable 2-part paint that is also repairable and can be buffed that lasts much longer than traditional Awlgrip.

In 2018 the current owners and sellers were looking for a return to the sailing world. They had previously owned a Hylas 54 and after a trip into the world of powerboats decided that they missed the days of sailing. They discovered 'Elise' and had the boat moved to Annapolis to become 'Solstice'. Upon taking ownership they completed a regime of upgrades to ensure that their days on the water were not tarnished. Since 2018 'Solstice' has been lightly cruised on the Chesapeake Bay and spent only the summer of 2019 in the waters of New England. She has always been professionally maintained. The sellers have decided that they wish to start another movement into the powerboat world and such the time has come to pass 'Solstice' onto the next lucky owner.

Take it from the listing agent who has sailed and sold many Hylas', this is not one to miss. 'Solstice' has been cared for lovingly since the beginning. This is not a yacht where the owners have stopped using her and forgotten their responsibilities of yacht ownership. Many items have been recently updated or serviced, the boat is literally in turn-key go sailing tomorrow condition. All systems are fully working as they should and having been surveyed only two years ago we expect no surprises. Compare to the other Hylas 46's on the market and you will find none in better condition.

This is your opportunity to enter the world of Hylas with a yacht that is capable of extended bluewater journeys but has only been lightly cruised while being maintained in bristol condition. Come see why Hylas is one of the world's most revered yacht builders.

Highlights:

  • Always professionally maintained to the highest level with maintenance records available. 2020 Spring commissioning included fresh bottom paint and stripped toe rail coated with 14 coats of Awlbrite.
  • Shoal draft keel drawing 5' 5".
  • 2019 9'/four-person high-pressure floor dinghy and 6HP outboard motor.
  • Hull painted in 2016 with Dupont Imron.
  • 2019 new mainsail and cockpit canvas.
  • Low equipment hours.

Dimensions

Length: 46'
Beam: 13' 9
Draft: 5' 5
Water Tank Capacity: 205 Gallons
Fuel Tank Capacity: 100 Gallons
Holding Tank Capacity: 45 Gallons
Engine Manufacturer: Yanmar
Engine Model: 4JH4-TE
Power: 75 HP
Number of Engines: 1
Fuel Type: Diesel
Engine Hours: 1465 Hours

Major Upgrades & Maintenance

Upgrades

  • 2016 - Imron hull paint, Flag Blue, covering the original Flag Blue gelcoat.
  • 2018 - OceanAir custom fitted shades on salon and master stateroom ports.
  • 2018 - Custom bedding for master stateroom.
  • 2019 - New Elvstrom mainsail.
  • 2019 - New bimini and side curtains.
  • 2019 - New West Marine 9' collapsible dinghy.
  • 2019 - New 6HP Tohatsu outboard motor.
  • 2020 - New in-mast furling motor & control.

Maintenance

  • 2018 - Replaced engine exhaust elbow & tachometer.
  • 2018 - Shop cleaned engine heat exchanger, flushed cooling system & new antifreeze.
  • 2018 - Top-coated toe rail with 2 coats of Epiphanes, repaired damaged areas.
  • 2019 - Replaced generator raw water pump.
  • 2019 - Revarnished cockpit table & drink holder with 3 coats of Epiphanes
  • 2019 - Sanded bottom & 2 coats of bottom paint, replaced zincs, Propspeed on running gear, waxed hull & repainted bow at waterline
  • 2019 - Varnished deck grab rails, cockpit fiddles, & companionway hatch
  • 2020 - Complete refrigeration service, new seals & coolant.
  • 2020 - Stripped toe rail to bare wood & applied 14 coats of Awlbrite.
  • 2020 - Varnished deck grab rails & cockpit fiddles with 2 coats of Epiphanes
  • 2020 - Bottom sanded & 2 coats of bottom paint, replaced zincs, Propspeed on running gear, waxed hull, compounded and waxes topsides.

 

Mechanical

  • Fischer Panda 8kW Genset
  • Mastervolt 130A High Output alternator with three stage regulator
  • Xantrex ProSine 2.0 Inverter/Charger
  • Mastervolt IVO Smart 50A secondary charger
  • Mastervolt generator battery charger
  • Engine bank 2x LifeLine 31 210ah total (2017)
  • Generator bank 1x LifeLine 31 105ah total (2017)
  • Windlass/Thruster bank 1x Mastervolt SL 200ah
  • Three AGM batteries for house bank located under aft berth.
  • 8D AGM battery for engine starting under aft end of dinette with dedicated 60A alternator.
  • Lewmar DU120 1/4hp autopilot drive for Mamba system
  • Bow Thruster/Windlass battery 8D AGM located forward under berth
  • Two zone CruiseAir Reverse Cycle AC/Heat with digital controls and dehumidifier. 12k BTU split system forward for salon, forward cabin and head.
  • Spectra Cape Horn 12V 15gph water maker
  • Vacuflush heads with separate tanks and macerator pumps

Note regarding engine hours, original engine tachometer replaced at 1201 hours. Hours since replacement 264 as noted by new tachometer. Maintenance history available. Current engine hours 1465, generator hours 505.

 

Hull

German Frer's designed the H46 hull with a fine modern entry. The wide beam carries well aft allowing the yacht to surf above her hull speed. This also creates a spacious aft master cabin. The wide sugar-scoop stern offers great deck storage for dive gear as well as easy access to the water for swimming and boarding the dinghy. Well balanced and supported by a partial skeg, the deep spade rudder creates a fun sporty feel under sail.

The hull of the Hylas 46 is completely hand laid solid fiberglass with 8 longitudinal stringers tied to each frame and bulkhead providing an unusually strong seamless monolithic structure in excess of A.B.S. standards. Watertight bulkheads fore and aft. The keel is externally bolted lead using 12 solid stainless steel 1 3/8" bolts with backing plates. The distance between the rudder and keel is measured by design to provide excellent directional stability and balance. The semi-skegged rudder provides for a solid combination of strength, protection, and performance. The bottom of the rudder is 6" higher than the low point of the keel providing protection for the rudder in the event of a grounding.

  • Solid hand-laid fiberglass with no core using vinyl ester resins and Isophthalic gel coat
  • Watertight collision bulkhead forward of forward cabin with independent overboard drainage
  • Watertight Stern sections across aft lazarettes and stern locker
  • Divided Anchor Locker with separate section for fenders and dock lines
  • Large Stern lazarettes, port and starboard with dual Bailey latches for watertight seal
  • Stern Garage with dedicated Rule Auto bilge pump with manual over ride in cockpit
  • Semi skeg-hung rudder for optimizing performance, strength and protection
  • Bottom of rudder plane is above the keel plane for grounding safety

 

Specifics of 'Solstice'

  • Custom Dupont Imron Flag Blue paint in 2016
  • Shoal draft keel drawing 5' 5" (great for the Chesapeake, ICW, and Bahamas!)
  • Side Power 95KFG Bow Thruster
  • Lewmar Mamba steering system (direct linkage from helm to rudder and also incorporates the autopilot drive, no cables to stretch or snap and no hydraulics to leak!)

 

Deck

The deck is fiberglass sandwich construction with balsa core. Solid GRP fiberglass in all areas of the deck for deck fittings and stress areas. The deck is bonded to the hull with 3M 5200 epoxy and thru bolted every 5" with backing plates.

  • Molded non-skid deck in linen beige
  • Solid stainless stem head fitting with split bow anchor rollers
  • Solid Stainless striker plates for bow protection
  • Maxwell 2200 windlass with deck and helm controls
  • Twin Lewmar Delta anchors with separate rodes. Primary anchor all chain, secondary chain to rope.
  • Salt water wash down pump for anchor wash down
  • Two pair of stainless steel 12" bow cleats, pair of 12" midship cleats and one pair of 12" stern cleats
  • Stern rails extended to mid-ship gates; 30" high stanchions with double lifelines
  • Manship 316 stainless overhead hatches and ports throughout
  • Teak Handrails on foredeck coach roof and aft coach roof
  • Stainless steel companionway handrails
  • Stainless steel boarding ladder that mounts at port/starboard lifeline gates
  • Whitlock Pedestal with Navpod and Ritchie 5" Compass
  • Teak varnished cockpit table with teak drink holders
  • Four stainless cowl vents, one pair forward and one pair aft
  • Stainless protective stern plate
  • Hot and cold freshwater shower on stern
  • Fold down stainless stern ladder
  • Inner Forestay Chain plate for optional inner forestay

 

Specifics of 'Solstice'

  • Sail/Anchor Locker forward for large deck access. Separate partitioned areas for two anchor rodes and storage.
  • Teak caprail (just refinished with 14 coats of Awlbrite - 2020)
  • Teak rubrail with stainless steel striker protection
  • Wichard pad-eyes, three total. Two forward end of cockpit on port and starboard, one located center behind helm.
  • Cockpit port light forward end of galley.
  • Solid companionway hatch boards with dark lexan.
  • Two aft opening ports.
  • Teak handrails, varnished.
  • Stern lifeline rails extended to midship gates.
  • Teak decking in cockpit sole and cockpit seating.
  • Cockpit cushions.
  • Centerline stern cleat.
  • Navy Blue canvas covers for hatches, grab rails, and spinnaker pole.
  • Winslow 6 person liferaft (due for service)

 

Sails & Rigging

The rig is a two spreader Selden spar with alloy boom and semi-rigid boom vang is stepped through the deck. The mast is supported by 1 x 19 stainless steel wire and attached to stainless steel chain plates. Mainsail furling is in-mast. The mast and deck are pre-set for the installation of a staysail furler or removable staysail for use as a cutter rig.

  • Selden anodized double spreader mast, with in-mast electric furling
  • Selden Boom with internal preventer system; Rodkicker vang
  • A true 'Blue Water' cruising rig with large, wire cap shrouds, forward and aft lowers
  • Deck level standing rigging terminates with Sta-lok fittings
  • Furlex 400 Series Roller Furling Forestay
  • Primary and secondary Main halyards, primary and secondary Genoa halyards, Spin halyard
  • Halyard Bales on forward dorades

 

'Solstice' Specifics

  • Antal electric primary winches, port and starboard, increased to Antal 60 2-speed size, the same as fitted to a Hylas 54.
  • Antal W48 Secondaries
  • Antal W44 Mainsheet, Coachroof, and Mast Halyard Winches
  • Electric in-mast furling (motor and control replaced - 2020)
  • Selden carbon fiber spinnaker pole with V-Stow Pack for mast mounting with Sunbrella cover
  • Elvstrom Mainsail (2019) and 135% Genoa (refreshed UV cover) with Sunbrella cover
  • Doyle APC cruising spinnaker

 

Electronics & Helm

Helm

  • Raymarine E80 MFD
  • Raymarine ST6002 Autopilot
  • Raymarine ST60+ Speed, Wind, Depth displays
  • Icom CommandMic
  • Side Power Thruster Joystick
  • Ritchie Powerdamp Compass

Nav Station

  • Raymarine E80
  • Icom M604 VHF
  • Alpine IVA-W505 Stereo

Other

  • Raymarine dome radar mounted on mast
  • Raymarine AIS250 Transceiver
  • Hailer horn mounted on mast

 

 

Exclusions

  • Interior rugs except for galley runner.
  • Artwork
  • Personal belongings.

 

VR Tour

Video

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 14.02 [empty string] [empty string] [empty string] Hylas 46' 2009 13' 9 5' 5 27,777 lbs Fiberglass German Frers [empty string] 75 HP Sail Solstice $435,000 Annapolis, MD [empty string] Diesel [empty string] 1465 Hours 1 4JH4-TE Yanmar 45 Gallons 100 Gallons 205 Gallons 46 [empty string] [empty string] November 9, 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 https://my.matterport.com/show/?m=feYyopXCneP [empty string] <p>Since the early 1980's Queen Long Marine has been producing some of the world's most renowned sailing yachts. The Hylas 46 started life as the Hylas 44, introduced in 1985, and was so revered that the model was twice updated with the addition of a swim step transom in 1993 to become the Hylas 45.5, and finally a fresh redesign to form the Hylas 46 in 1996. For 24 years the Hylas 46 has been in constant production with 70 hulls delivered and is arguably one of the longest-running blue waters hulls produced. As the model was updated and improved each new hull off the line in Kaohsiung, Taiwan, became even more luxurious, fitted with the best gear available, and second-to-none build quality that rivals every competitor.</p> <p>Being a semi-custom yacht builder gives owners much latitude in creating their special Hylas. As such no two are the same and you will find differences in every Hylas you see. There is a reason why a Hylas turns every head when it sails by. The lines are timeless, it is not a clumsy, high-freeboard cruising boat that has become all too common, boats where sailing ability and sea-keeping have taken a back seat to floating hotel rooms with sub-par equipment and build quality.</p> <p>The Hylas 46 has a low-slung deck line and subtle sheer, a destroyer like bow that pierces through the waves and a deep, rounded bottom that cuts through ocean waves with ease. The foils are designed for stability and performance, not only does the H46 have a SA/D of 18.4 but she has almost half of her displacement as ballast. With a generous sail-plan and her Frer's designed hull, the Hylas 46 will take you safely and quickly to your destination. Many Hylas' participate in the Caribbean 1500 and ARC rallies and routinely take top position.</p> <p>The object of the topic in question is presented before you. 'Solstice' is a 2009 Hylas 46, hull # 66. She is a late model Hylas that was delivered in a time where many yacht builders were found at a financial crossroads. Whereas many comparable listings would just list the specifications and equipment list allow me to tell you the story of 'Solstice' and why this Hylas 46 should be your yacht of choice.</p> <p>'Solstice' started life being delivered to the Hylas commissioning facility in Riviera Beach, FL. The first owner named her 'Elise' and shortly after taking delivery began a journey of exploration that eventually found them in San Diego CA after cruising the west coast of Mexico and Baja. The boat was been lightly used and impeccably maintained, with the only major work being a repaint of the original Flag Blue gelcoat with the same color in Dupont Imron paint. Imron is a durable 2-part paint that is also repairable and can be buffed that lasts much longer than traditional Awlgrip.</p> <p>In 2018 the current owners and sellers were looking for a return to the sailing world. They had previously owned a Hylas 54 and after a trip into the world of powerboats decided that they missed the days of sailing. They discovered 'Elise' and had the boat moved to Annapolis to become 'Solstice'. Upon taking ownership they completed a regime of upgrades to ensure that their days on the water were not tarnished. Since 2018 'Solstice' has been lightly cruised on the Chesapeake Bay and spent only the summer of 2019 in the waters of New England. She has always been professionally maintained. The sellers have decided that they wish to start another movement into the powerboat world and such the time has come to pass 'Solstice' onto the next lucky owner.</p> <p>Take it from the listing agent who has sailed and sold many Hylas', this is not one to miss. 'Solstice' has been cared for lovingly since the beginning. This is not a yacht where the owners have stopped using her and forgotten their responsibilities of yacht ownership. Many items have been recently updated or serviced, the boat is literally in turn-key go sailing tomorrow condition. All systems are fully working as they should and having been surveyed only two years ago we expect no surprises. Compare to the other Hylas 46's on the market and you will find none in better condition.</p> <p>This is your opportunity to enter the world of Hylas with a yacht that is capable of extended bluewater journeys but has only been lightly cruised while being maintained in bristol condition. Come see why Hylas is one of the world's most revered yacht builders.</p> <p><strong>Highlights:</strong></p> <ul> <li>Always professionally maintained to the highest level with maintenance records available. 2020 Spring commissioning included fresh bottom paint and stripped toe rail coated with 14 coats of Awlbrite.</li> <li>Shoal draft keel drawing 5' 5".</li> <li>2019 9'/four-person high-pressure floor dinghy and 6HP outboard motor.</li> <li>Hull painted in 2016 with Dupont Imron.</li> <li>2019 new mainsail and cockpit canvas.</li> <li>Low equipment hours.</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] 15561 [empty string] [empty string] C7AF3B05-9D8D-233D-85A60E02CE86E2BA [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/46-Hylas-2009/1859 13 The default yacht template for David Walters Yachts 1 Brokerage 1 Erik Erik Haaland Haaland, Erik Haaland (410) 279-3027 1859 [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 = 1859 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID