Blue Star | Little Harbor 53' 1988

Oxford, MD
$625,000


Print Yacht Specs



Tell Us About Your Ideal Boat

Basic Info

Yacht Name: Blue Star
Builder: Little Harbor
Model: 53
Year: 1988
Year Refit: 2022, 2012
Location: Oxford, MD
Asking Price: $625,000
Designer: ted Hood
Hull Material: Fiberglass
 

We are proud to present BLUE STAR, that is not only the finest Little Harbor 53, but also one of the stars in the movie 'Failure to Launch', starring Matthew McConaughey and Sarah Jessica Parker.

Designed by Ted Hood and built in the Lien Hwa shipyard in Taiwan, the Little Harbor line of sailing yachts was built for comfortable offshore sailing with top quality construction and pedigree. The cockpit is designed for single-handed sailing, with all controls easily reached from the helm. Inside, the generous beam and hull design lead to an interior that feels like a much larger yacht, providing exceptional living and storage space. Ideal for shallow waters, she features a deep, efficient centerboard that increases draft to 11?-4? when lowered.

Built in 1988 and commissioned in 1989 BLUE STAR has only had two owners, the first for 15 years and the current owners for the past 17. Her second owner has kept her maintained by the same boat yard, the same engineer, and the same varnish / cosmetics expertise. She's never been chartered, and is kept in her own private slip in Oxford, MD on the Chesapeake Bay when in season. BLUE STAR has cruised the US East Coast and the Caribbean, and when not cruising south she has been kept protected by her full canvas winter cover.

Below decks BLUE STAR's layout is especially focused on safety and offshore blue water sailing. All berths are equipped with lee cloths, the salon is designed to take full advantage of space, with a large curved dinette table and all safety reaches never out of arms distance. The aft owner's cabin has two oversized sea berths that each approach the size of a double bed with extra length.

BLUE STAR sleeps six in three private staterooms, each with private head and shower. Starting forward there is a large storage area/bosun's locker with workbench and deck access. Aft of the forepeak are two identical guest staterooms, each with over/under berths and separate heads, including showers. Each cabin has a full cedar-lined hanging locker, several drawers, large lockers, opening ports, opening hatches and fans over each berth. Winter and summer custom fitted coverlets and sheets and monogrammed towels are available for each cabin. Two sets of fitted coverlets for each berth; one cream colored and the other a rich patterned winter coverlet, fitted sheets. monogrammed linens include towels, pillows, shams (with a monogram of Blue Star's design), napkins, glasses, stationery, and more.

Paramount Pictures selected BLUE STAR to be featured as the sail boat in 'Bristol' condition for its movie, 'Failure to Launch' starring Sarah Jessica Parker and Matthew McConaughey. This selection was made after the Governor's office for Tourism referred their call to several boat yards and much competition from visited yachts resulted in BLUE STAR's selection. This selection speaks to the pristine condition of the yacht. BLUE STAR's role resulted in signed logs by Sarah and Matthew; one extra, transparent Bimini; and one set of new 'blue' cockpit cushions (desire of the Director, but in the end BLUE STAR's white cushions were chosen).

Please see the refit details in the Full Specifications

Key Points

  • Perfected Gel Coat and re-painted Blue Star top sides (Awlgrip Flag Blue), Boot Stripe (Cloud White), replaced as original-Gold foil name (red outlined) on stern, coach roof (Oyster White), non-skid (Moon Dust). Repaired, sanded, painted small areas of fiberglass found under/near old teak decks
  • Replaced original teak decks with new teak decks by Teak Decking Systems
  • Hard sanded bottom paint to the barrier coat (originally placed in 2011 re-fit). To sellers knowledge, no blisters have ever been found on Blue Star. Two coats of new, red bottom paint,
  • Micron CSC, were applied
  • Polished mast and boom (recently re-painted so only waxing/polishing needed)
  • Serviced and refurbished engine and generator: removed and cleaned heat exchangers; placed new hoses and zincs; replaced valve cover gasket, main engine
  • Replaced all 50 bolts for Genoa tracks
  • Replaced all rod rigging and running rigging, M Yacht Services, Annapolis
  • New dodger and bimini on order, contracted with Quantum Sails

Dimensions

Length: 53'
Beam: 15' 1
Draft: 5' 6
Water Tank Capacity: 225 Gallons
Fuel Tank Capacity: 155 Gallons
Holding Tank Capacity: 30 Gallons
Engine Manufacturer: Westerbeke
Engine Model: W100
Power: 100 HP
Number of Engines: 1
Fuel Type: Diesel

2022 Refit Details

  • Perfected Gel Coat and re-painted Blue Star top sides (Awlgrip Flag Blue), Boot Stripe (Cloud White), replaced as original-Gold foil name (red outlined) on stern, coach roof (Oyster White), non-skid (Moon Dust). Repaired, sanded, painted small areas of fiberglass found under/near old teak decks.
  • Replace teak decks with new teak decks by Teak Decking Systems
  • Refurbished center board and installed new cable and replaced/refurbished all related mechanisms
  • Re-chromed all fittings that were not stainless, primarily windlass
  • Hard sanded bottom paint to the barrier coat (originally placed in 2011 re-fit). To our knowledge, no blisters have ever been found on Blue Star. Two coats of new, red bottom paint, Micron CSC, were applied
  • Polished mast and boom (recently re-painted so only waxing/polishing needed)
  • Refurbished Boom Vang, all new seals placed
  • Toe rail taken down to bare wood and varnish built to look as original; eyebrow varnished, 10 coats
  • Serviced and refurbished engine and generator: removed and cleaned heat exchangers; placed new hoses and zincs; replaced valve cover gasket, main engine
  • Replaced hose clamps on shaft transmission to prop
  • Placed new sheaves and turning blocks for genoa and spinnaker sails
  • Replaced all 50 bolts for Genoa track
  • Replaced all rod rigging and running rigging, M Yacht Services, Annapolis

Additional Upgrades performed by MYacht Services, Annapolis

  • Serviced all winches
  • Cleaned mast step and mast heel
  • Boom vang toggle (hole was elongated)
  • Serviced main furler swivel
  • Serviced main furler top bearing (neoprene cover for top cap)
  • Service Genoa furler and swivel
  • Installed new LED Tri-anchor light
  • Replaced Windex-Installed new VHF antenna
  • Serviced furler drum
  • Installed new spreader leather boots
  • Installed new LED spreader lights
  • Replaced deck light
  • Replaced SSB coax cable
  • Replaced wooden mast chocks with Spartite
  • Rebuilt spinnaker pole ends
  • Serviced and repainted mast furling electric motor

 

2012 Refit Details

In 2012 BLUE STAR had a comprehensive refit. The following items were replaced, repaired and refinished:

  • All electrical wires replaced
  • Plumbing lines replaced
  • Fuel tanks polished
  • Refrigeration replaced, insulation for freezer replaced, teak covering freezer, and new refrigerator door handles
  • Espar heating system replaced, and lines were replaced as well
  • Three heads/toilets replaced
  • All hatch and port light lenses, including Lexan hull ports were replaced (2012)
  • All gaskets replaced (and continue to be maintained annually to ensure that there are no leaks whatsoever)
  • Solar powered vent installed in stern lockers to ensure no dampness
  • New curtains for port lights, screens for hatches and ports
  • New Awlgrip including topsides (Captain's Navy Blue), coach roof (Oyster White with Moon Dust treads), spars (Cloud White)
  • New larger-diameter safety lines

 

Electronics & Navigation


Entertainment Electronics:

  • Stereo System: Alpine CD player / Satellite radio with cockpit antenna
  • Speakers: Multiple speakers up and down
  • Televisions: Two LCD TVs with VCR and DVD / Shakespeare TV antenna 2030
  • New flat screen TV in salon recesses when not in use
  • Additional flat TV screen in master cabin
  • Antennas:
  • Mast top: (2) VHF antennas to nav station and cockpit / (2) Wind direction indicators; (1) wired to B&G system
  • Top port spreader/cell phone antenna with LRM400 cable to nav station
  • First starboard spreader: Giro compass antenna
  • Stern pole: 8' whip antenna for DGPS radar
  • Stern mount: GPS Northstar antenna
  • Port aft mount: Satellite phone
  • Dodger mount: Satellite radio antenna

Navigation Electronics:

  • VHF: (2) Standard Horizon / Icom-ICM500
  • Radar: Raytheon Pathfinder / Raymarine RC 80 Raydome 4kW M92652
  • GPS: Furuno GP36 and DGPS antenna / Northstar 951 X and DGPS antenna
  • Hailer: Standard 8-30W VLH-300 loud hailer with auto fog signal
  • Chart Plotter: RC 631 Plus Pathfinder radar and chart plotter
  • Autopilot: Robertson AP200 with remote F200 + RI 101 rudder indicator
  • Secondary Autopilot: B7G AIP Helmstar 740
  • Speedlog: Brookes and Gatehouse / GPS
  • Depth Sounder: Brookes and Gatehouse
  • Compasses: Sailcomp digital compass at nav station w/ displays port and stbd in the cockpit and Ritchie pedestal mount
  • Cellular Phone: Cell phone antenna with LMR400 cable with Wilson amplifier
  • SSB Radio: SSB Sea 322
  • Water Temp Gauge: Pytak sea temp MN 703200
  • Wind Instruments: Brookes and Gatehouse and Sailcomp displays
  • Weather FAX
  • AIS: SI-Tex radar automatic ID system
  • Satellite Phone: Westinghouse Series 1000 with Wavewalk antenna
  • AEC
  • Lightning rod on mast

 

Engine & Mechanical

  • Westerbeke 100 hp diesel engine
  • Kobelt single-lever engine controls
  • Spurs line cutter on prop shaft
  • Maxprop propeller
  • Oil transfer pump for engine and genset
  • Automatic fire extinguisher system in engine room
  • Espar cabin heater
  • Marine Air 10kW unit for owner's quarter (2008), and 16 kW unit for salon and forward cabins (2008)
  • Wesmar 12-volt, twin prop DPC-8E, 8" bow thruster
  • Sea Recovery 400 GPD watermaker
  • New toilets in forward heads (2017)
  • High water bilge alarm
  • Jabsco Par electric bilge pump
  • Rule 2500 gph electric bilge pump
  • (2) Edson manual diaphragm bilge pumps
  • Exhaust fans in galley and in heads
  • 30 gal. holding tank with macerator
  • Fuel and water tank gauges
  • Fans over each berth: (2) in main salon, (1) in galley

 

Sails & Rigging

All sail handling functions designed for singlehanded operation by the helmsman with all controls for sail handling at helm station.

SAILS

  • Doyle Stoway main sail
  • Doyle 130% genoa, 'crescent cut' Spectra with foam luff pad and reinforcements for reefing system
  • Hood MPS sail with sock
  • Full spinnaker package - pole, butt hoist, topping lift, foreguy, pole storage on mast, (2) sheets, (1) block and internal halyard with side winder pole light
  • Gail River sea drogue sail
  • Hood storm tri-sail

RIGGING

  • Electric Hood Stoway
  • Stoway spars, repainted Awlgrip Cloud White (2012)
  • Spare (second) Stoway motor
  • Double primary turning blocks
  • Staysail package - inner forestay with quick release, runners, halyard, sheets and blocks
  • Running backstays
  • Navtec hydraulic boom vang
  • Navtec insulated backstay with 'fail-safe' turnbuckles and 2-function panel in cockpit
  • Storm trysail track with block and halyard
  • Harken Mark III furling headstay system
  • Spreader lights
  • Tri-color light on masthead
  • Anchor light

 

Construction

Hand-laid fiberglass hull with Airex foam core construction. Molded in fiberglass fuel and water tanks and centerboard trunk. Internal cast-lead ballast. Hand-laid fiberglass deck and Divinycell core construction and 5/8" teak overlay. Varnished teak exterior trim with highest quality stainless steel portlights, (9) hatches, (9) cowl vents. Teak rub rails fastened to hull with stainless steel striker. (2) deck prisms. Centerboard is foil shaped for enhanced performance upwind. Centerboard configuration offers a minimum draft of 5'-6" with board up, and a maximum draft of 11' 4" with board down. Centerboard pennant recently replaced.

 

Cockpit & Canvas

  • Cockpit table, seats six with extension
  • Closed-cell foam cockpit cushions
  • Cockpit table cover
  • Cockpit light
  • Custom dodger with elkhide-covered grab bar
  • Bimini with full side enclosure
  • Redesigned, oversized diameter steel frames for Bimini and Dodger for added seaworthiness
  • Full Eisenglass cockpit enclosure with doors
  • Two awnings from mast forward (permitting hatches to be kept open)
  • Full bow-to-stern Stamoid awning, allowing all hatches to be kept open for shade while at the dock or on the hook
  • Full sun cover - bow to stern- for comfort when moored
  • Textilene mosquito net enclosure for sun shade in cockpit
  • Sun curtain for the aft cockpit area
  • New (yet to be used) full clear cockpit enclosure curtains
  • Leather steering wheel cover
  • Custom canvas winter cover
  • Custom turnbuckle covers
  • Outboard motor cover
  • Canvas life raft cover
  • Storage covers for all exterior teak, hatches, and winches - only eyebrow and toerail are not covered
  • Canvas delivery covers for all upholstery and cabin soles
  • Full winter canvas cover for winter storage

 

Deck Equipment

  • Nilsson V-1000 windlass with chain stopper
  • Bruce 60# anchor with chain and rode
  • Danforth 60# with rode
  • CAR 60# anchor with 3/8" chain
  • Caribe 10' dinghy with viewing glass in floor
  • Stainless steel stern davit for outboard
  • Varnished teak outboard mount
  • Lensref radar reflector
  • Lifelines, heavy mooring lines with bridle
  • Saltwater anchor wash
  • Teak pulpit seat
  • Fresh water washdown on stern
  • Fold-down stern swim ladder
  • 3-step side boarding ladder (for port and stbd)
  • (2) Boat hooks with adapters for gaff and scrub brushes
  • Fender boards
  • (2) Dock lines; jack lines
  • Recent large custom top-line New Zealand stainless steel propane gas grill
  • New stern dinghy davits, designed from 1.25 steel
  • Monogrammed navy fenders - (4) large, (6) medium, (6) small
  • Monogrammed gray fenders - (2) large
  • International flag kit
  • Dress ship's flag kit
  • Several large American flags for flying from stern or from the back stay
  • Teak flag pole for stern - perfectly maintained

 

Safety

  • Givens 6-person life raft with hydrostatic release, packed with own EPIRB
  • (2) ACR 406, RLB 32 EPIRBS with hydrostatic release
  • Emergency tiller steering
  • Lee cloths for all berths
  • Life Sling new
  • Horseshoe life rings
  • Type 1 life jackets
  • 'Abandon ship' bag
  • Flares
  • Fog bell
  • Medical kit
  • International Flags
  • (4) Hand-held fire extinguishers

 

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 16.15 [empty string] [empty string] [empty string] Little Harbor 53' 1988 15' 1 5' 6 59,224 lbs Fiberglass ted Hood [empty string] 100 HP Sail Blue Star $625,000 Oxford, MD 2022, 2012 Diesel [empty string] [empty string] 1 W100 Westerbeke 30 Gallons 155 Gallons 225 Gallons 53 [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>We are proud to present BLUE STAR, that is not only the finest Little Harbor 53, but also one of the stars in the movie 'Failure to Launch', starring Matthew McConaughey and Sarah Jessica Parker.</p> <p>Designed by Ted Hood and built in the Lien Hwa shipyard in Taiwan, the Little Harbor line of sailing yachts was built for comfortable offshore sailing with top quality construction and pedigree. The cockpit is designed for single-handed sailing, with all controls easily reached from the helm. Inside, the generous beam and hull design lead to an interior that feels like a much larger yacht, providing exceptional living and storage space. Ideal for shallow waters, she features a deep, efficient centerboard that increases draft to 11?-4? when lowered.</p> <p>Built in 1988 and commissioned in 1989 BLUE STAR has only had two owners, the first for 15 years and the current owners for the past 17. Her second owner has kept her maintained by the same boat yard, the same engineer, and the same varnish / cosmetics expertise. She's never been chartered, and is kept in her own private slip in Oxford, MD on the Chesapeake Bay when in season. BLUE STAR has cruised the US East Coast and the Caribbean, and when not cruising south she has been kept protected by her full canvas winter cover.</p> <p>Below decks BLUE STAR's layout is especially focused on safety and offshore blue water sailing. All berths are equipped with lee cloths, the salon is designed to take full advantage of space, with a large curved dinette table and all safety reaches never out of arms distance. The aft owner's cabin has two oversized sea berths that each approach the size of a double bed with extra length.</p> <p>BLUE STAR sleeps six in three private staterooms, each with private head and shower. Starting forward there is a large storage area/bosun's locker with workbench and deck access. Aft of the forepeak are two identical guest staterooms, each with over/under berths and separate heads, including showers. Each cabin has a full cedar-lined hanging locker, several drawers, large lockers, opening ports, opening hatches and fans over each berth. Winter and summer custom fitted coverlets and sheets and monogrammed towels are available for each cabin. Two sets of fitted coverlets for each berth; one cream colored and the other a rich patterned winter coverlet, fitted sheets. monogrammed linens include towels, pillows, shams (with a monogram of Blue Star's design), napkins, glasses, stationery, and more.</p> <p>Paramount Pictures selected BLUE STAR to be featured as the sail boat in 'Bristol' condition for its movie, 'Failure to Launch' starring Sarah Jessica Parker and Matthew McConaughey. This selection was made after the Governor's office for Tourism referred their call to several boat yards and much competition from visited yachts resulted in BLUE STAR's selection. This selection speaks to the pristine condition of the yacht. BLUE STAR's role resulted in signed logs by Sarah and Matthew; one extra, transparent Bimini; and one set of new 'blue' cockpit cushions (desire of the Director, but in the end BLUE STAR's white cushions were chosen).</p> <p>Please see the refit details in the Full Specifications</p> <p><strong>Key Points</strong></p> <ul> <li>Perfected Gel Coat and re-painted Blue Star top sides (Awlgrip Flag Blue), Boot Stripe (Cloud White), replaced as original-Gold foil name (red outlined) on stern, coach roof (Oyster White), non-skid (Moon Dust). Repaired, sanded, painted small areas of fiberglass found under/near old teak decks</li> <li>Replaced original teak decks with new teak decks by Teak Decking Systems</li> <li>Hard sanded bottom paint to the barrier coat (originally placed in 2011 re-fit). To sellers knowledge, no blisters have ever been found on Blue Star. Two coats of new, red bottom paint,</li> <li>Micron CSC, were applied</li> <li>Polished mast and boom (recently re-painted so only waxing/polishing needed)</li> <li>Serviced and refurbished engine and generator: removed and cleaned heat exchangers; placed new hoses and zincs; replaced valve cover gasket, main engine</li> <li>Replaced all 50 bolts for Genoa tracks</li> <li>Replaced all rod rigging and running rigging, M Yacht Services, Annapolis</li> <li>New dodger and bimini on order, contracted with Quantum Sails</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] 20456 [empty string] [empty string] ADD099F0-A903-6E08-7E9E3D1D88B62AD8 [empty string] [empty string] https://www.davidwaltersyachts.com/Sail/53-Little-Harbor-1988/3020 13 The default yacht template for David Walters Yachts 1 Brokerage 1 Erik Erik Haaland Haaland, Erik Haaland (410) 279-3027 3020 [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 = 3020 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID