The Patch Boys of New Haven and Milford

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344365,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.thepatchboys.com/new-haven-milford/",
      "title": "The Patch Boys of New Haven and Milford",
      "description": "   ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95060,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-27T00: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": 7,
      "city_id": 3048,
      "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": "4abd48c3-0aa3-11f0-a909-b66e99367f32",
      "subdate": "Mar 27, 2025",
      "subcategory": "Dry Wall Contractors",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "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": "The Patch Boys of New Haven and Milford 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 New Haven, CT. 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!",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-27 00:34:49"
   },
   "location": {
      "uuid": "4abd48c3-0aa3-11f0-a909-b66e99367f32",
      "link_id": 344365,
      "account_id": 95060,
      "company": "The Patch Boys of New Haven and Milford",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3048",
      "zip": "06401",
      "address": "165 Oneils Ct",
      "phone": "(203) 721-6000",
      "fax": null,
      "email": "thepatchboysct@brite-post.com",
      "name": "The Patch Boys of New Haven and Milford",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.3347428",
      "lon": "-73.0848632",
      "cityname": "Ansonia",
      "statename": "Connecticut"
   },
   "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": ""
}