haart Estate & Lettings Agents Colchester

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 339684,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://www.haart.co.uk/branch-finder/colchester-estate-agents/",
      "title": "haart Estate & Lettings Agents Colchester",
      "description": "At haart Colchester, 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": 90391,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-24T00: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": "ec16cb96-c1c7-11ef-a909-b66e99367f32",
      "subdate": "Dec 24, 2024",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 22
   },
   "visits": {
      "storefront": 22,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "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-24 07:23:07"
   },
   "location": {
      "uuid": "ec16cb96-c1c7-11ef-a909-b66e99367f32",
      "link_id": 339684,
      "account_id": 90391,
      "company": "haart Estate & Lettings Agents Colchester",
      "sid": 24,
      "country": 265,
      "countrycode": "GB",
      "state": 0,
      "city": "0",
      "zip": "",
      "address": "18-20 Head Street, Colchester, Essex, CO1 1NY",
      "phone": "01206 692353",
      "fax": null,
      "email": "haartestatecolchestr@brite-mail.com",
      "name": "haart Estate & Lettings Agents Colchester",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "51.8892407",
      "lon": "0.8964395",
      "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": ""
}