Walpole Outdoors at Pine Harbor - Hyannis

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347808,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.walpoleoutdoors.com/locations/hyannis-walpole-outdoors-at-pine-harbor",
      "title": "Walpole Outdoors at Pine Harbor - Hyannis",
      "description": "Walpole Outdoors at Pine Harbor in Hyannis, MA is your premier destination for outdoor enhancement solutions, located at 326 Yarmouth Road and serving Cape Cod with quality outdoor products and design services. Open Monday through Saturday from 9 AM to 5 PM, our Massachusetts location provides expert consultation and comprehensive outdoor living solutions to transform your exterior spaces with craftsmanship and style.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98503,
      "approve_dt": "2025-07-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-29T00: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": 21,
      "city_id": 9919,
      "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": 5855,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d0e1017a-3c39-11f0-a909-b66e99367f32",
      "subdate": "May 29, 2025",
      "subcategory": "Fence Contractors",
      "request_types": "",
      "visitcount": 41
   },
   "visits": {
      "storefront": 41,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Today's Walpole is a highly skilled, customer focused enterprise that makes smart use of the latest technology and materials while still honoring its handcrafted roots. For almost a century, Walpole Outdoors has been creating beautifully crafted fences, pergolas, arbors, gates, and more in our North American workshop. While some of our techniques and processes have been modernized for greater efficiency, we're committed to our legacy of quality craftsmanship. Learn more at walpoleoutdoors.com.",
      "service1": "Outdoor Design Consultation",
      "service2": " Outdoor Living Solutions",
      "service3": " Custom Installation Services",
      "service4": " Quality Product Sales",
      "service5": " Cape Cod Area Service",
      "service6": " Expert Outdoor Enhancement",
      "service7": " Professional Craftsmanship Solutions",
      "submit_dt": "2025-05-29 03:05:46"
   },
   "location": {
      "uuid": "d0e1017a-3c39-11f0-a909-b66e99367f32",
      "link_id": 347808,
      "account_id": 98503,
      "company": "Walpole Outdoors at Pine Harbor - Hyannis",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "9919",
      "zip": "02601",
      "address": "326 Yarmouth Rd",
      "phone": "(508) 775-3925",
      "fax": null,
      "email": "walpoleoutdoors@brite-email.com",
      "name": "Walpole Outdoors at Pine Harbor - Hyannis",
      "status": "hide",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.6633472",
      "lon": "-70.2732051",
      "cityname": "Barnstable Town",
      "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": ""
}