AMSTERDAM - MASONRY & TUCKPOINTING CONTRACTOR

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346959,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://amsterdamcontractor.com/",
      "title": "AMSTERDAM - MASONRY & TUCKPOINTING CONTRACTOR",
      "description": "Amsterdam Enterprises is a masonry company with over 43 years of experience, founded in 1982 by Gerard Stencel who built the business on passion, quality craftsmanship, and industry leadership. They specialize in comprehensive masonry services, offering customized solutions that understand each homeowner's unique vision and property character while maintaining meticulous attention to detail and using only the highest quality materials.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97654,
      "approve_dt": "2025-07-29T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-15T00: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": 13,
      "city_id": 5213,
      "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": 6646,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c29d388a-3156-11f0-a909-b66e99367f32",
      "subdate": "May 15, 2025",
      "subcategory": "Construction",
      "request_types": "",
      "visitcount": 14
   },
   "visits": {
      "storefront": 14,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Amsterdam Enterprises, a trusted masonry contractor, has been serving Buffalo Grove and the surrounding Chicago areas with excellence since 1982, bringing over 42 years of experience to every project. Our reputation is built on our dedication to quality craftsmanship, reliability, and top-tier service. Specializing in both residential and commercial masonry, we offer a wide range of services, including roofing, siding installation, tuckpointing, and window installation and repair.",
      "service1": "Masonry Contractor",
      "service2": "Tuckpointing Contractor",
      "service3": "Roofing Replacement",
      "service4": "Roofing Installation",
      "service5": "Siding and windows installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-15 06:35:15"
   },
   "location": {
      "uuid": "c29d388a-3156-11f0-a909-b66e99367f32",
      "link_id": 346959,
      "account_id": 97654,
      "company": "AMSTERDAM - MASONRY & TUCKPOINTING CONTRACTOR",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "5213",
      "zip": "60089",
      "address": "3 Villa Verde Drive, APT 216",
      "phone": "+1 847-439-1814",
      "fax": null,
      "email": "amsterdamroofer@brite-email.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.1365905",
      "lon": "-87.9876748",
      "cityname": "Buffalo Grove",
      "statename": "Illinois"
   },
   "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": ""
}