Hairy Houdini LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348350,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://hairyhoudini.net?utm_source=google&utm_medium=organic&utm_campaign=gbp-listing",
      "title": "Hairy Houdini LLC",
      "description": "Hairy Houdini is a locally owned and operated family business based in Carnation, WA, specializing in pet waste removal services throughout the Snoqualmie Valley and expanding into Redmond and Bellevue. With over two years of experience keeping yards clean, they operate with a genuine love for dogs and commitment to maintaining healthy, clean outdoor spaces for pet owners. Their reliable, family-focused approach ensures consistent service for busy pet families.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99045,
      "approve_dt": "2025-07-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23580,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "26787037-44f5-11f0-a909-b66e99367f32",
      "subdate": "Jun 09, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 58
   },
   "visits": {
      "storefront": 58,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 24,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hairy Houdini LLC offers expert pet waste removal in Carnation, Washington, ensuring a clean, odor-free yard. Our professional poop scooping service is reliable, eco-friendly, and tailored for busy pet owners. Trust our expertise for a hygienic, hassle-free solution to pet waste management!",
      "service1": "pet waste removal",
      "service2": " yard cleanup services",
      "service3": " regular maintenance schedules",
      "service4": " one-time cleanup services",
      "service5": " residential pet waste management",
      "service6": " commercial pet waste services",
      "service7": " dog waste disposal solutions",
      "submit_dt": "2025-06-09 05:46:55"
   },
   "location": {
      "uuid": "26787037-44f5-11f0-a909-b66e99367f32",
      "link_id": 348350,
      "account_id": 99045,
      "company": "Hairy Houdini LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23580",
      "zip": "98014",
      "address": "2817 298th Place Northeast",
      "phone": "+1 425-202-5189",
      "fax": null,
      "email": "hairyhoudinillc@brite-email.com",
      "name": "Hairy Houdini LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "47.632509",
      "lon": "-121.9413702",
      "cityname": "Carnation",
      "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": ""
}