Hardscape Marketing Crew

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344504,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://hardscapemarketingcrew.com/",
      "title": "Hardscape Marketing Crew",
      "description": "Hardscape Marketing Crew is a premier digital marketing agency specializing in landscape, hardscape, irrigation, and lawn care industries. As a trusted landscape marketing agency and hardscape digital marketing agency, we focus on elevating the online presence of businesses in landscaping, hardscaping, and outdoor services. Our services include website design, SEO, PPC management, social media marketing, content creation, and reputation management. With a deep understanding of the unique challenges in these industries, we tailor digital strategies that drive qualified leads and maximize ROI. Let us help you grow your business and dominate your local market with effective online marketing solutions.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95199,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-30T00: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": 46,
      "city_id": 23533,
      "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": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "bedbade1-0d38-11f0-a909-b66e99367f32",
      "subdate": "Mar 30, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 32
   },
   "visits": {
      "storefront": 32,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "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": "2025-03-30 07:29:42"
   },
   "location": {
      "uuid": "bedbade1-0d38-11f0-a909-b66e99367f32",
      "link_id": 344504,
      "account_id": 95199,
      "company": "Hardscape Marketing Crew",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23533",
      "zip": "98223",
      "address": "26221 5th Ave N.E.",
      "phone": "(360) 512-7338",
      "fax": null,
      "email": "ciarlantegiacalone@gmail.com",
      "name": "Hardscape Marketing Crew",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "48.2340063",
      "lon": "-122.2223756",
      "cityname": "Arlington",
      "statename": "Washington"
   },
   "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": ""
}