AZ Stone & Tile Concepts

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346399,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://azstoneandtileconcepts.com/",
      "title": "AZ Stone & Tile Concepts",
      "description": "AZ Stone %38 Tile Concepts is a trusted contractor specializing in custom home, kitchen, and bathroom remodels throughout the Phoenix Valley. The company is committed to turning client visions into reality through integrity, clear communication, collaboration, and quality craftsmanship. With expertise in both aesthetic design and functional enhancement, they offer solutions ranging from sleek modern styles to timeless classic touches, featuring their signature 3-week kitchen installation process that sets them apart in the remodeling industry.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97094,
      "approve_dt": "2025-08-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "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": 288,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7e59e786-2983-11f0-a909-b66e99367f32",
      "subdate": "May 05, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are licensed, bonded, and insured and have over 25 years of experience. Our dedicated team is here to accompany you every step of the way, and our goal is to provide you with a smooth and affordable kitchen, bathroom, or home remodeling project.",
      "service1": "custom kitchen remodeling",
      "service2": " bathroom renovation projects",
      "service3": " home remodeling services",
      "service4": " stone and tile installation",
      "service5": " rapid 3-week kitchen installs",
      "service6": " design consultation and planning",
      "service7": " custom countertop fabrication",
      "submit_dt": "2025-05-05 07:35:18"
   },
   "location": {
      "uuid": "7e59e786-2983-11f0-a909-b66e99367f32",
      "link_id": 346399,
      "account_id": 97094,
      "company": "AZ Stone & Tile Concepts",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85048",
      "address": "4106 East Windsong Drive",
      "phone": "+1 480-466-2761",
      "fax": null,
      "email": "azstoneandtileconcepts@mail-burst.com",
      "name": "AZ Stone & Tile Concepts",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.2953378",
      "lon": "-111.9943904",
      "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": ""
}