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 |
70' |
2015 |
18' |
8' |
[empty string] |
Fiberglass |
German Frers |
[empty string] |
260 HP |
Sail |
Independence |
$1,500,000 |
Fort Lauderdale, FL |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
6BY3-260 |
Yanmar |
88 Gallons |
740 Gallons |
360 Gallons |
70 |
Hylas (70' Fiberglass) |
Independence (70') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p><strong>INDEPENDENCE</strong> is Hylas Yachts' most recent construction of the H70 Flagship series. She was designed by renowned German Frers and built by one of the world's most experienced quality yacht builders, Queen Long Marine, exclusively for Hylas Yachts. Without compromise, INDEPENDENCE has enjoyed the benefit of a professionally managed maintenance program under the constant care of the same captain since her commissioning in August 2015.</p>
<p>With a spacious 4-stateroom interior arrangement, exquisite teak joinery with louvered cabinetry, raised panel doors, and modern bamboo cabin sole with teak stringers, INDEPENDENCE is a yacht designed to enhance the comfort and enjoyment of her crew and is especially well suited to long-distance cruising. Her equipment and amenities are simply unmatched and, upon inspection, will be noted to be superior to any current offering in her class.</p>
<p>The gorgeous teak deck is finished with light-colored caulking chosen for its modern aesthetics and gentleness on the feet in the warm summer sun. The deck is unrestricted, flowing to meet the topsides with a graceful sheer and a reverse counter stern with an integral swim platform and transom garage. The lines of the Hylas 70 are both modern and timeless. She’s beautiful.</p>
<p>Whether you’re a coastal cruiser, potential circumnavigator, or seeking a yacht with charter potential, INDEPENDENCE is a luxury performance cruising yacht with the integrity, exquisite finish, and state-of-the-art systems necessary to go anywhere.</p>
<p><strong>Highlights Include:</strong></p>
<ul>
<li>Bow thruster and retractable stern thruster</li>
<li>New generation deck styling with the wrap-around raised salon window design</li>
<li>The lowest hours of any H70 currently offered for resale with the larger and improved Yanmar 6BY 3rd generation 260 HP engine and desirable Northern Lights 12kW generator.</li>
<li>Fully integrated Bose audio/visual entertainment system with four independent zones</li>
<li>Incredibly well-equipped galley with six refrigerator/freezer units, 5-burner stovetop with oven and broiler, dishwasher, wine cooler, trash compactor, convection oven, and espresso machine</li>
<li>KVH TracPhone and TracVision satellite systems for high-speed internet, phone, and television</li>
<li>Navigation and communication for unrestricted global voyaging; four touchscreen Lighthouse II displays, the latest Raymarine i70 instruments, and extensive communication equipment, including both SSB and Sat systems</li>
<li>Spectra water maker with autorun and self-maintaining cycles upgraded with Z-Ion membrane protection system</li>
<li>CruiseAir 4-zone 66,000 BTU reverse cycle air conditioning system</li>
<li>Separate full-size washing machine and dryer</li>
<li>Simpson electric davits</li>
</ul> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
409E4AF7-A82C-BCA0-FE0E06379A9E7CE5 |
[empty string] |
[empty string] |
[empty string] |
1980 |
[empty string] |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Antigua |
60' |
2007 |
16' |
5' 8 |
65,000 lbs |
Fiberglass |
[empty string] |
[empty string] |
167 HP |
Sail |
Soolaimon |
$675,000 |
Fort Lauderdale, FL |
[empty string] |
[empty string] |
[empty string] |
3500 Hrs |
1 |
4LH-DTE |
Yanmar |
45 Gal |
450 Gal |
530 Gal |
60 Custom |
Antigua (60' Fiberglass) |
Soolaimon (60') |
[empty string] |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
https://my.matterport.com/show/?m=6fSwzxxtLUo |
[empty string] |
<p style="text-align: center;"><strong>THE ULTIMATE BAHAMAS CRUISER<br />5' 8" Shoal Draft & ICW Friendly Mast</strong></p>
<p> </p>
<p>SOOLAIMON is an extraordinary luxury cruising yacht with a robust and sea-kindly shoal draft hull and an exquisite custom 3-stateroom varnished teak interior. Configured and equipped for offshore cruising, few boats can measure up to the comfort and luxury of SOOLAIMON. Features include automated sail handling, the Leisure Furl in-boom mainsail furling, self-tacking staysail, oversized systems, expansive side decks with direct walk-thru access to the large center cockpit, and excellent walk-thru access to the immense center cockpit visibility from the helm enable this yacht to be very easily managed by a cruising couple.</p>
<p>With her shoal draft of 5’ 8” and an intercoastal waterway friendly bridge clearance of 64’, SOOLAIMON can be sailed into anchorages and marinas not otherwise available to many yachts over 50’. This is the ideal sailing yacht for a couple or family with a desire for limitless cruising without sacrificing the comforts of home.</p>
<p>SOOLAIMON is among the most unique yachts in her class, as evidenced by her construction and specific attention to detail. She is easily sailed by one or two individuals, built to be a safe and robust passage maker. Most of the systems were installed from 2007 to 2015 and are of the best engineering and highest quality available. SOOLAIMON is genuinely a masterpiece of form, function, and beauty with an impeccable design. Her interior arrangement and deck layout are ideally suited for liveaboard, extended passage making shorthanded, or potentially suited for VIP chartering.</p>
<p>There are few yachts so well designed and built as SOOLAIMON. Hundreds of additional details, large and small, make her very functional with exquisite joinery and system installation. "Elegant" is the word used by guests. Only during an inspection can one truly comprehend and appreciate the total commitment to quality, functionality, and beauty. With SOOLAIMON's shoal draft and low bridge clearance, she is excellent for the Bahamas and Keys as well as intercoastal travel along the US East Coast.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
42E3272F-AEC5-F9F9-29C934B2CEF2B3C0 |
[empty string] |
[empty string] |
[empty string] |
1913 |
[empty string] |
3 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas Yachts |
56' |
2017 |
15' 10 |
7' 4 |
50,200 lbs |
Fiberglass - Flag Blue |
German Frers |
[empty string] |
110 HP |
Sail |
Slainte |
$1,250,000 |
Fort Lauderdale, FL |
[empty string] |
Diesel |
[empty string] |
1,500 hrs |
1 |
4JH4-THE |
Yanmar |
[empty string] |
280 gal |
275 gal |
56 |
Hylas Yachts (56' Fiberglass - Flag Blue) |
Slainte (56') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p style="text-align: center;"><span style="font-size: 12pt;"><strong>PHOTOS & ADDITIONAL MEDIA COMING SOON!</strong></span></p>
<p> </p>
<p>The Hylas 56, first launched in 2010, is a mid-sized bluewater cruiser that has earned acclaim throughout the yachting industry as one of the most popular models ever produced by Hylas Yachts. With 27 hulls built, Slainte is among the last delivered as Hull Number 26.</p>
<p>Designed with the signature lines and performance put forth by renowned Naval Architect German Frers and constructed by Queen Long Marine, the exclusive builder of Hylas Yachts, known for their legendary craftsmanship, stout construction, and elegant interior finishings.</p>
<p>Final commissioning was completed in November of 2018. Since then, Slainte has enjoyed extensive cruising throughout the Northwestern Atlantic. Commissioned by an experienced sailor, Slainte was designed to meet the needs that were lacking in their previously owned vessels, making her perfect for summer family cruises in Long Island Sound to Montauk and Block Island, onward to Newport, cruising the Vineyard and Nantucket Sounds as well as offshore passages to Bermuda, BVI’s, Bahamas and up and down the Atlantic coast.</p>
<p>No expense has ever been spared with regards to upkeep and upgrades. As with any fine yacht, Slainte’s program has always emphasized safety first, which has been achieved through a diligent preventative maintenance regime. Slainte has always been under the management of a professional captain who assisted with passage planning and basic vessel handling while underway for offshore passages and deliveries and managed any upgrades and general maintenance while ashore.</p>
<p>A refit was completed in Connecticut during the 2020/21 winter season due to the associated travel complications related to the pandemic. The rig was removed and inspected, and some components were upgraded. The batteries were also replaced, along with a list of other improvements.</p>
<p>She was most recently hauled in March of 2022 for fresh paint on the hull, boot, cove stripes, and anti-fouling paint on the bottom and running gear. Slainte is as good today as the day she was commissioned and is always ready to take you anywhere you desire, safely, comfortably, and in full Corinthian style.</p>
<p><strong>Highlights</strong></p>
<ul>
<li>NEW Hull paint in Flag Blue with Snow White Cove and Boot Stipe! – March 2022!</li>
<li>NEW SeaHawk Red Bottom Paint – March 2022!</li>
<li>Exquisite teak interior with finely finished raised panel cabinets with high-end furniture-grade fixtures.</li>
<li>Bamboo cabin sole with teak inlay and positive locking sole hatches for offshore sailing.</li>
<li>Granite countertops throughout the galley and marble in the forward and aft heads.</li>
<li>Custom IMTRA lighting with dimmers and valance lighting throughout the yacht</li>
<li>High-quality upgrades include Moen faucets and plumbing fixtures, Cameo headliners, and Ultrafabric soft goods.</li>
<li>Twaron hull with carbon aramid fiber reinforcement, solid layup without core</li>
<li>Linen Beige molded non-skid fiberglass deck</li>
<li>Teak toe rail and rub rail (un-varnished)</li>
<li>Manship hull ports and opening deck hatches</li>
<li>Watertight collision bulkheads fore and aft</li>
<li>Side-Power bow thruster</li>
<li>Pushpit extended to the mid-ship gates</li>
<li>Full suite of Raymarine cruising electronics and iCOM communication equipment</li>
<li>110 HP Yanmar engine with 1,600 hours</li>
<li>9kW Northern Light generator with 1,250 hours</li>
<li>MaxProp Easy 22 propeller</li>
</ul> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0160F686-9A38-F44F-B88DB9B15822B285 |
[empty string] |
[empty string] |
[empty string] |
1965 |
[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 |