Espresso Design Limited

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343698,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.espressodesign.co.uk/",
      "title": "Espresso Design Limited",
      "description": "We are Espresso Design, an award-winning interior solutions company specializing in luxury kitchens, bedrooms, and living spaces. Based in London, our showrooms in Wandsworth and Chelsea Harbour showcase bespoke designs tailored to your unique lifestyle.At Espresso Design, we excel in creating stunning and functional kitchens by partnering with leading Italian manufacturers. This collaboration gives us access to the latest designs, finishes, and cutting-edge technology, ensuring your space is as stylish as it is practical.We take pride in managing every aspect of the design and installation process, offering you exceptional choices, outstanding design, and brilliant customer serviceall within your agreed budget.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94393,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-12T00: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": 476,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "78212f0a-ff24-11ef-a909-b66e99367f32",
      "subdate": "Mar 12, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 28
   },
   "visits": {
      "storefront": 28,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-12 09:29:17"
   },
   "location": {
      "uuid": "78212f0a-ff24-11ef-a909-b66e99367f32",
      "link_id": 343698,
      "account_id": 94393,
      "company": "Espresso Design Limited",
      "sid": 6,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "476",
      "zip": "SW11 1TQ",
      "address": "149 St. John''s Hill, London, SW11 1TQ",
      "phone": "02070789912",
      "fax": null,
      "email": "mazno131@mhmazno.com",
      "name": "Espresso Design Limited",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.460261",
      "lon": "-0.1764916",
      "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": ""
}