{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 337065,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "https://drainrooteredmonton.ca/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 87796,
"approve_dt": null,
"source": null,
"submit_dt": "2024-10-21T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 13,
"referrals": null,
"country": 99,
"countrycode": "CA",
"loc_id": 99,
"state_id": 0,
"city_id": 155,
"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": 4974,
"d_url": null,
"approved": null,
"logo_ext": "png",
"screen_ext": "png",
"pack_id": null,
"uuid": "5e1b6cd9-8f89-11ef-ab46-b66e99367f32",
"subdate": "Oct 21, 2024",
"subcategory": "Plumbing",
"request_types": "",
"visitcount": 35
},
"visits": {
"storefront": 35,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 2,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Drain-Rooter Edmonton offers expert plumbing, sewer, and drain cleaning services for residential and commercial clients. Specializing in trenchless sewer replacement, repair, camera inspections, and high-pressure water jetting, we aim to be your go-to Family Plumber.' Our 24/7 emergency services cover clogged drains, toilets, sinks, and more. With competitive rates and quality work, we're ready to help when you need it. Schedule a service today, and a plumber will be there when you need them.",
"service1": "Drain Cleaning",
"service2": "Sewer Line Replacement",
"service3": "Plumbing",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2024-10-21 08:49:22"
},
"location": {
"uuid": "5e1b6cd9-8f89-11ef-ab46-b66e99367f32",
"link_id": 337065,
"account_id": 87796,
"company": "Drain Rooter Edmonton",
"sid": 66,
"country": 99,
"countrycode": "CA",
"state": 0,
"city": "155",
"zip": "T5J 3S9",
"address": "Service Area",
"phone": "(780) 257-1110",
"fax": null,
"email": "drainrooteredm@brite-email.com",
"name": "Drain Rooter Edmonton",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "53.5406943",
"lon": "-113.5042034",
"cityname": "Edmonton",
"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
