Mahoney Plumbing Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310907,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://mahoneyplumbing.com/",
      "title": "Mahoney Plumbing Inc",
      "description": "Mahoney Plumbing is the North Shore plumbing contractor and North Shore HVAC contractor you can rely on for your residential and commercial plumbing, heating, cooling and electrical needs.  We have experienced professionals, offer quality products, and treat our customers fairly.  This is all backed by a 24/7 service commitment.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 62142,
      "approve_dt": "2015-11-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-11-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1513,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 13,
      "city_id": 0,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 4996,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95501505-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 04, 2015",
      "subcategory": "Home Plumbing Repair",
      "request_types": "",
      "visitcount": 1684
   },
   "visits": {
      "storefront": 1684,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a small local business run by a real family. We will run into our customers all around town. Our customers also are our neighbors and friends.  That’s why so many of our customers have been with us for decades.\nIf something needs replacing, we’ll tell you.  If it doesn’t, we’ll tell you that too.   The choice will always be yours, but we will give you our honest and expert opinion.\nWe always treat our customers’ homes with utmost respect, which is why we do things like wear booties, lay out tarps and ALWAYS clean up after ourselves.\nWe constantly discover ways to improve all aspects of our operations, from service calls to paperwork.   We get valuable suggestions from all sources, from our own employees to our customers to our suppliers.\nWe make every effort to keep our costs competitive.   We will occasionally provide our customers with valuable discounts, such as for furnace and AC maintenance.\n",
      "service1": "Plumbing",
      "service2": " Heating",
      "service3": " Air conditioning",
      "service4": " Sewers and drains",
      "service5": " Electrical",
      "service6": " Kitchen and bathroom remodeling",
      "service7": " New construction",
      "submit_dt": "2015-11-04 10:08:35"
   },
   "location": {
      "uuid": "95501505-56da-11ed-b77c-b66e99367f32",
      "link_id": 310907,
      "account_id": 62142,
      "company": "Mahoney Plumbing Inc",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "0",
      "zip": "60040",
      "address": "501 Bank Ln Highwood, IL",
      "phone": "+1 847-432-0320",
      "fax": "",
      "email": "daviddhaman123@gmail.com",
      "name": "Mahoney Plumbing Inc",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.20507",
      "lon": "-87.8113599",
      "cityname": "",
      "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": ""
}