Half Moon Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326424,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://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.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77295,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-11-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 36,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 18376,
      "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": "4e32708e-8743-11ee-8344-b66e99367f32",
      "subdate": "Nov 20, 2023",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 98
   },
   "visits": {
      "storefront": 98,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_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.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-11-20 01:22:43"
   },
   "location": {
      "uuid": "4e32708e-8743-11ee-8344-b66e99367f32",
      "link_id": 326424,
      "account_id": 77295,
      "company": "Half Moon Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "18376",
      "zip": "74133",
      "address": "7633 East 63rd Place",
      "phone": "",
      "fax": null,
      "email": "bsnssmngrhmp@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.0726693",
      "lon": "-95.8887254",
      "cityname": "Tulsa",
      "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": ""
}