Granite Expo – Emeryville

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347154,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://thegraniteexpo.com/",
      "title": "Granite Expo – Emeryville",
      "description": "Granite Expo is a trusted California-based home improvement company proudly serving the Bay Area since 1999. With ten distributor locations including San Jose, we offer top-quality kitchen cabinets, countertops, bathroom vanities, flooring, and tiles. Our selection includes quartz, granite, and marble surfaces perfect for stylish and durable kitchens and bathrooms. Homeowners, contractors, and developers rely on us for our huge in-stock inventory, low everyday pricing, and professional design team.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97849,
      "approve_dt": "2025-07-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-19T00: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": 1917,
      "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": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f3e8e461-3494-11f0-a909-b66e99367f32",
      "subdate": "May 19, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 12
   },
   "visits": {
      "storefront": 12,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Granite Expo is a leading California home improvement corporation serving the Bay Area since 1999, recognized throughout Northern California as a premier distributor of high-quality home improvement products. We exclusively distribute Kovastone® quartz countertops and Milzen Cabinetry®, specializing in kitchen and bathroom renovations for homeowners, contractors, and developers seeking sophisticated, durable, and beautiful materials.",
      "service1": "quartz countertop installation and distribution",
      "service2": " custom cabinetry design and installation",
      "service3": " kitchen renovation services",
      "service4": " bathroom remodeling solutions",
      "service5": " home improvement product distribution",
      "service6": " contractor and developer supply services",
      "service7": " design consultation and catalog services",
      "submit_dt": "2025-05-19 09:38:00"
   },
   "location": {
      "uuid": "f3e8e461-3494-11f0-a909-b66e99367f32",
      "link_id": 347154,
      "account_id": 97849,
      "company": "Granite Expo – Emeryville",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1917",
      "zip": "94608",
      "address": "1368 40th St, Emeryville, CA 94608 USA",
      "phone": "510-652-8882",
      "fax": null,
      "email": "thegraniteexpo1@gmail.com",
      "name": "Granite Expo – Emeryville",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.830002",
      "lon": "-122.2858296",
      "cityname": "Emeryville",
      "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": ""
}