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] |
Hanse |
57' |
2015 |
17' |
9' 6 |
42,990 lbs |
Composite |
Judel/Vrolijk & Co. |
[empty string] |
110 HP |
Sail |
Relentless |
$525,000 |
Brunswick, GA |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
4JH-110 |
Yanmar |
[empty string] |
138 Gallons |
214 Gallons |
575 |
Hanse (57' Composite) |
Relentless (57') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Relentless is a well maintained, gently enjoyed and well equipped Hanse 575. Built in 2015, she was displayed and represented the Hanse brand as the flagship of the 2016 and 2017 Annapolis boats shows. Since then, she has been cruising New England, Maine , Nova Scotia and has recently returned from 3 years in the Caribbean. Relentless is a turnkey, live aboard, blue water yacht that is self sufficient on anchor with onboard water making, laundry, solar power, generator, AC, dish washers, a wine fridge and more. She is spacious, luxurious and is the perfect vessel for an entertaining cruising couple. Hanse’s easy sailing concept makes this large yacht a pleasure to sail in all conditions, near shore and off shore. The current owners sail her as a couple and also single handed. She has recently been professionally repowered with the newest, state of the art 110hp, electronic controlled and EPA compliant Yanmar 4JH turbo diesel engine.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
D26F3717-AEA6-D442-B0ADC5F239200782 |
[empty string] |
[empty string] |
[empty string] |
1987 |
[empty string] |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Alden |
56' |
1998 |
15' 8 |
[empty string] |
[empty string] |
Fiberglass |
[empty string] |
[empty string] |
660 HP |
Power |
Domicilium |
$348,000 |
Wickford, RI |
[empty string] |
Diesel |
[empty string] |
1920 & 1925 Hours |
2 |
3196 |
Caterpillar |
40 Gallons |
715 Gallons |
150 Gallons |
Flybridge Motor Yacht |
Alden (56' Fiberglass) |
Domicilium (56') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Built for a very knowledgeable owner, this Alden has been cruised from Maine to the Keys. Interior arrangement includes an en-suite owners stateroom and VIP stateroom. An additional room has a berth for another guest or captain. Equipped with all the navigational, safety and comfort amenities expected of a quality builder.</p>
<p>One of the highlights of the Alden 56 is it's performance in a chop. The Hunt designed deep V hull and modest beam makes her a safe and comfortable boat when crossing Buzzards Bay or running down the coast.</p>
<p>Recent updates and servicing of engines and auxiliary systems. Ready to cruise.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
3073E144-E0AC-BACB-E29E56EDF7E1BE4A |
[empty string] |
[empty string] |
[empty string] |
1996 |
[empty string] |
3 |
14.02 |
no |
[empty string] |
[empty string] |
[empty string] |
yes |
no |
no |
Alden |
46' |
1988 |
13'6 |
5' 4 |
35,000 lbs |
Fiberglass |
J G Alden |
Westerbeke |
55 HP |
Sail |
Cara Lynn |
$199,000 |
Annapolis, MD |
[empty string] |
Diesel |
[empty string] |
2700 Hours |
1 |
[empty string] |
Westerbeke |
[empty string] |
105 Gallons |
220 Gallons |
[empty string] |
Alden (46' Fiberglass) |
Cara Lynn (46') |
no |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p><strong>CARA LYNN</strong> is a very well maintained and equipped Alden 46 that was designed and built by one of New England's highest quality semi-custom builders. The current and second owners of CARA LYNN have made the ongoing investment in upgrades and proper service. Her classic profile with aft cockpit is a standout wherever she cruises. This exceptionally strong, sea-kindly performance cruising yacht has an exquisite two-stateroom varnished teak interior and is very well equipped for extended shorthanded offshore cruising. Her shoal draft keel with centerboard allows access to many more sailing areas and harbors.</p>
<p>Accommodations include a very comfortable main salon, spacious galley, wide navigation center, large master suite forward with double V berth with ensuite head with separate stall shower, aft guest cabin with a convertible queen, and guest/day head is conveniently located adjacent to the companionway. </p>
<p>Recent upgrades in 2014/2015 include the addition of a bow thruster, 2 new heads (one electric), new holding tank, bottom and keel refinished and painted and unstepping, disassembling, and inspecting rigging and repainting mast. Also, the hull was Awl Gripped and the hydraulic system upgraded. The approximate cost of the 2014/15 upgrades was $60,000. Former upgrades include Seafrost holding plate refrigeration, full rudder bearing service in 2008, North MPS with sock (2006), Northstar 952 GPS plotter with cockpit repeater, new headliners throughout, and rebedded deck hatches, genoa tracks, and opening ports.</p>
<p>For sailors looking for a beautiful, proven, high quality, semi-custom, handcrafted, performance cruising design, that is fast and sea-kindly, the Alden 46 Cara Lynn is worthy of a serious look. She is one of the finest 40'-50' semi-custom production yachts ever built and is one of Alden's most popular designs. The cost to replace her today would be approximately $1.2 million if built by an established New England yard. Her large aft cockpit, wide side decks, and foredeck make her a pleasure to sail. The sea-kindly hull and shoal draft keel design and spacious interior arrangement offer superior safety and comfort for offshore passage making or coastal cruising. Cara Lynn has a great equipment inventory, many upgrades and is in excellent condition ready to cruise.</p>
<div> </div>
<div> </div> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
23233250-C7AC-9210-A16916C5BF3C4F9D |
[empty string] |
[empty string] |
[empty string] |
419 |
9999 |
4 |
14.02 |
no |
[empty string] |
[empty string] |
[empty string] |
yes |
no |
no |
Cambria |
46 |
1985 |
13'6 |
5'9 |
31,000 lb |
White fiberglass |
David Walters |
Perkins |
60 HP |
Sail |
Pegasus |
$130,000 |
Bristol, RI |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
4-154 |
Perkins |
[empty string] |
85 Gallons |
130 Gallons |
44/46 |
Cambria (46 White fiberglass) |
Pegasus (46) |
no |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>There are many reasons so many Cambria owners have kept their boats for 15, 20 or more years. Quality design and construction are the key elements. Exceptional strength and comfort are combined with manageable performance and beautiful lines. Pegasus is truly a classic yacht that has never been chartered or sailed in southern waters. Although now over 30 years old, her light use offers her next owners a high quality yacht that has fewer sea miles and lower engine hours than most yachts half her age.</p>
<p>Since delivery Pegasus has only been sailed summers in New England waters. Maine, Cape Cod and Rhode Island have become the preferred cruising waters. For many years she was stored at Hinckley Yachts in Southwest Harbor Maine and had worked completed by Quality Yachts in Tiverton, Rhode Island. She is currently stored during the winter at Bristol Marine, Bristol Rhode Island. Over the years her owners have continuously upgraded the equipment, and systems. Highlights of improvements include new engine, Quantum sails, rod rigging, roller furling, mast lights, asymmetrical spinnaker, new autopilot, GPS, solar panels, Mack Pack and both companionway dodgers.</p>
<p>Added benefits of Pegasus are her keel board design that provides a shoal draft fin keel, and rudder that is fully protected by a rugged skeg. Cambria’s are most often sailed by a couple. Pegasus has also been single handed many times and competed in the 2007 Bermuda 1-2.. The centerboard is available for added performance sailing to windward however is seldom lowered because the Cambria is good on all points of sail with the board in the raised position.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
7CBA2AEA-B552-DAB4-8493734F97A3298A |
[empty string] |
[empty string] |
[empty string] |
286 |
9999 |
5 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Sea Ray |
45' |
1999 |
14' 3" |
3' 1" |
27,000 lbs |
Fiberglass |
[empty string] |
[empty string] |
430 HP |
Power |
Resilience |
$147,500 |
East Greenwich, RI |
[empty string] |
Diesel |
[empty string] |
478 Hours |
2 |
73P |
Volvo |
55 Gallons |
350 Gallons |
120 Gallons |
420 |
Sea Ray (45' Fiberglass) |
Resilience (45') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Excellent example of a clean, well cared for SR 420AC. Low hours on a pair of Volvo 430 hp diesels, generator, AC, and bow thruster. All the equipment for safe comfortable coastal cruising.</p>
<p>The Sea Ray 420 Aft Cabin has three comfortable staterooms, ample walkways, and a cockpit that can accommodate a host of guests with ease. Below, the wide-open cabin allows passengers to enjoy a sumptuous interior noted for its quietness thanks to Sea Ray's patented underwater exhaust system, which reduces engine noise significantly while underway. An L-shaped salon sofa with pull-out ottomans provides a relaxing atmosphere. There's also a convenient raised L-shaped dinette with room for four.. Rich wood finishes complement the fully equipped galley, which features a flush-mounted three-burner electric stove, a microwave, refrigerator with freezer, sink, custom-molded countertop with new Corian covers, and a tremendous amount of storage space above and below. A Spacemaker coffee maker also comes standard on the 420 Aft Cabin. The staterooms are lavish, from the aft master stateroom with queen-size bed and innerspring mattress, abundant storage, and full master head with shower; to the forward stateroom V-berth with full-size pedestal bed and plenty of built-ins..The 420 Aft Cabin also has a port stateroom with twin beds for additional sleeping and storage space, Above, passengers can congregate on the roomy aft deck of the Sea Ray 420 Aft Cabin in any weather because it's protected by a fiberglass hardtop, custom fiberglass skirts, and acrylic entrance doors to port and starboard. The smooth, clean profile means there are no steps to the foredeck. A transom door allows easy access to the swim platform where there's an oversized storage compartment with gas-assisted hatch and automatic sump pump. The forward-mounted bridge helm affords the captain better visibility forward and aft, while guests have a wide open space to enjoy the bar The seating arrangement includes two custom slide and swivel helm seats, an aft-facing sun lounger and a bench seat. Courtesy lights, snap-in carpet, and beverage holders are also part of the appealing setting. The 420 Aft Cabin also includes a wealth of standard systems like the digital LCD systems monitor, remote start generator, Garmin electronics, anchor washdown hookup, portside storage concealing a dedicated shore power inlet and much, more.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
62CF7FAC-E8D2-132C-9F00C75C6D5762DE |
[empty string] |
[empty string] |
[empty string] |
3014 |
[empty string] |
6 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Island Gypsy |
44' |
1992 |
15' 4" |
4' 3" |
40,000 lbs |
Fiberglass |
[empty string] |
[empty string] |
550 HP |
Power |
Kodiak |
$155,000 |
East Greenwich, RI |
[empty string] |
Diesel |
[empty string] |
2566 Hours |
2 |
6V92TA |
Detroit |
40 Gallons |
720 Gallons |
320 Gallons |
44 |
Island Gypsy (44' Fiberglass) |
Kodiak (44') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Great Loop Compatible</p>
<p>The 44 Island Gypsy Motoryacht was designed by Harvey Halvorsen for the yachtsman who wanted a good looking sports yacht with a heavy, comfortable riding semi-displacement hull. This 44 Island Gypsy Motoryacht features three staterooms, two heads, large saloon and covered cockpit. L-shaped settee on fly bridge with two helm seats and fold down stairs to fore deck. Semi-displacement hull is comfortable at 10 knots or her top speed of 20 knots. Includes a 15 kw generator, five A/C units, new reefer, teak and holly soles, electronics and more. </p>
<p>Completed the Loop with previous owner.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
6249339F-0E87-10F0-9AA4FE1E6DDC5E5F |
[empty string] |
[empty string] |
[empty string] |
3013 |
[empty string] |
7 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Stevens |
40' |
1983 |
12' 7 |
6' |
24,000 lbs |
Fiberglass |
[empty string] |
[empty string] |
75 HP |
Sail |
Estella |
$149,000 |
Newburyport, MA |
[empty string] |
Diesel |
[empty string] |
[empty string] |
1 |
4JH4-TE |
2014 Yanmar |
40 Gallons |
80 Gallons |
216 Gallons |
40 |
Stevens (40' Fiberglass) |
Estella (40') |
[empty string] |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>One of only seven built, this custom cruiser designed by the esteemed Sparkman & Stephens naval architects and built at Queen Long Marine features only 3 owners. She has been lovingly maintained with the current owners investing over $200,000 USD. There are redundant systems throughout and lots of spare parts. Estella is ready to take her new owners anywhere in the world.</p>
<p>The center cockpit design allows an aft owner’s stateroom that is fit for proper accommodations featuring a huge, comfortable berth (fitted with lee cloths) and lots of headroom. There is a hanging locker, small counter area, and multiple storage bins, lockers and drawers. Adjacent to the aft stateroom, to starboard, is a fully enclosed, double access head with separate shower stall.</p>
<p>The galley is located to port with the double SS sinks located along the centerline. The center island below the companionway allows for excellent engine access.</p>
<p>Forward of the aft head is the nav station, which has ample area for storage of charts, books, navigation tools and electronics as well as a hanging locker.</p>
<p>The main salon has a port side L-shaped settee and straight settee to starboard. There is excellent storage outboard of the P&S settees in enclosed lockers and various areas of open and closed storage above the seat backs. The starboard settee pulls out to convert to a pilot berth (with lee cloth). Forward of the salon to port is the forward head which has access from both the main salon and the forward stateroom. Opposite is a wine locker and counter area with an additional large locker below.</p>
<p>The forward stateroom has a large and comfortable V-berth (fitted with lee cloths) just right for your guests or children. There is a hanging locker, two storage drawers and two additional storage lockers. (sail storage is accommodated in a separate area below the V-berth)</p>
<p>The interior is finished in varnished teak and offers a warm, traditional but bright feeling. There are plenty of opening ports and deck hatches to provide exceptional ventilation. The cabin sole is varnished, solid teak and holly. The galley and heads are finished in off white Formica with varnished teak trim for easy maintenance.</p>
<p>There is ample storage throughout the interior of the vessel as well as an oversized lazarette on the aft deck and a dedicated vented propane locker that can accommodate (2) 20-lb tanks.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
81AB98DE-04F8-D399-11EA6A429178C696 |
[empty string] |
[empty string] |
[empty string] |
781 |
[empty string] |
8 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Mason |
33' |
1985 |
10' 10 |
5' 2 |
14,020 lbs |
Fiberglass |
[empty string] |
[empty string] |
[empty string] |
Sail |
Mara |
$57,500 |
Pocasset, MA |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
35 |
100 |
33 |
Mason (33' Fiberglass) |
Mara (33') |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
<p>Classic, world cruiser recently updated by current owner. Needs nothing to take you anywhere you want to go. One of the many highlights is a 2011 Yanmar with only 500 hours on her. Lots of custom touches including coal stove heater, a "dipstick" door and five deck prisms for additional lighting. Owners change in plans necessitates her sale.</p> |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
C7E2AA44-C3A5-A8EC-F3C90248DF89D989 |
[empty string] |
[empty string] |
[empty string] |
3010 |
[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 = 10 and ( isArchived = 0 OR isArchived IS NULL)
ORDER BY data02 DESC |