American Surface Restoration (ASR California)

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335776,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.asrcalifornia.com",
      "title": "American Surface Restoration (ASR California)",
      "description": "ASR California is your premier surface restoration company in Northern California, known for ''Quality & Integrity Beyond Reproach.'' We specialize in exceptional power washing, sandblasting, floor preparation, and the expert application of industrial coatings, epoxy flooring, walls, and ceilings and waterproofing concrete. Serving cities including Auburn, Grass Valley, Roseville, Sacramento, Stockton, Modesto, and the Bay Area, our skilled team leverages cutting-edge techniques to transform and revitalize a wide range of surfaces. Trust ASR California for all your surface restoration and industrial coating needs.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86519,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-23T00: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": 5,
      "city_id": 1988,
      "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": 289,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f22d95e2-79ec-11ef-ab46-b66e99367f32",
      "subdate": "Sep 23, 2024",
      "subcategory": "Insurance",
      "request_types": "",
      "visitcount": 8
   },
   "visits": {
      "storefront": 8,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "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-09-23 20:46:45"
   },
   "location": {
      "uuid": "f22d95e2-79ec-11ef-ab46-b66e99367f32",
      "link_id": 335776,
      "account_id": 86519,
      "company": "American Surface Restoration (ASR California)",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1988",
      "zip": "95949",
      "address": "18900 wolf creek road, grass valley, CA 95949",
      "phone": "5305887000",
      "fax": null,
      "email": "AxdF7jnv.directory@usestyle.ai",
      "name": "American Surface Restoration (ASR California)",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.111444",
      "lon": "-121.033954",
      "cityname": "Grass Valley",
      "statename": "California"
   },
   "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": ""
}