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-10-11 00:00:00.0 |
2022-10-11 00:00:00.0 |
293 |
[empty string] |
<p style="text-align: center;"><strong><span style="color: #236fa1;">TOUR THIS YACHT DURING THE 2022 FORT LAUDERDALE BOAT SHOW</span></strong></p>
<p style="text-align: center;"><strong><span style="color: #236fa1;">October 26-30, 2022, at the Ferretti Group New Yachts Display: F Dock, Face 15</span></strong></p>
<p style="text-align: center;"><strong><span style="color: #236fa1;"><a href="../../../../partials/iframe.contact-form.cfm" target="_blank" rel="noopener"><img src="../../../../photos/articles/req-info-button-3.jpg" alt="Image 1408: " width="512" height="60" /></a> </span></strong><a href="tel:+1.954.462.5557" target="_blank" rel="noopener"><strong><span style="color: #236fa1;"><img src="../../../../photos/articles/riva-button.jpg" alt="Image 1409: " width="512" height="60" /></span></strong></a></p>
<p><strong><span style="color: #236fa1;">YACHT OVERVIEW</span></strong> <br />The Riva 90 Argo is a unique example of the new generation of Riva flybridges. With a futuristic design, a name that evokes the stuff of legend, and a supreme array of high-tech onboard solutions, this creation of magnetic beauty is a peerless star in the global yachting firmament.</p>
<p><iframe src="https://www.youtube.com/embed/3lHR3XUCguk" width="560" height="314" allowfullscreen="allowfullscreen"></iframe><br /><br />The instantly recognizable, forward-looking design defined by fluent, sporty lines lends her a free-flowing, potent profile that captures the eye to compelling effect. And in a sumptuous triumph of elegance and comfort, the generous spaces complement the unmistakable Riva style with contributions from the most prestigious names of Italian interior design. Her hull color is "Regal Silver."<br /><br /><span style="color: #236fa1;"><strong>ENGINES AND PERFORMANCE</strong></span><br />Her dual MTU 12V engines produce 3,896 horsepower (1,948 hp each) with V-Drive transmissions. Enjoy a cruising range of 320 nautical miles with a cruising speed of 22 kn and a max speed of 26 kn. Length is 93.5 feet with a beam of 21.33 feet. Seakeeper stabilization lets you cruise in comfort.<br /><br /><strong><span style="color: #236fa1;">ACCOMMODATIONS</span></strong><br />4 Staterooms, 7 Heads, 2 Crew Cabins<br /><br />The Riva 90 Argo features a full-beam master stateroom located on the main deck with an en-suite bathroom. On the lower deck, the 3 VIP staterooms are also en-suite, with one of them enjoying the extra spaciousness of being full-beam. The crew quarters feature 2 separate cabins, each with its own head. A day head on the lower level brings the total to 7 heads onboard. Enjoy lavish entertaining with spacious comfort for 20 guests and crew.<br /><br /><strong><span style="color: #236fa1;">NOTABLE FEATURES</span></strong></p>
<ul>
<li>Seakeeper stabilization</li>
<li>Master stateroom on main deck</li>
</ul>
<p><span style="color: #236fa1;"><strong>PRIVATE SHOWINGS</strong></span><br />Visit The Ferretti Group Showroom in Ft. Lauderdale, the largest covered, in-water marina in the US, featuring new and used Pershing, Riva, and Ferretti Yachts. Allied Marine is the exclusive dealer for these premier brands in the US and an authorized dealer for CRN and Custom Line yachts.</p>
<p> </p>
<hr />
<p> </p>
<h3><strong><span style="color: #236fa1;">OTHER YACHTS AT THE SHOW</span></strong></h3>
<p><strong><span style="color: #236fa1;"><a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-102-corsaro-super-new"><img src="../../../../photos/articles/15-riva-102-corsaro-super-new-sm.jpg" alt="Image 1410: " width="512" height="512" /></a> <a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-ferretti-yachts-920"><img src="../../../../photos/articles/15-ferretti-yachts-920-sm.jpg" alt="Image 1411: " width="512" height="512" /></a> <a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-pershing-8x"><img src="../../../../photos/articles/15-pershing-8x-sm.jpg" alt="Image 1412: " width="512" height="512" /> </a></span></strong><a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-riva-76-bahamas-super"><strong><span style="color: #236fa1;"><img src="../../../../photos/articles/15-riva76bahamassuper-sm.jpg" alt="Image 1498: " width="512" height="512" /></span></strong></a></p>
<p> </p> |
RIVA 90 ARGO |
2022-10-18 16:55:29.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 |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
1.0 |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
website |
https://www.alliedmarine.com |
[empty string] |
15-hero-riva-90-argo.jpg |
15-hero-riva-90-argo.jpg,15-riva76bahamassuper-sm.jpg,15-riva-102-corsaro-super-new-sm.jpg,15-pershing-8x-sm.jpg,15-ferretti-yachts-920-sm.jpg,riva-button.jpg,req-info-button-3.jpg |
2022-10-11 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
yachting-news |
2022-fort-lauderdale-boat-show-riva-90-argo |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/2022-fort-lauderdale-boat-show-riva-90-argo |
0 |
[empty string] |
[empty string] |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
[empty string] |
[empty string] |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW RIVA 90 ARGO |
[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 = '2022-fort-lauderdale-boat-show-riva-90-argo'
ORDER BY postedDate desc |