Sold Listing

Adventure | Hylas 46' 2003

Annapolis, MD


Print Yacht Specs



Erik Haaland

View Broker Bio Contact Broker


Tell Us About Your Ideal Boat

Basic Info

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

Rare offering! 2003 Hylas 46, one owner, lightly used in the Chesapeake and New England, never been to the islands!

Vessel owned by a transferrable Delaware Limited Liability Corporation!

Adventure is the Hylas 46 you've been dreaming of, like a needle in a haystack she's been eluding your searches. Her current and original owners spent much time planning and reviewing other Hylas 46's before placing their custom order. They took delivery of Adventure from Hylas' commissioning facility in Florida in 2003 and took her straight to her home on the Chesapeake Bay. From there she has been to New England several times, but never once been South of the Chesapeake except on her maiden voyage.

Since she was lightly used seasonally (hauled and covered every winter) she is in impeccable condition for the age. Her Yanmar diesel has only 1,000 hours! Her stainless glistens, gelcoat gleams, and down below it's hard to tell she's more than a couple of seasons old!

The Hylas 46 is the top of the game in a sub-50' TRUE blue water capable cruiser. Two large cabins, two large heads, full salon, passage way galley, better mechanical access to engine and generator than any other, center cockpit, and of course the top quality construction and finish work that is unmatched by any builder today. There is a reason why every head turns when a Hylas passes by..

The sellers loved their Hylas 46 so much they've decided for their next boat that it will be another Hylas and are in the build process now! Adventure is seriously for sale and in turn key condition. Contact the central agent today for more details and to schedule your private viewing of Adventure . Will you be the next member of the Hylas family?

- Fall 2018 new bimini, dodger, and enclosure. Enclosure panels have no use and are as new.
- Canvas covers for grab rails, deck hatches, and winches!
- Fixed staysail furler with running backstays!
- Stainless rubrail!
- Electric main furling and electric 2-Speed primary winches!
- Kato davits with dinghy and outboard!
- Only 1,000 engine hours!
- Custom companionway slider screen built in! (Only one ever made to our knowledge!)
- Summer 2019 new Magnum inverter/charger.
- Custom Northshore Canvas winter cover.
- Bow Thruster

Dimensions

Length: 46'
Beam: 13' 9
Draft: 6' 6
Water Tank Capacity: 214 Gallons
Fuel Tank Capacity: 100 Gallons
Engine Manufacturer: Yanmar
Engine Model: 4JH3-TE
Power: 75 HP
Number of Engines: 1
Fuel Type: Diesel
Engine Hours: 1100 Hours

Accommodations

The interior of the Hylas 46 has been thoughtfully arranged for comfort, mobility, and storage. This design is now timeless, as many have now attempted to copy the Hylas layout design, but only Hylas can do it to such perfection.

The salon is arranged with a port U-shaped settee and table. The table maybe lowered to form a berth, and the table center leaf of the table maybe removed and conveniently stored inside the lower portion of the table itself. There is also an ottoman that is adjustable by tracks on the floor, this doubles as another seat at the table, or could be used a low coffee table for the starboard settee! The starboard settee can be pulled out to form a sea berth. There are also two lockers above each settee and a book shelf under the portlights port and starboard. Behind the settee cushions are storage lockers and below the port settee is mechanical and electric access. There is a nice storage locker under the starboard settee.

  • Two zone air conditioning with reverse cycle heat.
  • Alpine AM/FM/CD Player with speakers and amplifier and CD changer.
  • Samsung flatscreen TV and DVD player built into shelving with hide-away door. TV antenna mounted on mast.

 

Forward Cabin

Forward of the salon is the guest stateroom. This private stateroom comes with fitted with an en-suite head and plenty of storage. The berth is a Pullman on the Port side, while on Starboard there are two hanging lockers and a locker with shelves. Above the berth is more storage, including two custom fitted bookshelves. Below the berth is much more storage in drawers and access to batteries and the forward air conditioner.

  • Custom book shelves.
  • Two hanging lockers and another locker with shelves.
  • Storage cubbies.
  • Pullman berth with foam mattress.
  • Three stainless steel opening port lights.
  • Large Manship deck hatch with bug screen and canvas cover.
  • Separate fan unit for air conditioner in forward cabin, variable fan speed.

 

