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-20 00:00:00.0 |
2022-05-20 00:00:00.0 |
272 |
[empty string] |
<p>An industry classic, the Marine Trader 34 Double Cabin is the best-selling small trawler ever imported and sold in the U.S.</p>
<p><img src="../../../../photos/articles/photo-6553699-dji-99-jpg-5273073-0-2021729183640-photo-original.jpg" alt="Image 1307: " width="100%" height="auto" /></p>
<p>Built by CHB in Taiwan, there were other distributors besides Marine Trader and she may be recognized on the West Coast as the La Paz, Eagle, or CHB 34 DC. She enjoyed her best years during the 1970s when powerboats, with their big fuel-guzzling engines, were out of favor.</p>
<p><img src="../../../../photos/articles/20210729-184754.jpg" alt="Image 1302: " width="100%" height="auto" /></p>
<p>There were several updates to the 34 over the years. Prior to 1975, she was built with a plywood house and a fiberglass cloth overlay. Until 1985 the decks were teak-planked and fastened through the fiberglass to a balsa sub-deck—a constant source of deck leaks—and after 1985 the 34 was constructed of solid fiberglass.</p>
<p><img src="../../../../photos/articles/20210729-184857.jpg" alt="Image 1303: " width="100%" height="auto" /></p>
<p>The flybridge was revised in 1991, and the teak window frames were eliminated in 1992. Below decks, the all teak interior is arranged with small staterooms fore and aft, two heads, and a very practical passageway from the aft stateroom to the cockpit.</p>
<p><img src="../../../../photos/articles/20210729-185053.jpg" alt="Image 1305: " width="100%" height="auto" /></p>
<p>A lower helm was standard, and a sliding salon door provides easy access to the deck. No one will ever confuse the Marine Trader 34 with a Grand Banks when it comes to quality.</p>
<p>For additional information see the <a href="../../../../used-yachts-for-sale/1977-Marine-Trader-33-34-Sasha-2-yacht-for-sale/8003138_2">listing</a> or contact <a href="../../../../our-team/yacht-broker-Coltin-Radabaugh/61" target="_blank" rel="noopener">Coltin Radabaugh,</a> Yacht broker, Allied Marine Stuart, FL</p> |
JUST LISTED YACHT FOR SALE | SASHA 2 1977 MARINE TRADER 33.5' |
2022-05-20 10:45:05.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 SASHA 2 1977 MARINE TRADER 33.5' YACHT |
1.0 |
Brokerage Luxury Used Yacht for Sale |
[empty string] |
JUST LISTED YACHT FOR SALE SASHA 2 1977 MARINE TRADER 33.5' YACHT |
website |
https://www.alliedmarine.com |
[empty string] |
photo-6553706-dji-106-jpg-5502741-0-2021729183746-photo-original.jpg |
photo-6553706-dji-106-jpg-5502741-0-2021729183746-photo-original.jpg,photo-6553699-dji-99-jpg-5273073-0-2021729183640-photo-original.jpg,20210729-184754.jpg,20210729-184905.jpg,20210729-184857.jpg,20210729-184643.jpg,20210729-184659.jpg,20210729-185111.jpg,20210729-185053.jpg |
2022-04-01 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Brokerage Luxury Used Yacht for Sale |
[empty string] |
JUST LISTED YACHT FOR SALE SASHA 2 1977 MARINE TRADER 33.5' YACHT |
yachting-news |
just-listed-yacht-for-sale-sasha-2-1977-marine-trader-335-yacht |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/just-listed-yacht-for-sale-sasha-2-1977-marine-trader-335-yacht |
61 |
[empty string] |
[empty string] |
[empty string] |
Brokerage Luxury Used Yacht for Sale |
[empty string] |
[empty string] |
[empty string] |
JUST LISTED YACHT FOR SALE SASHA 2 1977 MARINE TRADER 33.5' YACHT |
[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-sasha-2-1977-marine-trader-335-yacht'
ORDER BY postedDate desc |