| 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 |
Allan Leshchinsky |
News |
2019-04-08 00:00:00.0 |
2019-04-08 00:00:00.0 |
50 |
[empty string] |
<p><strong>by Tom & Brett Jenkins, Allied Marine Yacht Brokers</strong></p>
<p>"<a title="2017 Tiara 53' Yacht For Sale" href="https://www.alliedmarine.com/used-yachts-for-sale/2017-Tiara-65-53-Coupe-Windy-City-yacht-for-sale/7006517_2">Windy City</a>" is a 2017 Tiara 53' Coupe outfitted with over $450,000 of options. Maintained in pristine condition with a current asking price in excess of $650,000 under retail value. This is a very special, cruiser coupe for sale that is worth serious consideration.</p>
<img class="img-fluid" title="1985 Hatteras 60' Yacht for Sale" src="https://www.alliedmarine.com/photos/articles/2017-tiara-53-yacht-for-sale.jpg" alt="1985 Hatteras 60' Yacht for Sale" width="1200">
<p>For an excellent value in a brokerage sport fisherman, take a good look at "<a title="1985 Hatteras 60' Yacht For Sale" href="../../../../used-yachts-for-sale/1985-Hatteras-65-Convertible-with-Tower-Silver-Streak-yacht-for-sale/7029672_2">Silver Streak</a>" a 1985 Hatteras 60' yacht for sale with enclosed flybridge. This yacht has been excellently maintained all its life and is now updated with frameless windows, E&H Boat Works exterior paint, new engines with down angle transmission, a new generator, and new electronics. Beaming with the care that the owners gave it through the years, it is being sold only due to the owner's health issues.</p>
<img class="img-fluid" title="1985 Hatteras 60' Yacht for Sale" src="https://www.alliedmarine.com/photos/articles/1985-hatteras-60-yacht-for-sale.jpg" alt="1985 Hatteras 60' Yacht for Sale" width="1200">
<p>At this time, in preparation for the upcoming summer season, we are offering many advantageous opportunities to purchase new models - and brokerage owners are eager for offers. Please be assured that we are looking to deal on our new inventory and that brokerage yachts are seriously for sale. Likewise, if you have a yacht for sale, please be sure it is in the best condition possible so that no excuses need be made when interested buyers arrive with checkbook in hand!</p>
<p>If you don't see what you're looking for, we'll work hard to find it for you. We are always available for more complete details and assistance on any model of interest, or to offer our best advice on readying a boat for sale. Between the two of us, we know we can help!</p>
<div class="col-sm-6 col-md-8 col-lg-8">
<div class="row">
<div class="col-12 col-lg-6">
<div class="card w-100 text-center">
<div class="img-background"> </div>
<a href="https://www.alliedmarine.com/our-team/yacht-broker-Tom-Jenkins/21"> <img class="img-fluid" src="https://www.alliedmarine.com/photos/brokers/correct/21_1.jpg" alt="Stuart, FL Yacht Sales" width="200" height="200" /> </a>
<div class="card-body">
<div class="am-swash"><img src="../../../../assets/images/am-icon-blue.svg" alt="Allied Marine Logo" width="30" /></div>
<h6 class="card-title">Tom Jenkins</h6>
<p class="card-text">Yacht Broker</p>
<p class="phone"><a href="https://www.alliedmarine.com/our-team/yacht-broker-Tom-Jenkins/21"> <img src="../../../../assets/images/cell-circle.svg" alt="mobile phone" width="25" /></a>+1 772.201.1800</p>
</div>
</div>
</div>
<div class="col-12 col-lg-6">
<div class="card w-100 text-center">
<div class="img-background"> </div>
<a href="https://www.alliedmarine.com/our-team/yacht-broker-Brett-Jenkins/22"> <img class="img-fluid" src="https://www.alliedmarine.com/photos/brokers/22_1.jpg" alt="Stuart, FL Yacht Sales" width="200" height="200" /> </a>
<div class="card-body">
<div class="am-swash"><img src="../../../../assets/images/am-icon-blue.svg" alt="Allied Marine Logo" width="30" /></div>
<h6 class="card-title">Brett Jenkins</h6>
<p class="card-text">Yacht Broker</p>
<p class="phone"><a href="https://www.alliedmarine.com/our-team/yacht-broker-Brett-Jenkins/22"> <img src="../../../../assets/images/cell-circle.svg" alt="mobile phone" width="25" /></a>+1 772.201.1630</p>
</div>
</div>
</div>
<div class="col-12"> </div>
</div>
</div> |
Jenkins' Featured Yachts for Sale |
2019-09-30 14:18:58.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] |
B022,B021 |
[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 |
by Tom & Brett Jenkins, Allied Marine Yacht Brokers |
Jenkins' Featured Yachts for Sale |
1.0 |
by Tom & Brett Jenkins, Allied Marine Yacht Brokers |
[empty string] |
Jenkins' Featured Yachts for Sale |
website |
https://www.alliedmarine.com |
[empty string] |
tom-and-brett-jenkins-stuart-florida-yacht-brokers1.jpg |
tom-and-brett-jenkins-stuart-florida-yacht-brokers1.jpg,1985-hatteras-60-yacht-for-sale.jpg,2017-tiara-53-yacht-for-sale.jpg |
2019-04-11 09:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
by Tom & Brett Jenkins, Allied Marine Yacht Brokers |
[empty string] |
Jenkins' Featured Yachts for Sale |
yachting-news |
jenkins-featured-yachts-for-sale |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/jenkins-featured-yachts-for-sale |
0 |
[empty string] |
[empty string] |
[empty string] |
by Tom & Brett Jenkins, Allied Marine Yacht Brokers |
[empty string] |
[empty string] |
[empty string] |
Jenkins' Featured Yachts 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 = 'jenkins-featured-yachts-for-sale'
ORDER BY postedDate desc |