Mercerisland Remodeling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333331,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.mercerislandremodeling.com/",
      "title": "Mercerisland Remodeling",
      "description": "Mercer Island Remodeling is a family-owned business specializing in home, kitchen, and bathroom renovations for over seven years. They provide comprehensive remodeling and handyman services, emphasizing quality, craftsmanship, and customer satisfaction. Their team collaborates closely with clients to transform spaces, ensuring every project reflects the client''s vision and high standards. They offer services ranging from minor repairs to major renovations, focusing on precision and care. Trusted by many, Mercer Island Remodeling prides itself on transparency, integrity, and exceptional workmanship.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84108,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23801,
      "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": 5842,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "afe91045-4860-11ef-8344-b66e99367f32",
      "subdate": "Jul 22, 2024",
      "subcategory": "Appliance Repair",
      "request_types": "",
      "visitcount": 29
   },
   "visits": {
      "storefront": 29,
      "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": "2024-07-22 19:29:17"
   },
   "location": {
      "uuid": "afe91045-4860-11ef-8344-b66e99367f32",
      "link_id": 333331,
      "account_id": 84108,
      "company": "Mercerisland Remodeling",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23801",
      "zip": "98040",
      "address": "PO BOX 54 Mercer Island, WA 98040",
      "phone": "04254485449",
      "fax": null,
      "email": "communications@mercerislandremodeling.com",
      "name": "Mercerisland Remodeling",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.5824227",
      "lon": "-122.2331227",
      "cityname": "Mercer Island",
      "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": ""
}