{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 337473,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "https://callyellowsub.ca/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 88202,
"approve_dt": null,
"source": null,
"submit_dt": "2024-10-30T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 6,
"referrals": null,
"country": 99,
"countrycode": "CA",
"loc_id": 99,
"state_id": 0,
"city_id": 1323,
"ltop": "",
"facebook": "",
"tiktok": null,
"linkedin": "",
"twitter": "",
"googleplus": "",
"youtube_channel": null,
"youtube": "",
"youtube_title": null,
"pinterest": "",
"yelp": "",
"foursquare": "",
"instagram": "",
"tripadvisor": null,
"trustpilot": null,
"blog_link": null,
"ss_exchange": 0,
"googlebot": null,
"yahoobot": null,
"msnbot": null,
"author_id": null,
"subcat_id": 5026,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "bfeb3a51-965f-11ef-ab46-b66e99367f32",
"subdate": "Oct 30, 2024",
"subcategory": "Plumbers",
"request_types": "",
"visitcount": 33
},
"visits": {
"storefront": 33,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 4,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Yellow Submarine Plumbing & Rooter has been serving Nanaimo and the surrounding areas since 2019, providing top-notch residential and commercial plumbing services. Our team of licensed plumbers is equipped to handle any plumbing repair or routine maintenance you may need. From leaky pipes to clogged drains, we've got you covered! Contact us today to schedule an appointment and experience our exceptional service firsthand.",
"service1": "Plumbing Services",
"service2": "Drain Cleaning",
"service3": "Water Heater Services",
"service4": "Sewer Services",
"service5": "Bathroom/Kitchen Services",
"service6": "",
"service7": "",
"submit_dt": "2024-10-30 01:39:05"
},
"location": {
"uuid": "bfeb3a51-965f-11ef-ab46-b66e99367f32",
"link_id": 337473,
"account_id": 88202,
"company": "Yellow Submarine Plumbing & Rooter Ltd.",
"sid": 66,
"country": 99,
"countrycode": "CA",
"state": 0,
"city": "1323",
"zip": "V9S 2N8",
"address": "1020 Thunderbird Drive, Nanaimo",
"phone": "+1 778-601-8442",
"fax": null,
"email": "callyellowsub@burst-email.com",
"name": "Yellow Submarine Plumbing & Rooter Ltd.",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "49.1863112",
"lon": "-123.9731102",
"cityname": "British Columbia",
"statename": ""
},
"socialmedia": [
{
"title": "Facebook",
"ptype_id": 29,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Instagram",
"ptype_id": 30,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Youtube",
"ptype_id": 31,
"dbtable": "links_socialmedia",
"item": "Youtube Video",
"cnt": null
},
{
"title": "LinkedIn",
"ptype_id": 32,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "TikTok",
"ptype_id": 33,
"dbtable": "links_socialmedia",
"item": "Videos",
"cnt": null
},
{
"title": "Twitter",
"ptype_id": 34,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Reddit",
"ptype_id": 37,
"dbtable": "links_socialmedia",
"item": "Reddit",
"cnt": null
},
{
"title": "SnapChat",
"ptype_id": 38,
"dbtable": "links_socialmedia",
"item": "SnapChat",
"cnt": null
}
],
"promos": [
{
"item": "article",
"cnt": 0
},
{
"item": "video",
"cnt": 0
},
{
"item": "product",
"cnt": 0
},
{
"item": "coupon",
"cnt": 0
},
{
"item": "service",
"cnt": 0
},
{
"item": "article_external",
"cnt": 0
},
{
"item": "video_external",
"cnt": 0
},
{
"item": "product_external",
"cnt": 0
},
{
"item": "coupon_external",
"cnt": 0
},
{
"item": "service_external",
"cnt": 0
}
],
"featuredproduct": ""
}
all our featured social media
