{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 337022,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "http://www.tcrplumbing.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 87753,
"approve_dt": null,
"source": null,
"submit_dt": "2024-10-20T00: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": 32,
"city_id": 16128,
"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": 4993,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "43484f0e-8eea-11ef-ab46-b66e99367f32",
"subdate": "Oct 20, 2024",
"subcategory": "Plumbing Service",
"request_types": "",
"visitcount": 23
},
"visits": {
"storefront": 23,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 10,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "TCR Rooter & Plumbing has been providing Residential & Commercial plumbing services in Raleigh, NC since 1993. Your satisfaction is our goal. With our skilled team of certified, professional plumbers, we work to provide you with smart, satisfactory work for all your plumbing needs. New construction, remodels, leak repairs, sewer and water line replacements, water heaters, and any and all other service needs or emergencies you may have, we have your back.",
"service1": "Water Heater Installation",
"service2": "Water Heater Repair",
"service3": "Tankless Water Heaters",
"service4": "Septic Systems",
"service5": "Polybutylene Pipe Replacement",
"service6": "",
"service7": "",
"submit_dt": "2024-10-20 13:50:27"
},
"location": {
"uuid": "43484f0e-8eea-11ef-ab46-b66e99367f32",
"link_id": 337022,
"account_id": 87753,
"company": "TCR Rooter & Plumbing LLC",
"sid": 66,
"country": 277,
"countrycode": "US",
"state": 32,
"city": "16128",
"zip": "27616",
"address": "5020 Departure Dr., Ste. J",
"phone": "+1 919-467-2207",
"fax": null,
"email": "tcrplumbing@brite-post.com",
"name": "TCR Rooter & Plumbing LLC",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "35.8506274",
"lon": "-78.5954004",
"cityname": "Raleigh",
"statename": "North Carolina"
},
"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
