RESULTSET |
query |
|
ARTICLEAUTHOR |
ARTICLECATNAME |
ARTICLEDATE |
ARTICLEDATE2 |
ARTICLEID |
ARTICLEPLACEMENT |
ARTICLETEXT |
ARTICLETITLE |
ARTICLEUPDATED |
ARTICLEURL |
ARTICLE_SECTION |
ARTICLE_TAG |
CATREF |
ENABLEAUTHOR |
ENABLEDESCRIPTION |
ENABLEDOCUMENTSTAB |
ENABLELINKSTAB |
ENABLELOCATIONTAB |
ENABLEPHOTOSTAB |
ENABLESEOTAB |
ENABLESTARTENDDATES |
ENABLETAGSTAB |
ENABLEWEBSITE |
ENABLEYOUTUBETAB |
EXTDATA01 |
EXTDATA02 |
EXTDATA03 |
EXTDATA04 |
EXTDATA05 |
EXTDATA06 |
EXTDATA07 |
EXTDATA08 |
EXTDATA09 |
EXTDATA10 |
EXTDATA11 |
EXTDATA12 |
EXTLABEL01 |
EXTLABEL02 |
EXTLABEL03 |
EXTLABEL04 |
EXTLABEL05 |
EXTLABEL06 |
EXTLABEL07 |
EXTLABEL08 |
EXTLABEL09 |
EXTLABEL10 |
EXTLABEL11 |
EXTLABEL12 |
FB_ADMINS |
INTERLINKINGSETS |
ISAPPROVED |
ISARCHIVED |
KEYWORDS |
LATITUDE |
LINKTITLEP |
LINKTITLES |
LOCADDRESS1 |
LOCADDRESS2 |
LOCCITY |
LOCSTATEREF |
LOCZIP |
LONGITUDE |
METADESCRIPTION |
MYCHANGEFREQ |
MYDESCRIPTION |
MYPAGETITLE |
MYPRIORITY |
OG_DESC |
OG_IMAGE |
OG_TITLE |
OG_TYPE |
OG_URL |
ONFRONTPAGE |
PIC1 |
PICALL |
POSTEDDATE |
POSTSTATUSCOLOR |
POSTSTATUSNAME |
POSTSTATUSREF |
PRIMARY_TAGREG |
SCHEMA_DESC |
SCHEMA_IMAGE |
SCHEMA_NAME |
SEODIR |
SEOHANDCRAFTEDURL |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TAGNAME |
TAGURL |
TWITTER_CARD |
TWITTER_DESC |
TWITTER_IMAGE |
TWITTER_IMAGE_ALT |
TWITTER_SITE |
TWITTER_TITLE |
USERFIRSTNAME |
USERLASTNAME |
1 |
Dave Kresge |
News |
2022-05-18 00:00:00.0 |
2022-05-18 00:00:00.0 |
257 |
[empty string] |
<p>With a huge 70-square-foot cockpit and a comfortable, well-appointed interior, the Tiara 3600 Open is designed to please both anglers and cruisers. The 3600 rides on a modified-V hull with a sharp entry, solid fiberglass bottom, and a moderately large beam, similar to other late-model Tiaras.</p>
<p><img src="../../../../photos/articles/20220131-103139.jpg" alt="Image 1151: " width="100%" height="auto" /></p>
<p>Anglers will like the aft-facing chairs, overbuilt transom door, in-deck fish bins, and fold-down transom seat in the professional-grade cockpit.</p>
<p> </p>
<p>A portside lounge (with insulated cooler), a wet bar, and a tilt-away dash are all available on the helm deck. Solid-wood flooring, perfect teak joinery, Ultraleather upholstery, and brushed stainless-steel fittings make up the sumptuous decor below decks. The backrest folds up to make a Pullman sleeper, and the U-shaped dinette converts to a double berth.</p>
<p> </p>
<p><img src="../../../../photos/articles/20220127-112640.jpg" alt="Image 1151: " width="100%" height="auto" />In the master stateroom, a sliding door affords true seclusion. Fresh and raw water washdowns, an integrated bow pulpit, broadside decks, and cockpit bolsters are among the other features. Cummins diesel engines reach speeds of 24–26 knots.</p>
<p><img src="../../../../photos/articles/dji-0230.jpg" alt="Image 1150: " width="100%" height="auto" /></p>
<p> </p>
<p>For additional information see the <a href="../../../../used-yachts-for-sale/2003-Tiara-Yachts-38-3600-Open-Endeavor-yacht-for-sale/8179836_2" target="_blank" rel="noopener">listing</a> or contact <a href="../../../../our-team/yacht-broker-Coltin-Radabaugh/61" target="_blank" rel="noopener">Coltin Radabaugh</a>, Yacht broker, Allied Marine Stuart, FL</p> |
JUST LISTED YACHT FOR SALE | ENDEAVOR 2003 TIARA YACHTS 36' |
2022-05-20 10:45:39.0 |
|
[empty string] |
[empty string] |
1 |
1 |
1 |
1 |
0 |
0 |
1 |
1 |
0 |
1 |
0 |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Omit Sidebar |
Omit Gallery |
[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.000000 |
Links/Quotes |
Link/Quote |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0.000000 |
[empty string] |
weekly |
Brokerage Luxury Used Yacht for Sale |
JUST LISTED YACHT FOR SALE |
1.0 |
ENDEAVOR 2003 TIARA YACHTS 36' |
[empty string] |
JUST LISTED YACHT FOR SALE |
website |
https://www.alliedmarine.com |
[empty string] |
dji-0225.jpg |
dji-0225.jpg,dji-0230.jpg,20220131-103139.jpg,20220127-112640.jpg,20220127-112621.jpg,20220127-112602.jpg,20220127-112554.jpg |
2022-01-11 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
ENDEAVOR 2003 TIARA YACHTS 36' |
[empty string] |
JUST LISTED YACHT FOR SALE |
yachting-news |
just-listed-yacht-for-sale |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/just-listed-yacht-for-sale |
61 |
[empty string] |
[empty string] |
[empty string] |
ENDEAVOR 2003 TIARA YACHTS 36' |
[empty string] |
[empty string] |
[empty string] |
JUST LISTED YACHT FOR SALE |
[empty string] |
[empty string] |
|
SQL |
SELECT
articles.articleID,
articles.catREF,
articles.staffREF,
articles.postStatusREF,
articles.articleTitle,
articles.seoHandCraftedURL,
articles.articleAuthor,
articles.articleURL,
articles.seoURL,
articles.articleDate,
articles.articleDate2,
articles.postedDate,
articles.articleUpdated,
articles.latitude,
articles.longitude,
articles.articleText,
articles.isArchived,
articles.metaDescription,
articles.seoPreviewText,
articles.primary_tagREG,
articles.myPageTitle,
articles.myDescription,
articles.fb_admins,
articles.og_title,
articles.og_type,
articles.og_image,
articles.og_url,
articles.og_desc,
articles.twitter_card,
articles.twitter_site,
articles.twitter_title,
articles.twitter_desc,
articles.twitter_image,
articles.twitter_image_alt,
articles.article_section,
articles.article_tag,
articles.myChangeFreq,
articles.myPriority,
articles.schema_name,
articles.schema_desc,
articles.schema_image,
articles.seoPageTitle,
articles.keywords,
articles.isApproved,
articles.articlePlacement,
articles.onFrontPage,
articles.locAddress1,
articles.locAddress2,
articles.locCity,
articles.locStateREF,
articles.locZip,
articles.extData01,
articles.extData02,
articles.extData03,
articles.extData04,
articles.extData05,
articles.extData06,
articles.extData07,
articles.extData08,
articles.extData09,
articles.extData10,
articles.extData11,
articles.extData12,
articles.pic1,
articles.picAll,
articles.interlinkingSets,
articleCats.articleCatName,
articleCats.extLabel01,
articleCats.extLabel02,
articleCats.extLabel03,
articleCats.extLabel04,
articleCats.extLabel05,
articleCats.extLabel06,
articleCats.extLabel07,
articleCats.extLabel08,
articleCats.extLabel09,
articleCats.extLabel10,
articleCats.extLabel11,
articleCats.extLabel12,
articleCats.enableStartEndDates,
articleCats.enableLocationTab,
articleCats.enableLinksTab,
articleCats.linkTitleS,
articleCats.linkTitleP,
articleCats.enablePhotosTab,
articleCats.enableDocumentsTab,
articleCats.enableYouTubeTab,
articleCats.enableTagsTab,
articleCats.enableSeoTab,
articleCats.enableAuthor,
articleCats.enableDescription,
articleCats.enableWebsite,
articleCats.seoDir,
article_status.postStatusName,
article_status.postStatusColor,
article_tag.tagName,
article_tag.tagURL,
users.userLastName,
users.userFirstName
FROM
articles
LEFT JOIN articleCats ON articles.catREF = articleCats.articleCatID
LEFT JOIN article_status ON articles.postStatusREF = article_status.postStatusID
LEFT JOIN article_tag ON articles.primary_tagREG = article_tag.tagID
LEFT JOIN users ON articles.staffREF = users.userID
WHERE seoHandCraftedURL = 'just-listed-yacht-for-sale'
ORDER BY postedDate desc |