https://a2solicitors.co.uk/

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330306,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://a2solicitors.co.uk/",
      "title": "https://a2solicitors.co.uk/",
      "description": "Established since 1954, Andrew & Andrew have been providing a high quality, professional and reliable service across the nation for over 60 years.We are well known and well respected within Hampshire, Portsmouth and surrounding areas, as well as successfully assisting clients throughout the United Kingdom.We pride ourselves on our friendly and supportive approach to our clients. Our dedicated and varied team will always provide you with the best advice to suit your circumstances.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81115,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 24,
      "referrals": null,
      "country": 265,
      "countrycode": "UK",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 476,
      "ltop": "",
      "facebook": "https://www.facebook.com/A2LawSolicitors/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/andrew-and-andrew-solicitors/",
      "twitter": "https://twitter.com/A2Law",
      "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": 2172,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "37361c28-05cb-11ef-8344-b66e99367f32",
      "subdate": "Apr 29, 2024",
      "subcategory": "Attorney Legal Services",
      "request_types": "",
      "visitcount": 115
   },
   "visits": {
      "storefront": 115,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Established since 1954, Andrew&Andrew have been providing a high quality, professional and reliable service across the nation for over 60 years.\r
\r
We are well known and well respected within Hampshire, Portsmouth and surrounding areas, as well as successfully assisting clients throughout the United Kingdom.\r
\r
We pride ourselves on our friendly and supportive approach to our clients. Our dedicated and varied team will always provide you with the best advice to suit your circumstances.",
      "service1": "Wills, Probate & Trusts",
      "service2": "Personal Injury",
      "service3": "Contentious Probate",
      "service4": "Conveyancing",
      "service5": "Solicitors",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-29 01:53:04"
   },
   "location": {
      "uuid": "37361c28-05cb-11ef-8344-b66e99367f32",
      "link_id": 330306,
      "account_id": 81115,
      "company": "Andrew & Andrew Solicitors Portsmouth",
      "sid": 37,
      "country": 265,
      "countrycode": "UK",
      "state": 0,
      "city": "476",
      "zip": "PO2 8AL",
      "address": "114 Kingston Crescent",
      "phone": "+44 23 9267 5555",
      "fax": null,
      "email": "asolicitorshp@mail-burst.com",
      "name": "Andrew & Andrew Solicitors Portsmouth",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "50.8128322",
      "lon": "-1.0802277",
      "cityname": "London",
      "statename": ""
   },
   "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": ""
}