Pipes & Plugs LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329023,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://pipesandplugs.com/lafayette-plumbing-and-electrical-services/",
      "title": "Pipes & Plugs LLC",
      "description": "Since 2004, Pipes & Plugs has been the company that residents and business owners in New Iberia, Lafayette, and the surrounding areas have trusted to solve all of their plumbing and electrical problems. There’s no job too big or complicated for our licensed professionals, and all of our work is backed by the best warranties you’ll find in the area. Your comfort and safety are always our number one priority, and all of our services are designed to give you total peace of mind at home and at work.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79848,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-03-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 34,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 18,
      "city_id": 9229,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4352a88d-de7e-11ee-8344-b66e99367f32",
      "subdate": "Mar 10, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 98
   },
   "visits": {
      "storefront": 98,
      "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": "Water heater repair",
      "service2": "Electrical wiring",
      "service3": "Commercial Plumbing",
      "service4": "Repiping",
      "service5": "Generator installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-03-10 01:33:57"
   },
   "location": {
      "uuid": "4352a88d-de7e-11ee-8344-b66e99367f32",
      "link_id": 329023,
      "account_id": 79848,
      "company": "Pipes & Plugs LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 18,
      "city": "9229",
      "zip": "70503-3100",
      "address": "1405 W Pinhook Rd, Suite 1C",
      "phone": "337-455-7444",
      "fax": null,
      "email": "pipesandplugsla@brite-email.com",
      "name": "Pipes & Plugs LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.1984359",
      "lon": "-92.0157644",
      "cityname": "Lafayette",
      "statename": "Louisiana"
   },
   "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": ""
}