One Hour Heating & Air Conditioning

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 342034,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.onehourheatandair.com/ramsey/",
      "title": "One Hour Heating & Air Conditioning",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 92727,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11415,
      "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": 4218,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "62dbe8a1-e466-11ef-a909-b66e99367f32",
      "subdate": "Feb 06, 2025",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 42
   },
   "visits": {
      "storefront": 42,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Northern's One Hour Heating & Air Conditioning is located in Ramsey, MN, serving Minneapolis and surrounding area. When you purchase our services, not only do you receive the peace of mind the technician entering your home is background checked & drug tested, but they're skilled, trained, and experienced as well. Call us today to schedule HVAC repair, installation or maintenance services in Ramsey!",
      "service1": "HVAC Installation & Replacement",
      "service2": "HVAC Repairs",
      "service3": "IAQ Services",
      "service4": "Furnace Replacement",
      "service5": "AC Maintenance",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-02-06 08:43:06"
   },
   "location": {
      "uuid": "62dbe8a1-e466-11ef-a909-b66e99367f32",
      "link_id": 342034,
      "account_id": 92727,
      "company": "One Hour Heating & Air Conditioning",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11415",
      "zip": "55303",
      "address": "9431 Alpine Dr, Suite A5303",
      "phone": "763-314-1330",
      "fax": null,
      "email": "onehourheatandair@burst-email.com",
      "name": "One Hour Heating & Air Conditioning",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.2514922",
      "lon": "-93.5093097",
      "cityname": "Ramsey",
      "statename": "Minnesota"
   },
   "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": ""
}