Blue Umbrella Waterproofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344092,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.blueumbrellawaterproofing.com/",
      "title": "Blue Umbrella Waterproofing",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94787,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 13979,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpeg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "165e73a0-05fc-11f0-a909-b66e99367f32",
      "subdate": "Mar 21, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 21
   },
   "visits": {
      "storefront": 21,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Blue Umbrella provides basement waterproofing, sump pump installation, basement dehumidifier installation, window well replacement, foundation repair, and crawl space encapsulation. Our goal is to help homeowners and business owners across New Jersey stay dry and safe by providing them with reliable, long-lasting basement and foundation solutions. We are a team dedicated to workmanship and customer service, founded on integrity and trust. We proudly stand behind all our work.",
      "service1": "Basement Waterproofing",
      "service2": "Crawl Space Repair",
      "service3": "Basement Foundation Repair",
      "service4": "Sump Pump Installation",
      "service5": "French Drain Installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-21 02:27:51"
   },
   "location": {
      "uuid": "165e73a0-05fc-11f0-a909-b66e99367f32",
      "link_id": 344092,
      "account_id": 94787,
      "company": "",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "13979",
      "zip": "07016",
      "address": "29 Alden Street, Suite LL1B",
      "phone": "+1 908-432-8858",
      "fax": null,
      "email": "stvekarlik@mail-burst.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.6566295",
      "lon": "-74.3044008",
      "cityname": "Cranford",
      "statename": "New Jersey"
   },
   "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": ""
}