{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 338582,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "https://thedraindoctorcovina.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 89295,
"approve_dt": null,
"source": null,
"submit_dt": "2024-12-02T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 5,
"city_id": 1825,
"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": "6b2bd8a9-b06e-11ef-a909-b66e99367f32",
"subdate": "Dec 02, 2024",
"subcategory": "Plumbers",
"request_types": "",
"visitcount": 11
},
"visits": {
"storefront": 11,
"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": "Welcome to Drain Doctor Plumbing & Rooter, your premier plumber in Covina, CA, proudly serving since 1996. As a trusted family-owned business, we prioritize delivering top-notch services. Specializing in drain cleaning, sewer line repair, tankless water heater maintenance, and emergency plumbing, we ensure accurate estimates and transparent processes. Customer satisfaction is paramount, offering flexible financing, senior discounts, and PHCC membership. Call us today!",
"service1": "Drain services",
"service2": "Water heater installation",
"service3": "drain cleaning",
"service4": "sewer repair",
"service5": "Pipe repair",
"service6": "",
"service7": "",
"submit_dt": "2024-12-02 05:29:36"
},
"location": {
"uuid": "6b2bd8a9-b06e-11ef-a909-b66e99367f32",
"link_id": 338582,
"account_id": 89295,
"company": "Drain Doctor Plumbing & Rooter Service",
"sid": 66,
"country": 277,
"countrycode": "US",
"state": 5,
"city": "1825",
"zip": "91722",
"address": "527 N Azusa Ave, #354",
"phone": "626-323-9960",
"fax": null,
"email": "thedraindoctorcovina@mail-burst.com",
"name": "Drain Doctor Plumbing & Rooter Service",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "34.0898214",
"lon": "-117.9088807",
"cityname": "Covina",
"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
