Hanover Adams and York Painting Contractors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348145,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://hanover-adams-york-painting-contractors.com/",
      "title": "Hanover Adams and York Painting Contractors",
      "description": "For several years, Hanover Adams and York Painting Contractors have been a leading provider of high-quality painting services in Central PA. Our pride is in our ultra-modern technology and highly skilled craftsmen who ensure every project is perfect, using only the highest quality materials for every job. We are dedicated to your satisfaction from beginning to end, maintaining open communication throughout the project's course and completing every stroke with great care.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98840,
      "approve_dt": "2025-07-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 6,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19250,
      "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": 5875,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3c764718-411f-11f0-a909-b66e99367f32",
      "subdate": "Jun 04, 2025",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 60
   },
   "visits": {
      "storefront": 60,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Discover the difference professional craftsmanship can make with Hanover Adams and York Painting Contractors, serving homeowners across Hanover, PA. We stand out as leading painting contractors in Hanover by focusing on delivering superior quality services that enhance the beauty and longevity of your property. Our experienced house painters in Hanover are adept at handling any project size, using only high-quality materials for lasting results. At our core is a dedication to exceeding expectations  from detailed surface preparation to the final brushstroke, each step is handled with utmost professionalism. As a trusted painting company in Hanover, PA, we promise an efficient process that minimizes disruption while maximizing value. Elevate the aesthetic appeal of your living space or business premises with our expert touch today!",
      "service1": "Residential Interior Painting",
      "service2": " Residential Exterior Painting",
      "service3": " Commercial Building Painting",
      "service4": " Home Repainting",
      "service5": " Preparation Work",
      "service6": " Color Consultation",
      "service7": " Professional Quality Finishing",
      "submit_dt": "2025-06-04 08:38:07"
   },
   "location": {
      "uuid": "3c764718-411f-11f0-a909-b66e99367f32",
      "link_id": 348145,
      "account_id": 98840,
      "company": "Hanover Adams and York Painting Contractors",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19250",
      "zip": "17331",
      "address": " 525 Carlisle St rear",
      "phone": "(717) 524-4587",
      "fax": null,
      "email": "haaypainting@outlook.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.807546",
      "lon": "-76.9890801",
      "cityname": "Hanover",
      "statename": "Pennsylvania"
   },
   "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": ""
}