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] |
Hallberg Rassy |
62' |
2008 |
17' 3 |
8' 2 |
72,755 lbs |
Fiberglass |
German Frers |
[empty string] |
225 hp |
Sail |
Bonnefooi |
$995,000 |
Saint Martin |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
Sabre Turbo |
Perkins |
[empty string] |
426 Gallons |
413 Gallons |
62 |
Hallberg Rassy (62' Fiberglass) |
Bonnefooi (62') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Quality, Safety, Comfort, Craftsmanship</p>
<p>The Hallberg-Rassy 62, designed by German Frers and first produced in 1997 was the flagship model, showing off HR’s deep commitment to the safety and comfort of their owners. These boats are thoroughly thought out to ensure both the ownership experience and the sailing experience will be all pleasure. </p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
722B1BEB-A1D5-B70C-944802FD0CADF73D |
[empty string] |
[empty string] |
[empty string] |
3045 |
[empty string] |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Nautitech |
47' |
2007 |
24' 9 |
5' 2 |
24,757 lbs |
Fiberglass |
[empty string] |
[empty string] |
54HP |
Sail |
Sayonara 2 |
$349,000 |
Marigot, Saint Martin |
[empty string] |
Diesel |
[empty string] |
2790 Hours, 2159 Hours |
2 |
4JH4 |
Yanmar |
20 Gallons |
220 Gallons |
300 Gallons |
47 |
Nautitech (47' Fiberglass) |
Sayonara 2 (47') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p><strong>The Perfect Balance Between Sailing Performance and Comfort! </strong></p>
<p><br />The Nautitech 47 is widely regarded as one of the best-looking catamarans ever built. She looks quick, nimble and elegant even while sitting still. She's not only about good looks, she's a real sailor's boat that goes quick, is very responsive and has a sporty feel, while still retaining large and comfortable interior spaces. With only around 38 of these boats built in a 6-year run, these are hand-built, really well constructed, safe, blue-water boats. </p>
<p>The outboard helms provide amazing sightlines and really connect you with the wind and the sea when underway. When the weather is inclement, let the pilot drive and stay dry in the comfortable cockpit underneath the large hard bimini top. The lack of flybridge allows for an enormous, powerful mainsail with a boom set low down for a much lower center of effort. </p>
<p>Build quality of these boats is top notch; even in heavy seas there's no sense of stressing the boat, she remains quiet and composed, really inspiring confidence. This model features enormous wide side decks further inspiring confidence when moving around the vessel.</p>
<p>Upstairs is a u-shaped galley that is larger and more practically laid out than most catamarans of this size. The saloon is large, open and airy, the folding dining table able to seat perhaps 8 guests. There's also a very comfortable and practical navigation station for piloting when underway, or that serves as a comfortable workspace while stationary. Throughout the boat the furnishings are higher-quality wood veneers, there's no sense of ikea flat pack furniture on these vessels.</p>
<p><br />Down below are 4 cabins with ensuite heads, plus 2 kiddie/crew berths in each of the the forepeaks. Berths are large and comfortable, surrounded by rich and beautiful real-wood panelling. (One of the 4 heads is currently converted to a laundry facility). Plentiful ports and hatches makes for an airy, breezy sleep.</p>
<p>The vessel is currently a full-time cruiser and will be delivered ready to carry on exploring the Caribbean and beyond. She's equipped with high-quality Lithium battery bank, 2 solar arrays, 60L/hr watermaker. A large front-opening fridge and separate front-opening freezer keep you in fresh food for many days. The vessel comes with all the household goods required to cruise immediately. </p>
<p>She's powered by 54HP 4JH Yanmars with around 3,000 hours. Slow cruise fuel consumption is 2.2 Litres per hour per engine. SD50 Saildrives (recently disassembled and refreshed) are equipped with folding propellers for efficiency under sail. 3.4M Highfield tender is new from April of 2021, 18 HP Tohatsu Everrun outboard is from October of 2021.</p>
<p>Turn heads in every anchorage in this beautiful vessel, while you live aboard in safety and comfort. </p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
60D24229-9BAD-E985-BC7CC8ED89CD9576 |
[empty string] |
[empty string] |
[empty string] |
3026 |
[empty string] |
3 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Lagoon |
46' |
1993 |
24' 11" |
3' 11" |
19,842 lbs |
Fiberglass |
M. Van Pethegem - V. Lauriot-Prevost |
[empty string] |
28 HP |
Sail |
Lambada |
$225,000 |
Carriacou, Grenada |
[empty string] |
Diesel |
[empty string] |
[empty string] |
2 |
3GM30 |
Yanmar |
[empty string] |
95 Gallons |
185 Gallons |
47 |
Lagoon (46' Fiberglass) |
Lambada (46') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Those that know understand that these early Lagoons are not to be compared with their later cousins. These boats are lean, sleek and quick and built really well. Because they're so quick and sail so well, they continue to be in demand, though now come to market infrequently. </p>
<p>Lambada has been well cared for by her current owner, and the pride of ownership shows. She's clean and tidy and well-maintained. This version is a galley down layout with 4 cabins and three heads, the main head featuring a large separate shower. There is a great sense of openness and space everywhere. The galley is large with tons of working and storage space. The cockpit is roomy and breezy (look at the pics of the beautiful table!), the side decks are wide and easy to move about. The foredecks area is large with lots of room for lazing on a sunbed or reading in the trampoline in the evening breeze. </p>
<p>Lambada will make a fine fast cruiser for a couple or a family. Situated in Carriacou, Grenada, she's ready to take off immediately to explore the beautiful Grenadines.</p>
<p>More pictures are available upon request. </p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
A7AECAFB-C983-D1BB-7DFB08C437900BBF |
[empty string] |
[empty string] |
[empty string] |
3024 |
[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 = 52 and ( isArchived = 0 OR isArchived IS NULL)
ORDER BY data02 DESC |