Hargrave's Plumbing, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337614,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.hargravesplumbing.com",
      "title": "Hargrave's Plumbing, LLC",
      "description": "Hargrave Plumbing in Lafayette, LA, is a family owned and professionally licensed plumbing company in Louisiana, focused on repair plumbing, new construction plumbing, residential plumbing remodels, and commercial plumbing projects alike.Since 1996, Travis & Bridget Hargrave have been serving the plumbing needs of the Greater Acadiana area and it''s great residents. Plus, Hargrave''s Plumbing is always striving to be the best plumber in Lafayette, LA you can find. From Water Heater Replacement",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88335,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-11-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 6,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "242978c6-9fda-11ef-a909-b66e99367f32",
      "subdate": "Nov 11, 2024",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 61
   },
   "visits": {
      "storefront": 61,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Water Heater Repair & Replacement",
      "service2": "Sewer & Drain Clearing",
      "service3": "Leak Detection",
      "service4": "Backflow Preventer Testing",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-11-11 03:07:53"
   },
   "location": {
      "uuid": "242978c6-9fda-11ef-a909-b66e99367f32",
      "link_id": 337614,
      "account_id": 88335,
      "company": "https://www.hargravesplumbing.com",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 18,
      "city": "9229",
      "zip": "70503",
      "address": "141 Ridgeway Drive, Suite 102",
      "phone": "+1 337-344-3920",
      "fax": null,
      "email": "travishargrave@brite-post.com",
      "name": "https://www.hargravesplumbing.com",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "30.1997968",
      "lon": "-92.0423968",
      "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": ""
}