Sovana | Passport 54.5' 2014

En Route to Fort Lauderdale
$845,000


Print Yacht Specs



Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Sovana
Builder: Passport
Model: 545 Vista
Year: 2014
Location: En Route to Fort Lauderdale
Asking Price: $845,000
Designer: Passport Yachts Design
Hull Material: Fiberglass
 

Sovana is currently located in Richmond California, and will be moving via yacht transport to Fort Lauderdale, with an expected arrival in mid-December. This is your opportunity to have the perfect bluewater cruising yacht with a Bahamas friendly draft for the winter season.

Sovana is a stunning example of the Passport 545 Vista Center Cockpit, designed with luxurious accommodations, beautiful lines, safety, and ease of handling in mind.

The Passport 545 Vista CC was named the 2012 "Cruising Boat of the Year" by Cruising World magazine judges.

Sovana has a sleek profile with an ICW compatible rig. With a 6' shoal draft, she is also perfect for island cruising. The easily handled Solent rig is complete with a Yankee and a self-tacking jib. The fully enclosed, spacious cockpit can easily accommodate a crew of 6 and the helm has a full complement of electronics. The stern features a walk-up transom and stainless steel dinghy davits.

The center cockpit model features two comfortable, full-width staterooms with ensuite heads. The entire interior is crafted with high-quality cherry joinery. The main salon has a light and airy appeal in line with the desire of many modern sailors. The starboard walkthrough galley is easily accessible and is equipped with all the modern conveniences one would expect on a luxury yacht. The navigation station boasts state-of-the-art electronics and an electrical panel. The low-hours 110 hp Yanmar diesel engine can be easily accessed by three inspection panels and a separate door.

Sovana has been maintained in as new condition with numerous upgrades without regard to cost. Compare to the other Passport 545 offerings and you will find that Sovana stands tall. She is easy to see, located in Richmond, CA off of San Francisco Bay.

Recent Major Upgrades

  • New Highfield CL260 PVC tender (2023 model) with Tohatsu 9.8HP outboard (2022)
  • New Northern Lights 6 KW generator (125 hrs)
  • New AGM batteries, for house, engine, inverter and bow thruster
  • New inverter (2017)
  • New Cruise Air X 2 air conditioners/heaters
  • New Force 10 galley stove (2010)
  • Raymarine Hybrid Touch multi displays at helm and nav station
  • New flat screen 40" Samsung TV and Fusion sound system with Bose surround sound speakers
  • New freshwater manifold
  • Interior lighting upgraded with dimmer switches
  • Custom Raven Marine full cockpit enclosure (2020)

Image 17559:

Dimensions

Length: 54.5'
Beam: 15' 6
Draft: 5' 7
Water Tank Capacity: 250 Gallons
Fuel Tank Capacity: 286 Gallons
Holding Tank Capacity: 55 Gallons
Engine Manufacturer: Yanmar
Engine Model: 4JH4-HTE1
Power: 110 HP
Number of Engines: 1
Fuel Type: Diesel
Engine Hours: 850 Hours

Shipyard Updates

The following upgrades were added during the construction of Sovana.

  • Upgrade house batteries from 4D to 8 D
  • D-400 wind generator on custom pole with outboard motor lift and twin antenna arms
  • Fog horn and hailer on mast
  • Tri lens medium passive radar reflector
  • Wifi booster
  • Splendide washer/dryer
  • Ice maker
  • Additional corian surfaces
  • Teak seats on stern rail
  • Colored non skid (grey)
  • Shoal draft 6'
  • Port light in each hull
  • Powder coated mast and boom
  • Side power bow thruster
  • Teak eyebrow
  • Electric ST 46 utility winch
  • Spreader lights
  • Code Zero headsail package
  • Frigoboat digital refrigeration controls
  • Removable starboard settee table
  • Louvered locker
  • Curved companionway steps
  • Vanity and mirror
  • Folding headboard on master berth
  • Ultra leather fabric in main salon
  • Cherry interior
  • Glass fronted crystal liquor locker
  • Teak on stern platform and ladder steps
  • Spectra Little Wonder 12v 400 gal/day watermaker
  • Kato Island dinghy davits
  • Edson O/B motor bracket with rail brace

 

Accommodations

Sovana has a 2 stateroom /2 head interior arrangement with a third double from lowering the dinette table. Features include:

  • Large island queen berth with extra comfortable mattress in the V berth aft of a watertight bulkhead
  • Louvered cherry lockers to port and starboard
  • Two drawers and one locker under bed
  • Sink, vanity, mirror with storage under
  • Medicine cabinet
  • Opening hatch
  • LED lighting
  • Fully air conditioned or heated
  • Teak and holly floors
  • Easy access to the forward head via private entrance
  • The head has a electric marine toilet, storage lockers and an ensuite shower stall

Master Stateroom

  • Large island queen with comfortable custom mattress
  • Fold down headboard at the foot of the bed for optional sleeping position
  • Drawers and lockers with cherry louvered doors
  • Two large hanging lockers and numerous other lockers and drawers
  • Optional mirror with foldout makeup table
  • Large opening hatch and opening ports
  • LED lighting
  • 12v fans
  • Large storage area aft of bunk where cushions for the dinette berth are stored
  • Fully air conditioned or heated
  • The Master head is located to port and is a walkthru to the main salon
  • Features include an electric head that can be used with fresh or salt water flush
  • Vanity, sink, mirror, with storage area
  • Ensuite shower stall with door
  • Full sized entrance to the engine room
  • Opening port and LED lighting

 

Galley

Walk-thru galley to starboard with numerous drawers and louvered cabinet lockers

  • Opening ports and LED and fluorescent lighting
  • Louvered lockers
  • Double Stainless Steel Sinks with covers
  • Force 10 3-Burner Stove with Oven and Broiler (New in 2020)
  • Frigoboat Refrigerator and Freezer with digital controls and smart speed controls
  • Front and top opening refrigeration and freezer compartments
  • Built in Oster Microwave Oven
  • Spacious Corian Countertops
  • Custom Faucets
  • Fresh and Salt Water Foot Pumps
  • Two large pantries
  • Stove Top Cutting Boards
  • Hot and cold pressure water
  • 11 gal hot water tank ( 110v or from engine)
  • Propane solenoid
  • Hot water heater
  • Opening locker with built in spice rack
  • Trash bin

 

Main Salon

  • Beautiful, light and airy salon with large 14mm color tinted windows for scenic views
  • Port and Starboard opening ports in hull
  • Large dinette table that lowers into a double bed for extra guests or family
  • Full length settee berth to starboard with removable settee table
  • Ultra leather seating fabrics
  • Crystal glass liquor cabinet
  • Ice maker
  • Locker with built in printer
  • Three opening lockers with cherry louvered doors
  • Shelves and lockers to port and starboard outboard of the dining area and settee berth
  • Samsung 40" flat screen TV on forward bulkhead
  • Three blue colored skylights for added light and effect
  • Numerous opening ports
  • Opening hatch
  • Fully air conditioned or heated
  • LED lighting
  • Teak and holly floors with locking floorboards

 

Navigation Station

  • Comfortable forward facing navigation area with opening chart table and comfortable seating
  • Raymarine Hybrid Touch 9" chartplotter/radar
  • Raymarine ST 60+ log and speed
  • Raymarine ST 60+ depth sounder
  • Raymarine ST 60+ wind direction and speed
  • Raymarine autopilot
  • VHF radio
  • Iridium Go phone and internet
  • Smart meter for wind generator
  • Full electric panel for 12v and 110v by Blue Sea
  • Tank gauges for fuel, water and holding
  • Inverter remote
  • Battery monitoring gauges
  • Chart table light

 

Engine & Mechanical

  • Yanmar 110 hp diesel engine (850 hrs)
  • 110 amp Balmar alternator
  • Side Power bow thruster with 2 Group 31 batteries
  • 3 blade Max prop
  • CruisAir 36,000 BTU air conditioning or heating
  • Dual Racor fuel filter system
  • Spectra "Little Wonder" 12v 400 GPD watermaker
  • Ice maker
  • Oil changing system
  • Splendid 2100 XC washer/dryer
  • Muir windlass
  • D-400 wind generator

 

Electrical

  • New Northern Lights 6 KW diesel generator (125 hrs)
  • Magnum 2812 inverter/charger with remote
  • 4 X 8 D house batteries
  • 3 X Group 31 engine start, gen start and windlass/bow thruster
  • 4X 12v Hella fans
  • LED lighting
  • 12/110 v Blue Sky custom electric panel
  • Electric bilge pump
  • Floor courtesy lights
  • Oster built in microwave oven

 

Rigging

  • Triple spreader rig with Selden in the mast furling
  • Five internal halyards
  • Hard vang
  • LED masthead tricolor and anchor light
  • Deck and steaming lights
  • Masthead windex
  • 316 stainless steel rigging compression fittings
  • Furlex roller reefing system for yankee and jib
  • 2014 Quantum in-mast furling mainsail
  • 2014 Quantum yankee (carbon fiber laminate)
  • 2014 Quantum working jib, self-tacking
  • Custom Raven Marine full enclosure (New 2020)

 

