Willow River Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347657,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.willowrivercompany.com/",
      "title": "Willow River Company",
      "description": "Willow River Company is a family-owned landscaping business founded on the principles of hard work, trust, and integrity to create long-lasting relationships with clients. They provide comprehensive landscaping services with the expertise, communication, and dedication that comes from understanding each client's unique needs, ensuring properties receive the care and attention they deserve.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98352,
      "approve_dt": "2025-07-20T00: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": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 49,
      "city_id": 24577,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c1665b99-3aa7-11f0-a909-b66e99367f32",
      "subdate": "May 27, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 8
   },
   "visits": {
      "storefront": 8,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Willow River Company is a family-owned and operated landscaping company serving the St. Croix River Valley area since 1988. As your trusted full-service partner, we specialize in transforming outdoor spaces into beautiful, functional landscapes with a focus on quality and care. Our experienced team of certified arborists, contractors, and designers offers a wide range of services, from award-winning landscape design and installation to tree care, lawn maintenance, and more. Founded on trust and integrity, we treat every project with care, handling all your landscaping needs. Whether you're envisioning a complete landscape renovation or simply need seasonal upkeep, we're here to bring your vision to life.",
      "service1": "Dream garden design",
      "service2": " Tree installation services",
      "service3": " Expert landscape maintenance",
      "service4": " Comprehensive landscaping solutions",
      "service5": " Family business integrity",
      "service6": " Property care partnerships",
      "service7": " Trusted landscaping expertise",
      "submit_dt": "2025-05-27 03:07:42"
   },
   "location": {
      "uuid": "c1665b99-3aa7-11f0-a909-b66e99367f32",
      "link_id": 347657,
      "account_id": 98352,
      "company": "Willow River Company",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 49,
      "city": "24577",
      "zip": "54016",
      "address": "850 Kelly Road",
      "phone": "+1 715-386-3196",
      "fax": null,
      "email": "willowrivercompany@brite-email.com",
      "name": "Willow River Company",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "44.9858448",
      "lon": "-92.662023",
      "cityname": "Hudson",
      "statename": "Wisconsin"
   },
   "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": ""
}