Hamilton Heat and Air

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337542,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://www.hamiltonheatandair.com/",
      "title": "Hamilton Heat and Air",
      "description": "Danny has multiple years of experience and training in the industry. Danny's long-term goal has always been to open his own Heating and Air company where he can build his reputation by incorporating his personal values of integrity, dependability, and quality service at affordable prices.\r\n\r\nThrough diligent work and commitment to customer satisfaction, Danny has established himself as a leader in the industry.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88267,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-31T00: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": 35,
      "city_id": 18376,
      "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": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fdf08618-9728-11ef-ab46-b66e99367f32",
      "subdate": "Oct 31, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-31 01:39:39"
   },
   "location": {
      "uuid": "fdf08618-9728-11ef-ab46-b66e99367f32",
      "link_id": 337542,
      "account_id": 88267,
      "company": "Hamilton Heat and Air",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "18376",
      "zip": "74133",
      "address": "9246 South Sheridan Road, Suite 211",
      "phone": "+1 918-576-6835",
      "fax": null,
      "email": "hamiltonheatandair@brite-mail.com",
      "name": "Hamilton Heat and Air",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "36.0287739",
      "lon": "-95.9056859",
      "cityname": "Tulsa",
      "statename": "Oklahoma"
   },
   "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": ""
}