Super Brothers Plumbing, Heating and Air

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331362,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://superbrothers.com/",
      "title": "Super Brothers Plumbing, Heating and Air",
      "description": "We are Super Brothers Plumbing Heating & Air Contractor specializing in providing top-quality plumbing and HVAC services for both residential and commercial properties. We work directly with reputable companies, including SMUD, Home Depot, PG&E, Aquasana, Rheem, Ferguson, Bradford White, Trane, and Roseville Electric, to offer our customers exclusive benefits such as instant rebates and contractor discounts on all our plumbing and HVAC services. We honor all of our labor warranties and call-back",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82157,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 31,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1791,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3cd75fd8-1f2a-11ef-8344-b66e99367f32",
      "subdate": "May 31, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 105
   },
   "visits": {
      "storefront": 105,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "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-05-31 08:46:14"
   },
   "location": {
      "uuid": "3cd75fd8-1f2a-11ef-8344-b66e99367f32",
      "link_id": 331362,
      "account_id": 82157,
      "company": "",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1791",
      "zip": "95621",
      "address": "7475 Kanai Ave",
      "phone": "(916) 249-1822",
      "fax": null,
      "email": "superbrothersc@mail-burst.com",
      "name": "Super Brothers Plumbing, Heating and Air",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.7017276",
      "lon": "-121.2913881",
      "cityname": "Citrus Heights",
      "statename": "California"
   },
   "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": ""
}