| 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 |
10.97 |
[empty string] |
[empty string] |
[empty string] |
Hunter |
36' |
2009 |
12' 4 |
4' 11 |
13,900lbs |
Fiberglass |
[empty string] |
Hunter 3YM30 |
29hp |
Sail |
Intrepid |
$105,000 |
Pasadena, MD |
[empty string] |
[empty string] |
[empty string] |
Erik Haaland |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
May 21, 2018 |
$98,000 |
Erik Haaland |
[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] |
1 |
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>The Hunter 36 takes the best of European looks and American tastes and blends them beautifully. This is a beamy boat with a voluminous interior. This one has nearly all the options, and has been little used, but well maintained. Every winter her one owner has had the boat hauled, and covered with the boats custom made canvas winter storage cover. This cover can also be using while the boat is in the water.</p>
<p>Whether cruising on the bay or heading south this Hunter is well equipped to take you on your journey. Compared to other Hunter 36's on the market you won't find one better equipped. She shows extremely well; make an appointment to see her soon!</p>
<div class="two-col">
<dl>
<dt>Specs</dt>
<dd>Flag of Registry: United States<br />Keel: Other<br />Hull Shape: Displacement</dd>
</dl>
<dl>
<dt>Dimensions</dt>
<dd>LOA: 35 ft 6 in<br />Beam: 12 ft 4 in<br />LWL: 31 ft 3 in<br />Maximum Draft: 4 ft 11 in<br />Displacement: 13900 lbs<br />Ballast: 5023 lbs</dd>
</dl>
<dl>
<dt>Engines</dt>
<dd>Engine 1:<br />Engine Brand: Hunter<br />Year Built: 2009<br />Engine Model: 3YM30<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 350<br />Drive Type: Direct Drive<br />Engine Power: 29 HP</dd>
</dl>
<dl>
<dt>Tanks</dt>
<dd>Fresh Water Tanks: (75 Gallons)<br />Fuel Tanks: (38 Gallons)</dd>
</dl>
<dl>
<dt>Accommodations</dt>
<dd>Number of cabins: 2<br />Number of heads: 1</dd>
</dl>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Manufacturer Provided Description</strong><br />Borrowing heavily from the ideas of Hunter owners, dealers and prospective customers, the popular Hunter 36 represents the end collaboration of enthusiast feedback, brought to life by the hands and minds of Hunter engineers. The Hunter 36 features an extra wide beam spanning nearly the entire length of the boat to maximize both topside and interior accommodations. A large sail locker onboard the Hunter 36 easily stores gear, while the generously proportioned cockpit features a Lewmar steering system, fold-up tables and plenty of room for relaxation.</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Accommodations</strong><br />This Hunter 36 is equipped with a forward V-berth, aft cabin with double bed, and convertible salon. Both the forward and aft cabins include hanging closets and numerous cabinets for your personal items. The salon table drops down and a separate cushion enables the salon to double as a cabin for extra guests.<br />The cabin sole is in "like new" condition with fitted carpet covers to keep it that way. Hatch screens are included with covers to block out light from above if needed.</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Sails and Rigging</strong><br />Doyle Sails equipped with a furling main and furling headsail, allowing for ease of use with limited manpower. The Selden mast is deck stepped allowing for increased cabin space and ease of removal for maintanence. The Selden boom is completed by the Harken traveler system mounted onto a stainless arch above the cockpit. This frees the cockpit from lines and clutter. All control lines are led aft to the cockpit clutches on either side of the companionway. <br />135% Furling Doyle genoa <br />Hood Seafurl 5 furler <br />Furling Doyle mainsail <br />Lewmar self-tailing series 30 (x2) and 40 (x2) winches</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electronics</strong><br />A custom Garmin/Raymarine electronics package adorns this Hunter 36, allowing for ease of use, added functionality, and more capability than the standard electronics package would allow. <br />Garmin 7212 12" touch-screen display Navpod mounted at the helm <br />Garmin GMR18 High Definition radar, mast mounted <br />Garmin XM weather and radio receiver (subscription required) <br />Raymarine ST60+ depth, speed, and wind instrumentation networked to Garmin <br />system <br />Raymarine ST6002 autopilot <br />Icom M422 VHF with CommandMic at helm <br />JVC KD-G430 AM/FM/CD/AUX Stereo w/salon and cockpit speakers.</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td>
<p><br /><strong>Galley/Head</strong><br />The spacious galley is well laid out and includes storage space for all your supplies and food.? Corian countertops<br />Force 10 two-burner propane stove<br />NovaKool 12V Refrigerator/Freezer<br />Tappan microwave<br />Hunter galleyware set including 4x plates, bowls, and cups.<br />Kuuma 6-Gal water heater<br />The head is roomy and well lit with a separate head/shower stall from the sink area.<br />Corian countertop<br />Jabsco manual head</p>
<p> Adjustable shower head</p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electrical</strong><br />Two battery banks with selector switch <br />Windlass breaker <br />Promariner ProTech 1230iPlus automatic battery charger <br />Two 30A 120V inputs with two shore power cords and adapters.</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td>
<p><br /><strong>Other Equipment</strong><br />Kato Marine dinghy davits <br />Full canvas winter cover for use on the hard or in the water <br />Dodger and bimini in excellent shape <br />Fenders, docklines, snubbers</p>
<p>Lifejackets </p>
<p>Propane tank</p>
</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] |
6280 |
[empty string] |
[empty string] |
B8B964F8-97A4-30A8-CA3E0F5E420C010E |
[empty string] |
[empty string] |
https://www.davidwaltersyachts.com/Sail/36-Hunter-2009/577 |
13 |
The default yacht template for David Walters Yachts |
1 |
Brokerage |
1 |
Erik |
Erik Haaland |
Haaland, Erik |
Haaland |
(410) 279-3027 |
577 |
[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 = 577 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |
