Valley Concrete Coatings and Polishing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333727,
      "site_id": 23,
      "cat_id": 40,
      "priority": 2,
      "url": "https://www.thevalleycoatings.com/",
      "title": "Valley Concrete Coatings and Polishing",
      "description": " Valley Concrete Coatings & Polishing is a family-owned business serving the greater Phoenix Metropolitan area since 2004. We are licensed, bonded and insured. For Residential and Commercial purpose, we provide Decorative Concrete Services, including Epoxy Flooring, Epoxy Garage Flooring, Metallic Epoxy Flooring, Polyaspartic Flooring, Concrete Polishing, Concrete Grinding, Acrylic Flooring, Micro topping, Concrete Staining, Concrete Sealing, Joint fill, and much more.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84496,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 990,
      "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": 1400,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "50249e42-4fd5-11ef-8344-b66e99367f32",
      "subdate": "Aug 01, 2024",
      "subcategory": "Epoxy Flooring",
      "request_types": "",
      "visitcount": 28
   },
   "visits": {
      "storefront": 28,
      "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": "Epoxy flooring",
      "service2": "Polyaspartic flooring",
      "service3": "Concrete staining",
      "service4": "Acrylic overlay",
      "service5": "Cool decking",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-08-01 07:11:47"
   },
   "location": {
      "uuid": "50249e42-4fd5-11ef-8344-b66e99367f32",
      "link_id": 333727,
      "account_id": 84496,
      "company": "https://www.thevalleycoatings.com/",
      "sid": 23,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85009",
      "address": "3744 West Roanoke Avenue, Suite 13",
      "phone": "+1 480-721-9753",
      "fax": null,
      "email": "thevalleycoatings@brite-mail.com",
      "name": "https://www.thevalleycoatings.com/",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.0151366",
      "lon": "71.5249154",
      "cityname": "Phoenix",
      "statename": "Arizona"
   },
   "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": ""
}