Premier Plumbing and Fire Sprinkler Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347640,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.serviceprollc.com/",
      "title": "Premier Plumbing and Fire Sprinkler Solutions",
      "description": "Service Pro LLC stands as Maryland’s trusted plumbing partner, boasting over 60 years of combined expertise and a steadfast commitment to family‑driven values.
From the heart of Trappe, we serve Talbot, Queen Anne’s, Kent, Dorchester, Caroline, Anne Arundel, and surrounding counties with reliable, upfront pricing and local, personalized service that feels like family.
Our licensed, four‑year‑trained technicians tackle every job—whether it’s a leak, a new installation, or a full remodel—ensuring quality workmanship, timely delivery, and lasting solutions.
We believe the key to exceptional service is clear communication and continuous improvement, which is why we invest in cutting‑edge technology, ongoing training, and a transparent billing process that eliminates surprises.
Choose Service Pro LLC for peace of mind, professional craftsmanship, and a commitment to building lasting relationships with every customer, every call, every year.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98335,
      "approve_dt": "2025-11-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 20,
      "city_id": 9646,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0d468101-3a94-11f0-a909-b66e99367f32",
      "subdate": "May 27, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 45
   },
   "visits": {
      "storefront": 45,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Service Pro is your trusted, reliable plumber for those in the Maryland area across the Eastern Shore. We offer emergency services so when you have a plumbing problem, we will be there to help! Contact us today to get help now.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-27 00:46:40"
   },
   "location": {
      "uuid": "0d468101-3a94-11f0-a909-b66e99367f32",
      "link_id": 347640,
      "account_id": 98335,
      "company": "Service Pro, LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 20,
      "city": "9646",
      "zip": "21601",
      "address": "",
      "phone": "+14108204040",
      "fax": null,
      "email": "serviceprollc@mail-burst.com",
      "name": "Service Pro, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Easton",
      "statename": "Maryland"
   },
   "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": ""
}