Gelderman Landscape Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344522,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.gelderman.com/?utm_source=gmb&utm_medium=organic",
      "title": "Gelderman Landscape Services",
      "description": "Gelderman Landscape Services",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95217,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 157,
      "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": 4201,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "626dbaf9-0dd6-11f0-a909-b66e99367f32",
      "subdate": "Mar 31, 2025",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "For over 65 years, Gelderman Landscape Services has brought stunning landscapes to life. From residential backyards to commercial properties, we design and build custom landscapes including decks, pools, patios, retaining walls, outdoor kitchens, cabanas and more, while offering expert maintenance services. Our Red Carpet Service ensures seamless care, exceptional quality, and personalized attention"so you can enjoy a beautiful, worry-free outdoor space that perfectly suits your needs.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-31 02:18:07"
   },
   "location": {
      "uuid": "626dbaf9-0dd6-11f0-a909-b66e99367f32",
      "link_id": 344522,
      "account_id": 95217,
      "company": "Gelderman Landscape Services",
      "sid": 58,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "157",
      "zip": "L9N 2Z7",
      "address": "831 Centre Road",
      "phone": "+1 905-689-5433",
      "fax": null,
      "email": "geldermanlsrvcs@mail-burst.com",
      "name": "Gelderman Landscape Services",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "43.35299",
      "lon": "-79.92585",
      "cityname": "Hamilton",
      "statename": ""
   },
   "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": ""
}