| RESULTSET |
| query |
| |
CALC_1 |
CALC_2 |
CALC_3 |
CALC_4 |
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 |
FIELDORDER |
INCLUDEOFFICE |
INCLUDEUSER |
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 |
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 |
OFFICEREF |
PHOTOCAPTION |
PHOTOID |
PRIORITY |
PRIORITY |
RANDOMSEED |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TEMPLATEDESC |
TEMPLATEID |
TEMPLATENAME |
TEMPLATEREF |
USERFIRSTNAME |
USERFULLNAME |
USERFULLNAME2 |
USERLASTNAME |
USERPHONE |
YACHTID |
YATCOREF |
| 1 |
17.07 |
[empty string] |
[empty string] |
[empty string] |
Alden |
56 |
2002 |
15' 8 |
4' 6 |
[empty string] |
[empty string] |
[empty string] |
(2) Caterpillar |
660HP |
Power |
Seki II |
$450,000 |
Florida |
[empty string] |
[empty string] |
http://www.davidwaltersyachts.com/yacht-details.cfm?y=5775315 |
John Osetek |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Hardtop Express |
[empty string] |
[empty string] |
September 5, 2017 |
$440,000 |
John Osetek & George Eberhard |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
LAB03INT,LAB28STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB02STR,LAB03STR,LAB15STR,LAB01STR,LAB25STR,LAB01MEM,LAB03MEM,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB19STR,LAB21STR,LAB20STR,LAB10STR,LAB18STR,LAB16STR,LAB22STR,LAB23STR,LAB24STR |
0 |
1 |
[empty string] |
0 |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
1 |
0 |
[empty string] |
[empty string] |
[empty string] |
Link to Virtual Tour |
Builder |
[empty string] |
[empty string] |
[empty string] |
Length |
[empty string] |
Sold Yacht |
Additional Info |
Year Built |
[empty string] |
[empty string] |
[empty string] |
Beam |
[empty string] |
[empty string] |
[empty string] |
Draft |
[empty string] |
[empty string] |
[empty string] |
Displacement |
[empty string] |
[empty string] |
[empty string] |
Hull |
[empty string] |
[empty string] |
[empty string] |
Designer |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Power |
[empty string] |
Type (Sail or Power) |
[empty string] |
Yacht Name |
[empty string] |
Yacht Price |
[empty string] |
Location |
[empty string] |
Year Refit |
[empty string] |
Fuel Type |
[empty string] |
[empty string] |
[empty string] |
Engine Hours |
[empty string] |
Number of Engines |
[empty string] |
Engine Model |
Engine Manufacturer |
Holding Tank Capacity |
Fuel Tank Capacity |
Water Tank Capacity |
Model |
[empty string] |
[empty string] |
Selling Date |
[empty string] |
[empty string] |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
[empty string] |
[empty string] |
<p>Seki II is one of the handsomest Alden express yachts built. Its deck house was refined to enhance it's profile. Each interior space was refined with extensive use of curved surfaces to soften the feel of it's living areas. She is equipped for comfortable coastal cruising and would make an excellent choice to do the Great Loop. It's hull shape and custom tabbing enables the captain to choose the proper running angle for safe and efficient operation in all sea conditions. A very special yacht for the discerning owner.</p>
<div class="two-col">
<dl>
<dt>Dimensions</dt>
<dd>LOA: 56 ft 9 in<br />Beam: 15 ft 8 in<br />LWL: 50 ft 5 in<br />Maximum Draft: 4 ft 6 in<br />Bridge Clearance: 15 ft 6 in<br />Dry Weight: 42000 lbs</dd>
</dl>
<dl>
<dt>Engines</dt>
<dd>Engine 1:<br />Engine Brand: Caterpillar<br />Year Built: 2002<br />Engine Model: 3196E<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 1000<br />Drive Type: Direct Drive<br />Engine Power: 660 HP<br /><br />Engine 2:<br />Engine Brand: Caterpillar<br />Year Built: 2002<br />Engine Model: 3196E<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 1000<br />Drive Type: Direct Drive<br />Engine Power: 660 HP</dd>
</dl>
<dl>
<dt>Tanks</dt>
<dd>Fresh Water Tanks: (470 Gallons)<br />Fuel Tanks: 1 (615 Gallons)<br />Holding Tanks: (70 Gallons)</dd>
</dl>
<dl>
<dt>Accommodations</dt>
<dd>Number of double berths: 2<br />Number of cabins: 2<br />Number of heads: 2</dd>
</dl>
<dl>
<dt>Outside Equipment/Extras</dt>
<dd>Electric windlass</dd>
</dl>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Accommodations</strong><br />
<p>There is an extensive use of curved surfaces to soften the appearance of a cabin, to provide more space in the cabin and facilitate better communication between cabins.</p>
<ul>
<li>See "Layout"</li>
<li>Interior woodwork is finely detailed cherry.</li>
<li>Floors are solid teak and rock maple.</li>
<li>Bridge deck / upper salon overhead is ash with cherry battens.</li>
<li>Master stateroom has a center line queen berth.</li>
<li>Guest stateroom has a double berth.</li>
<li>There are two heads with a shared shower. </li>
<li>Stereo system with speakers through out the boat. Independent volume control in each room and cockpit.</li>
<li>Comprehensive lighting options to provide many moods in each cabin.</li>
<li>Hancock chairs and Baker sofa in main Salon.</li>
<li>TV and DVR. TV retracts out of view when not in use.</li>
<li>Helm and companion seating rotate to add to salon seating.</li>
<li>Window heights in the main salon allow for easy viewing of surroundings while seated and an enhanced open feel to the boat. </li>
<li>Marine Air Air conditioning systems through out. (3) Zones with Passport II displays. Updated 2017</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Navigation & Electronics</strong><br />
<ul>
<li>GPS: Raymarine Raystar 120LP WAAS</li>
<li>Radar: Furuno Navnet 1943 plotter; 4 years old, last production series</li>
<li>ARP 11 Radar Autopilot </li>
<li>Depth: Furuno Netwiork sounder ETR 6/10N; 2 EA</li>
<li>Autopilot: Robertson AP20 Pilot</li>
<li>Raymarine ST60 Tridata speed and depth.</li>
<li>RF300 rudder reference</li>
<li>RFC35 Compass</li>
<li>RPU80 Pump</li>
<li>J300X Junction Unit</li>
<li>Gyro Compass: KVH Gyro Trac Sensor</li>
<li>KVH advanced digital control unit </li>
<li>Analog Compass: Richie navigator compass</li>
<li>Raymarine STSO wind system analog vane</li>
<li>VHF: Standard spectrum VHF DSC</li>
<li>Inclinometer: US digital CA-8 inclinometer</li>
<li>ED-2 readout</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Engines/Mechanical</strong><br />
<ul>
<li>Twin Caterpillar 3196E diesel engines (660 hp each). ZF transmissions.</li>
<li>After coolers were replaced as part of a program by Caterpillar to remedy a manufacturing defect.</li>
<li>Northern Lights generator (16kw).</li>
<li>Dual Racor fuel filters.</li>
<li>Oil change system.</li>
<li>Auto fire extinguisher system.</li>
<li>Bow Thruster.</li>
<li>Custom trim tab system.</li>
<li>Engine power switch: common ground</li>
<li>Toggle switch panel</li>
<li>Level 1- EVD Panel</li>
<li>ZF gearbox 2000017012</li>
<li>AF oil filter 3213308019</li>
<li>ZF MC2000 control head</li>
<li>ZF handheld micro commander/clear command</li>
<li>Packless sealing system</li>
<li>Racor 75/900 Max (180gal)</li>
<li>Large engine room with easy access to all sides of the engines. </li>
<li>(4) bilge pumps with condition indicators at the helm.</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electrical</strong><br />
<ul>
<li>Xantrex Freedom SW </li>
<li>Sine Wave inverter/charger SW 3012</li>
<li>Xanbus system control panel SCP</li>
<li>Xantrex Link 10 meter</li>
<li>Xintex CMD- 3M marine carbon monoxide detector</li>
<li>50 amp shore power chords with fore and aft retrievers.</li>
<li>16kW Generator (Northern Lights)</li>
<li>12 volt system. (4) 8D AGM house batteries, (2) 8D GPL engine batteries, (1) GPL -27 AGM Generator battery.</li>
<li>Dedicated Alternators for Engine, House and Generator battery charging.</li>
<li>120volt, 50 Amp service.</li>
<li>Wired for KVH antenna.</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Hull and deck</strong><br />
<p>Hunt designed deep V hull with pocketed props. A modest beam to length ratio gives Seki impressive performance figures and ride, not found on her wide beam counter parts.</p>
<ul>
<li>Fully enclosed bridge deck and salon, with 360 degree visibility at speed and at the dock. </li>
<li>Beautiful deep cockpit with removable awning.</li>
<li>Wide side decks with contrasting non-skid and teak toe rails.</li>
<li>Transom door leading to TNT submerging dinghy platform.</li>
<li>Hot and Cold cockpit shower. (Atwood)</li>
<li>Bow pulpit with Ocean Concert Capstan windlass.</li>
<li>Deck wash down system (Atwood).</li>
<li>Stainless railings with custom stainless safety lattice.</li>
<li>ACR remote spot light.</li>
<li>Kahlenberg air horn.</li>
<li>Exalto windshield wipers and electronic controls.</li>
<li>Thru hulls, valves and strainers are bronze. (Groco)</li>
<li>Teak decking on cockpit sole. </li>
<li>Flag Blue Awl Grip hull. (Clear coated)</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Galley</strong><br />
<p>Beautiful C-shaped galley with cherry cabinets and corian counter tops. Abundant storage and counter space. Opening port and circular hatch for ventilation.</p>
<ul>
<li>Sub-zero Refrigerator and freezer Model 249.</li>
<li>Gaggenau Oven model HLE- B27 3700W</li>
<li>Gaggenau Glass/ceramic HOB (Cook top) with super quick cooking zones.</li>
<li>Gaggenau HOB Ventilator.</li>
<li>Icer-ette Ice cube maker.</li>
<li>Franke Little Butler Waste Disposal.</li>
<li>Raritan 20 gal. water heater.</li>
<li>Groco Paragon Senior water pressure system.</li>
<li>Washer/Dryer (under companionway steps)</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Heads</strong><br />
<p>Dual heads with full size shower accessible from each head. Cherry cabinetry with curved Corian counter tops and gold fixtures. Large beveled mirrors.</p>
<ul>
<li>Two Wilcox Tecma electric heads with holding tank and by pass valve for offshore discharge outside US waters.</li>
<li>Molded sinks integral to the</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div> |
[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] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
4993 |
[empty string] |
[empty string] |
B8B91AC9-D05B-5C90-0F32B802A0BD681B |
[empty string] |
[empty string] |
https://www.davidwaltersyachts.com/Power/56-Alden-2002/478 |
10 |
The default yacht template for David Walters Yachts |
1 |
Brokerage |
1 |
John |
John Osetek |
Osetek, John |
Osetek |
(401) 465-8634 |
478 |
[empty string] |
|
| SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
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.yachtID,
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_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.userPhone,
users.userFirstName + ' ' + users.userLastName AS userFullName,
users.userLastName + ', ' + users.userFirstName AS userFullName2,
yacht_photos.photoID,
yacht_photos.photoCaption,
yacht_photos.priority,
yacht_model.mfrRef,
yacht_model.modelName,
yacht_mfr.mfrName
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 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
WHERE ( yachtID = 478 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |
