John McCarter Construction Full-service Exterior Remodeling Contractor Detroit

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309459,
      "site_id": 67,
      "cat_id": 81,
      "priority": 0,
      "url": "http://johnmccarterconstruction.com",
      "title": "John McCarter Construction Full-service Exterior Remodeling Contractor Detroit",
      "description": "John McCarter Construction is a full-service exterior remodeling contractor serving the South Lyon, Ann Arbor and entire Detroit area. We specialize in Hardieplank siding and are certified as an Elite James Hardie Preferred Contractor. We also specialize in replacement windows, roofing and replacement doors. We transform home exteriors by offering superior products we trust, skilled and detailed w",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60695,
      "approve_dt": "2015-05-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-05-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1958,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10680,
      "ltop": "",
      "facebook": "http://www.facebook.com/JohnMcCarterConstruction",
      "tiktok": "",
      "linkedin": "",
      "twitter": "http://twitter.com/john_mccarter",
      "googleplus": "http://plus.google.com/113632957701951613319/about",
      "youtube_channel": "",
      "youtube": "http://www.youtube.com/watch?v=013O5hJwNVA",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5046,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9548135e-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 12, 2015",
      "subcategory": "Roofing",
      "request_types": "",
      "visitcount": 2328
   },
   "visits": {
      "storefront": 2328,
      "articles": 0,
      "videos": 0,
      "reviews": 28,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Full-Service Exterior Remodeling Contractor Michigan\n\n\nFor the best siding, windows and exterior remodeling investment you can make, trust your home to the exterior remodeling experts at John McCarter Construction.\n\nWe transform home exteriors by offering superior products we trust, skilled and detailed workmanship, reliable and trustworthy staff and industry leading qualifications. This increases the homes value and curb-appeal and gives homeowners peace of mind.\n\nAs one of the most experienced siding and exterior remodeling companies in Ann Arbor, we’ve learned that Your Satisfaction Means Everything! Our focus is on your 100% satisfaction, and we will strive to exceed your quality and service expectations.\n",
      "service1": "fiber cement siding",
      "service2": "hardieplank siding",
      "service3": "james hardie siding",
      "service4": "replacement windows",
      "service5": "replacement doors",
      "service6": "roofing",
      "service7": "roof replacement",
      "submit_dt": "2015-05-12 06:53:59"
   },
   "location": {
      "uuid": "9548135e-56da-11ed-b77c-b66e99367f32",
      "link_id": 309459,
      "account_id": 60695,
      "company": "John McCarter Construction, LLC",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10680",
      "zip": "48178",
      "address": "475 Washington St",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.457039",
      "lon": "-83.652282",
      "cityname": "South Lyon",
      "statename": "Michigan"
   },
   "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": ""
}