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 |
2020-11-24 00:00:00.0 |
2020-11-24 00:00:00.0 |
119 |
[empty string] |
<p>Allied Marine announces the sale of a new <a title="Ferretti Yachts 850 Description Page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-850">Ferretti Yachts 850</a> in Ft. Lauderdale, Florida. Allied Marine Broker <a title="Thomas Knutson Page" href="../../../../our-team/yacht-broker-Thomas-Knutson/24">Thomas Knutson</a> made the sale.</p>
<p>Like a penthouse surrounded by the sea, this magnificent flybridge offers bright, airy accommodation elegantly furnished with refined design. The main deck of the Ferretti Yachts 850 enhances the dynamism of the overall design: A single glazed expanse cuts through the entire superstructure to complement the fore-and-aft hard top over the raised helm station. The garage door tilts open with a special mechanism to reveal a beach area that eases below the water as a large submerged platform for guests to enjoy (and a handy way for the crew to maneuver the tender). Covered walls, floor-to-ceiling windows, billowy curtains and plenty of freestanding furnishings are the keys to a concept that is metropolitan yet livable, ultracontemporary yet warm – and all in consummate Ferretti Yachts style.</p>
<p>The buyers are repeat clients within the Ferretti Group brands, this time choosing the <a title="Ferretti Yachts Models" href="../../../../new-yachts-for-sale/ferretti-yachts-for-sale">Ferretti Yachts</a> 850 as their best fit. They are experienced boat owners, and will be wintering the boat in Jupiter, Florida and traveling through the Northeast in summertime.</p>
<p>See our <a title="Sold Boats Page" href="../../../../sell-your-yacht/sold-yachts">Sold Boats</a> page for a list of additional yachts brokered by Allied Marine.</p>
<p><strong>GENERAL APPOINTMENTS</strong><br />Length Overall 26.14 m - 85 ft 9 in<br />Length Of Hull 23.98 m - 78 ft 8 in<br />Load Waterline Length 21.59 m - 70 ft 10 in<br />Max beam 6.28 m - 20 ft 7 in<br />Draft 2 m - 6 ft 7 in<br />Unladen displacement 67.000 kg - 147,710 lbs<br />Laden displacement 77.500 kg - 170,858 lbs<br />Fuel 6.750 l - 1,783 US gal<br />Water 1.320 l - 349 US gal<br />Material GRP<br />People on board 20<br />Cabins 4<br />Bathrooms 5<br />Bathrooms in crew quarter 2</p> |
New Ferretti Yachts 850 Sold |
2020-12-08 17:08:36.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 |
Allied Marine announces the sale of a new Ferretti Yachts 850 in Ft. Lauderdale, Florida. Allied Marine Sales Rep Thomas Knutson made the sale. |
Ferretti Yachts 850 Sold |
1.0 |
Allied Marine announces the sale of a new Ferretti Yachts 850 in Ft. Lauderdale, Florida. |
[empty string] |
Ferretti Yachts 850 Sold |
website |
https://www.alliedmarine.com |
[empty string] |
ferretti-850-11.jpg |
ferretti-850-11.jpg,ferretti-8501.jpg |
2020-11-30 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Allied Marine announces the sale of a new Ferretti Yachts 850 in Ft. Lauderdale, Florida. |
[empty string] |
Ferretti Yachts 850 Sold |
yachting-news |
ferretti-yachts-850-sold-2020-11-24-204166 |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/ferretti-yachts-850-sold-2020-11-24-204166 |
24 |
[empty string] |
[empty string] |
[empty string] |
Allied Marine announces the sale of a new Ferretti Yachts 850 in Ft. Lauderdale, Florida. |
[empty string] |
[empty string] |
[empty string] |
Ferretti Yachts 850 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 = 'ferretti-yachts-850-sold-2020-11-24-204166'
ORDER BY postedDate desc |