New England Pipe Restoration, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 342458,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://nepipe.com/residential-services/pipe-bursting/",
      "title": "New England Pipe Restoration, Inc.",
      "description": "Pipe Bursting in Boston, MA\r\nFor fast sewer repairs, trust New England Pipe Restoration. Our trenchless pipe bursting technology replaces damaged sections from the inside, minimizing property damage and reducing costs.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 93152,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 9927,
      "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": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "958209a1-eb19-11ef-a909-b66e99367f32",
      "subdate": "Feb 14, 2025",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pipe Bursting in Boston, MA\r
For fast sewer repairs, trust New England Pipe Restoration. Our trenchless pipe bursting technology replaces damaged sections from the inside, minimizing property damage and reducing costs.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-02-14 21:20:58"
   },
   "location": {
      "uuid": "958209a1-eb19-11ef-a909-b66e99367f32",
      "link_id": 342458,
      "account_id": 93152,
      "company": "New England Pipe Restoration, Inc.",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "9927",
      "zip": "01453",
      "address": "Serving areas in",
      "phone": "(978) 962-2340",
      "fax": null,
      "email": "nepipemarketing@gmail.com",
      "name": "New England Pipe Restoration, Inc.",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.5233434",
      "lon": "-71.7385225",
      "cityname": "Boston",
      "statename": "Massachusetts"
   },
   "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": ""
}