Nelson’s Hardscape and Tree Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343334,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://nelsonstreeservice.com/",
      "title": "Nelson’s Hardscape and Tree Service",
      "description": "Nelsons Hardscape and Tree Service has been providing quality tree care to the residents of the Greater Massachusetts area for over 10 years. We are a family-owned and operated business, and we take pride in our reputation for providing quality work. We offer a full range of tree care services, including tree removal, tree trimming, lawn care, storm cleanup, and stump grinding. We are fully insured, and our work is guaranteed. Whether you need us to remove a dangerous tree from your property or simply want to improve the look of your yard, we can help. We are dedicated to providing our customers with the highest quality of service possible, and our team of certified arborists is ready to handle any job, big or small.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94029,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-05T00: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": 0,
      "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": 5884,
      "d_url": null,
      "approved": null,
      "logo_ext": "14",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "5a156bf2-f9dc-11ef-a909-b66e99367f32",
      "subdate": "Mar 05, 2025",
      "subcategory": "Tree Services",
      "request_types": "",
      "visitcount": 25
   },
   "visits": {
      "storefront": 25,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Nelsons Hardscape and Tree Service has been providing quality tree care to the residents of the Greater Massachusetts area for over 10 years. We are a family-owned and operated business, and we take pride in our reputation for providing quality work. We offer a full range of tree care services, including tree removal, tree trimming, lawn care, storm cleanup, and stump grinding. We are fully insured, and our work is guaranteed. Whether you need us to remove a dangerous tree from your property or simply want to improve the look of your yard, we can help. We are dedicated to providing our customers with the highest quality of service possible, and our team of certified arborists is ready to handle any job, big or small.",
      "service1": "Tree Removal",
      "service2": "Tree Trimming",
      "service3": "Emergency Tree Service",
      "service4": "Lawn Care",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-05 16:10:27"
   },
   "location": {
      "uuid": "5a156bf2-f9dc-11ef-a909-b66e99367f32",
      "link_id": 343334,
      "account_id": 94029,
      "company": "Nelson’s Hardscape and Tree Service",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "01904",
      "address": "17 BULFINCH ST UNIT 2, LYNN, MA 01904",
      "phone": "9783007370",
      "fax": null,
      "email": "treeservicenelsons@gmail.com",
      "name": "Nelson’s Hardscape and Tree Service",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.4699588",
      "lon": "-70.9611935"
   },
   "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": ""
}