Halo Overhead Doors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336050,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.houstonoverheaddoor.com/",
      "title": "Halo Overhead Doors",
      "description": "We’ve proudly been a locally operated overhead door company in Houston since 1991. We continue to expand our product selections and services to meet our customers’ needs best as we grow.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86791,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-29T00: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": 5860,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1e342419-7e48-11ef-ab46-b66e99367f32",
      "subdate": "Sep 29, 2024",
      "subcategory": "Garage Door",
      "request_types": "",
      "visitcount": 16
   },
   "visits": {
      "storefront": 16,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Nestled in the bustling city of Houston, TX, Halo Overhead Doors takes pride in offering top-tier residential garage doors to discerning homeowners. Since our inception, we have prioritized customer satisfaction by presenting an extensive range of options that cater to various preferences and needs. Our showroom serves as the ideal venue for clients to discover an assortment of overhead door Houston solutions from respected manufacturers known for their commitment to quality. Committed to excellence, our team at Halo Overhead Doors provides comprehensive support ensuring that every client finds a garage door that not only meets their expectations but also enhances their home's security and aesthetic appeal. We focus on delivering personalized services tailored to each homeowner's unique demands while maintaining unwavering standards of professionalism and craftsmanship in every project we undertake.\r
\r
- Company Hours: Monday to Saturday: 07:00-18:00 | Sunday: Closed",
      "service1": "Residential Garage Doors",
      "service2": "Commercial & Industrial Sectional Doors",
      "service3": "Commercial & Industrial Rolling Doors",
      "service4": "Commercial & Industrial Grilles",
      "service5": "Automatic Entry Doors",
      "service6": "Garage Door Repair",
      "service7": "Garage Door Openers",
      "submit_dt": "2024-09-29 09:49:28"
   },
   "location": {
      "uuid": "1e342419-7e48-11ef-ab46-b66e99367f32",
      "link_id": 336050,
      "account_id": 86791,
      "company": "Halo Overhead Doors",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77066",
      "address": "6631 Theall Rd",
      "phone": "(713) 338-0210",
      "fax": null,
      "email": "houstonoverheaddoor@outlook.com",
      "name": "Halo Overhead Doors",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.9647506",
      "lon": "-95.5220099",
      "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": ""
}