Dean Silva Plumbing and Heating

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310719,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "http://www.silvaplumbingandheating.com/",
      "title": "Dean Silva Plumbing and Heating",
      "description": "Dean Silva Plumbing and Heating is a small plumbing and heating company located in Methuen, Massachusetts. We are fully licensed and insured and we offer free estimates. We are here for 24/7 emergency service. We can troubleshoot any problem and repair it quickly to get your water up and running. We provide services for commercial plumbing, drain cleaning, faucet repair, general plumbing, tank-less water heater, toilet repair and installation, water heater repair& service. Our drain service solves the problem the right way, the first time. We also do full kitchen remodeling and bath remodels! We always have technicians available in your area. Call on us for the top plumbing service in Methuen!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61954,
      "approve_dt": "2015-10-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-10-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1424,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 10016,
      "ltop": "",
      "facebook": "https://www.facebook.com/Dean-Silva-Plumbing-and-Heating-246303218766310/?ref=hl",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/u/0/112711655753799109049/posts",
      "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": 4197,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954ee5f8-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 14, 2015",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 1723
   },
   "visits": {
      "storefront": 1723,
      "articles": 0,
      "videos": 0,
      "reviews": 30,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Dean Silva Plumbing and Heating is a small plumbing and heating company located in Methuen, Massachusetts. We are fully licensed and insured and we offer free estimates. We are here for 24/7 emergency service. We can troubleshoot any problem and repair it quickly to get your water up and running. We provide services for commercial plumbing, drain cleaning, faucet repair, general plumbing, tank-less water heater, toilet repair and installation, water heater repair& service. Our drain service solves the problem the right way, the first time. We also do full kitchen remodeling and bath remodels! We always have technicians available in your area. Call on us for the top plumbing service in Methuen!",
      "service1": "Bath remodeling",
      "service2": " Faucet repair",
      "service3": " Drain cleaning",
      "service4": " Kitchen remodeling",
      "service5": " Tank-less water heater installation",
      "service6": " Commercial plumber",
      "service7": " Water heater  replacement",
      "submit_dt": "2015-10-14 07:41:39"
   },
   "location": {
      "uuid": "954ee5f8-56da-11ed-b77c-b66e99367f32",
      "link_id": 310719,
      "account_id": 61954,
      "company": "Dean Silva Plumbing and Heating",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "10016",
      "zip": "01844",
      "address": "Essex",
      "phone": "978-204-7337",
      "fax": "",
      "email": "deansilva12345@gmail.com",
      "name": "Dean Silva Plumbing and Heating",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.7262016",
      "lon": "-71.1908924",
      "cityname": "Methuen",
      "statename": "Massachusetts"
   },
   "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": ""
}