DeshefyPlumbing,LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329862,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://deshefyplumbingllc.com/",
      "title": "DeshefyPlumbing,LLC",
      "description": "DESHEFY PLUMBING, LLC offers a variety of Plumbing Repair, Maintenance and Installation services throughout Eastern Connecticut to both Residential and Commercial Customers. Our Plumbing Services include general repairs, new fixtures (toilets, faucets, sinks, etc.), water filtration, well pumps, piping, sump pumps, hot water heaters and more.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80675,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 15,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "04af0f75-f862-11ee-8344-b66e99367f32",
      "subdate": "Apr 12, 2024",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 68
   },
   "visits": {
      "storefront": 68,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "DESHEFY PLUMBING, LLC offers a variety of Plumbing Repair, Maintenance and Installation services throughout Eastern Connecticut to both Residential and Commercial Customers. Our Plumbing Services include general repairs, new fixtures (toilets, faucets, sinks, etc.), water filtration, well pumps, piping, sump pumps, hot water heaters and more.",
      "service1": "Plumbing Repairs",
      "service2": "Well Water System Repairs",
      "service3": "Hot Water Heaters",
      "service4": "Residential Plumbing",
      "service5": "Commercial Plumbing",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-12 00:17:16"
   },
   "location": {
      "uuid": "04af0f75-f862-11ee-8344-b66e99367f32",
      "link_id": 329862,
      "account_id": 80675,
      "company": "Deshefy Plumbing, LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "",
      "zip": "06359",
      "address": "98 Reutemann Rd, North Stonington",
      "phone": "(860) 625-7848",
      "fax": null,
      "email": "deshefyplumbingllc@mail-burst.com",
      "name": "Deshefy Plumbing, LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.4485237",
      "lon": "-71.8648343"
   },
   "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": ""
}