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-05-19 00:00:00.0 |
2022-05-19 00:00:00.0 |
265 |
[empty string] |
<p>64' LIDIA - Characterised by an aerodynamic flybridge this Ferretti Yachts 650 is designed to set a new functional and technical standard. This yacht is in pristine condition.</p>
<figure class="image"><img title="Sister ship Images (more coming soon!)" src="../../../../photos/articles/4929080-20150130023445824-1-xlarge.jpg" alt="Image 1198: " width="100%" height="auto" />
<figcaption><em>Sister ship Image (more coming soon!)</em></figcaption>
</figure>
<p> </p>
<p>Ferretti Yachts 650 is the first in a series of models that are bound to set a new functional and technical standard for the "Yachts" product line below 70 feet in length. Developed thanks to the cooperation between the Product Strategy Committee, Ferretti Group's Marketing Department, AYT&D - Advanced Yachts Technology & Design, and Studio Zuccon International Project, the project draws inspiration from the Ferretti 620.</p>
<p> </p>
<figure class="image"><img title="Sister ship Images (more coming soon!)" src="../../../../photos/articles/4929080-20150130023652527-1-xlarge.jpg" alt="Image 1202: " width="100%" height="auto" />
<figcaption><em>Sister ship Image (more coming soon!)</em></figcaption>
</figure>
<p> </p>
<p>The Ferretti Yacht 650 immediately strikes the eye for its extensively renovated profile. Its outer silhouette is characterized by an aerodynamic flybridge and new fiberglass decorative elements that "cut" through the profile of the glazing in the superstructure.</p>
<p> </p>
<figure class="image"><img title="Sister ship Images (more coming soon!)" src="../../../../photos/articles/4929080-20150130023602943-1-xlarge.jpg" alt="Image 1200: " width="100%" height="auto" />
<figcaption><em>Sister ship Image (more coming soon!)</em></figcaption>
</figure>
<p> </p>
<figure class="image"><img title="Sister ship Image (more coming soon!)" src="../../../../photos/articles/4929080-20150130023717603-1-xlarge.jpg" alt="Image 1203: " width="100%" height="auto" />
<figcaption><em>Sister ship Image (more coming soon!)</em></figcaption>
</figure>
<p> </p>
<p>An unprecedented decoration connects the windows of the three cabins below deck. The main deck is a truly open space forward until the windshield and functional.</p>
<p> </p>
<figure class="image"><img title="Sister ship Image (more coming soon!)" src="../../../../photos/articles/4929080-20150130023754867-1-xlarge.jpg" alt="Image 1204: " width="100%" height="auto" />
<figcaption><em>Sister ship Image (more coming soon!)</em></figcaption>
</figure>
<p> </p>
<p>The galley is completely open: this solution allows to fully exploit this room as a large bar area opening onto the stern and towards the dining and living areas, further contributing to a sense of volume and making living onboard even more enjoyable. The underdeck layout includes three double cabins and three separate heads.</p>
<p> </p>
<figure class="image"><img title="Sister ship Image (more coming soon!)" src="../../../../photos/articles/4929080-20150130023539447-1-xlarge.jpg" alt="Image 1199: " width="100%" height="auto" />
<figcaption><em>Sister ship Image (more coming soon!)</em></figcaption>
</figure>
<p> </p>
<p>For additional information see the <a href="../../../../used-yachts-for-sale/2017-Ferretti-Yachts-70-650-LIDIA-yacht-for-sale/8298973_2">listing</a> or contact <a href="../../../../our-team/yacht-broker-Justin-Sullivan/30" target="_blank" rel="noopener">Justin Sullivan</a>, Yacht broker, Allied Marine Fort Lauderdale, FL</p> |
JUST LISTED YACHT FOR SALE | LIDIA 2017 FERRETTI YACHT 64.5' YACHT |
2022-05-20 10:14:48.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 |
Brokerage Luxury Used Yacht for Sale |
JUST LISTED YACHT FOR SALE LIDIA 2017 FERRETTI YACHT 64.5' |
1.0 |
|
[empty string] |
JUST LISTED YACHT FOR SALE LIDIA 2017 FERRETTI YACHT 64.5' |
website |
https://www.alliedmarine.com |
[empty string] |
8298973-20220428095118493-1-xlarge.jpg |
8298973-20220428095118493-1-xlarge.jpg,4929080-20150130023445824-1-xlarge.jpg,4929080-20150130023652527-1-xlarge.jpg,4929080-20150130023602943-1-xlarge.jpg,4929080-20150130023717603-1-xlarge.jpg,4929080-20150130023628006-1-xlarge.jpg,4929080-20150130023539447-1-xlarge.jpg,4929080-20150130023054552-1-xlarge.jpg,4929080-20150130023754867-1-xlarge.jpg |
2022-04-29 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
|
[empty string] |
JUST LISTED YACHT FOR SALE LIDIA 2017 FERRETTI YACHT 64.5' |
yachting-news |
just-listed-yacht-for-sale-lidia-2017-ferretti-yacht-645 |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/just-listed-yacht-for-sale-lidia-2017-ferretti-yacht-645 |
30 |
[empty string] |
[empty string] |
[empty string] |
|
[empty string] |
[empty string] |
[empty string] |
JUST LISTED YACHT FOR SALE LIDIA 2017 FERRETTI YACHT 64.5' |
[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 = 'just-listed-yacht-for-sale-lidia-2017-ferretti-yacht-645'
ORDER BY postedDate desc |