query
RESULTSET
query
  ASKINGPRICE ASKINGPRICEFORMATTED BOATNAME BUILDER CALC_1 CALC_2 CALC_3 CALC_4 CURRENCY 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 DATA26 DATA27 DATA28 DATA29 DATA30 DEC01 DEC02 DEC03 DEC04 DEC05 DEC06 DEC07 DEC08 DEC09 DEC10 DEFAULTSORT FB_ADMINS FIELDORDER INCLUDEOFFICE INCLUDEUSER INCSECTIONS INT01 INT02 INT03 INT04 INT05 INT06 INT07 INT08 INT09 INT10 ISARCHIVED ISFEATURED KEYWORDS LAB01DEC LAB01INT LAB01MEM LAB01STR LAB02DEC LAB02INT LAB02MEM LAB02STR LAB03DEC LAB03INT LAB03MEM LAB03STR LAB04DEC LAB04INT LAB04MEM LAB04STR LAB05DEC LAB05INT LAB05MEM LAB05STR LAB06DEC LAB06INT LAB06MEM LAB06STR LAB07DEC LAB07INT LAB07MEM LAB07STR LAB08DEC LAB08INT LAB08MEM LAB08STR LAB09DEC LAB09INT LAB09MEM LAB09STR LAB10DEC LAB10INT LAB10MEM LAB10STR LAB11MEM LAB11STR LAB12MEM LAB12STR LAB13MEM LAB13STR LAB14MEM LAB14STR LAB15MEM LAB15STR LAB16MEM LAB16STR LAB17MEM LAB17STR LAB18MEM LAB18STR LAB19MEM LAB19STR LAB20MEM LAB20STR LAB21STR LAB22STR LAB23STR LAB24STR LAB25STR LAB26STR LAB27STR LAB28STR LAB29STR LAB30STR LOAFEET LOAMETERS MEM01STATE MEM02STATE MEM03STATE MEM04STATE MEM05STATE MEM06STATE MEM07STATE MEM08STATE MEM09STATE MEM10STATE MEM11STATE MEM12STATE MEM13STATE MEM14STATE MEM15STATE MEM16STATE MEM17STATE MEM18STATE MEM19STATE MEM20STATE MEMO01 MEMO02 MEMO03 MEMO04 MEMO05 MEMO06 MEMO07 MEMO08 MEMO09 MEMO10 MEMO11 MEMO12 MEMO13 MEMO14 MEMO15 MEMO16 MEMO17 MEMO18 MEMO19 MEMO20 METADESCRIPTION MFRNAME MFRREF MODELNAME MODELREF OFFICENAME OFFICEREF OG_DESC OG_IMAGE OG_TITLE OG_TYPE OG_URL PHOTOCAPTION PHOTOID PRIORITY RANDOMSEED SALESPERSON SALESPERSONCELLPHONE SALESPERSONEMAIL SALESPERSONPHONE SCHEMA_DESC SCHEMA_IMAGE SCHEMA_NAME SEOPAGETITLE SEOPREVIEWTEXT SEOURL STAFFREF TEMPLATEDESC TEMPLATEID TEMPLATENAME TEMPLATEREF TWITTER_CARD TWITTER_DESC TWITTER_IMAGE TWITTER_IMAGE_ALT TWITTER_SITE TWITTER_TITLE USERFIRSTNAME USERFULLNAME USERFULLNAME2 USERLASTNAME VESSELID VESSELLOCATION YACHTID YATCOREF YCSEOURL YEARBUILT YPHOTOLARGE YPHOTOMEDIUM YPHOTOSMALL
