Acorn Kitchen & Bath

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320231,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://acornkitchen.com/",
      "title": "Acorn Kitchen & Bath",
      "description": "At Acorn Kitchen and Bath our focus is on quality products, installation, and design.\nOur design staff averages 15 years of experience in the kitchen and bath industry. With this experience we can surely make the most utilized rooms in your home, functional and aesthetically pleasing. Our ultimate goal is to provide you with a finished space that you can be proud of.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71423,
      "approve_dt": "2021-03-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2020-12-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 488,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10607,
      "ltop": "",
      "facebook": "http://www.facebook.com/acornkandb",
      "tiktok": null,
      "linkedin": "",
      "twitter": "http://twitter.com/@Acornkandb",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "http://www.pinterest.com/acornkandb",
      "yelp": "",
      "foursquare": "",
      "instagram": "http://instagram.com/acornkitchenandbath",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957e5a37-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 08, 2020",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 629
   },
   "visits": {
      "storefront": 629,
      "articles": 0,
      "videos": 0,
      "reviews": 8,
      "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": "Acorn Kitchen & Bath, one of Michigan's largest Kitchen and Bath design showrooms. You can shop with confidence that our experienced staff can help you with every step of your project. At Acorn Kitchen and Bath, our focus is on quality products, installation, and design. Serving the heart of Southeast Michigan for 40 years. With this experience we can surely make the most utilized rooms in your home, functional and aesthetically pleasing. Our ultimate goal is to provide you with a finished space that you can be proud of. Request Appointment!",
      "service1": "Cabinetry Lines",
      "service2": " Countertops",
      "service3": " Appliances",
      "service4": " Plumbing Fixtures",
      "service5": " Tiles",
      "service6": " Vendors",
      "service7": "  DIY Cabinetry Only Purchase",
      "submit_dt": "2020-12-08 09:18:17"
   },
   "location": {
      "uuid": "957e5a37-56da-11ed-b77c-b66e99367f32",
      "link_id": 320231,
      "account_id": 71423,
      "company": "Acorn Kitchen & Bath",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10607",
      "zip": "48341",
      "address": "111 S. Telegraph Rd.",
      "phone": "(248) 335-0111",
      "fax": null,
      "email": "acornkitchen01@aol.com",
      "name": "Acorn Kitchen & Bath",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.6318383",
      "lon": "-83.324911",
      "cityname": "Pontiac",
      "statename": "Michigan"
   },
   "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": ""
}