Ambassador Floor Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 307840,
      "site_id": 23,
      "cat_id": 40,
      "priority": 0,
      "url": "http://www.ambassadorfloor.com",
      "title": "Ambassador Floor Company",
      "description": "Ambassador Floors features Stainmaster & Karastan Carpet. Serving Chesterfield, MO, Ellisville, Town and Country, Manchester, O'Fallon, Ballwin, Creve Coeur. We carry a fine selection of floors including carpet, hardwood, laminate, ceramic tile, vinyl, LVT",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59081,
      "approve_dt": "2025-04-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2013-08-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3117,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 1373,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "94821fbe-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 31, 2013",
      "subcategory": "Hardwood Floors",
      "request_types": "",
      "visitcount": 3634
   },
   "visits": {
      "storefront": 3634,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Ambassador Floors: A distinguished family-owned flooring specialist with over 30 years of experience serving Chesterfield, Ellisville, Town and Country, Manchester, O'Fallon, Ballwin, and Creve Coeur. \n\nWe pride ourselves on offering premium Stainmaster and Karastan products alongside a comprehensive selection of flooring solutions tailored to every lifestyle and budget. Our team of certified installation experts ensures flawless results, while our design consultants provide personalized guidance to help you select the perfect flooring for your home. \n\nWith our price-match guarantee, extensive showroom, and commitment to customer satisfaction, Ambassador Floors transforms your vision into reality with quality craftsmanship that stands the test of time.",
      "service1": "Carpet Installation",
      "service2": " Hardwood Flooring",
      "service3": " Laminate Flooring",
      "service4": " Ceramic Tile Installation",
      "service5": " Luxury Vinyl Tile (LVT)",
      "service6": " Free In-Home Consultation",
      "service7": " Professional Floor Restoration",
      "submit_dt": "2013-08-31 03:16:01"
   },
   "location": {
      "uuid": "94821fbe-56da-11ed-b77c-b66e99367f32",
      "link_id": 307840,
      "account_id": 59081,
      "company": "Ambassador Floor Company",
      "sid": 23,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "63005",
      "address": "17770 Chesterfield Airport Road",
      "phone": "636-728-9171",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.668293",
      "lon": "-90.6248295",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}