Full House Remodeling Houston TX

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317657,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://fullhouse-remodeling.com",
      "title": "Full House Remodeling Houston TX",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68855,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-08-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 173,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "ltop": "",
      "facebook": "https://www.facebook.com/fullhouseremodeling/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/full_remodeling",
      "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": 4186,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9570eaf8-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 24, 2019",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 265
   },
   "visits": {
      "storefront": 265,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Welcome to Full House Remodeling in Houston TX, a home improvement and full service roofing company that offers high quality services to maintain the well-being of our consumers and resolves their household needs. We focus on fixing, installing, and remodeling gutters, windows, roofs, bathrooms, kitchen, patio, flowing, landscape, and a lot more. We only use the greatest quality materials and work with the best people who are licensed and highly trained in taking care of any type of home remodeling services. As a company with years of experience in the business, we strive to offer competent and budget-friendly home remodeling services throughout Houston, Texas by following the highest standards of service and preserving the credibility we created through time.",
      "service1": "remodeling contractors",
      "service2": "general contractor",
      "service3": "kitchen remodeling",
      "service4": "bathroom remodeling",
      "service5": "home remodeling",
      "service6": "remodeling",
      "service7": "",
      "submit_dt": "2019-08-24 07:40:01"
   },
   "location": {
      "uuid": "9570eaf8-56da-11ed-b77c-b66e99367f32",
      "link_id": 317657,
      "account_id": 68855,
      "company": "Full House Remodeling Houston TX",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77035",
      "address": "6002 Duxbury St",
      "phone": "(713) 842-9569",
      "fax": null,
      "email": "fullhouseremodelingtx@gmail.com",
      "name": "Full House Remodeling Houston TX",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.6479975",
      "lon": "-95.4959908",
      "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": ""
}