haart Estate & Lettings Agents Walthamstow

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 339760,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://www.haart.co.uk/branch-finder/walthamstow-estate-agents/",
      "title": "haart Estate & Lettings Agents Walthamstow",
      "description": "At haart Walthamstow, as part of the UK's largest independent estate agents, we help thousands of people buy, sell, let, or rent their homes through our network of over 100 branches. We offer a range of services, including financial & legal support, valuations, and more. As members of The Property Ombudsman, we're committed to providing top-quality customer service. Contact us today - we're available for a call until 10pm.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90467,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "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": 1433,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e3bd9a0b-c35a-11ef-a909-b66e99367f32",
      "subdate": "Dec 26, 2024",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 20
   },
   "visits": {
      "storefront": 20,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "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-12-26 07:27:40"
   },
   "location": {
      "uuid": "e3bd9a0b-c35a-11ef-a909-b66e99367f32",
      "link_id": 339760,
      "account_id": 90467,
      "company": "haart Estate & Lettings Agents Walthamstow",
      "sid": 24,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "0",
      "zip": "",
      "address": "143-145 Hoe Street, Walthamstow, Greater London, E17 3AL",
      "phone": "02045 128377",
      "fax": null,
      "email": "haartwalthamstow@burst-email.com",
      "name": "haart Estate & Lettings Agents Walthamstow",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.5847342",
      "lon": "-0.01929",
      "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": ""
}