Scott Findlay

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318759,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.scottfindlay.co.uk/",
      "title": "Scott Findlay ",
      "description": "Scott Findlay is a local, long established family firm which prides itself on offering high quality, friendly, reliable service throughout Edinburgh.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69953,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-03-19T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 173,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 469,
      "ltop": "",
      "facebook": "https://www.facebook.com/scottfindlayplumbingandheating/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/scottfindlayplumbingandheating/",
      "twitter": "https://twitter.com/scott_findlayph",
      "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": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95771096-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 19, 2020",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 228
   },
   "visits": {
      "storefront": 228,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Scott Findlay we pride ourselves on being Edinburghu2019s most trusted plumbing & heating engineers.\r\n\r\nA family business with over 30 years serving Edinburgh, weu2019re often recommended as the most reliable and professional, local central heating and plumbing company.\r\n\r\nFrom boiler repairs and servicing to central heating and plumbing works, our clients tell us that our experienced team of plumbing & heating engineers are courteous and knowledgeable, efficient and friendly.\r\n\r\nAs part of our commitment to customer service we offer convenient one hour appointment slots.\r\n\r\nIf youu2019re looking for specialists in boiler installation and central heating near you then youu2019ll find us modern plumbers with traditional values.\r\n",
      "service1": "boiler repairs",
      "service2": "new boilers",
      "service3": "boiler servicing",
      "service4": "gas engineers",
      "service5": "heating",
      "service6": "",
      "service7": "Plumbing",
      "submit_dt": "2020-03-19 14:02:22"
   },
   "location": {
      "uuid": "95771096-56da-11ed-b77c-b66e99367f32",
      "link_id": 318759,
      "account_id": 69953,
      "company": "Scott Findlay ",
      "sid": 66,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "469",
      "zip": "EH8 7AD",
      "address": "5-7 Wolseley Place",
      "phone": "0131 669 9993",
      "fax": null,
      "email": "marketing@scottfindlay.co.uk",
      "name": "Scott Findlay ",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "55.9550567",
      "lon": "-3.1503393",
      "cityname": "Edinburgh",
      "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": ""
}