1 [empty string] [empty string] [empty string] [empty string] 29.87 3624320.00 [empty string] [empty string] [empty string] [empty string] 98FT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] CAT C32 [empty string] [empty string] [empty string] [empty string] 371 [empty string] Aluminum [empty string] [empty string] [empty string] [empty string] 2014 [empty string] [empty string] S100 3,624,320 2 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] LAB06INT,LAB05MEM,LAB06MEM,LAB03STR,LAB23STR,LAB26STR,LAB21STR,LAB28STR,LAB27STR,LAB05INT,LAB02STR,LAB01STR,LAB18STR,LAB10STR,LAB11STR,LAB15STR,LAB16STR,LAB17STR,LAB24STR,LAB29STR,LAB25STR,LAB04STR,LAB02INT,LAB03INT,LAB04INT,LAB01INT,LAB19STR,LAB20STR,LAB20MEM,LAB03MEM,LAB08MEM,LAB07MEM,LAB02MEM,LAB09MEM,LAB11MEM 1 1 [empty string] [empty string] [empty string] 0 0 1 [empty string] [empty string] [empty string] [empty string] [empty string] 0 0 [empty string] [empty string] Motor Type [empty string] Hull Length [empty string] Fuel Type Trade-In Comments Length Overall [empty string] Number of Motor PDF Link Boat Name [empty string] Trailer Included [empty string] Colors [empty string] Currency Trade-In Manufacturer [empty string] [empty string] Vessel Category Trade-In Line [empty string] [empty string] [empty string] Specifications [empty string] [empty string] [empty string] VT / walk through link [empty string] [empty string] [empty string] Options [empty string] [empty string] [empty string] [empty string] Engine Manufacturer Standard Features Engine Model [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Draft [empty string] Hours [empty string] Engine Type [empty string] Hull Material [empty string] Horse Power Bridge Clearance Fuel Type Stock # [empty string] Year Hull Condition Interior Condition Model Asking Price Type Mechanical Condition [empty string] [empty string] [empty string] 0 2 0 0 0 0 2 0 2 1 2 2 0 0 0 0 0 0 0 0 [empty string] <p>One of a kind Sport Fishing Yacht designed by the famous designer Paolo Scanu who has worked some of the most important shipyards in the world such as Benetti, CRN and Alloy Yachts.</p> <p>This Aico S100 has been built by one of the best Turkish shipyards in 2014 and delivered to her owners in 2015.&nbsp;</p> <p>The interior of the yacht is luxurious with satin, lacquer, and bamboo. The floors in the staterooms are carpeted.</p> <p>Accommodations<strong>:</strong>&nbsp;Owner's cabin with double bed, separate wardrobe and bathroom with shower. Two double cabins with separate bathrooms. VIP cabin in the bow with separate wardrobe and bathroom with shower. Crew accommodation with independent access from outside. Laundry room storage, freezer, washer dryer and mini workshop.</p> <p>Aft there is a large comfortable area with a sofa and table to accommodate 10 people.</p> <p>Large living room with separate dining area for 8 people open to large kitchen with all the necessary amenities including induction stove top, electric oven, microwave, fridge, dishwasher and minibar.</p> <p style="text-align: center;"><span style="font-size: 10pt;"><strong><em>offered by</em></strong><strong>&nbsp;<br /><span style="font-size: 14pt;">Inter</span></strong><span style="font-size: 14pt;"><em><strong>Marine Yacht&nbsp;</strong></em><strong>Group</strong><em><strong><br /></strong></em><span style="background-color: #ffff00;"><strong>Listing Broker: Mike Smalley, CPYB - Call&nbsp;954.665.7138</strong></span></span><em><strong><br /></strong></em>email: mike@intermarineyachts.com&nbsp;/ www.Intermarineyachts.com&nbsp;</span><br /><br /><span style="font-size: 10pt;"><em>Authorized Dealer:</em>&nbsp;Prestige Yachts - Monte Carlo Yachts (80', 86', 96' &amp; 105')</span><br /><span style="font-size: 10pt;">Bayliner - Chaparral - Four Winns - Jeanneau (Power Boats)</span><br /><br /><span style="font-size: 10pt;"><em>Exclusive North America Distributor (United States &amp; Canada):<br /></em>DL Yachts Dreamline - 26 to 49 meters - Fiberglass / Aluminum Construction</span><br /><span style="font-size: 10pt;">Nuova Jolly - Europe's Leading Brand of&nbsp;<em>High-End</em>&nbsp;Inflatable Boats 5 - 13 meters</span></p> <p style="text-align: center;"><span style="font-size: 10pt;">Three Locations - Open 7 Days a Week</span><br /><span style="font-size: 10pt;">New &ndash; Trades &ndash; Brokerage - Consignment /&nbsp;Flexible&nbsp;Financing</span><br /><span style="font-size: 10pt;">Export Worldwide - We speak English, French, Spanish&nbsp;&amp; Russian</span></p> <p style="text-align: center;"><span style="font-size: 10pt;"><strong>FORT LAUDERDALE&nbsp;<br /></strong><em>Sales - Service - Parts - Storage / Corporate<br /></em>4550 Anglers Avenue Fort Lauderdale, FL 33312</span><br /><br /><span style="font-size: 10pt;"><strong>DANIA BEACH&nbsp;<br /></strong><em>In Water Yacht Display<br /></em>320 North Federal Hwy Dania Beach, FL 33004</span><br /><br /><span style="font-size: 10pt;"><strong><strong>JUPITER&nbsp;<br /></strong></strong><em>Sales - Service - Marina<br /></em>19157 SE Federal Highway (at County Line Road) Jupiter, FL 33469</span><br /><br /><span style="font-size: 10pt;"><em>Like us on Facebook at&nbsp;</em>www.facebook.com/intermarineboats</span><br /><span style="font-size: 10pt;">Big Enough to Perform ...Small Enough to Care</span></p> [empty string] [empty string] Custom Aico <h2>Additional Specs, Equipment and Information:</h2> <div class="two-col"> <dl> <dt>Specs</dt> <dd>Flag of Registry: Gibraltar (UK)<br />Hull Shape: Deep Vee</dd> </dl> <dl> <dt>Dimensions</dt> <dd>LOA: 98 ft 0 in<br />Beam: 11 ft 1 in<br />Maximum Draft: 3 ft 5 in<br />Displacement: 327800 lbs</dd> </dl> <dl> <dt>Engines</dt> <dd>Engine 1:<br />Engine Brand: CAT<br />Year Built: 2014<br />Engine Model: C32<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Location: Port<br />Engine Hours: 371<br />Drive Type: Direct Drive<br />Engine Power: 1825 HP<br /><br />Engine 2:<br />Engine Brand: CAT&nbsp;<br />Year Built: 2014<br />Engine Model: C32<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Location: Starboard<br />Engine Hours: 371<br />Drive Type: Direct Drive<br />Engine Power: 1825 HP</dd> </dl> <dl> <dt>Tanks</dt> <dd>Fresh Water Tanks: 1 (792 Gallons)<br />Fuel Tanks: 1 (6604 Gallons)</dd> </dl> <dl> <dt>Accommodations</dt> <dd>Number of single berths: 4<br />Number of double berths: 2<br />Number of cabins: 4<br />Number of heads: 4<br />Seating Capacity: 12</dd> </dl> <dl> <dt>Electrical Equipment</dt> <dd>Electrical Circuit: 220V</dd> </dl> <dl> <dt>Outside Equipment/Extras</dt> <dd>Total Liferaft Capacity: 12</dd> </dl> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Accommodation</strong><br /> <p><strong>Number of cabins:</strong></p> <ul> <li>1 Master Cabin &ndash; Separate Bathroom</li> <li>1 Vip Cabin &ndash; Separate Bathroom</li> <li>2 Guest Cabins &ndash; Separate Bathroom</li> <li>1 Crew Cabin &ndash; Separate Bathroom &ndash; 2 Berths</li> <li>1 Small Workshop</li> <li>1 Day Head</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Galley and laundry</strong><br /> <ul> <li>Service bathroom.</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Electronics and Navigation Equipment</strong><br /> <p><strong>HELM STATION:</strong></p> <ul> <li>Two GPS Raymarine G series</li> <li>Two Command Autopilot ST70</li> <li>Autopilot ST70 with two repeater&nbsp;</li> <li>Steering Gear Control</li> <li>Bow and Stern thruster</li> <li>Compass</li> <li>VHF Raymarine 240 E</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Flystation</strong><br /> <ul> <li>One GPS Raymarine G series</li> <li>One Autopilot Raymarine ST70</li> <li>Autopilot ST70</li> <li>VHF Raymarine 240 E</li> <li>Bow and Stern thruster</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Cockpit Station</strong><br /> <ul> <li>Control Station</li> <li>Autopilot Control</li> <li>Bow and Stern thruster</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Electrical System</strong><br /> <ul> <li>Bow thruster</li> <li>Stern thruster</li> <li>Water makers model C1600 -&nbsp;25 Gal/Hour</li> <li>Air Conditioning</li> <li>Inverter</li> <li>Sewage treatment plant</li> <li>Fuel waste oil tank</li> <li>Compressor Fire-fighting system in the engine room</li> <li>Generator Kohler 33 Kw &ndash; hours 943</li> <li>Kohler 20 Kw &ndash; hours 450</li> <li>4 Raymarine Cameras</li> <li>Antenna Tv</li> <li>Phone System</li> <li>Washer &amp; Dryer</li> <li>Ice maker in crew area</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Deck Equipment</strong><br /> <ul> <li>Interior equipment Electric bilge pump Electric toilet Battery charger Manual bilge pump Catwalk Opacmare 3800</li> <li>Hydraulic davit Opacmare &ndash; 1500 kg Displacement</li> <li>2 Anchors for 200 kg each in stainless steel</li> <li>2 Winches hydraulic</li> <li>2Winches warping</li> <li>Waterproof doors</li> <li>Watertight doors</li> <li>Camera and sub lighthouse</li> <li>Searchlight</li> <li>Electronic instrumentation</li> <li>Dinghy Gommonautica G48</li> <li>Engine Dinghy Honda 90 Hp Vtec &ndash; year 2014</li> <li>Beach umbrella</li> </ul> </td> </tr> </tbody> </table> </div> <div> <table border="0"> <tbody> <tr> <td><br /><strong>Other Features</strong><br /> <ul> <li>Cockpit shower</li> <li>Teak cockpit</li> <li>Cockpit table</li> <li>Hydraulic gangway</li> <li>Cushions</li> </ul> </td> </tr> </tbody> </table> </div> <p style="text-align: center;">&nbsp;</p> <p style="text-align: center;"><span style="font-size: 10pt;"><strong><em>offered by</em></strong><strong>&nbsp;<br /><span style="font-size: 14pt;">Inter</span></strong><span style="font-size: 14pt;"><em><strong>Marine Yacht&nbsp;</strong></em><strong>Group</strong><em><strong><br /></strong></em><span style="background-color: #ffff00;"><strong>Listing Broker: Mike Smalley, CPYB - Call&nbsp;954.665.7138</strong></span></span><em><strong><br /></strong></em>email: mike@intermarineyachts.com&nbsp;/ www.Intermarineyachts.com&nbsp;</span><br /><br /><span style="font-size: 10pt;"><em>Authorized Dealer:</em>&nbsp;Prestige Yachts - Monte Carlo Yachts (80', 86', 96' &amp; 105')</span><br /><span style="font-size: 10pt;">Bayliner - Chaparral - Four Winns - Jeanneau (Power Boats)</span><br /><br /><span style="font-size: 10pt;"><em>Exclusive North America Distributor (United States &amp; Canada):<br /></em>DL Yachts Dreamline - 26 to 49 meters - Fiberglass / Aluminum Construction</span><br /><span style="font-size: 10pt;">Nuova Jolly - Europe's Leading Brand of&nbsp;<em>High-End</em>&nbsp;Inflatable Boats 5 - 13 meters</span></p> <p style="text-align: center;"><span style="font-size: 10pt;">Three Locations - Open 7 Days a Week</span><br /><span style="font-size: 10pt;">New &ndash; Trades &ndash; Brokerage - Consignment /&nbsp;Flexible&nbsp;Financing</span><br /><span style="font-size: 10pt;">Export Worldwide - We speak English, French, Spanish&nbsp;&amp; Russian</span></p> <p style="text-align: center;"><span style="font-size: 10pt;"><strong>FORT LAUDERDALE&nbsp;<br /></strong><em>Sales - Service - Parts - Storage / Corporate<br /></em>4550 Anglers Avenue Fort Lauderdale, FL 33312</span><br /><br /><span style="font-size: 10pt;"><strong>DANIA BEACH&nbsp;<br /></strong><em>In Water Yacht Display<br /></em>320 North Federal Hwy Dania Beach, FL 33004</span><br /><br /><span style="font-size: 10pt;"><strong><strong>JUPITER&nbsp;<br /></strong></strong><em>Sales - Service - Marina<br /></em>19157 SE Federal Highway (at County Line Road) Jupiter, FL 33469</span><br /><br /><span style="font-size: 10pt;"><em>Like us on Facebook at&nbsp;</em>www.facebook.com/intermarineboats</span><br /><span style="font-size: 10pt;">Big Enough to Perform ...Small Enough to Care</span></p> [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0 Off-Site Location 5 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 24867 [empty string] 5C7178C8-E295-A097-B3E7FBF744160E7A [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] http://www.intermarineboats.com/yacht-consignment/2014-Custom-98FT-Aico/1264 24 Template to add In-House Featured and Trade-In yachts 2 In-House Featured and Trade-In 2 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Mike Mike Smalley Smalley, Mike Smalley [empty string] [empty string] 1264 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 63
SQL SELECT yacht_data.yachtID, yacht_data.isArchived, yacht_data.templateREF, yacht_data.staffREF, yacht_data.officeREF, yacht_data.yatcoREF, yacht_data.modelREF, yacht_data.isFeatured, yacht_data.calc_1, yacht_data.calc_2, yacht_data.calc_3, yacht_data.calc_4, yacht_data.priority, 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.data26, yacht_data.data27, yacht_data.data28, yacht_data.data29, yacht_data.data30, yacht_data.int01, yacht_data.int02, yacht_data.int03, yacht_data.int04, yacht_data.int05, yacht_data.int06, yacht_data.int07, yacht_data.int08, yacht_data.int09, yacht_data.int10, yacht_data.dec01, yacht_data.dec02, yacht_data.dec03, yacht_data.dec04, yacht_data.dec05, yacht_data.dec06, yacht_data.dec07, yacht_data.dec08, yacht_data.dec09, yacht_data.dec10, yacht_data.memo01, yacht_data.memo02, yacht_data.memo03, yacht_data.memo04, yacht_data.memo05, yacht_data.memo06, yacht_data.memo07, yacht_data.memo08, yacht_data.memo09, yacht_data.memo10, yacht_data.memo11, yacht_data.memo12, yacht_data.memo13, yacht_data.memo14, yacht_data.memo15, yacht_data.memo16, yacht_data.memo17, yacht_data.memo18, yacht_data.memo19, yacht_data.memo20, yacht_data.randomSeed, yacht_data.metaDescription, yacht_data.keywords, yacht_data.seoPreviewText, yacht_data.seoPageTitle, yacht_data.seoURL, yacht_data.fb_admins, yacht_data.og_title, yacht_data.og_type, yacht_data.og_image, yacht_data.og_url, yacht_data.og_desc, yacht_data.twitter_card, yacht_data.twitter_site, yacht_data.twitter_title, yacht_data.twitter_desc, yacht_data.twitter_image, yacht_data.twitter_image_alt, yacht_data.schema_name, yacht_data.schema_desc, yacht_data.schema_image, yacht_templates.templateID, yacht_templates.fieldOrder, yacht_templates.mem01state, yacht_templates.mem02state, yacht_templates.mem03state, yacht_templates.mem04state, yacht_templates.mem05state, yacht_templates.mem06state, yacht_templates.mem07state, yacht_templates.mem08state, yacht_templates.mem09state, yacht_templates.mem10state, yacht_templates.mem11state, yacht_templates.mem12state, yacht_templates.mem13state, yacht_templates.mem14state, yacht_templates.mem15state, yacht_templates.mem16state, yacht_templates.mem17state, yacht_templates.mem18state, yacht_templates.mem19state, yacht_templates.mem20state, yacht_templates.templateDesc, yacht_templates.templateName, yacht_templates.lab01str, yacht_templates.lab02str, yacht_templates.lab03str, yacht_templates.lab04str, yacht_templates.lab05str, yacht_templates.lab06str, yacht_templates.lab07str, yacht_templates.lab08str, yacht_templates.lab09str, yacht_templates.lab10str, yacht_templates.lab11str, yacht_templates.lab12str, yacht_templates.lab13str, yacht_templates.lab14str, yacht_templates.lab15str, yacht_templates.lab16str, yacht_templates.lab17str, yacht_templates.lab18str, yacht_templates.lab19str, yacht_templates.lab20str, yacht_templates.lab21str, yacht_templates.lab22str, yacht_templates.lab23str, yacht_templates.lab24str, yacht_templates.lab25str, yacht_templates.lab26str, yacht_templates.lab27str, yacht_templates.lab28str, yacht_templates.lab29str, yacht_templates.lab30str, yacht_templates.lab01int, yacht_templates.lab02int, yacht_templates.lab03int, yacht_templates.lab04int, yacht_templates.lab05int, yacht_templates.lab06int, yacht_templates.lab07int, yacht_templates.lab08int, yacht_templates.lab09int, yacht_templates.lab10int, yacht_templates.lab01dec, yacht_templates.lab02dec, yacht_templates.lab03dec, yacht_templates.lab04dec, yacht_templates.lab05dec, yacht_templates.lab06dec, yacht_templates.lab07dec, yacht_templates.lab08dec, yacht_templates.lab09dec, yacht_templates.lab10dec, yacht_templates.lab01mem, yacht_templates.lab02mem, yacht_templates.lab03mem, yacht_templates.lab04mem, yacht_templates.lab05mem, yacht_templates.lab06mem, yacht_templates.lab07mem, yacht_templates.lab08mem, yacht_templates.lab09mem, yacht_templates.lab10mem, yacht_templates.lab11mem, yacht_templates.lab12mem, yacht_templates.lab13mem, yacht_templates.lab14mem, yacht_templates.lab15mem, yacht_templates.lab16mem, yacht_templates.lab17mem, yacht_templates.lab18mem, yacht_templates.lab19mem, yacht_templates.lab20mem, yacht_templates.defaultSort, yacht_templates.includeUser, yacht_templates.includeOffice, users.userLastName, users.userFirstName, users.userFirstName + ' ' + users.userLastName AS userFullName, users.userLastName + ', ' + users.userFirstName AS userFullName2, yc_data.askingPrice, yc_data.loaMeters, yc_data.vesselID, yc_data.vesselLocation, yc_data.yearBuilt, yc_data.askingPriceFormatted, yc_data.boatName, yc_data.builder, yc_data.currency, yc_data.loaFeet, yc_data.salesPerson, yc_data.SalesPersonCellPhone, yc_data.SalesPersonEmail, yc_data.SalesPersonPhone, yc_data.incSections, yc_data.yPhotoLarge, yc_data.yPhotoMedium, yc_data.yPhotoSmall, yc_data.ycSeoUrl, yacht_photos.photoID, yacht_photos.photoCaption, yacht_model.mfrRef, yacht_model.modelName, yacht_mfr.mfrName, userOffices.officeName FROM yacht_data LEFT JOIN yacht_templates ON yacht_data.templateREF = yacht_templates.templateID LEFT JOIN users ON yacht_data.staffREF = users.userID LEFT JOIN yc_data ON yacht_data.yatcoREF = yc_data.vesselID LEFT JOIN yacht_photos ON yacht_data.yachtID = yacht_photos.yachtREF LEFT JOIN yacht_model ON yacht_data.modelREF = yacht_model.modelID LEFT JOIN yacht_mfr ON yacht_model.mfrREF = yacht_mfr.mfrID LEFT JOIN userOffices ON yacht_data.officeREF = userOffices.officeID WHERE ( yachtID = 1264 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID
S100 | InterMarine Boats
$3,624,320

Custom S100

Stock Number: N/A

$3,624,320

Custom S100

98FT

Length

Beam

Draft

Cruising Speed
C32
Max Speed
CAT
Hours
371
Hull Material
Aluminum

How Can We Help You Today?

Schedule an appointment

You can schedule an appointment today for a live or recorded video tour or request an in-person showing. A sales representative will contact you to confirm appointment.

SCHEDULE

Credit Application

Don't let the dream of owning a boat be just a dream. Apply for financing today on new and used boats with our partners Elite Recreational Finance.

APPLY NOW

Email a Friend

Excited about this boat?! Share this boat with a friend or family member!

SHARE NOW
asd
let's work together

CONTACT DEALER