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] |
Alden |
47' |
1974 |
13' 9 |
6' 1 |
32,700 lbs |
Fiberglass |
John Alden |
[empty string] |
75 HP |
Sail |
Fawkes |
$71,000 |
Annapolis, MD |
[empty string] |
Diesel |
[empty string] |
3043 Hours |
1 |
4JH4-TE |
Yanmar (2009) |
35 Gallons |
200 Gallons |
200 Gallons |
Dolphin 47 |
Alden (47' Fiberglass) |
Fawkes (47') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Alden Dolphin 47</p>
<p>Looking for a Classic Yacht, without the dark cave interior?</p>
<p>Fawkes has the classic lines and the sturdy construction with an abundance of natural light and ventilation while still retaining the <br />Old Classic Styling & Clipper Bow<br />Cutter Ketch For Multiple Sail Plans<br />Full Keel</p>
<p>Her Interior Woodwork shines like new and her galley/salon area is wide open and bright</p>
<p>Cook a meal while watching dolphins through the giant static ports</p>
<p>Her current owners cruised on the boat for 12 years and homeschooled their children for four of those years. <br /> Many fond memories aboard Fawkes, but now it's time for new owners to continue the journey and she's ready to fulfill new dreams.</p>
<p>Thinking of living Aboard, Cruising the Islands?</p>
<p>Here's Fawkes equipment list that will help make living aboard a reality:</p>
<p>Watermaker <br />Dinghy & Davits <br /> Robust Maxwell 3500 with reversing solenoid <br />73 lb Rocna <br />Furuno 36 Mile Radar <br />Auto Pilot: Simrad NAC-3 <br />AIS Send & Receive <br />(You See Them, They See You)</p>
<p>Kyocera Solar (2) 85 Watts, (2) 135 Watts <br />Regulator: Victron MPPT 75/50 <br />Oversized Alternator (Balmar 110 amp) <br />Fuel Polishing System</p>
<p><br />Over the year's numerous improvements have been made including a Yanmar motor in 2009<br /> <br />Look over the list of improvements and upgrades in the description section</p>
<p>Virtual showings available</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
CCA8A812-F5E4-96A8-31B5EA1CB296413A |
[empty string] |
[empty string] |
[empty string] |
1847 |
[empty string] |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hylas |
46' |
2002 |
13' 9 |
6' 6 |
27,777 lbs |
Fiberglass |
German Frers |
[empty string] |
75 HP |
Sail |
Brizo |
$365,000 |
Annapolis, MD |
[empty string] |
Diesel |
[empty string] |
6710 Hours |
1 |
4JH2-TE |
Yanmar |
[empty string] |
165 Gallons |
210 Gallons |
46 |
Hylas (46' Fiberglass) |
Brizo (46') |
[empty string] |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>The Hylas 46 is one of the most desirable Hylas models, and for good reason!Brizo will not disappoint!<br />"Brizo" is a beautiful Dark Green 2002 Hylas 46 She is in excellent condition with the standard 6'6" draft keel, and a very comprehensive list of extras. The 46 is one of German Frers' most successful designs built by one of the worlds highest quality semi-custom yards, Queen Long. Brizo is set up to sail shorthanded with Boom Furling, electric winches and side power bow thruster. Meticulous owner with attention to detail has kept this boat in cruise ready condition. Her luxury options include 2 zone reverse cycle A/C and heating, only 250 hours on the generator. She's ready to go!</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
9A99C583-D9E6-AB92-0F333B8008D44C75 |
[empty string] |
[empty string] |
[empty string] |
1925 |
[empty string] |
3 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Voyage Yachts |
44' |
2000 |
25' 1" |
4' 1" |
22,000 lbs |
Fiberglass |
[empty string] |
[empty string] |
[empty string] |
Sail |
Kelpie |
$385,000 |
Cape Canavarel, FL |
[empty string] |
Diesel |
[empty string] |
3900 Hours |
2 |
3JH3E |
Yanmar |
[empty string] |
[empty string] |
[empty string] |
440 |
Voyage Yachts (44' Fiberglass) |
Kelpie (44') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>S/V Kelpie is a 2000 Voyage 440 catamaran Kelpie is a 3-cabin, 2-head owners version layout.<br />No expense was spared! This Yacht has undergone over $175K in upgrades and service in the past 12 months. It is a fully capable cruising yacht and has been cruised for the past 11 months.<br />This boat is fully loaded, including air conditioning throughout, and a washing machine.<br />She comes equipped with New B&G electronics and radar, AIS, folding props, HVAC, watermaker, washing machine, electric winch, solar panels, 1600Ah lithium batteries, aluminum arch with solar (1200watts) and dinghy davits, new bottom paint (2022) and more.</p>
<p>This boat is a well-kept world cruiser which has been maintained to the highest standard, with a good selection of important spare parts, and a 62ft ICW friendly mast height. She is an “off the grid” boat; everything runs off the solar and battery system.</p>
<p>Did we say this boat is Fast? She has Great performance – The voyage 440 was the first multihull to win yacht of the year against mono hulls. She amazing sailing boat. 10+ knots under sail is easily achievable and has seen speeds of up to 14 knots. New sails and the heavily raked main allow for great pointing angles</p>
<p>Intercoastal compliant 62.5′ height</p>
<p>Electronics are the newest available B&G, boat is capable of running both AC units and water heaters off the New Victron 5K Quatro Inverter, 1600AH of Lithium batteries providing comfort at night without firing up the genset.</p>
<p>Hydranet sails and Dynema Running rigging – Only the best for this boat</p>
<p>If your looking for a boat that has really been outfitted for cruising, this is your boat.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
A7B1FFB5-B7CE-6000-7C9770BB0A1AFFFA |
[empty string] |
[empty string] |
[empty string] |
1990 |
[empty string] |
4 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Cruisers Yachts |
37' |
2000 |
13' 8" |
[empty string] |
[empty string] |
Fiberglass |
[empty string] |
[empty string] |
[empty string] |
Power |
Comfort Zone |
$115,000 |
Annapolis, MD |
[empty string] |
Diesel |
[empty string] |
850 Hours |
2 |
6LY2 |
Yanmar |
[empty string] |
[empty string] |
[empty string] |
3750 |
Cruisers Yachts (37' Fiberglass) |
Comfort Zone (37') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>2000 Cruisers 3750 Motoryacht Low Engine Hours Port Engine 850 Hours, Starboard Engine Rebuilt with 200 hours 7kw Generator has only 1240 hours Aft Cabin Layout "Comfort Zone" has two cabins and two heads Her interior is light and bright throughout 2 Zone Air Conditioning Vacu flush heads New Refrigerator Galley is Generous size Desirable Yanmar Engines Canvas is only 3 years old New swim platform synthetic teak New carpet on aft deck</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
3AFC4415-950C-31D5-6D7409AC22C1CB5B |
[empty string] |
[empty string] |
[empty string] |
1934 |
[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 = 32 and ( isArchived = 0 OR isArchived IS NULL)
ORDER BY data02 DESC |