{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 346077,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://mehtamcconnell.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 96772,
"approve_dt": null,
"source": null,
"submit_dt": "2025-04-29T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 1,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 32,
"city_id": 15779,
"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": 233,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "b4147c77-24bd-11f0-a909-b66e99367f32",
"subdate": "Apr 29, 2025",
"subcategory": "Attorneys",
"request_types": "",
"visitcount": 18
},
"visits": {
"storefront": 18,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 6,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "We may be a new firm, but we have over 30 years of combined legal experience. When you hire the Charlotte workers' compensation and personal injury lawyers at Mehta & McConnell, you will be working directly with North Carolina State Bar board-certified workers' compensation attorneys. Our team of North Carolina workers' comp attorneys has combined legal experience handling complex and simple cases. Contact our workers' comp and personal injury lawyers at Mehta & McConnell, PLLC today.",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-04-29 05:49:23"
},
"location": {
"uuid": "b4147c77-24bd-11f0-a909-b66e99367f32",
"link_id": 346077,
"account_id": 96772,
"company": "Mehta & McConnell, PLLC",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 32,
"city": "15779",
"zip": "28203",
"address": "2201 South Blvd., Suite 410",
"phone": "980-326-2270",
"fax": null,
"email": "mehtamcconnellpllc@brite-email.com",
"name": "Mehta & McConnell, PLLC",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "35.2066384",
"lon": "-80.8610415",
"cityname": "Charlotte",
"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
