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 |
Allan Leshchinsky |
News |
2019-05-22 00:00:00.0 |
2019-05-22 00:00:00.0 |
56 |
[empty string] |
<h3>The Experience</h3>
<p>When it comes to choosing a boat, or a yacht brand, you should ask yourself, "What is my ideal experience?" Are you looking for someplace to spend a few weeks, a weekend, or do you just want a cool new toy to take to lunch on summer days? Longer trips require a little more space, and a little more storage. You may want several outdoor seating options for your guests to gather, tables with shade, or sunpads open to the sky. Location of the galley is important to certain buyers - do you like to help yourself in the kitchen when that Nutella craving hits or would you prefer personalized service and walk around decks.</p>
<h3>Personal Taste</h3>
<p>Another factor is your own personal taste and how much attention you're comfortable with. Do you like to turn heads and get a "I have to have that" reaction out of people? If so, consider <a title="Riva Yachts for Sale" href="../../../../new-yachts-for-sale/riva-yachts-for-sale">Riva</a> and <a title="Pershing Yachts for Sale" href="../../../../new-yachts-for-sale/pershing-yachts-for-sale">Pershing</a> for performance, style and speed. Alternatively, if you love to spend time onboard relaxing, the model that will make you comfortable and feel most at home is <a title="Ferretti Yachts for Sale" href="../../../../new-yachts-for-sale/ferretti-yachts-for-sale">Ferretti Yachts</a>. The Ferretti Yachts brand makes a line of fantastic boats that your family will enjoy. Ordering a brand new product allows a client to create their own color scheme and select their own finishings and soft goods. There are also the <a title="Itama Yachts for Sale" href="../../../../new-yachts-for-sale/itama-yachts-for-sale">Itama</a> brands to explore ...</p>
<h3>Practicality</h3>
<p>Practicality is another important aspect. Do you have kids and want a yacht with higher side railings? Are the ceilings and door frames tall enough for you? <a title="Custom Line Yachts for Sale" href="../../../../new-yachts-for-sale/custom-line-yachts-for-sale">Custom Line</a> is a division owned by Ferretti Group that produces larger customizable yachts, and Allied Marine is proud to be an authorized dealer. It's the choice Ferretti Group brand - allowing you to add custom features such as a jacuzzi tub, elevator, or gym area. Yachts longer than 50 meters (164 feet) are a specialty of <a title="CRN Yachts for Sale" href="../../../../new-yachts-for-sale/crn-yachts-for-sale">CRN</a>. Each CRN yacht is a complete custom build, made entirely to suit its buyer. These vessels frequently offer beach clubs, spas, helicopter pads, or swimming pools; they are unique in every way.</p>
<h3>Budget</h3>
<p>Finally, what is your budget? There is no point spending time researching available boats for sale that cost more than you can or are willing to spend. Allied Marine's professional <a href="../../../../our-team">yacht brokers </a>are experienced and trained to deal with a variety of clients and requests. You will always receive the best service and tailored advice from your broker when you can be as specific as possible regarding what you're looking for in a yacht.</p>
<p>Article courtesy of our <a title="Sag Harbor Yacht Sales and Charter Team" href="../../../../our-offices/yachts-for-sale-in-Sag-Harbor-New-York/">Sag Harbor team</a>:</p>
<div class="col-sm-6 col-md-8 col-lg-8">
<div class="row">
<div class="col-12 col-lg-6">
<div class="card w-100 text-center">
<div class="img-background"> </div>
<a href="../../../../our-team/yacht-broker-Eric-Frank/14"> <img class="img-fluid" src="../../../../photos/brokers/14_1.jpg" alt="Sag Harbor Yacht Sales" width="200" height="200" /> </a>
<div class="card-body">
<div class="am-swash"><img src="../../../../assets/images/am-icon-blue.svg" alt="Allied Marine Logo" width="30" /></div>
<h6 class="card-title">Eric Frank</h6>
<p class="card-text">Yacht Broker</p>
<p class="phone"><a href="../../../../our-team/yacht-broker-Eric-Frank/14"> <img src="../../../../assets/images/cell-circle.svg" alt="mobile phone" width="25" /></a>+1 954.600.0369</p>
</div>
</div>
</div>
<div class="col-12 col-lg-6">
<div class="card w-100 text-center">
<div class="img-background"> </div>
<a href="../../../../our-team/yacht-broker-Jessica-Frank/45"> <img class="img-fluid" src="../../../../photos/brokers/45_1.jpg" alt="Sag Harbor Yacht Sales" width="200" height="200" /> </a>
<div class="card-body">
<div class="am-swash"><img src="../../../../assets/images/am-icon-blue.svg" alt="Allied Marine Logo" width="30" /></div>
<h6 class="card-title">Jessica Frank</h6>
<p class="card-text">Charter Broker</p>
<p class="phone"><a href="../../../../our-team/yacht-broker-Jessica-Frank/45"> <img src="../../../../assets/images/cell-circle.svg" alt="mobile phone" width="25" /></a>+1 954.439.2280</p>
</div>
</div>
</div>
<div class="col-12"> </div>
</div>
</div> |
4 Factors to Choosing a Ferretti Group Brand |
2021-04-20 10:23:14.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 |
Learn what to consider when choosing a Ferretti Group yacht brand. Find a yacht brand based on your experience, personal taste, practicality and budget. |
4 Aspects to Choosing a Ferretti Group Brand |
1.0 |
Learn what to consider when choosing one of our yacht brands. |
|
4 Aspects to Choosing a Ferretti Group Brand |
website |
https://www.alliedmarine.com |
[empty string] |
riva-yacht-fleet-running-on-sea1.jpg |
riva-yacht-fleet-running-on-sea1.jpg |
2019-05-27 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Learn what to consider when choosing one of our yacht brands. |
|
4 Aspects to Choosing a Ferretti Group Brand |
yachting-news |
4-aspects-to-choosing-a-ferretti-group-brand |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/4-aspects-to-choosing-a-ferretti-group-brand |
0 |
[empty string] |
[empty string] |
summary |
Learn what to consider when choosing one of our yacht brands. |
|
|
|
4 Aspects to Choosing a Ferretti Group Brand |
[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 = '4-aspects-to-choosing-a-ferretti-group-brand'
ORDER BY postedDate desc |