Deck Equipment & Cockpit

  • Delta 55 lb fast set anchor with chain
  • Custom 316 double bow roller/stem fitting
  • Muir 12v electric windlass
  • Double lifelines with port and starboard gates
  • 6 SS mooring cleats
  • 20 Hood SS opening ports with screens
  • 5 Manship opening hatches
  • Spinlock sheet stoppers in cockpit
  • Custom SS laminated glass windshield
  • Custom sliding hatch board with acrylic insert
  • Custom SS dropping companionway hatch board
  • Custom fiberglass propane tank storage, 2X 20 lbs
  • Custom SS Kato dinghy davits
  • Custom SS boarding ladder on transom
  • SS pulpit and pushpit
  • Built in rail seating in stern
  • Harken Radial #70 ST electric sheet winches
  • Harken Radial #46 ST electric utility winch
  • Harken Radial 2 speed mainsail winch
  • 2 X Harken Radial #46 ST halyard winches
  • 2 lockers for storage at transom
  • 1 locker forward for fender storage
  • Cockpit
  • Edson pedestal steering system with SS steering wheel
  • Raymarine chartplotter, depth, speed, wind autopilot and VHF radio
  • Engine controls
  • Custom cockpit cushions
  • Ritchie SP 5 compass
  • Dodger and full enclosure from Raven Marine
  • Teak cockpit sole
  • Teak cockpit table
  • Emergency steering system with tiller
  • Hot and cold shower on transom

 

Safety

  • Winslow LTE liferaft (needs recertification)
  • Full Coast Guard equipment package including , PFD's, horseshoe buoy, flare kit, fire extinguishers and horn
  • Mooring package, anchor and chain, dock lines and fenders
  • Complete CG navigation lights

 

Additional Unit

  • 2023 Highfield CL260 PVC

 

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.61 [empty string] [empty string] [empty string] Passport 54.5' 2014 15' 6 5' 7 38,500 lbs Fiberglass Passport Yachts Design [empty string] 110 HP Sail Sovana $845,000 En Route to Fort Lauderdale [empty string] Diesel [empty string] 850 Hours 1 4JH4-HTE1 Yanmar 55 Gallons 286 Gallons 250 Gallons 545 Vista [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] 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] 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 [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><strong>Sovana is currently located in Richmond California, and will be moving via yacht transport to Fort Lauderdale, with an expected arrival in mid-December. This is your opportunity to have the perfect bluewater cruising yacht with a Bahamas friendly draft for the winter season.</strong></p> <p>Sovana is a stunning example of the Passport 545 Vista Center Cockpit, designed with luxurious accommodations, beautiful lines, safety, and ease of handling in mind.</p> <p>The Passport 545 Vista CC was named the 2012 "Cruising Boat of the Year" by Cruising World magazine judges.</p> <p>Sovana has a sleek profile with an ICW compatible rig. With a 6' shoal draft, she is also perfect for island cruising. The easily handled Solent rig is complete with a Yankee and a self-tacking jib. The fully enclosed, spacious cockpit can easily accommodate a crew of 6 and the helm has a full complement of electronics. The stern features a walk-up transom and stainless steel dinghy davits.</p> <p>The center cockpit model features two comfortable, full-width staterooms with ensuite heads. The entire interior is crafted with high-quality cherry joinery. The main salon has a light and airy appeal in line with the desire of many modern sailors. The starboard walkthrough galley is easily accessible and is equipped with all the modern conveniences one would expect on a luxury yacht. The navigation station boasts state-of-the-art electronics and an electrical panel. The low-hours 110 hp Yanmar diesel engine can be easily accessed by three inspection panels and a separate door.</p> <p>Sovana has been maintained in as new condition with numerous upgrades without regard to cost. Compare to the other Passport 545 offerings and you will find that Sovana stands tall. She is easy to see, located in Richmond, CA off of San Francisco Bay.</p> <p>Recent Major Upgrades</p> <ul> <li>New Highfield CL260 PVC tender (2023 model) with Tohatsu 9.8HP outboard (2022)</li> <li>New Northern Lights 6 KW generator (125 hrs)</li> <li>New AGM batteries, for house, engine, inverter and bow thruster</li> <li>New inverter (2017)</li> <li>New Cruise Air X 2 air conditioners/heaters</li> <li>New Force 10 galley stove (2010)</li> <li>Raymarine Hybrid Touch multi displays at helm and nav station</li> <li>New flat screen 40" Samsung TV and Fusion sound system with Bose surround sound speakers</li> <li>New freshwater manifold</li> <li>Interior lighting upgraded with dimmer switches</li> <li>Custom Raven Marine full cockpit enclosure (2020)</li> </ul> <p style="text-align: center;"><img src="../../../../photos/yachts/large/17559.jpg" alt="Image 17559: " width="800" height="543" /></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] 17546 [empty string] [empty string] D53FB5CF-937A-DC31-D3ED29D7909827B8 [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/545-Passport-2014/1941 13 The default yacht template for David Walters Yachts 1 Brokerage 1 Erik Erik Haaland Haaland, Erik Haaland (410) 279-3027 1941 [empty string]
CACHED false
EXECUTIONTIME 7
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 = 1941 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID