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-04-20 00:00:00.0 |
2022-04-20 00:00:00.0 |
254 |
[empty string] |
<p><strong>Allied Marine Yacht Brokerage is delighted to announce the sale of a new RIVA 110' DOLCEVITA by <a href="../../../../our-team/yacht-broker-Justin-Sullivan/30" target="_blank" rel="noopener">Justin Sullivan</a> from Allied Marine Fort Lauderdale.</strong></p>
<figure class="image"><img src="../../../../photos/articles/dolcevita-interni-206.jpg" alt="Image 1129: " width="100%" height="auto" />
<figcaption><span style="color: #95a5a6;">Riva 110' DOLCEVITA Deck</span></figcaption>
</figure>
<p>Characterized by her sporty profile this Riva 110' DOLCEVITA is a maritime masterpiece. She is a flybridge of unlimited beauty, the result of a partnership between Officina Italiana Design and the Ferretti Group Engineering Department. She is a magnificent invention in every way - for her spectacular visual impact, her unrivaled balance of aesthetics, luxury, and high technology, and the exceptional cruising experience she provides.</p>
<figure class="image"><img src="../../../../photos/articles/dolcevita-interni-330.jpg" alt="Image 1139: " width="100%" height="auto" />
<figcaption><span style="color: #95a5a6;">Riva 110' DOLCEVITA Main Salon</span></figcaption>
</figure>
<figure class="image"><img src="../../../../photos/articles/dolcevita-interni-337.jpg" alt="Image 1140: " width="100%" height="auto" />
<figcaption><span style="color: #95a5a6;">Riva 110' DOLCEVITA Deck</span></figcaption>
</figure>
<figure class="image"><img src="../../../../photos/articles/dolcevita-interni-214.jpg" alt="Image 1130: " width="100%" height="auto" />
<figcaption><span style="color: #95a5a6;">Riva 110' DOLCEVITA Deck</span></figcaption>
</figure>
<p>This 110ft superyacht spreads across three decks and features 5 staterooms, ensuring a luxury experience for up to 20 guests and crew in roomy comfort. Her dual MTU 16V engines produce 4,000 horsepower (2,000 hp each) with V-Drive transmission and has a range of 430 nautical miles with a cruising speed of 23kn with maximum comfort always ensured by her gyro stabilization.</p>
<figure class="image"><img src="../../../../photos/articles/dolcevita-interni-160.jpg" alt="Image 1126: " width="100%" height="auto" />
<figcaption><span style="color: #95a5a6;">Riva 110' DOLCEVITA Master Suite</span></figcaption>
</figure>
<p>If you're interested in buying or selling a yacht, contact the professional team of yacht brokers at Allied Marine, one of the largest and most experienced yacht brokerages in the world. Founded in 1945, we specialize in luxury brokerage yachts and both new and brokerage superyachts.</p>
<p><strong>Congratulations to all involved.</strong><br /><br />For more information contact Allied Marine or to inquire about more Riva yachts for sale <a href="../../../../new-yachts-for-sale/riva-yachts-for-sale" target="_blank" rel="noopener">click here</a>.</p> |
JUST SOLD SUPERYACHT | RIVA 110' DOLCEVITA |
2022-05-20 10:22:23.0 |
|
[empty string] |
riva,riva yacht sales,sold riva yacht,superyacht |
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 Yacht Brokerage is delighted to announce the sale of a RIVA 110’ DOLCEVITA by Justin Sullivan from Allied Marine Ft Lauderdale to an American owner. |
110ft DOLCEVITA Superyacht Sold! |
1.0 |
Allied Marine Yacht Brokerage is delighted to announce the sale of a RIVA 110’ DOLCEVITA by Justin Sullivan from Allied Marine Ft Lauderdale to an American owner. |
[empty string] |
110ft DOLCEVITA Superyacht Sold! |
website |
https://www.alliedmarine.com |
[empty string] |
dolcevita-interni-241.jpg |
dolcevita-interni-241.jpg,dolcevita-interni-214.jpg,dolcevita-interni-284.jpg,dolcevita-interni-349.jpg,dolcevita-interni-233.jpg,dolcevita-interni-337.jpg,dolcevita-interni-224.jpg,dolcevita-interni-220.jpg,dolcevita-interni-187.jpg,dolcevita-interni-206.jpg,dolcevita-interni-253.jpg,dolcevita-interni-325.jpg,dolcevita-interni-315.jpg,dolcevita-interni-330.jpg,dolcevita-interni-197.jpg,dolcevita-interni-353.jpg,dolcevita-interni-160.jpg,dolcevita-interni-133.jpg,dolcevita-interni-114.jpg,dolcevita-interni-365.jpg |
2022-04-20 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Allied Marine Yacht Brokerage is delighted to announce the sale of a RIVA 110’ DOLCEVITA by Justin Sullivan from Allied Marine Ft Lauderdale to an American owner. |
[empty string] |
110ft DOLCEVITA Superyacht Sold! |
yachting-news |
110ft-dolcevita-superyacht-sold |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/110ft-dolcevita-superyacht-sold |
30 |
[empty string] |
[empty string] |
[empty string] |
Allied Marine Yacht Brokerage is delighted to announce the sale of a RIVA 110’ DOLCEVITA by Justin Sullivan from Allied Marine Ft Lauderdale to an American owner. |
[empty string] |
[empty string] |
[empty string] |
110ft DOLCEVITA Superyacht Sold! |
[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 = '110ft-dolcevita-superyacht-sold'
ORDER BY postedDate desc |