Studio Alliance

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349008,
      "site_id": 6,
      "cat_id": 39,
      "priority": 0,
      "url": "https://www.studio-alliance.com/",
      "title": "Studio Alliance",
      "description": "Our members provide a range of services including workplace consultancy, architectural and interior design, fit out and furnishing of commercial offices. They share best practice, knowledge, experiences and the occasional bottle of wine! Clients include international end user occupiers, co-working operators, asset managers and real estate advisors; all of whom benefit from our members international vision and local expertise.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99702,
      "approve_dt": "2025-07-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 158,
      "countrycode": "IE",
      "loc_id": 158,
      "state_id": 0,
      "city_id": 0,
      "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": 261,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7f15753b-4f44-11f0-a909-b66e99367f32",
      "subdate": "Jun 22, 2025",
      "subcategory": "Consultants",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Studio Alliance is a global network of commercial office design and fit-out specialists created to provide international clients with continuity of supply, seamless communication, and guaranteed quality across different countries and cultures. Their members combine international vision with local expertise to serve end user occupiers, co-working operators, asset managers, and real estate advisors through shared best practices and collaborative knowledge exchange.",
      "service1": "workplace consultancy",
      "service2": " architectural design",
      "service3": " interior design",
      "service4": " commercial office fit-out",
      "service5": " office furnishing",
      "service6": " international project coordination",
      "service7": " real estate advisory services",
      "submit_dt": "2025-06-22 08:40:05"
   },
   "location": {
      "uuid": "7f15753b-4f44-11f0-a909-b66e99367f32",
      "link_id": 349008,
      "account_id": 99702,
      "company": "Studio Alliance ",
      "sid": 6,
      "country": 158,
      "countrycode": "IE",
      "state": 0,
      "city": "0",
      "zip": "D15 F896",
      "address": "Ballycoolen, Dublin",
      "phone": "+35316274222",
      "fax": null,
      "email": "studioalliance@brite-mail.com",
      "name": "Studio Alliance",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "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": ""
}