Half Moon Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326388,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.halfmoonplumbing.com/",
      "title": "Half Moon Plumbing",
      "description": "Half Moon Plumbing has expanded their affordable Tulsa plumber''s services into Tulsa and the surrounding areas here in Oklahoma. We are now providing experienced, top Tulsa Oklahoma plumbers to more businesses and residents, giving you another option that has been around for years.With a team built up with nothing but the best of the top Tulsa Oklahoma plumbers who provide only top-quality plumbing services to complete our mission of providing the best plumbing services in the state.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77273,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-11-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 41,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 18214,
      "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": "23352800-850c-11ee-8344-b66e99367f32",
      "subdate": "Nov 17, 2023",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 98
   },
   "visits": {
      "storefront": 98,
      "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": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-11-17 05:42:47"
   },
   "location": {
      "uuid": "23352800-850c-11ee-8344-b66e99367f32",
      "link_id": 326388,
      "account_id": 77273,
      "company": "Half Moon Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "18214",
      "zip": "74055",
      "address": "14705 East 116th Street North",
      "phone": "",
      "fax": null,
      "email": "halfmoonplumbing@mail-burst.com",
      "name": "Half Moon Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.3224262",
      "lon": "-95.8097118",
      "cityname": "Owasso",
      "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": ""
}