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 |
$350,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] |
75797639-A897-ED20-8C2B685B05458232 |
[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] |
Amel |
46' |
1990 |
13' |
6' 2 |
24,250 lbs |
Fiberglass |
[empty string] |
[empty string] |
50 HP |
Sail |
Notorious |
$98,500 |
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] |
B9CA431F-C561-D3C5-22A159821E4FA077 |
[empty string] |
[empty string] |
[empty string] |
3018 |
[empty string] |
3 |
[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] |
4 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Pacific Seacraft |
37' |
1990 |
10' 10" |
5' 6" |
[empty string] |
Fiberglass |
William Crealock |
[empty string] |
44 hp |
Sail |
Earendil |
$119,000 |
Cataumet, MA |
[empty string] |
Diesel |
[empty string] |
3260 Hours |
1 |
4 JHE |
Yanmar |
[empty string] |
[empty string] |
[empty string] |
Crealock 37 |
Pacific Seacraft (37' Fiberglass) |
Earendil (37') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Earendil has been well maintained by her single owner since she left the shipyard in San Diego. <br />This William Crealock designed boat is well suited to cruise the Gulf of Maine on down to the shoals of the Bahama's in a good balance of speed and comfort. The diesel heater dampens the chill of Maine and the excellent ventilation makes for comfortable nights on the hook in the warmer latitudes. <br />The solid laid up hull provides a stiff and rugged hull for the offshore cruising days. The balsa core insulation added to the hull adds additional warmth while cruising ocean waters.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
2AE121AE-991C-CC82-C93099EACC15F589 |
[empty string] |
[empty string] |
[empty string] |
3036 |
[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 |