{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 330966,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "https://seweranddrainchampion.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 81767,
"approve_dt": "2025-12-23T00:00:00.000Z",
"source": null,
"submit_dt": "2024-05-20T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 15,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 5,
"city_id": 2416,
"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": {
"type": "Buffer",
"data": [
49
]
},
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "0f52234a-1663-11ef-8344-b66e99367f32",
"subdate": "May 20, 2024",
"subcategory": "Plumbers",
"request_types": "",
"visitcount": 49
},
"visits": {
"storefront": 49,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 1,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Hello, I'm Dillon and I've been in the plumbing industry for over a decade. After working for top companies in Sacramento, I decided to start my own company to deliver exceptional plumbing services at a reasonable price. Our focus is on quality work and ensuring customer satisfaction. We specialize in drain cleaning, sewer repair and replacement, water repiping, and more. No job is too big or small for our certified team to handle. Give us a call for all your plumbing needs!",
"service1": "Drain Cleaning",
"service2": "Hydro Jetting",
"service3": "Drain Repair",
"service4": "Clogged Sewer Line",
"service5": "Clogged Kitchen Sink",
"service6": "",
"service7": "",
"submit_dt": "2024-05-20 04:40:28"
},
"location": {
"uuid": "0f52234a-1663-11ef-8344-b66e99367f32",
"link_id": 330966,
"account_id": 81767,
"company": "Sewer & Drain Champion",
"sid": 66,
"country": 277,
"countrycode": "US",
"state": 5,
"city": "2416",
"zip": "95677",
"address": "3640 Amethyst Drive",
"phone": "916-755-2147",
"fax": null,
"email": "sewerdrainchampion@burst-email.com",
"name": "Sewer & Drain Champion",
"status": "show",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "38.7893353",
"lon": "-121.2602501",
"cityname": "Rocklin",
"statename": "California"
},
"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
