Hayfield Animal Hospital

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314516,
      "site_id": 15,
      "cat_id": 33,
      "priority": 2,
      "url": "http://hayfieldanimalhospital.com/",
      "title": "Hayfield Animal Hospital",
      "description": "Hayfield Animal Hospital is one of the leading pet care clinic providing high quality  veterinary care and treatment for the pets in Alexandria, Virginia (VA) and the surrounding areas. Check out our website or contact us at 703-971-2127 for more information about our services!!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65743,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-02-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 133,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23152,
      "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": 564,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9560cb21-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 26, 2018",
      "subcategory": "Veterinarians",
      "request_types": "",
      "visitcount": 158
   },
   "visits": {
      "storefront": 158,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hayfield Animal Hospital is one of the leading pet care clinic providing high quality  veterinary care and treatment for the pets in Alexandria, Virginia (VA) and the surrounding areas. Check out our website or contact us at 703-971-2127 for more information about our services!!",
      "service1": "Pet Diagnostics",
      "service2": "Pet Medical Treatment",
      "service3": "Veterinary Care",
      "service4": "Pet Care",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-02-26 06:43:57"
   },
   "location": {
      "uuid": "9560cb21-56da-11ed-b77c-b66e99367f32",
      "link_id": 314516,
      "account_id": 65743,
      "company": "Hayfield Animal Hospital",
      "sid": 15,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23152",
      "zip": "22315",
      "address": "7724 Telegraph Road",
      "phone": "",
      "fax": null,
      "email": "hayfieldanimalhospital0@gmail.com",
      "name": "Hayfield Animal Hospital",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.7476932",
      "lon": "-77.1450843",
      "cityname": "Alexandria",
      "statename": "Virginia"
   },
   "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": ""
}