Trey Harrell Auto Accident and Personal Injury Attorney

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327494,
      "site_id": 18,
      "cat_id": 69,
      "priority": 2,
      "url": "http://www.attorneyharrell.com/",
      "title": "Trey Harrell Auto Accident and Personal Injury Attorney",
      "description": "Trey Harrell is a former Federal Prosecutor with extensive experience as a Personal Injury Attorney and Auto Accident Attorney as well as the capabilities to handle any Estate Planning matter. Trey Harrell will patiently and professionally work with you and your family by giving each new case the attention it deserves and walking you through each step of the process.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78343,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-09T00: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": 39,
      "city_id": 20231,
      "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": 764,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ddfb947c-af4a-11ee-8344-b66e99367f32",
      "subdate": "Jan 09, 2024",
      "subcategory": "Personal Injury Attorney",
      "request_types": "",
      "visitcount": 63
   },
   "visits": {
      "storefront": 63,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-09 23:57:38"
   },
   "location": {
      "uuid": "ddfb947c-af4a-11ee-8344-b66e99367f32",
      "link_id": 327494,
      "account_id": 78343,
      "company": "",
      "sid": 18,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20231",
      "zip": "29407",
      "address": "2000 Sam Rittenberg Boulevard",
      "phone": "(843) 636-7980",
      "fax": null,
      "email": "attyharrellsc@brite-mail.com",
      "name": "Trey Harrell Auto Accident and Personal Injury Attorney",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.7948359",
      "lon": "-80.0289682",
      "cityname": "Charleston",
      "statename": "South 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": ""
}