query

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	Holly Buisson	News	2021-06-04 00:00:00.0	2021-06-04 00:00:00.0	158	[empty string]	<p><img src="../../../../photos/articles/steelpointe-yacht-charter-show-crop.jpg" alt="Image 0306: " width="300" height="128" /></p> <p>The <a title="Steelpointe Show Web Page" href="https://www.steelpointeboatshows.com/"><strong>Steelpointe Yacht & Charter Show</strong></a> is the Northeast’s premier showcase for yachting excellence, rare and vintage cars, private aviation and so much more. Allied Marine will feature two yachts at the show which is held in Bridgeport, CT, from June 17-20, 2021. </p> <p>Allied Marine will showcase the Pershing 82 and the Riva 48' Dolceriva, just delivered from Italy.</p> <h2>THE PERSHING 82</h2> <p>Featuring a streamlined and aggressive external profile, the <strong><a title="Pershing 82" href="../../../../used-yachts-for-sale/2019-Pershing-82-82-Our-Trade-yacht-for-sale/7796270_2">Pershing 82</a></strong> immediately shows its strong sporting spirit. The eye-catching distinctive feature is the sundeck with an optional retractable helm station that can be reached by means of an innovative carbon-steel staircase, lowered automatically into the cockpit by an electro-hydraulic control.</p> <p><img title="Pershing 82" src="../../../../photos/articles/pershing-82-new.jpg" alt="Image 0307: " width="500" height="333" /></p> <p> </p> <h2>THE RIVA 48' DOLCERIVA HARD TOP</h2> <p>Enjoy a first look at the the <a title="Riva Dolceriva" href="../../../../used-yachts-for-sale/2022-Riva-1000-48-DOLCERIVA-Dolceriva-48-yacht-for-sale/7842673_3"><strong>Riva 48' Dolceriva</strong></a> hard top. She has a futuristic design but with all the heritage of the legendary Riva yard. In addition, the <a href="../../../../yachting-news/new-dolceriva-with-hardtop-a-marvel-of-design-comfort-and-relaxation">new carbon-fiber hard top</a> shelters you from sun and rain. She is a yacht conceived for on-board living in consummate comfort.</p> <p><img src="../../../../photos/articles/riva-48-dolceriva-hardtop1.jpg" alt="Image 0327: " width="500" height="325" /></p> <p> </p> <h2>PRIVATE EVENT - INVITATION ONLY</h2> <p><a href="../../../../events-and-boatshows/steelpointe-yacht-charter-show">The Steelpointe Yacht & Charter Show</a> is an invitation-only event with no general admission. If you would like to attend, please contact an <a title="Broker Team" href="../../../../our-team">Allied Marine Broker</a> to be put on the guestlist.</p> <p> </p> <h2>SHOW INFORMATION</h2> <h3>DATES & TIMES</h3> <p style="padding-left: 30px;">Thursday, June 17 - 12 pm to 6 pm</p> <p style="padding-left: 30px;">Friday, June 18 - 12 pm to 9 pm</p> <p style="padding-left: 30px;">Saturday, June 19 - 12 pm to 9 pm</p> <p style="padding-left: 30px;">Sunday, June 20 - 12 pm to 5 pm</p> <h3>LOCATION</h3> <p style="padding-left: 30px;">BRIDGEPORT HARBOR MARINA<br />10 E Main Street, Bridgeport, CT 06608</p> <p style="padding-left: 30px;">The marina is conveniently accessible by land, sea and air via I-95, the Metro Railroad servicing Connecticut and New York, the Port Jefferson Ferry from Long Island, the nearby Bridgeport Memorial (Sikorsky) Airport and Long Island Sound.</p> <p> </p> <p> </p>	Allied Marine Features 2 Boats at the Steelpointe Yacht and Charter Show	2021-06-29 12:51:09.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	BOLD. ELITE. ELEVATED. This invitation-only show takes place at the Bridgeport Harbor Marina in Bridgeport, CT.	Allied Marine Attends the Steelpointe Yacht and Charter Show	1.0		[empty string]	Allied Marine Attends the Steelpointe Yacht and Charter Show	website	https://www.alliedmarine.com	[empty string]	steelpoint-2021-06-08-150302-crop1.jpg	steelpoint-2021-06-08-150302-crop1.jpg,pershing-82-new.jpg,riva-48-dolceriva-hardtop1.jpg,steelpointe-yacht-charter-show-crop.jpg	2021-06-04 00:00:00.0	[empty string]	[empty string]	3	[empty string]		[empty string]	Allied Marine Attends the Steelpointe Yacht and Charter Show	yachting-news	allied-marine-attends-the-steelpointe-yacht-and-charter-show	[empty string]	[empty string]	https://www.alliedmarine.com/yachting-news/allied-marine-attends-the-steelpointe-yacht-and-charter-show	0	[empty string]	[empty string]	[empty string]		[empty string]	[empty string]	[empty string]	Allied Marine Attends the Steelpointe Yacht and Charter Show	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

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 = 'allied-marine-attends-the-steelpointe-yacht-and-charter-show' ORDER BY postedDate desc

Allied Marine Features 2 Boats at the Steelpointe Yacht and Charter Show

Jun 04, 2021

Image 0306:

The Steelpointe Yacht & Charter Show is the Northeast’s premier showcase for yachting excellence, rare and vintage cars, private aviation and so much more. Allied Marine will feature two yachts at the show which is held in Bridgeport, CT, from June 17-20, 2021.

Allied Marine will showcase the Pershing 82 and the Riva 48' Dolceriva, just delivered from Italy.

THE PERSHING 82

Featuring a streamlined and aggressive external profile, the Pershing 82 immediately shows its strong sporting spirit. The eye-catching distinctive feature is the sundeck with an optional retractable helm station that can be reached by means of an innovative carbon-steel staircase, lowered automatically into the cockpit by an electro-hydraulic control.

Image 0307:

THE RIVA 48' DOLCERIVA HARD TOP

Enjoy a first look at the the Riva 48' Dolceriva hard top. She has a futuristic design but with all the heritage of the legendary Riva yard. In addition, the new carbon-fiber hard top shelters you from sun and rain. She is a yacht conceived for on-board living in consummate comfort.

Image 0327:

PRIVATE EVENT - INVITATION ONLY

The Steelpointe Yacht & Charter Show is an invitation-only event with no general admission. If you would like to attend, please contact an Allied Marine Broker to be put on the guestlist.

SHOW INFORMATION

DATES & TIMES

Thursday, June 17 - 12 pm to 6 pm

Friday, June 18 - 12 pm to 9 pm

Saturday, June 19 - 12 pm to 9 pm

Sunday, June 20 - 12 pm to 5 pm

LOCATION

BRIDGEPORT HARBOR MARINA
10 E Main Street, Bridgeport, CT 06608

The marina is conveniently accessible by land, sea and air via I-95, the Metro Railroad servicing Connecticut and New York, the Port Jefferson Ferry from Long Island, the nearby Bridgeport Memorial (Sikorsky) Airport and Long Island Sound.

Fort Lauderdale

Bahia Mar

Huntington

Sag Harbor

Stuart