The Patch Boys of Lake Orion, Troy, and Clinton Township

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340919,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.thepatchboys.com/lake-orion/",
      "title": "The Patch Boys of Lake Orion, Troy, and Clinton Township",
      "description": "The Patch Boys of Lake Orion, Troy, and Clinton Township specialize in drywall repair, ceiling repair, plaster repair, and drywall installations. The Patch Boys offers dependable service for your home or business. Whether it’s a small hole or large job, we’re the most effective and efficient drywall repair company in Lake Orion, Troy, and Clinton Township MI. We strive to have most jobs done within the same day. We’ll get your walls and ceilings to \"like nothing ever happened\" condition. Call today for your free estimate!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 91616,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-17T00: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": 10455,
      "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": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "09cb638c-d481-11ef-a909-b66e99367f32",
      "subdate": "Jan 17, 2025",
      "subcategory": "Dry Wall Contractors",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-17 03:13:35"
   },
   "location": {
      "uuid": "09cb638c-d481-11ef-a909-b66e99367f32",
      "link_id": 340919,
      "account_id": 91616,
      "company": "The Patch Boys of Lake Orion, Troy, and Clinton Township",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10455",
      "zip": "48362",
      "address": "Service Area",
      "phone": "(248) 455-3999",
      "fax": null,
      "email": "patchboyslakeorion@burst-email.com",
      "name": "The Patch Boys of Lake Orion, Troy, and Clinton Township",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.780604",
      "lon": "-83.2395539",
      "cityname": "Lake Orion",
      "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": ""
}