The Patch Boys of Tacoma

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 341129,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.thepatchboys.com/tacoma/",
      "title": "The Patch Boys of Tacoma",
      "description": "The Patch Boys of Tacoma 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 Tacoma, WA. 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": 91826,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-21T00: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": 46,
      "city_id": 23888,
      "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": "3b297b6b-d7ce-11ef-a909-b66e99367f32",
      "subdate": "Jan 21, 2025",
      "subcategory": "Dry Wall Contractors",
      "request_types": "",
      "visitcount": 27
   },
   "visits": {
      "storefront": 27,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "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-21 08:03:42"
   },
   "location": {
      "uuid": "3b297b6b-d7ce-11ef-a909-b66e99367f32",
      "link_id": 341129,
      "account_id": 91826,
      "company": "The Patch Boys of Tacoma",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23888",
      "zip": "98371",
      "address": "Service Area",
      "phone": "(253) 999-5669",
      "fax": null,
      "email": "patchbyspylp@mail-burst.com",
      "name": "The Patch Boys of Tacoma",
      "status": "",
      "start_dt": null,
      "end_dt": null,
      "lat": "47.1971241",
      "lon": "-122.3213693",
      "cityname": "Puyallup",
      "statename": "Washington"
   },
   "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": ""
}