Drywall Complete Services LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344212,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.drywallcontractorannarbormi.com",
      "title": "Drywall Complete Services LLC",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94907,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10769,
      "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": 5853,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c1f23db7-08b1-11f0-a909-b66e99367f32",
      "subdate": "Mar 24, 2025",
      "subcategory": "Dry Wall Contractors",
      "request_types": "",
      "visitcount": 38
   },
   "visits": {
      "storefront": 38,
      "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": "\"Drywall Complete Services LLC. was founded by Lloyd Scherdt, a second-generation contractor. Lloyd grew up learning drywall skills from his father and uncle and became increasingly passionate about the construction industry. Since the late 1970's he has worked on several projects from residential home renovations to commercial building construction. He prides himself in continuously seeking improvement and bringing you the latest in drywall technologies to ensure long-lasting, quality work.\"",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-24 13:13:20"
   },
   "location": {
      "uuid": "c1f23db7-08b1-11f0-a909-b66e99367f32",
      "link_id": 344212,
      "account_id": 94907,
      "company": "Drywall Complete Services LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10769",
      "zip": "48198",
      "address": "1830 Carol Ann Avenue",
      "phone": "+1 734-368-5568",
      "fax": null,
      "email": "drywallannarbor@burst-email.com",
      "name": "Drywall Complete Services LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.2297872",
      "lon": "-83.5745986",
      "cityname": "Ypsilanti",
      "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": ""
}