The Patch Boys of Phoenix

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 341261,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.thepatchboysphx.com/",
      "title": "The Patch Boys of Phoenix",
      "description": "The Patch Boys of Phoenix 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 Phoenix AZ. 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": 91956,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-23T00: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": 3,
      "city_id": 1026,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "b761f8b0-d934-11ef-a909-b66e99367f32",
      "subdate": "Jan 23, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 18
   },
   "visits": {
      "storefront": 18,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "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-23 02:49:51"
   },
   "location": {
      "uuid": "b761f8b0-d934-11ef-a909-b66e99367f32",
      "link_id": 341261,
      "account_id": 91956,
      "company": "The Patch Boys of Phoenix",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1026",
      "zip": "85260",
      "address": "7900 E Greenway Rd, Suite 107",
      "phone": "(480) 236-6520",
      "fax": null,
      "email": "thepatchboysphoenix@brite-mail.com",
      "name": "The Patch Boys of Phoenix",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.6261227",
      "lon": "-111.9110187",
      "cityname": "Scottsdale",
      "statename": "Arizona"
   },
   "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": ""
}