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 |
2021-08-04 00:00:00.0 |
2021-08-04 00:00:00.0 |
199 |
[empty string] |
<p>Allied Marine announces the sale of TRIPLE NET, a 2001 92' Monte Fino motoryacht in Bridgeport, Connecticut. Allied Marine Broker <a title="Broker Page" href="../../../../our-team/yacht-broker-Jim-McConville/28">Jim McConville</a> represented the seller.</p>
<p>TRIPLE NET just completed a Major refit with the seller spending close to $1,000,000. Almost every area of the vessel was transformed into a showpiece, updated, redesigned and turn key ready to cruise. </p>
<p>TRIPLE NET is roomy and versatile, featuring four guest staterooms, a spacious flybridge with a hard top, full walk-around decks, a large aft deck and a sizable swim platform. The vessel's open interior layout combines the vintage charm of high-gloss wood finish with the luxurious comfort of a contemporary motoryacht. The interior of the yacht has an elegant, comfortable clubhouse décor which is finished in high-gloss Cherry wood.</p>
<p>From the swim platform, there is access to the lazarette which features storage for the boat's gear and tools, as well as a day head. The swim platform has a shower hose with hot and cold water. Two stairwells on either side of the swim platform ascend to a spacious aft deck designed for relaxation and entertaining. The sliding door opens into the relaxed and casual main salon. On the starboard side of the salon, a spiral staircase provides access to the lower deck foyer.</p>
<p>The accommodations aboard this family-friendly vessel are versatile enough to host a number of people in several clever combinations. From the lower-deck foyer, the full beam master stateroom is situated amidships with an ensuite head featuring both a tub and shower. Forward of the master are two substantial twin staterooms with ensuite baths with showers - each of these twin staterooms offer the flexibility of being reconfigured as oversized Queens and both have an additional Pullman berth to accommodate extra guests. The forward VIP stateroom is comfortable and spacious, with a queen bed and a well-appointed ensuite bath with shower.</p>
<p>Via a broad hallway on the starboard side of the main salon are the adjoining gourmet galley, a morning dining banquet, and pilothouse which share the panoramic view. Crew quarters are accessed through a separate stairwell forward of the pilothouse, where three crew are accommodated in two staterooms.</p> |
Monte Fino 92' Sold |
2021-08-04 16:01:30.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 TRIPLE NET. |
Monte Fino 92 Sold |
1.0 |
Allied Marine announces the sale of TRIPLE NET. |
[empty string] |
Monte Fino 92 Sold |
website |
https://www.alliedmarine.com |
[empty string] |
triple-net.jpg |
triple-net.jpg |
2021-07-07 10:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Allied Marine announces the sale of TRIPLE NET. |
[empty string] |
Monte Fino 92 Sold |
yachting-news |
monte-fino-92-sold |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/monte-fino-92-sold |
28 |
[empty string] |
[empty string] |
[empty string] |
Allied Marine announces the sale of TRIPLE NET. |
[empty string] |
[empty string] |
[empty string] |
Monte Fino 92 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 = 'monte-fino-92-sold'
ORDER BY postedDate desc |