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-11-21 00:00:00.0 |
2022-11-21 00:00:00.0 |
318 |
[empty string] |
<p style="text-align: center;"><span style="color: #236fa1;"><strong>$100K PRICE REDUCTION</strong></span></p>
<p style="text-align: center;"><span style="color: #236fa1;"><strong>Here's an opportunity to own an ALMOST NEW Riva 88' Folgore with a Full Factory Warranty - </strong></span><span style="color: #236fa1;"><strong>Ready for immediate delivery!</strong></span></p>
<p style="text-align: center;"><a href="../../../../download/BE5999A8E037A684829FA99C32E0B910FD3C7D8CD9CA97160BEF4C03BC29B1C9" target="_blank" rel="noopener"><img style="display: block; margin-left: auto; margin-right: auto;" src="../../../../photos/articles/brochure-frank-button.jpg" alt="Image 1777: " width="512" height="60" /></a></p>
<p style="text-align: left;"><span style="color: #236fa1;"><strong>This new 2022 Riva 88' Folgore is available now and ready for immediate delivery! </strong></span>She carries a Full Factory Warranty. The Riva 88' Folgore, this blaze of brilliant style, this irresistible thunderbolt, is ready to seduce owners and devotees of the Riva legend around the world. Riva 88' Folgore is the new sportfly with a difference: potent and revolutionary with an almost sci-fi beauty, this is a yacht that is made to dazzle.</p>
<p style="text-align: center;"><a href="tel:+1954.600.0369" target="_blank" rel="noopener"><img src="../../../../photos/articles/call-frank-button.jpg" alt="Image 1778: " width="512" height="60" /> </a><a href="mailto:Eric.Frank@AlliedMarine.com"><img src="../../../../photos/articles/frank-request-button.jpg" alt="Image 1779: " width="512" height="60" /></a></p>
<p style="text-align: left;">The magnetic allure of her design is created in the harmony between past and present, in the concept that unites innovative materials like carbon with traditional stylish features from mahogany inlay to decorative steel. This blaze of brilliant style, this irresistible thunderbolt, is ready to seduce owners and devotees of the Riva legend around the world. Riva 88' Folgore is the new sportfly with a difference: potent and revolutionary with an almost sci-fi beauty, this is a yacht that is made to dazzle.</p>
<p><iframe title="YouTube video player" src="https://www.youtube.com/embed/LFEacJZXIqs" width="560" height="315" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p>
<p>The magnetic allure of her design is all in the harmony between past and present, in the concept that unites innovative materials like carbon with traditional stylish features from mahogany inlay to decorative steel.</p>
<p>Like all the masterpieces in Riva’s recent history, the 88' Folgore is a product of the partnership between Officina Italiana Design (the studio founded by Mauro Micheli with Sergio Beretta), the Product Strategy Committee headed by Piero Ferrari, and the Ferretti Group Engineering Department. <a href="../../../../used-yachts-for-sale/2022-riva-folgore-bel-sogno-yacht-for-sale/8568579_2" target="_blank" rel="noopener">See the full listing.</a></p>
<p><span style="color: #236fa1;"><strong>NOTABLE FEATURES</strong></span></p>
<ul>
<li>Gyro stabilizer</li>
<li>Engines MTU 2638 HP EPA compliant</li>
<li>Custom internal Timber</li>
<li>Aquamatic watermaker</li>
<li>Manual sliding bed in portside guest cabin</li>
<li>Automatic battery charger for generators</li>
<li>Hatch for staircase leading to flybridge</li>
<li>Antenna TV SAT KVH M7 HD</li>
<li>Empty dome for KVHTV6 </li>
<li>Cockpit area manual Bimini with carbon poles</li>
<li>Bimini Top at bow</li>
<li>Flybridge Bimini top with carbon fiber poles</li>
<li>Electrical opening roof</li>
<li>Premium sound in master cabin</li>
<li>SIMRAD screen upgrade on main bridge and flybridge</li>
<li>Custom salon and dining area wooden floor</li>
<li>Custom layout in master cabin</li>
<li>Third control station and bow/stern thruster in cockpit</li>
<li>FLIR thermal night vision video camera</li>
<li>Underwater Lumishore Lights</li>
<li>Ambient lights in salon, dinning area and cabins</li>
<li>Ambient lights in bathrooms hydraulic stern thruster internal</li>
<li>USB sockets</li>
<li>Joystick dual station</li>
<li>Joystick dynamic positioning system</li>
<li>CockpitTable with HI-LO System</li>
<li>US decoder in VIP cabin and port/stbd guest cabin</li>
<li> Pilot seat with up & down system</li>
<li>Wine cellar in dining</li>
<li>Drawer fridge on flybridge</li>
<li>Bar furniture in cockpit with electric up & down system</li>
<li>Electric curtains</li>
<li>Electric blackout blinds</li>
<li>Additional mooring cleats (2)</li>
<li>Foredeck table with stainless steel base and Corian top</li>
<li>90cm oven and cooking plate in galley</li>
<li>Double sink in galley</li>
<li>Dimmer all over the boat</li>
<li>Extra storage in cabins</li>
<li>Salon furniture top and lower deck cabins closets leather upholstered</li>
<li>Bathroom modifications and washroom area</li>
<li>Fusion A/V upgrade on external areas</li>
<li>TV 55" in master cabin</li>
<li>TV 43" in port guest cabin with stainless steel TV totem</li>
<li>TV 55" in salon</li>
<li>TV 24" in starboard guest cabin with stainless steel TV totem</li>
<li>AIS system receiver SIMRAD NAIS500</li>
<li>Custom marble in bathrooms</li>
<li>Boat name rear illuminate</li>
<li>Pipingfor external cushions (only on seats)</li>
<li>Stainless steel protection for side cleats</li>
<li>Garage predisposition for tender and jet-ski winches</li>
<li>Gloss 100 mahogany wood for stern portside & stbd rub rail</li>
<li>Lower deck cabins: additional stainless steel finish & details for wardrobe doors</li>
<li>Side Gates</li>
<li>Custom external upholstery</li>
<li>Code change XFA</li>
<li>Teak cockpit makeover</li>
<li>Mini HiFi fusion dinette</li>
<li>Electric Glendinning for 100A shore power connection</li>
<li>Tender retractable system</li>
</ul> |
JUST REDUCED! 2022 RIVA 88 BEL SOGNO |
2022-11-21 17:27:24.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 |
Here's an opportunity to own an ALMOST NEW Riva 88' Folgore with Full Factory Warranty! Ready for immediate delivery. |
Price Reduced! 2022 RIVA 88 BEL SOGNO |
1.0 |
Here's an opportunity to own an ALMOST NEW Riva 88' Folgore with Full Factory Warranty! Ready for immediate delivery. |
[empty string] |
Price Reduced! 2022 RIVA 88 BEL SOGNO |
website |
https://www.alliedmarine.com |
[empty string] |
hero-belsogno2.jpg |
hero-belsogno2.jpg,frank-request-button.jpg,call-frank-button.jpg,brochure-frank-button.jpg |
2022-11-21 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Here's an opportunity to own an ALMOST NEW Riva 88' Folgore with Full Factory Warranty! Ready for immediate delivery. |
[empty string] |
Price Reduced! 2022 RIVA 88 BEL SOGNO |
yachting-news |
price-reduced-2022-riva-88-bel-sogno |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/price-reduced-2022-riva-88-bel-sogno |
0 |
[empty string] |
[empty string] |
[empty string] |
Here's an opportunity to own an ALMOST NEW Riva 88' Folgore with Full Factory Warranty! Ready for immediate delivery. |
[empty string] |
[empty string] |
[empty string] |
Price Reduced! 2022 RIVA 88 BEL SOGNO |
[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 = 'price-reduced-2022-riva-88-bel-sogno'
ORDER BY postedDate desc |