Forward Head

In the forepeak is a large head, private to the forward stateroom. To starboard there is a vanity with sink and four mirrors with storage behind. Beneath the sink is access to the head thru-hulls and the manual waste discharge pump for the holding tank. The head is manually operated. To port there are two lockers and forward there is a large storage locker for tools or sails. There is also an electric shower sump pump.

  • Manual flush pump toilet.
  • Whale manual waste pump with removable handle.
  • Manship deck ventilation hatch with bug screen and canvas cover.
  • Teak floor grate with shower sump pump.
  • Hot/Cold shower with flip down teak seat.
  • Storage lockers.
  • Mirrors
  • Anchor windlass and bow thruster master disconnect switches.
  • Shower curtain track (curtain not installed).

 

Aft Cabin

A real, stand up head room aft cabin with centerline queen bed. His and her sides, which vanity and pop up mirror on port. Three large lockers with shelves and hanging. Multiple storage cabinets and drawers. Under the bed is the aft water tank and steering gear access.

  • 10,000 BTU air conditioner with reverse cycle heat, SMX II control.
  • Two 12V fans.
  • Large deck hatch and two opening port lights.
  • Full length mirror behind cabin door.

 

Aft Head

The aft head is nicely appointed with a separate shower stall, vanity with mirrors, and an extra large storage cabinet.

  • Manual flush toilet.
  • Sink with hot/cold.
  • Mirrors with storage behind.
  • Opening port light for ventilation.
  • Shower with flip down teak seat.
  • Extra large storage locker that can be converted to fit a washing machine.

 

Galley

One of the hallmarks of the Hylas design is the galley. This area forms the starboard passage to the aft cabin. It is a full length passageway design, this incorporates a generous counter top and two large refrigeration units that top and front load.

  • Inboard, over the engine counter space and double basin stainless steel sink. Mixed with pull out for sprayer.
  • Force10 3-burner stove and oven with broilers. Gimballed. Counter top cover for when not in use. Stainless steel safety bar.
  • Built in cutting board.
  • Hidden trash receptacle.
  • Built in knife storage.
  • Grunert sea-water cooled holding plate refrigerator and freezer.
  • Under deck dry storage.
  • Microwave
  • Pantry
  • Multiple storage drawers and cabinets.

 

Mechanical & Plumbing

  • Air conditioner for salon and forward cabin. 16,000 BTU Reverse Cycle. Split unit with separate compressor and fan unit. Forward cabin fan unit speed adjustable. Main fan unit and temperature controlled from salon SMX II control.
  • Air conditioner for aft cabin. 10,000 BTU Reverse Cycle. Split unit with separate compressor and fan unit. Controlled by SMX II control in aft cabin.
  • Freshwater system three tanks, stainless steel. Port and starboard under salon sole 40 gallons each. Aft tank under aft berth 134 gallons. Primary and backup Shurflo electric pumps, Groucho accumulator pressure tank. 10 gallon water heater 110V/engine heating.
  • Two 50 gallon diesel tanks, stainless steel, under salon sole. Electric diesel fuel priming pump or can be used for fuel polishing.
  • Tank Tender fuel and water tank vacuum gauge.
  • Dual Racor engine fuel filters for easy filter changes while underway. Separate Racor filter and 12V pump for genset.
  • Feathering Autoprop and spare three blade fixed prop.
  • Whale manual bilge pump at Nav station.
  • Greco oil change pump
  • Engine compartment blower.
  • Dripless stuffing box.
  • Stainless steel emergency steering tiller.

 

Electrical

  • Batteries
  • 2x 8D AGM house, 1x 4D AGM house/windlass under forward berth
  • 1x 8D AGM house under starboard settee 2017
  • 1x 4D lead acid engine start under port settee
  • 1x Generator battery under starboard settee (removed for winter storage)
  • All batteries secured in spill proof fiberglass boxes.
  • Summer 2019 New Magnum Inverter/Charger with digital control panel.
  • Xantrex Link10 Battery Monitor
  • Balmar 165A alternator with smart regulator.
  • Hitachi 80A alternator
  • Panda Mini 8kw generator with sound enclosure, 360 hours

 

Electronics & Navigation

  • Fall 2017 New Raymarine GPS Receiver
  • Helm
  • Raymarine RC530+ Radar/Chartplotter
  • Raymarine ST6001+ Autopilot with hydraulic drive unit.
  • Raymarine ST600R Autopilot Remote (Wired)
  • Raymarine ST60 Multi
  • Standard Horizon Remote Mic for VHF
  • Ritchie Powerdamp Compass
  • Companionway
  • Raymarine ST60 Depth
  • Raymarine ST60 Wind
  • Raymarine ST60 Speed
  • Nav Station
  • Raymarine RL80C Radar
  • ICOM M802 SSB with AT140 Tuner and Pactor Modem with USB connection
  • Standard Horizon Spectrum+ VHF with mast mounted hailer/fog horn.

 

Deck Gear

Being a center cockpit design the Hylas 46 has a great amount of space both forward and aft of the cockpit. Starting aft there are two large waist lazarettes plus another locker under the transom steps. Propane is accessible in its own compartment on the starboard deck. The cockpit coaming is fitted with two small lockers for miscellaneous gear. On the bow there is a split anchor locker with port and starboard anchor rodes and a large space for fenders and docklines to be stowed. There is also a sea-water wash down in the anchor locker.

  • Custom winter cover (Northshore Canvas)
  • Fall 2018 New bimini and dodger. Side panels are in as new condition.
  • Transom pulpit fold down stainless and teak seats. (Stored off the boat.)
  • Kato stainless davits
  • Four dorade vents
  • Manship deck hatches
  • Teak and stainless boarding ladder
  • Forward and aft varnished teak grab rails
  • Aluminum toe rail
  • Teak and stainless rubrail
  • Maxwell windlass with foot pedals and helm controls
  • Lewmar Delta anchor with all chain rode
  • Backup anchor rode chain/line.
  • Twin anchor rollers
  • Twin anchor line pipes with covers
  • Anchor locker with separate partitions for two anchor rodes, and storage.
  • Propane locker with two bottles and regulator
  • Hot/Cold freshwater shower on transom
  • 2004 AB RIB Dinghy and 15HP Mercury Outboard included with purchase of Adventure. *Not currently aboard, stored offsite for winter.

 

Sails & Rigging

The Hylas 46 is an excellent sailing yacht. Her German Frers hull design, powerful Selden rig, and cutter sail plan merge to produce a fast and capable yacht in almost any condition.

  • Doyle Sails in-mast furling mainsail, genoa and staysail.
  • Selden electric mainsail in-mast furler.
  • Furlex 400S Genoa and Furlex 300S Staysail with furling lines led aft to clutches.
  • Inboard adjustable staysail tracks (added option)
  • Adjustable genoa track.
  • Selden aluminum mast, two spreader, deck light, steaming light and tricolor.
  • Mast boot renewed - 2019
  • Selden Rodkicker adjustable vang
  • Mast head spinnaker halyard.
  • Adjustable running backstays.
  • (2) Antal W44 stainless winches on mast
  • (2) Antal W48 secondary winches
  • (2) Antal W60 primary winches, electric two speed
  • Antal W44 cabin top winch
  • Antal W44 mainsheet winch
  • Harken traveler

 

Exclusions

