Constantine Scotland

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334133,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.constantinescotland.co.uk/",
      "title": "Constantine Scotland",
      "description": "Constantine Scotland is your trusted partner for fine art logistics and storage, as well as international, premium home, and commercial removals. We offer specialised commercial removal services for a diverse range of businesses, including laboratories, libraries, offices, IT departments, schools, and universities. Our nationwide and international removal services can take you anywhere in the world. Additionally, we collaborate closely with the nation''s leading museums, galleries, and private collectors to provide expert storage and removal solutions for fine art.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84890,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-13T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 2,
      "referrals": null,
      "country": 265,
      "countrycode": "GB",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 470,
      "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": 248,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f5657b6b-598a-11ef-ab46-b66e99367f32",
      "subdate": "Aug 13, 2024",
      "subcategory": "Shipping & Trucking",
      "request_types": "",
      "visitcount": 22
   },
   "visits": {
      "storefront": 22,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 31,
      "social": 14,
      "services": 15,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Constantine Scotland is your trusted partner for fine art logistics and storage, as well as international, premium home, and commercial removals. We offer specialised commercial removal services for a diverse range of businesses, including laboratories, libraries, offices, IT departments, schools, and universities. Our nationwide and international removal services can take you anywhere in the world. Additionally, we collaborate closely with the nation's leading museums, galleries, and private collectors to provide expert storage and removal solutions for fine art.\r
",
      "service1": "international removals",
      "service2": "commercial removals",
      "service3": "premium home removals",
      "service4": "fine art logistics",
      "service5": "fine art storage",
      "service6": "moving services",
      "service7": "office removals",
      "submit_dt": "2024-08-13 15:44:43"
   },
   "location": {
      "uuid": "f5657b6b-598a-11ef-ab46-b66e99367f32",
      "link_id": 334133,
      "account_id": 84890,
      "company": "Constantine Scotland",
      "sid": 6,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "470",
      "zip": "ML5 4EF",
      "address": "North Caldeen Road, Coatbridge",
      "phone": "01236750055",
      "fax": null,
      "email": "marketingconstantinescotland@gmail.com",
      "name": "Constantine Scotland",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "55.856001",
      "lon": "-4.0129572",
      "cityname": "Glasgow",
      "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": 1
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 1
      },
      {
         "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": {
      "pid": 991,
      "link_id": 334133,
      "product_title": "International Removal Services",
      "product_description": "At Constantine Scotland, we understand that moving abroad can be daunting. We offer a full suite of international moving services designed to make your relocation as smooth and stress-free as possible. From our initial consultation to customs clearance and beyond, we will take care of every detail.\r\n\r\nOur service covers a range of destinations from Scotland, including European removals to France, Spain, Germany, the Netherlands, and Belgium, Australia and New Zealand removals, removals to the USA, and the rest of the world, including Canada, Dubai, and South Africa.",
      "product_link": "https://www.constantinescotland.co.uk/international-removals/",
      "image_name": "",
      "extension": "jpeg",
      "status": null,
      "subcat_id": 6129,
      "product_price": "",
      "click_count": null,
      "keywords": null,
      "view_count": 47,
      "pdate": "2024-08-29T00:00:00.000Z",
      "post_status": 1
   }
}