Indigo plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346558,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://indigoplumbingokc.com/",
      "title": "Indigo plumbing",
      "description": "At Indigo Plumbing, we bring years of hands-on experience and expert service to homeowners and businesses across Oklahoma City. Specializing in hot water systems, plumbing repairs, installations, and emergency services, our licensed professionals deliver dependable solutions with integrity and precision. As a trusted local provider, were committed to quality workmanship, transparent pricing, and exceptional customer care. Whether you need a water heater replacement, drain cleaning, or whole-home repipe, were here 24/7 to help. Discover why Oklahoma City residents rely on Indigo Plumbing for honest, efficient, and long-lasting plumbing solutions.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97253,
      "approve_dt": "2025-08-03T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 18205,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f218aab3-2b4b-11f0-a909-b66e99367f32",
      "subdate": "May 07, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 10
   },
   "visits": {
      "storefront": 10,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "Indigo Plumbing is a trusted plumbing company with years of industry experience, staffed by skilled licensed plumbers dedicated to providing prompt and efficient solutions for all residential and commercial plumbing needs.",
      "service1": "leak repair",
      "service2": " drain cleaning",
      "service3": " water heater installation",
      "service4": " residential plumbing",
      "service5": " plumbing installations",
      "service6": " plumbing maintenance",
      "service7": " emergency plumbing services",
      "submit_dt": "2025-05-07 14:02:43"
   },
   "location": {
      "uuid": "f218aab3-2b4b-11f0-a909-b66e99367f32",
      "link_id": 346558,
      "account_id": 97253,
      "company": "Indigo plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "18205",
      "zip": "73112",
      "address": "3030 Northwest Expy Suite 300",
      "phone": "(405) 626-3740",
      "fax": null,
      "email": "cdiocarossmandy3272@gmail.com",
      "name": "Indigo plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "35.5267684",
      "lon": "-97.5695876",
      "cityname": "Oklahoma City",
      "statename": "Oklahoma"
   },
   "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": ""
}