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 |
299 |
[empty string] |
<p style="text-align: center;"><span style="color: #236fa1;"><strong>TOUR THIS YACHT DURING THE 2022 FORT LAUDERDALE BOAT SHOW. <br /></strong></span><span style="color: #236fa1;"><strong>OCTOBER 26-30, 2022at the Allied Marine Brokerage Yacht Display: E Dock, Face 1 </strong></span></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 1448: " width="512" height="60" /></a> <a href="tel:+1%20954.849.0855" target="_blank" rel="noopener"><img src="../../../../photos/articles/jim-mcconville-bttn.jpg" alt="Image 1447: " width="512" height="60" /></a></span></strong></p>
<p style="text-align: center;"> </p>
<p style="text-align: left;"><span style="color: #236fa1;"><strong>YACHT OVERVIEW</strong></span> <br />Joan’s Ark is “Immaculate” in every way! She is a turnkey vessel and ready to leave the dock for a two-month cruise. Her owner’s carte blanche attitude for keeping their vessel to A1 standards and one of the finest Captains who has been with the family for 11 years makes Joan’s Ark second to none to anything on the market. Joan's Ark is an elegant lady, full of surprises around every corner. Every element is thoughtful and inviting.</p>
<p style="text-align: left;">The ambiance aboard includes a traditional tone with a contemporary flair featuring Sapele and Pomele mahogany woodwork, marble floors, luxurious carpets, and granite counters. Attention to every detail provides that wonderful feeling of home. The cozy country kitchen offers an opportunity for relaxed dining in an intimate atmosphere that encourages conversation and good times.</p>
<p style="text-align: left;">Joan's Ark features a magnificent master king suite below deck, a VIP queen suite below deck forward, a guest queen port, a twin aft starboard, and a twin over and under is also available bringing the number of guests to 11. Each suite features ample storage and stylish comfort, with rich woods, elegant wall coverings, abundant lighting, and beautiful floor treatments, providing a restful sleep after your fun day at sea. <a href="../../../../used-yachts-for-sale/2003-crescent-121-raised-pilothouse-motoryacht-joans-ark-yacht-for-sale/8338383_2" target="_blank" rel="noopener">See the full listing.</a></p>
<p style="text-align: center;"><span style="color: #236fa1;"><strong>JIM MCCONVILLE | SUPERYACHT BROKER | TEL +1 954.849.0855</strong></span></p>
<p style="text-align: center;"> </p>
<hr />
<p> </p>
<h3><span style="color: #236fa1;"><strong>OTHER YACHTS AT THE SHOW</strong></span></h3>
<p><span style="color: #236fa1;"><strong><a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-2007-benetti-120"><img src="../../../../photos/articles/4-mamma-mia-sm.jpg" alt="Image 1442: " width="512" height="512" /></a> <a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-2012-ferretti-yachts-83"><img src="../../../../photos/articles/4-crystal-parrot-sm.jpg" alt="Image 1444: " width="512" height="512" /></a> <a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-2017-pershing-82"><img src="../../../../photos/articles/4-double-or-nothing.jpg" alt="Image 1445: " width="512" height="512" /></a> <a href="../../../../yachting-news/2022-fort-lauderdale-boat-show-2021-riva-76-bahamas"><img src="../../../../photos/articles/4-baby-pearl-sm.jpg" alt="Image 1446: " width="512" height="512" /></a></strong></span></p> |
2003 CRESCENT 121 - JOANS ARK |
2022-10-18 17:19:28.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 Joan’s Ark - 2003 CRESCENT 121’ - $6,495,000 |
2022 FORT LAUDERDALE BOAT SHOW 2003 CRESCENT 120 |
1.0 |
2022 FORT LAUDERDALE BOAT SHOW Joan’s Ark - 2003 CRESCENT 120’ - $6,495,000 |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW 2003 CRESCENT 120 |
website |
https://www.alliedmarine.com |
[empty string] |
4-joansark-hero.jpg |
4-joansark-hero.jpg,4-mamma-mia-sm.jpg,4-double-or-nothing.jpg,4-crystal-parrot-sm.jpg,4-baby-pearl-sm.jpg,req-info-button-3.jpg,jim-mcconville-bttn.jpg |
2022-10-11 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW Joan’s Ark - 2003 CRESCENT 120’ - $6,495,000 |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW 2003 CRESCENT 120 |
yachting-news |
2022-fort-lauderdale-boat-show-2003-crescent-120 |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/2022-fort-lauderdale-boat-show-2003-crescent-120 |
0 |
[empty string] |
[empty string] |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW Joan’s Ark - 2003 CRESCENT 120’ - $6,495,000 |
[empty string] |
[empty string] |
[empty string] |
2022 FORT LAUDERDALE BOAT SHOW 2003 CRESCENT 120 |
[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-2003-crescent-120'
ORDER BY postedDate desc |