Ester Electrical

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338697,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://www.ester.co.nz/",
      "title": "Ester Electrical",
      "description": "At Ester Electrical we work on a wide range of commercial, civil and residential projects through our various divisions. Our scale and resources ensure we will deliver your project safely, within time and on budget. Our project management team and quality control systems allow us to deliver an exceptional finish. We value close communication with our clients on and off the job, offering efficiency and cost-saving options at every stage of your project.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 89408,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 200,
      "countrycode": "NZ",
      "loc_id": 200,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c01cb5af-b1d9-11ef-a909-b66e99367f32",
      "subdate": "Dec 04, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 18
   },
   "visits": {
      "storefront": 18,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-04 00:50:26"
   },
   "location": {
      "uuid": "c01cb5af-b1d9-11ef-a909-b66e99367f32",
      "link_id": 338697,
      "account_id": 89408,
      "company": "Ester Electrical",
      "sid": 6,
      "country": 200,
      "countrycode": "NZ",
      "state": 0,
      "city": "0",
      "zip": "1061",
      "address": "702 Great South Road",
      "phone": "+64 508 437 837",
      "fax": null,
      "email": "ester@brite-email.com",
      "name": "Ester Electrical",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "-36.9046076",
      "lon": "174.8103659",
      "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": ""
}