The following items do not convey with the sale of Adventure.

  • Duck watercolor in main salon.
  • All carpets.
  • Barometer and clock by nav station.
  • All loose contents of deck lockers, and interior cabinets and drawers, except items original to the boat (emergency tiller, fixed blade spare prop, blue fenders, 45lb Danforth anchor). *Note, Danforth anchor is not currently on the boat.

 

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' 2003 13' 9 6' 6 27,777 lbs Fiberglass German Frers [empty string] 75 HP Sail Adventure $350,000 Annapolis, MD [empty string] Diesel [empty string] 1100 Hours 1 4JH3-TE Yanmar [empty string] 100 Gallons 214 Gallons 46 [empty string] [empty string] July 30, 2020 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] LAB03INT,LAB28STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB02STR,LAB03STR,LAB15STR,LAB01STR,LAB25STR,LAB01MEM,LAB03MEM,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB19STR,LAB21STR,LAB20STR,LAB10STR,LAB18STR,LAB16STR,LAB22STR,LAB23STR,LAB24STR 0 1 [empty string] [empty string] 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 0 [empty string] [empty string] [empty string] Link to Virtual Tour Builder [empty string] [empty string] [empty string] Length [empty string] Sold Yacht Additional Info Year Built [empty string] [empty string] [empty string] Beam [empty string] [empty string] [empty string] Draft [empty string] [empty string] [empty string] Displacement [empty string] [empty string] [empty string] Hull [empty string] [empty string] [empty string] Designer [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Power [empty string] Type (Sail or Power) [empty string] Yacht Name [empty string] Yacht Price [empty string] Location [empty string] Year Refit [empty string] Fuel Type [empty string] [empty string] [empty string] Engine Hours [empty string] Number of Engines [empty string] Engine Model Engine Manufacturer Holding Tank Capacity Fuel Tank Capacity Water Tank Capacity Model [empty string] [empty string] Selling Date [empty string] [empty string] 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [empty string] [empty string] <p>Rare offering! 2003 Hylas 46, one owner, lightly used in the Chesapeake and New England, never been to the islands!</p> <p>Vessel owned by a transferrable Delaware Limited Liability Corporation!</p> <p>Adventure is the Hylas 46 you've been dreaming of, like a needle in a haystack she's been eluding your searches. Her current and original owners spent much time planning and reviewing other Hylas 46's before placing their custom order. They took delivery of Adventure from Hylas' commissioning facility in Florida in 2003 and took her straight to her home on the Chesapeake Bay. From there she has been to New England several times, but never once been South of the Chesapeake except on her maiden voyage.</p> <p>Since she was lightly used seasonally (hauled and covered every winter) she is in impeccable condition for the age. Her Yanmar diesel has only 1,000 hours! Her stainless glistens, gelcoat gleams, and down below it's hard to tell she's more than a couple of seasons old!</p> <p>The Hylas 46 is the top of the game in a sub-50' TRUE blue water capable cruiser. Two large cabins, two large heads, full salon, passage way galley, better mechanical access to engine and generator than any other, center cockpit, and of course the top quality construction and finish work that is unmatched by any builder today. There is a reason why every head turns when a Hylas passes by..</p> <p>The sellers loved their Hylas 46 so much they've decided for their next boat that it will be another Hylas and are in the build process now! Adventure is seriously for sale and in turn key condition. Contact the central agent today for more details and to schedule your private viewing of Adventure . Will you be the next member of the Hylas family?</p> <p>- Fall 2018 new bimini, dodger, and enclosure. Enclosure panels have no use and are as new.<br />- Canvas covers for grab rails, deck hatches, and winches!<br />- Fixed staysail furler with running backstays!<br />- Stainless rubrail!<br />- Electric main furling and electric 2-Speed primary winches!<br />- Kato davits with dinghy and outboard!<br />- Only 1,000 engine hours!<br />- Custom companionway slider screen built in! (Only one ever made to our knowledge!)<br />- Summer 2019 new Magnum inverter/charger.<br />- Custom Northshore Canvas winter cover.<br />- Bow Thruster</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] 11137 [empty string] [empty string] 1D0B58A7-9DE0-E883-02BE0790AAD7753B [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/46-Hylas-2003/773 13 The default yacht template for David Walters Yachts 1 Brokerage 1 Erik Erik Haaland Haaland, Erik Haaland (410) 279-3027 773 [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 = 773 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID