Christi Anne | Grand Banks 42' 2002

East Greenwich, RI


Print Yacht Specs



Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Christi Anne
Builder: Grand Banks
Model: 42 Europa
Year: 2002
Location: East Greenwich, RI
Hull Material: Fiberglass
 

Grand Banks demo boat in Malaysia. She was outfitted and used by Grand Banks executives as a result, special care was put into her outfitting and new things such as teak crown molding, glass inserts for sliding saloon doors were added to this boat before the rest of the Grand Banks lines. 

She was purchased and brought stateside by a former US Expatriate in Singapore. She's completed the great circle loop and has attended numerous Grand Banks Rendezvous along the East Coast.

Currently owned by a couple who have functionally enhanced her and upgraded her inventory to today's standards. They have cruised her up and down the east coast and have kept her in tip top condition. Life changes have led to their offering Christi Anne for sale.

Dimensions

Length: 42'
Beam: 14' 1
Draft: 4' 2
Engine Manufacturer: Caterpillar
Engine Model: 3208 TA
Power: 375 HP
Number of Engines: 2
Fuel Type: Diesel
Engine Hours: 2680 Hours, 2670 Hours

Vessel Walkthrough

This is the popular Europa model that offers covered aft and side decks. You enter the boat through sliding teak doors with clear glass inserts, to saloon. A large curved settee is on port with two swivel barrel chairs flanking an entertainment center cabinet. A bar cabinet with ice-maker is forward of the barrel chairs on starboard. A sliding helm seat is aft of the lower helm.

The L-shaped galley is on port and offers a corner reach-in ice box and a large under counter refrigerator. The ice box has 4 inch foam insulation - 6 cubic feet of storage. A built-in microwave is in the overhead cabinet. Drop down dish lockers are over the Corian single sink.

Down three steps a companionway leads to the port guest cabin with one fore and aft bunk and one athwartship bunk. There is also a hanging locker and drawer stowage.

The head is on starboard with a door from the companionway and a door coming in from the forward master cabin. The head has a large separate stall shower.

The master cabin is forward and offers an island queen berth, hanging locker and bureau drawer stowage.

Teak cabinetry and teak parquet soles throughout. Custom drapes and tie backs. All cabinet door hinges have spring open and close. Teak crown molding throughout boat. All cabin windows have a light tint.

 

Deck Equipment

  • Stainless steel hand rails
  • Teak cap rails and all outside teak bright work (refinished 2018)
  • (6) Braided lines
  • (6) fenders
  • Freshwater and saltwater washdown systems, connections change to stainless steel spickit
  • Sunbrella Windshield cover
  • Sunbrella Side Window covers
  • Teak decks
  • Kahlenberg airhorn - single trumpet
  • Staircase to bridge with stowage under
  • Transom hot and cold shower
  • 50 amp shore connection fore and aft
  • Twin 30 amp to 50 amp splitter
  • TV connection fore and aft
  • Transom door
  • Teak topped deck box on main deck
  • Large teak slated swim platform
  • Folding swim ladder with 3 steps
  • Large aft lazarette
  • Large "utility" area with door to engine room
  • Splendide combo washer and VENTED dryer
  • Numerous spare Caterpillar parts and filters,Cat specific tools
  • Tool chest with spare light bulbs, stainless screws, clamps, etc.
  • Navy Blue transom canvas cover
  • 5/8" double braid mooring lines
  • Stainless steel scupper covers
  • (3) gate openings in safety railing
  • Stainless grab rails - both sides of house and both sides trunk cabin
  • Lofrans Tigres double windlass
  • Dual anchor rollers at bow platform
  • CQR anchor with 3/8" all chain rode
  • Nylon anchor snubber for CQR
  • Danforth second anchor with 30' of 3/8" chain and 200' line
  • Teak burgee mast - bow
  • Teak flag mast - stern
  • Underwater transom lights
  • Line cutters

 

 

Flybridge

  • Teak decking
  • Sliding door to under helm stowage
  • Large double or triple helm bench seat facing fore and aft
  • Single port side fore and aft bench seat
  • Navy Blue bench seat canvas covers
  • Navy Blue steering wheel cover
  • Full enclosure with drop curtain
  • Bimini top extended past mast for excellent sun coverage
  • 2 life Rings - Starboard ring has 100’ of Safety line attached
  • Glomax powered TV antenna
  • 2 new LED multi color spreader lights - 2017
  • 10 - life jackets with lights and whistles - 4 with out
  • USB & charging station installed next to radio
  • Walk-thru from main upper deck to dingy area
  • White vinyl bench seat cushions
  • L-settee with white vinyl cushions
  • Teak table with starboard inlay
  • Navy Blue settee canvas cover
  • Stowage beneath all seating areas with teak grates to allow for air circulation
  • Mast and boom with self-tailing winch
  • Navy Blue weather cloth
  • Sliding hatch cover over stairs to lower deck
  • Yamaha outboard engine with mount
  • 10' Zodiac Yachtman RIB dinghy w/ Yamaha 2.5 HP 4 stroke engine

 

Engine Room

  • Twin 375hp 3208TA Caterpillar engines
  • Additional LED lights installed in engine room
  • Oil change completed main engines and generator 2017
  • Engine and generator Zincs changed 2017
  • Xantrex battery monitor
  • Xantrex FSW 3000 Inverter with monitor installed
  • Batteries House - 2 AGM 8 D’s - 2016
  • Starting - 1 each AGM 8 D - 2016
  • Generator Starting - 1 Series 24 - 2016

 

Engine Service

  • 2017 all injectors replaced, both aftercoolers sonic cleaned all belts and hoses checked by Catapillar
  • Port & Starboard Engine Block Heaters Installed
  • High water alarm installed in each bilge area
  • All new zincs engines, generator (9/2017)
  • 13.5kw Onan generator in soundshield
  • Dripless shafts
  • Dual Racor fuel filters with vacuum gauges both engines
  • Side mount mild steel fuel tanks
  • Offset overhead fuel fills
  • Zinc saver galvonic isolator
  • Walker Engineering Airsep filters
  • Glendinning synchronizer
  • (3) remote mount aircon compressors - 40,000 BTU total
  • 12v engine room lights with LED bulbs
  • (3) bilge pumps
  • (2) engine room exhaust blowers
  • Macerator pump
  • Oil Exchanger pump and manifold for mains and generator
  • Hot water tank - 20 gallon
  • Water surge tank
  • Professional Mariner Pro-50 battery charger
  • Delta T mist separators installed on all engine room intake vents
  • Groco sea strainers - Bronze

 

Forward Master Cabin

  • Queen island berth with linens
  • (5) drawer bureau
  • Cedar lined hanging locker
  • Chart drawer
  • (4) large drawers under berth
  • (2) sliding doored cabinets
  • Full length beveled teak framed mirror
  • (2) Hella 12v fans
  • (2) stainless steel reading lights- LED bulbs 2018
  • Crown molding
  • Ocean sliding nite/ocean hatch
  • Teak parquet sole
  • Formica wall paneling
  • Teak planked ceiling against hull side
  • (4) Port lights with drapes
  • Two way overhead light switches at both sides of queen

 

Guest Stateroom

  • (1) athwartship upper berth with linens
  • (1) fore and aft lower berth with linens
  • (2) stainless steel reading lights- LED bulbs 2018
  • (2) Hella 12v fans
  • (2) port lights with lined drapes
  • Ocean sliding nite/screen hatch
  • Cedar lined hanging locker
  • (2) drawers
  • (1) shelved cabinet
  • Teak parquet sole
  • LED overhead lights
  • Formica paneled walls
  • Teak planked ceiling (against hullside)
  • Teak sliding cabin door
  • Vimar electrical light switch
  • Grand Banks teak "towel" holder (double)

 

