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 |
2018-10-22 00:00:00.0 |
2018-10-22 00:00:00.0 |
18 |
[empty string] |
<p>If <a href="../../../../our-offices/yachts-for-sale-in-Fort-Lauderdale-Florida/">Fort Lauderdale</a> is the “Yachting Capital of the World”, then Allied Marine is the beating heart of the city. Ever since the inception of the yacht show, Allied Marine has been a major presence. This year Allied Marine, Ferretti Group’s <a href="../../../../used-yachts-for-sale">yacht brokerage</a> and <a href="../../../../yacht-charter-vacations/yacht-charter-search">charter </a>division, is at The Fort Lauderdale Boat Show for the 57th time.</p>
<p>Until November 7th, the <a href="../../../../our-offices/yachts-for-sale-in-Bahia-Mar-Fort-Lauderdale-Florida/">Bahia Mar</a> floating docks D/E will house Allied Marine’s vast selection of pristine yachts that are ready for new oceanic adventures. <a href="../../../../our-team">Allied Marine’s expert brokers</a> are present on location and will guide and advise guests and VIP’s, to find the vessel they always wanted. A total of 13 yachts on display, ranging from 41’ to 90’, reflect the wide range of Allied Marine’s available yachts.</p>
<p>The following yachts offered by Allied Marine are available:</p>
<p>Dominator – 90’ – 2008 – “Freewind” – Broker Enzo Garoche<br />Johnson – 87’ – 2005 – “4 MAL” – Broker <a href="../../../../our-team/yacht-broker-Tom-Jenkins/21">Tom Jenkins</a><br /><a href="../../../../used-yachts-for-sale/brands/Ferretti-Yachts">Ferretti Yachts</a> - 80’ - 2012 – “Alter Ego” - Broker <a href="../../../../our-team/yacht-broker-Justin-Sullivan/30">Justin Sullivan</a><br />Ferretti Yachts - 84’ - 2013 – “She Said Yes Again” - Broker <a href="../../../../our-team/yacht-broker-Peter-Hopwood/20">Peter Hopwood</a><br /><a href="../../../../used-yachts-for-sale/brands/Bertram">Bertram</a> – 67’ – 2003 - Bronx Tail – Broker <a href="../../../../our-team/yacht-broker-Cole-Watkins/34">Cole Watkins</a><br /><a href="../../../../used-yachts-for-sale/brands/Absolute">Absolute</a> – 64’ – 2013 – Quality Time – Broker <a href="../../../../our-team/yacht-broker-Thomas-Knutson/24">Tom Knutson</a><br />Bertram – 63’ – 2005 - Brisa II – Broker <a href="../../../../our-team/yacht-broker-Sean-Fenniman/12">Sean Fenniman</a><br /><a href="../../../../used-yachts-for-sale/brands/Pershing">Pershing </a>- 62’ - 2006 - Coalition - Broker <a href="../../../../our-team/yacht-broker-Geoff-Zimmerman/37">Goeff Zimmerman</a><br />Ferretti Yachts - 62’ - 2011 - Contrails - Broker <a href="../../../../our-team/yacht-broker-Sean-Fenniman/12">Sean Fenniman</a><br />Rybovich – 48’ – 1989 - Ram Rod – Broker <a href="../../../../our-team/yacht-broker-Cole-Watkins/34">Cole Watkins</a><br /><a href="../../../../used-yachts-for-sale/brands/Riva">Riva</a> - 44’ - 2012 - Lady M - Broker <a href="../../../../our-team/yacht-broker-Chris-Holtzheuser/19">Chris Holtzheuser</a><br /><a href="../../../../used-yachts-for-sale/brands/Tiara">Tiara</a> – 43’ – 2016 – Intermezzo – Broker <a href="../../../../our-team/yacht-broker-Bob-Martin/27">Bob Martin</a><br /><a href="../../../../used-yachts-for-sale/brands/Regulator">Regulator</a> 41’- 2016 – “Dropped Call” – Broker <a href="../../../../our-team/yacht-broker-Cole-Watkins/34">Cole Watkins</a></p>
<p>With over 40 trained and professional yacht brokers coordinating daily sales, Allied Marine has, over the past 6 decades, grown to become the destination of choice for <a href="../../../../sell-your-yacht/sold-yachts">yacht sales</a>, brokerage and charters. At any given time, Allied Marine has over 300 yachts for sale, ranging from 30’ to over 200’.<br />With this extensive and varied fleet at its disposal, Allied Marine has the unique ability to accommodate each client - from the yachting novice to the experienced super yacht owner - according to their individual needs.</p>
<p>“Allied Marine is an extension of every element in the Ferretti Group philosophy. Each client deserves the utmost attention and best customer service and Allied Marine sets the bar for the entire industry. From highly trained brokers to extensive advertising both online and offline, Allied Marine satisfies even the most demanding customer. By providing a flawless experience and successfully completing record-setting sales, Allied Marine remains ahead of its competitors.” Says <a href="../../../../our-team/allied-marine-staff-Jon-Burkard/5">Jon Burkard</a>, Allied Marine President.</p> |
Visit Allied Marine at FLIBS Dock D/E |
2020-11-05 10:12:59.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 |
Allied Marine’s vast selection of pristine yachts are ready for new oceanic adventures. Expert brokers are on location to guide and advise guests and VIP’s. |
Visit Allied Marine at FLIBS Dock D/E |
1.0 |
|
[empty string] |
Visit Allied Marine at FLIBS Dock D/E |
website |
http://allied.advantage.services |
[empty string] |
allied-marine-team-at-flibs-boat-show.jpg |
allied-marine-team-at-flibs-boat-show.jpg |
2016-11-05 07:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
|
[empty string] |
Visit Allied Marine at FLIBS Dock D/E |
yachting-news |
visit-allied-marine-at-flibs-dock-de |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/visit-allied-marine-at-flibs-dock-de |
0 |
[empty string] |
[empty string] |
[empty string] |
|
[empty string] |
[empty string] |
[empty string] |
Visit Allied Marine at FLIBS Dock D/E |
[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 = 'visit-allied-marine-at-flibs-dock-de'
ORDER BY postedDate desc |