Stump Removal in Blacksburg, VA

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326500,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.mcgrathstumpremoval.com/",
      "title": "Stump Removal in Blacksburg, VA",
      "description": "Welcome to McGrath Stump Removalyour trusted partner for specialized Tree Stump Removal, precise Small Tree Cutting, and thorough Debris Cleanup services. Serving Blacksburg, Radford, Christiansburg, and Montgomery County, VA, our dedicated team guarantees efficiency and professionalism in every project. Choose McGrath Stump Removal for unparalleled expertise and satisfaction in landscaping solutions.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77371,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-11-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 22,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23265,
      "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": 5182,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fd6a3970-8903-11ee-8344-b66e99367f32",
      "subdate": "Nov 22, 2023",
      "subcategory": "Landscaping Trees",
      "request_types": "",
      "visitcount": 55
   },
   "visits": {
      "storefront": 55,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-11-22 06:54:32"
   },
   "location": {
      "uuid": "fd6a3970-8903-11ee-8344-b66e99367f32",
      "link_id": 326500,
      "account_id": 77371,
      "company": "Stump Removal in Blacksburg, VA",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23265",
      "zip": "24141",
      "address": "7527 Ridge Rd",
      "phone": "5404451259",
      "fax": null,
      "email": "mcgrathstumpgrindingpro@gmail.com",
      "name": "Stump Removal in Blacksburg, VA",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.1511935",
      "lon": "-80.5751128",
      "cityname": "Fairlawn",
      "statename": "Virginia"
   },
   "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": ""
}

all our featured social media