RESULTSET |
query |
|
CALC_LENGTH |
CHECKBOX01 |
CHECKBOX02 |
CHECKBOX03 |
CHECKBOX04 |
CHECKBOX05 |
CHECKBOX06 |
CHECKBOX07 |
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 |
EZSELECTNAME |
EZSELECTNAME2 |
HASBROCHURE |
ISARCHIVED |
ISFEATURED_CHARTER |
ISFEATURED_SALE |
LOCATION1_REF |
LOCATION2_REF |
LOCATION3_REF |
LOCATION4_REF |
MEMO01 |
MEMO02 |
MEMO03 |
MEMO04 |
MEMO05 |
MEMO06 |
MEMO07 |
OFFICEREF |
RANDOMSEED |
USER2_REF |
USER3_REF |
USERREF |
YACHTID |
YACHTPRIORITY |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
60' |
2020 |
17' 3 |
6' 6 |
65,256 lbs |
Fiberglass |
German Frers |
[empty string] |
150 HP |
Sail |
H60-01 AVAILABLE NOW |
Call for Pricing |
Riviera Beach, FL |
[empty string] |
Diesel |
[empty string] |
25 |
1 |
D3-150 |
Volvo Penta |
40 gal |
370 gal |
391 gal |
H60 NEW |
Hylas (60' Fiberglass) |
H60-01 AVAILABLE NOW (60') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
https://my.matterport.com/show/?m=PZV1vLvmH1v |
[empty string] |
<p>Built for comfort, designed for performance. This luxurious yacht is loaded with conveniences that make handling her effortless even when short-handed. With the Germán Frers eye for performance, the Hylas H60 will make short work of even the longest passages. Don’t let your sailing dreams be restricted by anything other than your own imagination. The H60 adopts innovative design and construction techniques to bring broader appeal to a well-established brand. We are excited to continue our long partnership with world-class designer Germán Frers, once again testing the boundaries of performance, functionality, and quality for bluewater cruising yachts. Being built at the Hylas Yard she also keeps our reputation for great value very much intact.</p>
<p>Primarily designed to be light work when short-handed, this uncomplicated sail plan can be handled without difficulty. A great fit for a couple looking for the modern cruising lifestyle. This exciting new development stays true to the Hylas core competence of safely crossing oceans in comfort and style.</p>
<p>From the integrated bowsprit with a receiving case for a self-launching anchor to the automated telescoping passerelle at the transom, this vessel brings a new level of simple elegance to cruising. The flowing lines of the hydrodynamic hull design offer comfort and speed during cross-ocean passages. The bulbed fin keel ensures leeway (Side slip) is reduced and stiffens the yacht allowing her to carry the sail area the tall rig allows (Air draft 92’). The spade twin rudders minimize upwind sailing angles and provide the best traction when heeled. The wrap-around window, over-sized portlights, and a full 17’3″ beam that carries well aft create a Superyacht sense of space and comfort. </p>
<p>Working closely with the Italian interior design team Hot Lab this yacht oozes style from stem to stern. Three or four-cabin layouts are available. The Hylas touch comes to the for with wood type, grain direction, cabinetry design, and facings options. Numerous color and texture choices for seats, surfaces, and liners are available. Every Hylas interior is slightly different with unique features. Many of our standard offerings have come from improvements driven by client usage and change requests. We listen closely to what our clients want, give guidance from the experience of others, and believe strongly that adaptability and continuous improvement should be vigorously pursued and not simply accepted.</p>
<p style="text-align: center;"> </p>
<p style="text-align: center;">HYLAS H60 3 CABIN VERSION</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15082.jpg" alt="Image 15082: " width="600" height="217" /></p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15083.jpg" alt="Image 15083: " width="600" height="234" /></p>
<p style="text-align: center;"> </p>
<p style="text-align: center;">HYLAS H60 4 CABIN VERSION</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15084.jpg" alt="Image 15084: " width="600" height="217" /></p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15081.jpg" alt="Image 15081: " width="600" height="217" /></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
C4350F33-B33E-85CB-AE23A262C3CF41B2 |
[empty string] |
[empty string] |
[empty string] |
1836 |
[empty string] |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
57 |
2022 Delivery |
17' 0 |
Standard 8' 2 / Shoal 6' 5 |
57,685 lbs |
Fiberglass |
Bill Dixon |
[empty string] |
150 HP |
Sail |
H57-04 NEW |
Call for Pricing |
Fort Lauderdale, FL |
[empty string] |
Diesel |
[empty string] |
0 |
1 |
D3-150 |
Volvo Penta |
61 gal |
286 gal |
260 gal |
H57 |
Hylas (57 Fiberglass) |
H57-04 NEW (57) |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>The Hylas brand is synonymous with quality, performance, functionality, and value. We are delighted to introduce our newest blue-water sailing vessel. From world-class designer Bill Dixon the Hylas H57 is a perfect blend of classic Hylas, contemporary good looks, and an embracing of the latest technology in construction and design. Twin helms and rudders for improved performance, a lighter weight cored hull for improved strength and insulation plus the Solent rig for ease of handling mark a new era in Hylas designs. With a 3 or 4 cabin layout, this yacht will meet the needs of liveaboard couples or those planning extended cruises with friends and family. Primarily designed to be handled easily by a couple and fit the modern cruising lifestyle, this exciting new development stays true to the Hylas core competence of safely crossing oceans in comfort and style.</p>
<p>The Hylas H57 will impress discerning yachtsmen and women. The flowing lines of the latest hydrodynamic hull design offer comfort and speed during trans ocean passages. The fin keel ensures leeway (Side slip) is reduced and stiffens the yacht allowing her to carry the sail area this tall rig allows (Air draft 83’8”). The spade twin rudders optimize upwind sailing angles and provide the best traction when heeled. The wrap-around window, oversized portlights, and a full 17′ beam that carries well aft create a Superyacht sense of space and comfort.</p>
<p>With a three or four-cabin arrangement Hylas H57 offers great versatility and an ability to cruise with additional family, friends, or professional crew. Customization is an important part of the Hylas value proposition. There is always a willingness to work closely with clients in creating an interior that reflects personal tastes. Dixon has worked hard to ensure the Hybrid cockpit with aft helm stations does not impact headroom in the standing areas of the master stateroom.</p>
<p style="text-align: center;">THE NEW HYLAS H57</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15025.jpg" alt="Image 15025: " width="600" height="579" /></p>
<p style="text-align: center;"> </p>
<p style="text-align: center;">3 CABIN LAYOUT</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15026.jpg" alt="Image 15026: " width="600" height="232" /></p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15023.jpg" alt="Image 15023: " width="600" height="232" /></p>
<p style="text-align: center;">4 CABIN LAYOUT</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15024.jpg" alt="Image 15024: " width="600" height="232" /></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
5B282340-FF79-359B-8155692BF56041B2 |
[empty string] |
[empty string] |
[empty string] |
1835 |
[empty string] |
3 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
56' |
2013 |
15' 10 |
6' 4 |
50, 200 lbs |
Fiberglass |
German Frers |
[empty string] |
110 HP |
Sail |
Last Dollar |
$1,050,000 |
Muskegon, MI |
[empty string] |
Diesel |
[empty string] |
320 Hours |
1 |
4JH |
Yanmar |
27+37 Gallons |
275 Gallons |
280 Gallons |
56 |
Hylas (56' Fiberglass) |
Last Dollar (56') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p><strong>LAST DOLLAR is among the finest examples of the renowned Hylas 56 ever constructed and is the third new Hylas commissioned by her highly experienced owner.</strong> Always kept on the freshwater of Lake Michigan and stored away for 6 months out of the year, LAST DOLLAR has seen exceptionally light use, has never been cruised hard, and has enjoyed the attention of a professional maintenance program since new.</p>
<p>The Hylas 56 was designed by German Frers and built by one of the world’s most experienced semi-custom yacht builders; Queen Long Marine exclusively for Hylas Yachts. With a three cabin, two head configuration, exquisite teak joinery and raised panel cabinetry finished with a hand rubbed satin varnish, and a high gloss varnished teak and holly sole. LAST DOLLAR is a yacht designed and ready for long distance cruising. Her equipment and amenities are second to none and upon inspection will be found to be superior to any current offering in her class.</p>
<p><strong>Highlights Include:</strong></p>
<ul>
<li>Very low hours on the 110 HP Yanmar (320 hrs.) and 9kW Northern Lights generator (110 hrs.)</li>
<li>Always freshwater and kept on the Great Lakes, stored on the hard for 6 months a year</li>
<li>Desirable shoal draft keel</li>
<li>Low maintenance fiberglass decks with stainless-steel handrails – Minimal exterior teak</li>
<li>Simpson polished stainless-steel electric davits</li>
<li>Side Power bow thruster with joystick controls</li>
<li>Well-equipped galley with high efficiency refrigerator and freezer, U-Line ice maker, and Isotherm pullout beverage chiller</li>
<li>Full compliment of cruising electronics and communication equipment, B&G/Simrad with AIS, DSC VHF, SSB radio with Pactor III modem, autopilot with wireless remote, sonar module, and multifunction displays at the helm and navigation station</li>
<li>Full length bimini, dodger, and connector with enclosure built by Andy’s Canvas in Fort Lauderdale</li>
<li>Top-of-the-line Doyle Carbon sails in excellent condition</li>
<li>Freshwater electric flush toilets in the heads</li>
<li>3-Zone CruiseAir air conditioning and reverse cycle heat</li>
<li>Exquisite, raised panel interior and tucked Oyster Ultraleather upholstery with numerous custom aesthetic details</li>
<li>Solid teak and holly cabin sole finished with high gloss varnish</li>
<li>Bristol condition stem to stern!</li>
</ul>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15715.jpg" alt="Image 15715: " width="800" height="600" /></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
61411CFC-91DB-C717-F9713C0E2E4AC194 |
[empty string] |
[empty string] |
[empty string] |
1868 |
[empty string] |
4 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas Yachts |
49' |
2020 |
14' 3 |
6' |
31,967 lbs |
Fiberglass |
Sparkman and Stephens |
[empty string] |
75 hp |
Sail |
LizzyLea |
$699,000 |
Sapphire Beach, USVI |
[empty string] |
Diesel |
[empty string] |
103 |
1 |
4JHe-HTE |
Yanmar |
27+27 gallons |
145 gallons |
250 gallons |
49 |
Hylas Yachts (49' Fiberglass) |
LizzyLea (49') |
[empty string] |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p style="text-align: center;"><strong>A RARE OPPORTUNITY TO OWN A LIKE NEW HYLAS 49!</strong></p>
<p> </p>
<p>Designed by Sparkman & Stephens and built by Queen Long Marine - The Hylas 49 evolved from the brilliant lines of the Stevens 47. The Hylas 49 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 met with glowing reviews from nearly every sailing publication and serious offshore sailor.</p>
<p>The Hylas 49 is one of the most sought-after and iconic sailing vessels in its 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 make cruising safe, easy, and enjoyable.</p>
<p>Exceptional quality and built to the highest standards - LizzyLea is constructed of the highest quality materials and resins to provide a stiff and robust hull with proper form to reduce pounding in rough seas. Tall lifelines with a solid stainless steel pushpit extended to the midship gates, watertight bulkheads, and a bone-dry cockpit. The design of the Hylas 49 is revered for its performance in heavy seas, comfort, and security. All the characteristics desired by a cruising couple.</p>
<p>The mechanical systems aboard LizzyLea are, simply put – Superb. The Jefa 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 passage making. And a critical feature while cursing, the access to the engine and generator is effortless from all sides, making maintenance hassle-free.</p>
<p>LizzyLea is an exceptional example of the fine artisanship and superior design, which has placed the Hylas 49 among the most widely sought-after blue water cruising boats. It only fits then that she is the last of this iconic series ever to be built – Hull Number 68. Her owner, perhaps the most prolific Hylas 49 owner of all time, has owned three Hylas 49s in his lifetime. Throughout his multi-decade experience of sailing these yachts, he applied every grain of knowledge into the design and construction of this yacht, making LizzyLea the perfect blend of form, function, and beauty. She is an exceptional yacht.</p>
<p style="text-align: center;"><em>[Updated photos coming soon! Note: The main image is of LizzyLea's sistership. All other photos are of LizzyLea and were taken by the owner.]</em></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
656DEBE8-BBDE-67CD-4938CE3774974761 |
[empty string] |
[empty string] |
[empty string] |
1888 |
[empty string] |
5 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
49' |
2022 Delivery |
13' 6 |
3' 2 |
25,353 lbs |
Fiberglass |
Deal Salthouse |
(2) Yanmar 8LV |
740 HP Total |
Power |
M49 NEW |
$835,000 Base |
Fort Lauderdale, FL |
[empty string] |
Diesel |
[empty string] |
0 |
2 |
8LV-370 |
Yanmar |
60 Gallons |
240 Gallons |
185 Gallons |
M49 |
Hylas (49' Fiberglass) |
M49 NEW (49') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Spacious, fuel-efficient, plenty of power, and exceptional craftsmanship are what you will find with the new Hylas M49 power yacht. One level of comprehensive entertaining from the helm station to the swim platform. Grill, day heads, cockpit refrigeration, sun lounger, galley, dinette and helm station can all open up to form a stunning bright and inclusive environment. This new Hylas power yacht reflects the finest handcrafted quality and tradition that boat owners have come to expect from Hylas.</p>
<p>Salthouse has been designing the finest quality yachts for over 65 years. This southern hemisphere based architect has developed a well-proven “down-east” style motor yacht. The M49 hull has been tested for decades around New Zealand’s rugged coastlines. These hull designs, in keeping with the workboat heritage of today’s most successful sedan style cruisers, owe their origins as workboats for commercial fishing and offshore angling.</p>
<p>Relax in the luxurious salon or enjoy alfresco dining or lounging in the covered spacious cockpit. Rooftop storage for the dinghy, paddleboards, or kayaks. Perfect for the family. Experience the proven performance, economical cruising, and quality craftsmanship of Hylas Yachts.</p>
<p>Highlights Include:</p>
<ul>
<li>Spacious forward master stateroom with centerline queen</li>
<li>Offset guest cabin with two twin lower berths with an insert to convert to a double and single upper berth</li>
<li>Fullsize head with electric Masterflush toilet with both freshwater and saltwater flush, and a separate stall shower</li>
<li>Day head located on the main deck</li>
<li>Large windows, providing panoramic visibility while underway or enjoying the surroundings at anchor</li>
<li>Aft galley positioning designed to enable easy conversation while preparing food and entertaining</li>
<li>Full galley with a large pull-out pantry for great storage</li>
<li>Salon and cockpit tables providing options for dining indoors or out</li>
<li>Spacious living areas, compared with those of much larger vessels</li>
<li>Generous-sized aft lounge - perfect for alfresco dining, fishing, and relaxing</li>
<li>Handcrafted teak interior with matt varnish finish</li>
<li>Twin Yanmar 8LV-370 370HP 8-cylinder direct injection common rail turbocharged diesel engines</li>
<li>Yanmar KMH50A gearboxes, direct drive shafts, with 4-blade CNC propellers</li>
<li>Bennett trim tabs with helm controls</li>
<li>2-Zone CruiseAir air conditioning</li>
<li>Sidepower SE80/285T bow thruster</li>
<li>Seastar electro-hydraulic steering</li>
<li>Cockpit refrigeration and serving area</li>
</ul>
<p style="text-align: center;"> </p>
<p style="text-align: center;">HYLAS M49</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15121.jpg" alt="Image 15121: " width="600" height="203" /></p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15122.jpg" alt="Image 15122: " width="600" height="203" /></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
2DE24F53-A5FB-FCCC-7CE2FD5838EA3215 |
[empty string] |
[empty string] |
[empty string] |
1839 |
[empty string] |
6 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
48 |
2022 Delivery |
14' 6 |
Standard 6' 6 / Shoal 5' 10 |
35360 |
Fiberglass |
Bill Dixon |
[empty string] |
75 hp |
Sail |
H48-04 NEW |
Call for Pricing |
Fort Lauderdale, FL |
[empty string] |
Diesel |
[empty string] |
0 |
1 |
4Jh4-TCE |
Yanmar |
113 gallons |
290 gallons |
119 gallons |
H48 |
Hylas (48 Fiberglass) |
H48-04 NEW (48) |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
https://my.matterport.com/show/?m=1vmzmWT4CtH&fbclid=IwAR2cqOq4Ov2juHUFEL0LMUDlT0zafCkcEMDcr5jiYNBbWQXc9DdRPwZYXlw |
[empty string] |
<p>New in its class, the Bill Dixon designed Hylas 48 was precisely engineered for strength and reliability to satisfy even the most demanding buyer. This stately yacht is powerful but graceful which includes sleek raised salon windows for easy viewing, the choice of two or three cabins and a large center cockpit vessel that will impress any guest. The Hylas 48 offers premium quality and handcrafted details that make this luxury yacht stand in a class of its own.</p>
<p> <strong>Special Features</strong></p>
<ul>
<li>Expansive cockpit for relaxation as the helmsperson enjoys the balanced wheel</li>
<li>Uncluttered deck space</li>
<li>Easy to manage and versatile sail plan</li>
<li>Large salon with iconic styling and sleek raised windows for easy viewing</li>
<li>Comfortable seating with custom interiors</li>
<li>Plenty of storage providing versatility and function</li>
<li>Interior is bright and well-appointed with evident Hylas trademark craftsmanship</li>
<li>Choose from two or three comfortable cabins built to suit the owner’s personal taste</li>
</ul>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/12098.jpg" alt="Image 12098: " width="650" height="251" /></p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/12099.jpg" alt="Image 12099: " width="650" height="251" /></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
2DD91E74-BF32-BFC8-B9C076B2E5CF46DF |
[empty string] |
[empty string] |
[empty string] |
802 |
[empty string] |
7 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
44' |
2022 Delivery |
13' 6 |
3' 2 |
20,944 lbs |
Fiberglass |
Deal Salthouse |
(2) Yanmar 8LV |
740 HP Total |
Power |
M44 NEW |
Call for Pricing |
Fort Lauderdale, FL |
[empty string] |
Diesel |
[empty string] |
0 |
2 |
8LV-370 |
Yanmar |
60 Gallons |
240 Gallons |
185 Gallons |
M44 |
Hylas (44' Fiberglass) |
M44 NEW (44') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Strong, capable, and comfortable are synonymous when describing the new Hylas M44 power yacht. Collaborating with globally renowned New Zealand yacht builder Salthouse, this new Hylas design reflects the finest handcrafted quality and tradition that powerboat owners have come to revere and expect. The new M44 offers fuel efficiency, functional design, and maximum space while providing the power and performance that is unprecedented.</p>
<p>Relax in the luxurious salon or enjoy alfresco dining or lounging in the covered spacious cockpit. Rooftop storage for the dinghy, paddleboards, or kayaks. Perfect for the family. Experience the proven performance, economical cruising, and quality craftsmanship of Hylas Yachts.</p>
<p>Highlights Include:</p>
<ul>
<li>Spacious forward master stateroom with centerline queen</li>
<li>Offset guest cabin with two twin lower berths with an insert to convert to a double and single upper berth</li>
<li>Fullsize head with electric Masterflush toilet with both freshwater and saltwater flush, and a separate stall shower</li>
<li>Large windows, providing panoramic visibility while underway or enjoying the surroundings at anchor</li>
<li>Aft galley positioning designed to enable easy conversation while preparing food and entertaining</li>
<li>Full galley with a large pull-out pantry for great storage</li>
<li>Saloon and cockpit tables providing options for dining indoors or out</li>
<li>Spacious living areas, compared with those of much larger vessels</li>
<li>Generous-sized aft lounge - perfect for alfresco dining, fishing, and relaxing</li>
<li>Handcrafted teak interior with matt varnish finish</li>
<li>Twin Yanmar 8LV-370 370HP 8-cylinder direct injection common rail turbocharged diesel engines</li>
<li>Yanmar KMH50A gearboxes, direct drive shafts, with 4-blade CNC propellers</li>
<li>Bennett trim tabs with helm controls</li>
<li>2-Zone CruiseAir air conditioning</li>
<li>Sidepower SE80/285T bow thruster</li>
<li>Seastar electro-hydraulic steering</li>
</ul>
<p style="text-align: center;"> </p>
<p style="text-align: center;">HYLAS M44</p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15061.jpg" alt="Image 15061: " width="600" height="257" /></p>
<p style="text-align: center;"><img src="../../../../photos/yachts/large/15060.jpg" alt="Image 15060: " width="600" height="243" /></p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
305A872B-A229-F826-FAF5F86D4D23EA3D |
[empty string] |
[empty string] |
[empty string] |
1838 |
[empty string] |
|
SQL |
SELECT
yacht_data.yachtID,
yacht_data.data01 + ' (' + data02 + ' ' + data07 + ')' AS ezSelectName,
yacht_data.data12 + ' (' + data02 + ')' AS ezSelectName2,
yacht_data.yachtPriority,
yacht_data.officeREF,
yacht_data.isArchived,
yacht_data.userREF,
yacht_data.calc_length,
yacht_data.hasBrochure,
yacht_data.user2_REF,
yacht_data.user3_REF,
yacht_data.location1_REF,
yacht_data.location2_REF,
yacht_data.location3_REF,
yacht_data.location4_REF,
yacht_data.isFeatured_Sale,
yacht_data.isFeatured_Charter,
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.memo01, yacht_data.memo02, yacht_data.memo03, yacht_data.memo04, yacht_data.memo05, yacht_data.memo06, yacht_data.memo07,
yacht_data.checkbox01, yacht_data.checkbox02, yacht_data.checkbox03, yacht_data.checkbox04, yacht_data.checkbox05, yacht_data.checkbox06, yacht_data.checkbox07,
randomSeed
FROM yacht_data
WHERE staffREF = 7 and ( isArchived = 0 OR isArchived IS NULL)
ORDER BY data02 DESC |