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] |
Cheoy Lee |
63' |
1985 |
18' 6 |
6' 6 |
98,500 lbs |
Fiberglass |
[empty string] |
[empty string] |
[empty string] |
Sail |
Maraya II |
$385,000 |
Edgewater, MD |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
3208 |
Caterpillar |
[empty string] |
1500 Gallons |
1275 Gallons |
Motor Sail 63 |
Cheoy Lee (63' Fiberglass) |
Maraya II (63') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Maraya II is a classic long range motor sailor. With fuel capacity of 1500 gallons and a cruising speed of 9 knots she can go well over 1,000 miles when the wind does not blow. For the true patient cruiser she can carry you around the world comfortably without ever stopping for fuel. <br />She has been kept current with on going maintenance and equipment replacement making her ready for the next big cruise.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
5954983B-B5F2-453E-7BD95A9E754446F1 |
[empty string] |
[empty string] |
[empty string] |
3029 |
[empty string] |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Beneteau |
57' |
2010 |
16' 4 |
8' 7 |
48,623 lbs |
Fiberglass |
Bruce Farr |
[empty string] |
160 HP |
Sail |
Suzie Too |
$449,000 |
Annapolis, MD |
[empty string] |
Diesel |
[empty string] |
2730 Hours |
1 |
4LHA |
Yanmar |
55 gallons |
180 gallons |
260 gallons |
Farr 57 |
Beneteau (57' Fiberglass) |
Suzie Too (57') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>This is not your average Beneteau. This Bruce Farr designed vessel was built in the Waquiez yard in Lille, France. Her single owner commissioned the project upgrading structure and systems right from the beginning. She has spent her life cruising to the Islands each winter and back to the US for professional service and care.</p>
<p>Suzie Too has had constant upgrades to maintain her superlative cruise ready state. The new dinghy and outboard motor added just last year and sails the year before are a testimony to the extensive care she has received.</p>
<p>This is one of the finest, cleanest sailboats I have seen in quite some time fully equipped and ready for blue water adventure.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
CF01A096-AEAC-814E-96EF26A206614CE9 |
[empty string] |
[empty string] |
[empty string] |
1981 |
[empty string] |
3 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Amel |
46' |
1990 |
13' |
6' 2 |
24,250 lbs |
Fiberglass |
[empty string] |
[empty string] |
50 HP |
Sail |
Notorious |
$115,000 |
Annapolis, MD |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
[empty string] |
Perkins |
[empty string] |
160 Gallons |
210 Gallons |
46 |
Amel (46' Fiberglass) |
Notorious (46') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Amel Santorin 46 is designed and built for blue water sailing in comfort and safety. The solid fiber glass hull, fully bonded hull, deck and bulkheads make her stiff and able to stand up to turbulent seas.<br />Notorious is an excellent example of a well cared for yacht ready for blue water adventure. She is well equipped and ready for an adventure to the Islands and beyond.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0017FD20-A68C-C30B-81D1499AC29237B4 |
[empty string] |
[empty string] |
[empty string] |
3018 |
[empty string] |
4 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Valiant |
40' |
1977 |
12' 4 |
5' 11 |
22,450 lbs |
Fiberglass |
[empty string] |
[empty string] |
[empty string] |
Sail |
Black Douglas |
$98,500 |
Spring Cove, MD |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
BV2203EPA |
Beta |
14 Gallons |
85 Gallons |
125 Gallons |
40 |
Valiant (40' Fiberglass) |
Black Douglas (40') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>The Valiant 40 is a very popular cruising vessel. The Bob Perry design is a near perfect balance between comfort at sea and good sailing performance. The solid laid up hull construction makes her a sturdy craft at sea.</p>
<p>Black Douglas has been meticulously cared for and upgraded all her life. The hull was laid up in 1977 but most everything else on this vessel is recently refurbished or replaced. She was repowered in 2006 with a 50 HP Beta diesel that has less than 400 hours. Below are upgrades and additions in just the last two years.</p>
<p>2021 Upgrades and Replacements:</p>
<ul>
<li>North Sails Mainsail with 3 Reef Points</li>
<li>Furler Sail Modified</li>
<li>Rod Standing Rigging</li>
<li>Running Rigging</li>
<li>Hydraulic Backstay Adjuster</li>
<li>Rebuilt Profurl Furler</li>
<li>Hailer and Horn</li>
<li>Tri-color, Anchor Light, Strobe and Deck Light</li>
<li>2 Coats Bottom Paint and New Zincs</li>
</ul> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
5FF3A019-F58F-65B3-5B7B911A98C316EC |
[empty string] |
[empty string] |
[empty string] |
1929 |
[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 = 30 and ( isArchived = 0 OR isArchived IS NULL)
ORDER BY data02 DESC |