Head

  • Separate stall shower with teak grate sole
  • Shower sump pump
  • Molded sink and counter
  • Grohe sink and shower faucets
  • Beveled teak framed mirror
  • (3) large cabinet stowage areas
  • Bi-fold glass shower doors
  • (2) shower shelves - teak slates and fiddle
  • Custom stainless steel towel bar
  • LED overhead lights
  • Ocean sliding nite/screen hatch
  • Vacuflush fresh water toilet- new flush unit 2017
  • Stainless toothbrush and glass holder
  • Teak parquet sole
  • (2) Port lights with drape and plastic curtain
  • Door to companionway
  • Door to forward stateroom
  • Tank watch holding tank monitor
  • (2) teak towel holders

 

Saloon

  • Curved L-settee with Blue ultrasuede fabric - stowage underneath
  • High-low fold-out leaf dining table
  • (2) barrel chairs with Blue ultrasuede fabric.
  • Teak tambour sliding door entertainment center cabinet
  • Cable TV connection and multiple 110v plugins
  • (2) small overhead cabinets with spring hinges
  • Teak crown molding
  • Custom drapes and tie-backs
  • Teak parquet sole
  • Teak bar cabinet with glass and bottle storage
  • U-line ice maker (2016)
  • Teak end table with large drawer and reach-in stowage
  • (2) sliding teak/glass insert doors to aft deck creating open feeling
  • All cabin glass is lightly tinted
  • (6) Throw pillows
  • (2) Stainless steel reading lights- LED lights
  • (3) Hella 12v fans
  • Overhead teak grab rail
  • Bronze Vimar electric light switches and plugins
  • Marine Air air conditioning/reverse cycle head (2 units for saloon/galley areas)
  • All lights have been changed to LED bulbs

 

Entertainment

  • New 32” LG Digital TV
  • Glomax powered antenna
  • Forward & Aft Cable connections
  • Fusion stereo installed 2017 with Bluetooth capability, remote Control/monitoring unit on flybridge. Additionally DVD player Connected to TV via HTMI cable.
  • 4 New fusion speakers installed two on the flybridge two in the main salon

 

Galley

  • Corian counters
  • Large single Corian sink
  • (2) flush mount Corian sink covers with teak cutting boards
  • Grohe single lever faucet
  • Sharp Carousel Micro - eye level 2018
  • Insulated ice-box
  • Drop down dish lockers
  • New Norcold AC/DC refrigerator installed 2018
  • Water filter for entire water system in after equipment room
  • Pur water filter on galley faucet
  • 12v exhaust fans over range
  • Princess 3 burner propane range with oven
  • Tip-out trash container
  • Tip-out sponge container
  • (7) slide out drawers with felt lining in (2) for silverware
  • Compartmentalized dish storage in forward bulkhead
  • (3) shelved storage cabinets
  • LED overhead lighting
  • (1) Hella 12v fan
  • Teak parquet sole
  • Teak dish towel holder
  • Marine Air air-conditioning with reverse cycle heat (2 units for galley/saloon area)
  • Custom drapes and tie-backs
  • Seaward Solenoid propane gas on/off switch
  • Opening center windshield for ventilation
  • Chart map light-flexible stock
  • End of counter glass and bottle storage cabinet

 

Lower Helm

  • Sliding helm seat with blue Ultrasuede fabric and flip-up foot rest
  • Opening starboard helm door
  • Traditional teak spoked and rim steering wheel
  • Panish gear and throttle controls
  • Port and starboard emergency fuel shut-off valves
  • VDO gauges for each engine
  • Generator start/stop control
  • S 100 controller remote auto pilot control
  • SR6 Sirius receiver with high-speed network switch
  • RCU-3 Remote control unit
  • Raymarine 218 VHF radio with DSC
  • Upper and Lower Helm are equipped with Raymarine E-127 MFD
  • Raymarine 24 inch HD digital radar VIA MFD
  • DSM 300 digital Sounder head
  • P 70 auto pilot controller head
  • Several extra outside LED lights added to boat, 1 each side 1 forward & one Aft
  • Camera on both Port & Starboard sides
  • Side Power bow thruster installed with lower helm controller
  • Windlass control panel
  • Bennett trim tabs
  • Engine start/stop panel
  • Battery condition monitor
  • Amps monitor
  • Perko battery selector switch (1, 2, both, off)
  • AC power selector switch (fore, aft, generator)
  • DC/AC breaker panel
  • DC breaker panel for electronics
  • (3) windshield wiper/washer switches
  • Panel showing generator, synchronizer, engine room lights, forward, mid and aft bilges. Panel lights up when one of above is running
  • Jabsco search light control switch
  • Compass
  • Teak electronics himalaya

 

Upper Helm

  • Hydraulic steering
  • Wood spoked stainless rimmed wheel
  • Stereo speakers
  • Panish gears and throttles
  • Bennett Trim tabs
  • Equipment "running" light on panel - same as lower helm
  • Compass
  • Jabsco searchlight control panel
  • Chart locker
  • windlass controler

 

Raymarine Electronics

  • S 100 controller remote auto pilot control
  • RCU-3 Remote control unit
  • Raymarine 218 VHF radio with DSC
  • Raymarine E-125 MFD
  • Raymarine 24 inch HD digital radar via MFD
  • DSM 300 digital Sounder head
  • P 70 auto pilot controller head
  • AIS
  • Side Power Bow thruster installed with upper helm control
  • 2 new 2017 Fusion speakers
  • New 2017 Fusion Remote controller unit
  • Loud Hailer w/ auto fog signal

 

Extra Equipment

  • Two cameras, one starboard one port, both can be viewed on either upper or lower hem via E127/E125 MFD
  • Two variable displacement water pumps Installed. If one fails a switch between the two can be activate to select the unused pump
  • WinchRite Electric winch handle. This allows for ease of operation to launch and recover Dinghy
  • All windows have navy blue Sunbrella coverings additionally dual sliding doors and side door have Sunbrella screens on the inside.

 

Lighting

  • All Interior lights have new LED bulbs
  • Spreader lights Replaced 2017 LED units
  • All engine room and aft equipment room lights have new LED bulbs.
  • Additionally 3 New LED lights installed in engine room.
  • 7 exterior LED multi color light units added to boat - most on separate switches

 

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 12.80 [empty string] [empty string] [empty string] Grand Banks 42' 2002 14' 1 4' 2 39,000 lbs Fiberglass [empty string] [empty string] 375 HP Power Christi Anne $415,000 East Greenwich, RI [empty string] Diesel [empty string] 2680 Hours, 2670 Hours 2 3208 TA Caterpillar [empty string] [empty string] [empty string] 42 Europa [empty string] [empty string] July 1, 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>Grand Banks demo boat in Malaysia. She was outfitted and used by Grand Banks executives as a result, special care was put into her outfitting and new things such as teak crown molding, glass inserts for sliding saloon doors were added to this boat before the rest of the Grand Banks lines.&nbsp;</p> <p>She was purchased and brought stateside by a former US Expatriate in Singapore. She's completed the great circle loop and has attended numerous Grand Banks Rendezvous along the East Coast.</p> <p>Currently owned by a couple who have functionally enhanced her and upgraded her inventory to today's standards. They have cruised her up and down the east coast and have kept her in tip top condition. Life changes have led to their offering Christi Anne for sale.</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] 9510 [empty string] [empty string] 3365F118-0A37-3A21-DEEBB29E632BB9C2 [empty string] [empty string] https://www.davidwaltersyachts.com/Power/42-Grand-Banks-2002/728 10 The default yacht template for David Walters Yachts 1 Brokerage 1 John John Osetek Osetek, John Osetek (401) 465-8634 728 [empty string]
CACHED false
EXECUTIONTIME 34
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 = 728 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID