|Yacht Name:||Slow Dancing|
|Designer:||Sparkman & Stephens|
YOUR SEARCH FOR A WELL EQUIPPED
CAPABLE BLUE WATER CRUISER ENDS HERE!
UPDATED PHOTOS COMING SOON!
We are pleased to offer one of the most beautiful and well equipped Hylas 49’s to be offered for re-sale. Truly special, Slow Dancing is a one owner boat built to order by a discerning owner with an eye for attractive styling and knowledge of the proper equipment desired for distance cruising.
Designed by Sparkman & Stephens and built by Queen Long Marine - The Hylas 49 evolved from the exceptional lines of the Stevens 47 and incorporates numerous design improvements such as a refined interior layout, optimized deck plan, revised sugar scoop transom, and substantial updates to the operating systems. Classic meets modern in this smartly configured 3-cabin cruiser with contemporary styling and a motion at sea that’s been met with glowing reviews from nearly every sailing publication and serious offshore sailor.
The Hylas 49 is one of the most sought after sailing vessels in the class of high-quality semi-custom blue water cruisers - Tailored for upscale cruising couples with a desire for the finest qualities, the Hylas 49 has rightfully earned a reputation for comfort, safety, and exhilarating performance. This luxurious center cockpit is ideal for short handed sailing and well configured to be sailed with confidence in a wide range of conditions. The design concept and layout makes cruising safe, easy, and enjoyable.
Praised for its comfortable interior, enough to border on plush, and built to a standard that is unrivaled - Slow Dancing is certainly a head turning boat which draws the envy of many. Some of her highlights include Antal electric winches and in-mast electric mainsail furling for effortless pushbutton sailing, versatile cutter rig with removeable inner forestay, newer Doyle Zenith and Pro Radial sails, the latest Raymarine eS series electronics, 3-zone air conditioning, bow-thruster, and so much more.
Fitted with nearly every available option from the builder- Slow Dancing boasts stunning interior aesthetics such as Wahlee Stone surfaces in the galley and head, high-gloss varnished bamboo flooring, Ultraleather upholstery, louvered cabinetry with styled round corners, joinery upgrades, and teak trimmed hatches.
Enjoy the freedom and ability to sail unbound - Slow Dancing is equipped with the capability to accept both US and European shorepower with a 15kVA isolation transformer. Unplug and cruise unrestricted with the 8kW generator(1460 Hours), fresh banks of new MasterVolt AGM batteries, D400 wind generator, Spectra Newport MKII DC watermaker, efficient 12VDC refrigerator and freezer, and upgraded LED lighting.
Exceptional quality and built to the highest of standards - Slow Dancing is constructed of the highest quality materials and resins to provide a stiff and strong hull with proper form to reduce pounding in rough seas. Tall lifelines with a solid stainless steel pushpit extended to the midship gates, water tight bulkheads, a bone-dry cockpit with full enclosure, and a brand new 6-manWinslow life raft with complete safety systems offer a level of security desired by the cruising couple.
Mechanical systems aboard Slow Dancing are superb - Lewmar Mamba torque tube steering system with solid linkage from the pedestal to the steering quadrant ensures a responsive helm, high capacity stainless steel water and fuel tanks offer the capability for long distance passagemaking, and access to the engine and generator is outstanding from all sides. Upgraded at the factory, Slow Dancing is equipped with a 100HP 4-cylinder turbo diesel with only 2,200 hours! A substantial improvement from the standard 75HP. All mechanicals were installed at the factory to the highest quality of workmanship.
Slow Dancing is an exceptional example of the fine craftsmanship and superior design which has placed the Hylas 49 among the most widely sought after blue water cruising boats. The perfect blend of form, function, and beauty, Slow Dancing is sure to impress and ready to go.
The spacious and open interior, with contemporary styling features a modern deck salon with large panoramic front and side windows delivering warm, natural light and spectacular views from the comfort of the main salon. Walhee Stone surfaces, textured off white headliners, and softgoods upholstered with tan Ultraleather contrast and compliment the light undertones of the bamboo cabin sole finished in a high gloss varnish. The superb teak joinery and cabinetry is handcrafted and varnished to a satin finish. Six large deck hatches with teak trimmed screens, four dorade vents, and numerous opening portlights provide excellent ventilation and a cooling breeze while the three-zone climate control delivers welcome relief when desired.
Slow Dancing boasts three well sized staterooms. A full beam v-berth forward with ensuite access to the day head, a single berth guest cabin forward to port, and a roomy master stateroom with a queen centerline berth and private head with separate stall shower and second passageway leading to the main salon. All staterooms feature cedar lined hanging lockers and finished cabinetry with louvered doors, and all the desirable comforts. Passageway galley with over 7 feet of useable Wahlee Stone countertop complete with an island style surface under the companionway offers more than ample space for the cuisine loving crew and generous amounts of storage. Equally well suited for entertaining or intimate dining for a cruising couple.
Interior Styling & Additional Features:
Light colored bamboo with contrasting teak positive locking cabin sole for offshore sailing, laid on solid, epoxy sealed sub flooring, and finished with an epoxy urethane coating with 7 layers of varnish for exceptional durability and beauty.
World class teak joinery with top-choice materials and hand varnished satin finish
Finely finished louvered cabinetry styled with rounded corners and complete with furniture grade fixtures and chromed push button latches.
Cedar lined hanging lockers and cabinets with numerous removeable shelves
Solid teak doors, trim, and cabinetry
Trim pieces incorporate fiddled handholds throughout the boat making traversing the interior while underway safe and secure
Drop down teak framed deck hatches in the cabins and main salon
Easy to remove vinyl headliners throughout
Wahlee Stone surfaces throughout the galley and heads
LED overhead and personal lighting throughout
Bright and full of natural light, the spacious main salon with it’s raised bamboo cabin sole is warm and welcoming and offers spectacular views through the large panoramic fixed side and forward windows. To starboard is a full length settee which slides out an additional 9 inches to expand to a comfortable sea berth complete with lee cloth. To starboard is a custom two-way folding dinette table with a solid teak base and wine rack storage. In it’s most compact configuration it’s the perfect cocktail size for entertaining, expand the leafs, and you a comfortable dining table with seating for six with a large settee and double bench seat. Softgoods are upholstered in tan Ultraleather which is both attractive and easy to care for. Outboard cabinetry and shelving, storage behind the settees, as well as a custom locker integrated into the teak mast wrap offers an incredible amount of storage space. Headroom is a generous 6’ 7”. Natural ventilation through two large opening deck hatches with teak trimmed screens and opening portlights are welcomed on those warm tropical evenings but when needed, the reverse cycle climate control is a desirable feature.
Cruise Air reverse cycle air conditioning and heat with digital controller – 12,000 BTU
Comfortable, full length settees to port and starboard upholstered with easy to care for tan Ultraleather which attractively compliments the light tones of the bamboo flooring.
Starboard settee pulls out 9” to convert to a well-suited sea-berth with lee cloth, comfortable in length and perfect for offshore cruising. Additional storage behind the backrest.
Custom two-way folding teak dinette table with wine bottle storage and inboard bench seating
Liquor locker with glassware storage and bottle rack in forward starboard cabinet
Custom masthead locker with teak mast wrap and removable shelving
Samsung 21” flatscreen TV with DVD player
Stereo speakers with zoned volume controls
Red night lighting
12VDC Hella fans
LED overhead and swivel reading lights
Vacuum placed behind Port settee with 25-foot hose.
Slow Dancing is unrivaled in both luxury and style. The well-appointed master stateroom is your sanctuary on the water with a custom innerspring centerline queen berth, rich satin hand varnished cabinetry and joinery finished with cedar, ensuite entertainment, and ample comforts including LED reading and overhead lights and high speed Hella fans. The stateroom was designed with his and her matching hanging lockers, drawers, and fiddled shelving. The view through the aft opening portlights is spectacular and a welcome start to your day. To port, is ensuite access to the private aft head and a second passageway leading forward to the main salon.
Cruise Air reverse cycle air conditioning and heat with digital controller – 7,000 BTU
Queen size centerline berth with custom inner spring mattress
Lee cloth and hooks installed for comfort and practicality while offshore
Four drawers under the berth
(2) Aft opening portlights
Raymarine ST60+ multifunction display within easy view of the berth
Sony Bravia 22” flatscreen TV with DVD player inset into the forward bulkhead with fiddled shelving above
Niles stereo volume control adjacent to berth
Red night lighting
12VDC Hella fans
LED overhead and swivel reading lights
The ensuite aft head is beautifully finished with Wahlee Stone vanity, sink, and flooring with white trim to coordinate with the laminate wall surfaces. A full-length dressing mirror is located on the doorway. Storage is bountiful with a cabinet below the sink and a sizeable linen closet outboard. The separate stand up shower has excellent headroom, a Lexan glass door, and a second passageway to the main salon.
Wahlee Stone flooring with white trimmed edging
Wahlee Stone countertop and sink with Moen faucet
Teak trimmed vanity mirror and medicine cabinet above the sink with additional storage below
Full length mirror mounted to the inside of the head door
Separate stall shower with Lexan door and fold down teak seat
Well sized linen closet
Vacuflush head with 27-gallon dedicated holding tank with “Y” valve
12VDC Hella fan – White
GFI 110 VAC outlets
The only complaint you’ll have about the forward stateroom is your guests will be so comfortable you’ll have a hard time getting them to disembark. This wonderfully inviting cabin with ensuite access to the forward head has a full beam custom inner spring v-berth mattress which is 6’ 9” in length, the width of a king size bed at the aft end, and incredibly comfortable. Teak cabinetry with removeable shelving and hanging lockers lined with cedar were customized for added depth and improved volume. Additional storage is accessed under the berth via a hydraulically assisted lift. A large overhead hatch with teak trimmed fold down screen provides natural ventilation. Zoned climate control with independent digital control is shared with the port guest cabin.
Full beam, double v-berth with custom inner spring mattress and lee cloth – 6’ 9” in length
Hydraulic assisted lift allows access to an incredible amount of storage underneath the berth
Red night lighting
LED overhead and swivel reading lights
12VDC Hella fans mounted to hanging locker bulkhead
Stereo speakers with zoned volume control
Aft and to starboard of the guest stateroom is the forward head which opens to both the guest stateroom and the passageway forward.
Wahlee stone countertop surface and sink with pull out faucet
Teak trimmed vanity with mirror and medicine cabinet above the sink with additional storage below
Folding teak shower seat
Raritan manual head with dedicated 27 gallon holding tank and “Y” valve
Wahlee stone countertop surfaces and sink
12VDC Hella fan – White
GFI 110 VAC outlet
Aft and to port is the second guest cabin with single berth complete with lee cloth. Ideal for storage or the occasional guest, this cabin is a desirable and versatile space with plentiful cabinetry, cedar lined hanging locker, and additional storage under the berth accessed via a hydraulically assisted lift and cabinet door. An overhead teak trimmed hatch with drop down screen and opening portlight provide ventilation and climate control is shared with the forward cabin. A Splendide combination washer and dryer vents overboard.
Cruise Air reverse cycle air conditioning and heat – 7,000 BTU shared with forward cabin
Single berth with custom inner spring mattress and lee cloth
Hydraulically assisted lift raises to revel storage below which can also be accessed through the cabinet door below the berth.
Splendide 2000 combination washer and dryer – Ventilated overboard for proper drying
Red night lighting
LED overhead and swivel reading light
12VDC Hella fans mounted to hanging locker bulkhead
Slow Dancing features a galley that is smartly laid out and functional with over 7 feet of Wahlee Stone surface and inboard island style countertop aft of the companionway.Designed for practicality at sea the galley is safe and functional underway on either tack. The top and front loading refrigerator and freezer include dual seals and heavy insulation and were designed with a flush surface to ensure easy cleanup and seamless aesthetics. The Frigoboat system operates off 12VDC and incorporates efficient keel coolers. The three burner LPG Force 10 stove with oven has a Wahlee Stone insert for added prep surface when in place or offers a stainless steel backsplash when stowed behind the stove. Ample cabinets, storage lockers, and drawers are located outboard and below the countertop.
12VDC Frigoboat refrigerator and freezer with keel coolers
Top and front load refrigerator and freezer with heavy insulation and dual seals – top access designed to be flush with countertop surface for easy clean up
Over 7’ of Wahlee stone countertop with additional surface inboard
Double stainless steel deep basin sinks with pull out faucet
Pressurized fresh water hot/cold faucet
Manual fresh and salt water foot pumps
LG Microwave with GFI 110VAC outlet inside the cabinetry
Force 10 gimbaled three burner stove with oven
Custom pot and pan storage below the stove
Countertop insert recesses over the stove allowing for stainless steel backsplash or increased counter space when in place
Hide-a-way rubbish bin
Opening portlight and 12VDC Hella fan smartly positioned for added airflow and ventilation
Overhead LED lighting
Red passageway night lighting
Aft and to port of the main salon is the outward facing navigation station with custom bi-fold hinged desktop and swing out seat with Ultraleather upholstery. The instrument and electrical panels, with lighted displays, have fast-pin hinges allow easy access to the exceptionally well organized and carefully labeled wiring. All instruments and wiring are labeled inside and out and traced numerically at each end. Slow Dancing has been recently outfitted with the latest Raymarine eS series multifunction displays at both the helm and navigation station. These units are WiFi and Bluetooth compatible and fully integrated with the ships systems. There is a bank of drawers and full size file cabinet inboard and below the chart table.
Outboard facing navigation station with swing out seat, custom bi-fold hinged desktop, filing cabinet, and bank of drawers
Raymarine eS97 multifunction display with integrated chartplotter and radar – NEW 2017
iCOM M594 VHF radio
Panda Fischer generator control panel
Wema tank monitoring system
Spectra watermaker remote panel
Wema tank tender monitoring system for all tanks
Xantrex battery monitor
Xantrex Prosine 2.0 2000W combination inverter/charger remote panel
AC power fault indicator with polarity warning lights
Fuel flow alarm
La Crosse digital weather display
Alpine CDA9885 AM/FM/CD/iPod Stereo
Red & white overhead and chart lighting
110VAC GFI & dual 12VDC outlets
Raymarine eS127 multifunction display with integrated chartplotter and radar – NEW 2017
Raymarine RD424D digital radar integrated with both nav station and helm displays
Raymarine ST60+ instrumentation for wind, speed, and depth
Raymarine ST6002+ autopilot with Whitlock DU120 autopilot drive unit coupled directly to the Mamba steering
iCOM VHF Command Mic
Standard Horizon & iCOM IC-M340 handheld VHF radios
The Hylas 49 is a well proven and extremely capable blue water cruiser. Slow Dancing is fast, sea-kind, and strong. Constructed with hand laid up fiberglass laminates set with vinylester resins and isophthalic gelcoat for superior protection from osmosis and blistering. Eight longitudinal stringers are tied to each frame and bulkhead. The result, is a stiff and seamless monolithic structure in excess of ABS standards. The encapsulated lead keel and low ballast provides a low center of gravity for high stability and is fastened with solid 35mm stainless steel keel bolts with transverse mounted 8mm backing plates. The forward hull section is well shaped for rough seas and well-reviewed for its excellent abilities in heavy weather without pounding. The distance between rudder and keel is measured by design to provide excellent directional stability and balance. The rudderpost has full structural support running through hull to deck. For added safety and protection from hard grounding, the rudder skeg is 2 inches higher than the low point of the keel.
White gelcoat hull in excellent condition with red bootstripes and gold covestripe
Teak rubrail with stainless steel capping below the sheerline
Solid hand laid fiberglass layup with vinylester resins and isophthalic gelcoat for superb strength and stiffness and a hull well protected against osmosis and blistering
Watertight collision bulkhead forward with independent overboard drainage and watertight stern sections across aft lazarettes and stern locker
Fully skegged rudder for optimal strength and protection – Bottom of the rudder plane is 2” above the keel for grounding safety
Unidirectional modified keel that is fully encapsulated solid lead secured with 35mm stainless steel keel bolts with transverse mounted 8mm backing plates.
3” Copper counterpoise running the length of each side of the hull
Characterized by wide side decks, high stanchions, and equipped with the desirable option to bring the pushpit stainless steel rail the full length to the mid-ship gates, Slow Dancing is a boat aboard which the crew will feel safe and secure. The deck is laid up with a sandwich core construction with end grain balsa core. Solid laminate is utilized in all areas of the deck for fittings and high stress areas. Chemically and mechanically fastened with 5200 epoxy and through-bolted every 5 inches with backing plates, the Hylas 49 is known for its superior strength and solid construction. The surface is molded non-skid.
Molded non-skid in contrasting linen beige – Gentile on the feet yet excellent grip when wetted
Aluminum toe rail
Sugar scoop transom with centerline boarding gate and three wide steps finished with teak hardwood, incorporates four stainless steel grab rails and a folding ladder to allow unrestricted and easy access to and from the water level.
Stainless steel protective trim along the edge of the transom
Fresh water hot and cold transom shower
Side boarding ladder with port and starboard side mounting brackets
Pushpit extended to midship gates – A solid stainless steel railing running from the transom to mid-ship gates for extra safety and security, a highly desired option requested by many offshore sailors.
Pushpit seats on port and starboard quarters
Large stern garage with dedicated bilge pump and manual override in the cockpit
Large aft lazarettes with dual Bailey latches for watertight seal and internal rails for line storage, self draining
Liferaft cradle mounted to the pushpit rail
Ten, 12” stainless steel mooring cleats with backing plates – Includes an additional two midship cleats added by the builder
Stainless steel radar mast with integrated dinghy motor lift
Stainless steel mast for Eclectic D400 wind generator
Propane locker starboard midship sizeable enough for two standard size propane tanks
Four, dorade vents, 2 aft & 2 forward with protective stainless steel rails – Forward dorades can be removed and a dinghy cradle installed
Four, teak grabrails, two on the foredeck and two on the aft coach roof – Well positioned for safety about the boat while underway
Six, stainless steel deck hatches with acrylic lenses and teak trimmed screens – Complete set of tan canvas hatch covers
Ten, opening portlights
Deck salon design with four, fixed windows, one to port and starboard and two forward – Delivers an incredible amount of natural light and beautiful views from the main salon
31” high stanchions with double, uncoated stainless steel wire lifelines – Much higher than most boats adding a welcomed level of security and safety when moving about the deck
Stainless steel stem fitting and striker plate for bow and hull protection
Stainless steel pulpit
Fresh and salt water washdown
Cable TV shoreside connection
Fresh water shoreside connection
US & European shorepower connections – True freedom to cruise anywhere
Forward chain locker with segmented stowage for primary and secondary anchor rode with separate storage for docklines and fenders, self draining
Stainless steel dual bow roller for primary and secondary anchors
Stainless steel striker plate on deck and stainless steel stem fitting to protect the bow and hull from unruly ground tackle
Maxwell 2200 vertical electric windlass, chain feed and bow stopper, with controls at the bow and helm
70lb Delta primary anchor with 250-feet of galvanized high tensile 3/8” chain
65lb Rocna secondary anchor with galvanized high tensile 3/8” chain
Fortress FX-37 aluminum anchor
Maxwell chain counter
Assortment of docklines, springlines, and fenders
Selden electric in-mast furling
Selden 2-spreader anodized aluminum keel stepped mast
Selden aluminum boom with internal boom preventer
|Engine Hours:||Josh McLean|
|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 = 597 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID|