Plumber

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331189,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.aqualineplumberselectriciansheating.com/",
      "title": "Plumber",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81990,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 14,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23922,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "70ea070f-1bff-11ef-8344-b66e99367f32",
      "subdate": "May 27, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 62
   },
   "visits": {
      "storefront": 62,
      "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": "Aqualine Plumbing, Electrical and Heating LLC in West Seattle is your go-to full-service contractor, expertly handling all your plumbing, electrical, and heating/AC needs. Our team of certified professionals is committed to delivering reliable and efficient solutions, ensuring your home operates smoothly. From sewers and general plumbing, to Electricians for wiring your home or adding an EV charger or installing or servicing a furnace, heat pump or air conditioner, we do it all.",
      "service1": "Sewer & Drain Cleaning",
      "service2": "Furnace & AC Installation",
      "service3": "Heat Pumps",
      "service4": "Water Heaters",
      "service5": "Plumbing Installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-27 08:02:19"
   },
   "location": {
      "uuid": "70ea070f-1bff-11ef-8344-b66e99367f32",
      "link_id": 331189,
      "account_id": 81990,
      "company": "Aqualine Plumbing, Electrical and Heating LLC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23922",
      "zip": "98116",
      "address": "4800 California Ave SW",
      "phone": "(206) 944-6212",
      "fax": null,
      "email": "aqualineplumber@brite-post.com",
      "name": "Aqualine Plumbing, Electrical and Heating LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.5591979",
      "lon": "-122.3864417",
      "cityname": "Seattle",
      "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": ""
}