William Bain & Sons Ltd

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321792,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.william-bain.co.uk/",
      "title": "William Bain & Sons Ltd",
      "description": "William Bain & Sons is a plastering company based in Edinburgh. Our experienced plasterers have been providing plastering services in Lothian areas for over 70 years. We are a third-generation family business that has a great reputation and we strive to make sure we go above and beyond on every project.We offer all types of plastering services from exterior roughcasting to interior cornice repairs, damp proofing, and plaster skimming.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72968,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-02-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 469,
      "ltop": "",
      "facebook": "https://www.facebook.com/pages/category/Contractor/William-Bain-Sons-Ltd-224817414218291/",
      "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": 2512,
      "subcat_id": 5873,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95870a73-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 24, 2022",
      "subcategory": "Masonry Contractors",
      "request_types": "",
      "visitcount": 10
   },
   "visits": {
      "storefront": 10,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "William Bain&Sons is a plastering company based in Edinburgh. Our experienced plasterers have been providing plastering services in Lothian areas for over 70 years. We are a third-generation family business that has a great reputation and we strive to make sure we go above and beyond on every project.We offer all types of plastering services from exterior roughcasting to interior cornice repairs, damp proofing, and plaster skimming.",
      "service1": "plastering",
      "service2": "plaster skimming",
      "service3": "roughcasting",
      "service4": "harling",
      "service5": "damp proofing",
      "service6": "plaster repairs",
      "service7": "",
      "submit_dt": "2022-02-24 14:03:24"
   },
   "location": {
      "uuid": "95870a73-56da-11ed-b77c-b66e99367f32",
      "link_id": 321792,
      "account_id": 72968,
      "company": "William Bain & Sons Ltd",
      "sid": 76,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "469",
      "zip": "EH6 5PB",
      "address": "36-38 West Bowling Green Street",
      "phone": "0131 555 2009",
      "fax": null,
      "email": "marketing@william-bain.co.uk",
      "name": "William Bain & Sons Ltd",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "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": ""
}