Vicki Lea | Fountaine Pajot 37' 2002

Fort Lauderdale, FL


Print Yacht Specs



Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Vicki Lea
Builder: Fountaine Pajot
Model: Maryland 37
Year: 2002
Location: Fort Lauderdale, FL
Designer: Joubert-Nivelt
Hull Material: Fiberglass
 

Upgraded Yanmar 240 HP Engines and Northern Lights Generator with Low Hours - Exceptionally Equipped and Ready to Cruise - Impeccably Clean!

Vicki Lea is unlike any Fountaine Pajot Maryland 37 you've seen yet. Incredibly rare, with her highly desirable 240 HP Yanmar engines with just over 2,300 hours, Northern Lights 6kW generator with 1,874 hours, dual zone MarineAir A/C and reverse cycle heat, updated Simrad electronics, KVH sat TV, and much more. She's been exceptionally well cared for and impeccably maintained.

Just back from the Great Loop, Vicki Lea is absolutely ready to head out and do it again. Her hull shines like it's never seen the Florida sun, her interior is in excellent condition, and she's been gone through from stem to stern. If you're looking for a long range cruiser with the legs to get you where you want to go in yet demand creature comforts, then Vicki Lea is a must see!

  • Upgraded 240HP Yanmar engines with low hours
  • Northern Lights 6kW generator with low hours
  • Upgraded Simrad electronics
  • Tracvision TV3 satellite system            
  • Air conditioning and reverse cycle heat
  • Absolutely pristine condition!

Dimensions

Length: 37'
Beam: 16' 8
Draft: 3' 6
Water Tank Capacity: 130 Gallons
Fuel Tank Capacity: 350 Gallons
Holding Tank Capacity: 35 Gallons
Engine Manufacturer: Yanmar
Engine Model: 4LHA-STP
Power: 240 hp
Number of Engines: 2
Fuel Type: Diesel
Engine Hours: 2310 Hours & 2308 Hours

Manufacturer Provided Description

The Maryland 37 has a long cruising range and a hull form that provides exceptional seagoing qualities. This type of trawler enables one to cover 1000 nautical miles at nine knots. Her two hulls and two engines provide great stability for anchoring and ease of maneuvering, allowing the Maryland to evolve in small spaces. The Maryland 37 has an large saloon with a cabinetwork table for six to eight people which can be converted into a double bed. The galley is designed with a large worktop, a cabinetwork bar, and a cockpit with a panoramic view. The two beautiful cabins have private showers and toilets. On deck there are two aft platforms, with a ladder and a cold water shower on the port side. The flybridge has a complete pilotage console.

 

Aft Deck

With walk-thru access from both side decks, as well as from the large sliding patio door to the main saloon, the aft deck is a functional and enjoyable area of the boat. Spacious enough for a set of patio chairs, or simply left uncluttered, the aft deck where you are sure to spend a good amount of time either underway or at anchor. With little effort, you can install the full-screen enclosure for protection from the sun and mosquitos!

  • Walk-thru access to side decks and stairway access to the flybridge
  • Single basin sink with pullout faucet and storage with propane locker below
  • Wrap around stainless-steel hand railing
  • Screen enclosure
  • Overhead lighting
  • Stereo speakers integrated with the Fusion stereo system
  • 110VAC GFI/12VDC outlets
  • Marinco 30A/125V shore power inlet and cord storage locker
  • Marinco cable TV shore inlet
  • Top access to port and starboard engine compartments
  • Plastimo manual bilge pump (2017)

 

Flybridge

The wide wrap around stairwell, with molded non-skid stairs and a sturdy stainless-steel hand railing, makes traversing to and from the aft deck to the flybridge safe and easy while underway. Up top, the U-shaped lounge with table and double settee make for an enjoyable experience with spectacular views. The double helm seat offers unrestricted sightlines for the skipper and full access to the ship’s navigation and communication equipment.  The full-length bimini top with Isinglass forward opening windows offers welcome protection from the sun and proper ventilation when needed. Access ports beneath the lounge and settee, as well as an opening hatch beneath the helm seat, provides lots of room for storage.

  • Molded stairwell leading from aft deck to flybridge with non-skid stairs and stainless-steel railing
  • Stainless-steel grab rail
  • Full-length bimini top with a stainless steel frame and opening forward Isinglass windows (2017)
  • Navy blue Sunbrella cushions and backrests (2016)
  • Seating for 8
  • Yanmar engine start panels with oil, temperature, and voltage audible and visual alarms and tachometers
  • Twin throttle controls
  • Goiot stainless steel wheel with leather wrap
  • Navigation and communication equipment
  • Plastimo binnacle
  • Stereo speakers integrated with Fusion stereo system
  • 12VDC outlet
  • Storage under lounge and seats

 

Hull & Deck

  • Stainless steel davits with 5:1 purchase blocks, with custom extensions to provide clearance of the swim platform when raising and lowering the dinghy
  • Stainless steel folding swim ladder off the port side swim platform
  • 6 Mooring cleats – 2 aft, 2 mid-ship, 2 forward
  • Padeyes port and starboard for safety harness or jacklines
  • Port and starboard deck fills for diesel tank and waste pump-outs, water fill port forward of cockpit windows
  • Molded non-skid steps leading from aft deck to side decks
  • Stainless steel side deck railing and pulpit
  • Trampoline between the hulls, forward of the pulpit (2017, currently removed)
  • 4 Opening deck hatches and 2 solar vents
  • Lofrans Cayman 88 1000W 12VDC horizontal windlass serviced in 2017
  • Rocna 25kg primary anchor with 130’ 3/8” chain
  • Segmented foredeck locker with massive compartments for fenders, dock lines, and anchor chain, self-bailing.
  • Fenders and dock lines
  • Boathook
  • GoLight remote searchlight mounted to the foredeck with cockpit controls
  • Bridle mount inboard of bows
  • Windshield wiper on the center cockpit window

 

Galley

Configured as much for entertaining as utility, the galley of the Fountaine Pajot Maryland 37 is open and accessible to the main salon with island style counters, superb front access refrigeration, a very large top loading freezer, and a 3-burner stove top with easy to clean fiddled molding. The deep, double basin stainless steel sink even has a recessed, self-draining drying rack for dishes and glassware. You’ll find no shortage of storage for provisions, there are two large cabinets aft as well as pot and pan storage under the countertop. Forward, there is a large pantry cabinet with a drawer for utensils below. Warp around stainless-steel railings ensure there’s always a steady hand hold.

  • 3-Burner SMEV cooktop with oven
  • Double basin stainless steel sink with hot/cold faucet
  • Dedicated drinking water faucet with Seagull IV-S-1F filtration
  • 12VDC Frigoboat Frigomatic ELBA 35F refrigeration with Danfoss BD35F compressor (2014)
  • Front load stainless steel refrigerator
  • Top load freezer
  • Pullout rubbish bin with top access
  • Flush mount Sharp microwave oven (2017)
  • LED overhead lights
  • 12VDC Hella fan

 

Main Salon

Comfortably seating 6 adults, the wraparound lounge with a convertible table is the center of it all. Adjacent the galley for interactive dining, open to the aft deck for entertaining, and within easy chatting distance to the helm station, the main salon is where you’ll find many hours of relaxation and enjoyment. Flanked by large panoramic windows, the natural light is abundant and pleasant, yet shades can be drawn to cut down the afternoon sun or add privacy when desired. Aft, there is a Visio 32” HD TV mounted to a swiveling bracket, fully integrated with the vessels Tracvision TV3 KVH satellite TV antenna. The lounge is raised just enough to ensure an eye-level view when seated and is long enough to stretch out, perfect for a nap or a good book. The 12VDC Hella fan, opening forward windows, and large sliding glass door to the aft deck bring a cool breeze through the interior, but when that’s not enough, enjoy the chill of the 16,000 BTU reverse cycle air conditioning with digital controls in the main saloon, even underway thanks to the 6kW Northern Lights generator.

  • 16,000 BTU MarineAir reverse cycle air conditioning with digital controls
  • Seating for 6 at the lounge with table
  • Ultrasuede upholstery (2016)
  • 32” Visio HD-TV
  • Overhead LED lighting

 

Inside Helm

With long distance cruising in mind, the inside helm station is much more functional than most. The sightlines from the bolster style captains chair are unrestricted while the large windows to port and starboard make docking, even from inside, simple. Built for all climate enjoyment such features include opening forward windows when a little extra breeze is welcome, centerline windshield wipers when it’s dreary, and reverse cycle climate controls for the warm tropics or brisk fall mornings. Monitoring and operating the boat is all done at your fingertips with dual engine panels and throttle controls, tridata instrumentation, autopilot, windlass controls, and even a remote-control searchlight.

  • Yanmar engine control panels with oil, temperature, voltage audible and visual alarms and tachometers
  • Twin throttle controls
  • Folding top navigation desks port and starboard
  • Bolster style captain’s chair with white Ultraleather upholstery
  • Wired for second chart plotter (flybridge plotter can be moved and installed when desired)
  • Forward opening windows (2)
  • Navigation and cruising electronics (See Electronics section)
  • Plastimo binnacle
  • Goiot stainless steel helm with leather wrap
  • Octopus wiper controls
  • Bilge switches (4)
  • Electrical distribution panel
  • Stereo speakers
  • 110VAC outlets (2)
  • 12VDC outlets (2)

 

Accommodations

The port and starboard hulls are laid out in near symmetry. Each features a centerline double berth, very spacious for two guests with mattresses recently upgraded (port in 2016/starboard in 2017). There are two tall hanging lockers and a folding top desk. In the port stateroom, there is an extra shelf above the desk and additional storage beneath the berth. The starboard hull has a 16,000 BTU MarineAire reverse cycle A/C unit with digital controls. Natural ventilation and lighting is excellent, with two opening deck hatches, a solar vent, and three opening outboard portlights with shades per stateroom. Each stateroom has ensuite heads with Raritan Marine Elegance Electric flush toilets, vanity with mirror and cabinets below, and a very large separate stall shower with access to the bow locker and the separate 35-gallon holding tanks forward.

 

Port & Starboard Staterooms

  • Double berths with custom mattresses (port hull 2016/starboard hull 2017)
  • Desktop with folding top, above the desk, the port hull has shelving while starboard has access to the freshwater pumps
  • 16,000 BTU MarineAire reverse cycle air conditioning with digital controls in the starboard hull
  • Overhead opening hatches
  • Opening outboard portlights with shades
  • Solar Vent
  • Padded vinyl headliner
  • Hanging lockers
  • LED overhead and bulkhead mounted reading lights
  • 110VAC outlets

 

Ensuite Heads

  • Raritan Marine Elegance Electric heads with dedicated 35-gallon holding tanks
  • Single basin vanity with pullout faucet, Corian countertop, mirror, and cabinetry below
  • Stainless steel grab rail and towel rack
  • Separate stall shower with Lexan divider
  • Forward access to bow locker
  • Dedicated 35-gallon polypropylene holding tanks

 

Engine & Mechanical

One of the best features of this boat is her upgraded Yanmar 4LHA-STP 240HP diesel engines installed new in 2008. These engines were professionally installed and have been recently serviced. New mufflers, exhaust hoses, and ports were changed out in 2016, the shaft seals and bellows replaced in 2017, and the propellers and shafts tuned in 2017. One of the best features of Vicki Lea are her protected prop skegs, the direct drive shafts are encapsulated in a strong sturdy skeg to keep the running gear protected in case of an accidental grounding.

  • Yanmar 4LHA-STP 240HP engines (2,308 hrs port/2,310 hrs starboard) 4-cylinder inline, rated to 3,300 RPM, turbocharged with intercooler
  • ZF Hurth Marine ZF 63A-2.0 Transmissions
  • Groco sea strainers
  • Racor fuel filters
  • Vetus mufflers, exhaust hoses, and ports (2017)
  • Propellers and shafts tuned in 2017
  • Shaft seals and bellows replaced (2017)

 

Tankage

  • Freshwater – 130 gallons
  • Fuel – 350 gallons
  • Holding – 2x 35 gallons

 

Navigation & Electronics

  • Tracvision TV3 KVH antenna with Seaview mount (2015)
  • Simrad 3G broadband radar mounted on a stainless steel mast
  • Simrad sounder with structure scan
  • Raymarine depth transducers (in each hull)

 

Inside Helm

  • Simrad AP 28 autopilot control head
  • Fusion stereo system
  • Simrad Sonic Hub Audio
  • Raymarine ST 60 Tridata display
  • Windlass controls
  • Octopus windshield wiper controls
  • Standard Horizon Explorer GPS (2016)
  • Bilge pump panel
  • Stereo speakers
  • Plastimo binnacle

 

Flybridge Electronics

  • Simrad AP 28 autopilot control head
  • Raymarine ST 60 Tridata display
  • Simrad NSS-12 Multifunction Display with adjustable mount
  • Standard Horizon Ram 3 Command Mic VHF (2016)
  • Simrad GPS antenna
  • Stereo speakers
  • Plastimo binnacle

 

Electrical

  • Northern Lights 6kW generator with 1,874 hours
  • Factory wired for US power w/110VAC & 12VDC outlets throughout
  • AC/DC Distribution panel at the helm station
  • Isotemp 6-gallon hot water heater (2017)
  • 60A Battery charger
  • 400A AGM Battery bank (2017)
  • G27 Generator start battery

 

Additional Equipment

  • 8’ Highfield RIB with an aluminum floor (2018)
  • Torquedo T1003 Travel electric outboard (2018)
  • First Alert smoke detector
  • Fire extinguishers
  • Throwable life ring

 

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 11.28 [empty string] [empty string] [empty string] Fountaine Pajot 37' 2002 16' 8 3' 6 16,280 lbs Fiberglass Joubert-Nivelt [empty string] 240 hp Power Vicki Lea $199,000 Fort Lauderdale, FL [empty string] Diesel [empty string] 2310 Hours & 2308 Hours 2 4LHA-STP Yanmar 35 Gallons 350 Gallons 130 Gallons Maryland 37 [empty string] [empty string] June 5, 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="text-align: center;">Upgraded Yanmar 240 HP Engines and Northern Lights Generator with Low Hours - Exceptionally Equipped and Ready to Cruise - Impeccably Clean!</p> <p>Vicki Lea is unlike any Fountaine Pajot Maryland 37 you've seen yet. Incredibly rare, with her highly desirable 240 HP Yanmar engines with just over 2,300 hours, Northern Lights 6kW generator with 1,874 hours, dual zone MarineAir A/C and reverse cycle heat, updated Simrad electronics, KVH sat TV, and much more. She's been exceptionally well cared for and impeccably&nbsp;maintained.</p> <p>Just back from the Great Loop, Vicki Lea is absolutely ready to head out and do it again. Her hull shines like it's never seen the Florida sun, her interior is in excellent condition, and she's been gone through from stem to stern. If you're looking for a long range cruiser with the legs to get you where you want to go in yet demand creature comforts, then Vicki Lea is a must see!</p> <ul> <li>Upgraded 240HP Yanmar engines with low hours</li> <li>Northern Lights 6kW generator with low hours</li> <li>Upgraded Simrad electronics</li> <li>Tracvision TV3 satellite&nbsp;system&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li> <li>Air conditioning and reverse cycle heat</li> <li>Absolutely pristine condition!</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] 9259 [empty string] [empty string] 9445DBE4-D59F-7F28-651145E393B5F85D [empty string] [empty string] https://www.davidwaltersyachts.com/Power/37-Fountaine-Pajot-2002/716 7 The default yacht template for David Walters Yachts 1 Brokerage 1 Josh Josh McLean McLean, Josh McLean (616) 204-9658 716 [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 = 716 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID