The Patch Boys of North Charlotte

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 341017,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.thepatchboys.com/north-charlotte/",
      "title": "The Patch Boys of North Charlotte",
      "description": "The Patch Boys of North Charlotte 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 North Charlotte NC. 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": 91714,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-20T00: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": 32,
      "city_id": 15779,
      "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": "335ee7a5-d6dc-11ef-a909-b66e99367f32",
      "subdate": "Jan 20, 2025",
      "subcategory": "Dry Wall Contractors",
      "request_types": "",
      "visitcount": 25
   },
   "visits": {
      "storefront": 25,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-20 03:11:11"
   },
   "location": {
      "uuid": "335ee7a5-d6dc-11ef-a909-b66e99367f32",
      "link_id": 341017,
      "account_id": 91714,
      "company": "The Patch Boys of North Charlotte",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15779",
      "zip": "28215",
      "address": "Service Area",
      "phone": "(704) 672-5551",
      "fax": null,
      "email": "thepatchboysnorth@brite-email.com",
      "name": "The Patch Boys of North Charlotte",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "35.2413572",
      "lon": "-80.7103532",
      "cityname": "Charlotte",
      "statename": "North Carolina"
   },
   "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": ""
}