https://www.bluefrogplumbingnorthdallas.com/

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349136,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "https://www.bluefrogplumbingnorthdallas.com/",
      "title": "https://www.bluefrogplumbingnorthdallas.com/",
      "description": "Bluefrog Plumbing + Drain of North Dallas delivers expert residential and commercial plumbing services across North Dallas. Known for 24/7 availability and transparent pricing, our licensed technicians specialize in drain cleaning, water heater repair, leak detection, hydro jetting, and trenchless sewer solutions. We prioritize customer satisfaction with prompt, courteous service and a \"Right Solution Guarantee.” Whether it's an emergency or routine maintenance, Bluefrog ensures less mess and less stress for every client. Call 24/7 to schedule all types of reliable Plumbing Services in Frisco!  ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99830,
      "approve_dt": "2025-07-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 0,
      "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": "34a7181b-530c-11f0-a909-b66e99367f32",
      "subdate": "Jun 27, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Bluefrog Plumbing + Drain of North Dallas delivers expert residential and commercial plumbing services across North Dallas. Known for 24/7 availability and transparent pricing, our licensed technicians specialize in drain cleaning, water heater repair, leak detection, hydro jetting, and trenchless sewer solutions. We prioritize customer satisfaction with prompt, courteous service and a \"Right Solution Guarantee.” Whether it's an emergency or routine maintenance, Bluefrog ensures less mess and less stress for every client. Call 24/7 to schedule all types of reliable Plumbing Services in Frisco!",
      "service1": "Leak Detection",
      "service2": "Water Filtration System",
      "service3": "Drain Cleaning",
      "service4": "Repiping",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-27 04:07:13"
   },
   "location": {
      "uuid": "34a7181b-530c-11f0-a909-b66e99367f32",
      "link_id": 349136,
      "account_id": 99830,
      "company": "Kris Stewart",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "",
      "zip": "75036",
      "address": "122 Rose Lane, Ste. K1, Frisco, Texas,",
      "phone": "(469) 214-2582",
      "fax": null,
      "email": "bluefrogplumber@brite-mail.com",
      "name": "https://www.bluefrogplumbingnorthdallas.com/",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null
   },
   "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": ""
}