Houston Granite Guy

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336595,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://houstongraniteguy.com/",
      "title": "Houston Granite Guy",
      "description": "Since 2008, Houston Granite Guy (HGG) has been the trusted home remodeling expert in Houston, TX. We specialize in transforming kitchens with custom cabinets, kitchen islands, and premium countertops. Our bathroom renovations add luxury with tailored designs and high-quality materials. With over 20 years of experience, we handle every project with care and precision. Our commitment to excellence and glowing reviews make us the top choice for homeowners. Contact us today for a free quote.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87328,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "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": 5878,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1be2abd0-86db-11ef-ab46-b66e99367f32",
      "subdate": "Oct 10, 2024",
      "subcategory": "Renovations",
      "request_types": "",
      "visitcount": 13
   },
   "visits": {
      "storefront": 13,
      "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": "Since 2008, Houston Granite Guy (HGG) has been the trusted home remodeling expert in Houston, TX. We specialize in transforming kitchens with custom cabinets, kitchen islands, and premium countertops. Our bathroom renovations add luxury with tailored designs and high-quality materials. With over 20 years of experience, we handle every project with care and precision. Our commitment to excellence and glowing reviews make us the top choice for homeowners. Contact us today for a free quote.",
      "service1": "Countertop fabrication and installation",
      "service2": "Home remodeling",
      "service3": "Kitchen and bathroom remodeling",
      "service4": "Exterior remodeling",
      "service5": "Custom windows and doors",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-10 07:41:49"
   },
   "location": {
      "uuid": "1be2abd0-86db-11ef-ab46-b66e99367f32",
      "link_id": 336595,
      "account_id": 87328,
      "company": "Houston Granite Guy",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77090",
      "address": "16749 North Freeway, C",
      "phone": "281-377-3765",
      "fax": null,
      "email": "houstongranite@brite-email.com",
      "name": "Houston Granite Guy",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "30.01069",
      "lon": "-95.4292226",
      "cityname": "Houston",
      "statename": "Texas"
   },
   "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": ""
}