Red Box London

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338231,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.redboxlondon.com/",
      "title": "Red Box London",
      "description": "We specialise in home improvements, extensions, kitchen fitting and bathrooms as well as the associated services of plumbing, electrical and full decoration work.Our team work closely with architects and designers, either engaged by us or which you may have already engaged. We are happy to follow your design or work with you on a design to fit your budget and taste.We can undertake major and minor structural work to improve the layout and flow of your home. In addition, we offer an ongoing maintenance and repair services to residential and commercial properties and customers.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88950,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-11-25T00: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": 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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1102ac7e-ab0a-11ef-a909-b66e99367f32",
      "subdate": "Nov 25, 2024",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 7
   },
   "visits": {
      "storefront": 7,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-11-25 08:48:39"
   },
   "location": {
      "uuid": "1102ac7e-ab0a-11ef-a909-b66e99367f32",
      "link_id": 338231,
      "account_id": 88950,
      "company": "Red Box London",
      "sid": 6,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "0",
      "zip": "SW6 3PA",
      "address": "Ranelagh Gardens, Fulham, London SW6 3PA",
      "phone": "02073811539",
      "fax": null,
      "email": "mazno128@mhmazno.com",
      "name": "Red Box London",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.4676487",
      "lon": "-0.2079718",
      "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": ""
}