Mr Electric Of Tucson

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332023,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://mrelectric.com/tucson-southern-az",
      "title": "Mr Electric Of Tucson",
      "description": "Mr Electric of Tucson provides expert electrical services to residential and commercial customers in and near Tucson, Oro Valley, Marana, Casas Adobes, Catalina Foothills, Tanque Verde, Sahuarita, Vail, and surrounding communities. The electricians at Mr Electric of Tucson have been background checked and trained to be true electrical service professionals. With free estimates, upfront pricing, and background-checked electricians, there are never any surprises with Mr Electric of Tucson.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82812,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-19T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 19,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1070,
      "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": 5854,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fedfe004-2e45-11ef-8344-b66e99367f32",
      "subdate": "Jun 19, 2024",
      "subcategory": "Electricians",
      "request_types": "",
      "visitcount": 84
   },
   "visits": {
      "storefront": 84,
      "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": "Mr Electric of Tucson provides expert electrical services to residential and commercial customers in and near Tucson, Oro Valley, Marana, Casas Adobes, Catalina Foothills, Tanque Verde, Sahuarita, Vail, and surrounding communities. The electricians at Mr Electric of Tucson have been background checked and trained to be true electrical service professionals. With free estimates, upfront pricing, and background-checked electricians, there are never any surprises with Mr Electric of Tucson.",
      "service1": "Electrician Services",
      "service2": "Electrical Installation Services",
      "service3": "Electrical Repair Services",
      "service4": "Electrical Outlet and Switch Replacement",
      "service5": "Electrical Panel Repair, Installation, and Upgrade",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-19 14:12:43"
   },
   "location": {
      "uuid": "fedfe004-2e45-11ef-8344-b66e99367f32",
      "link_id": 332023,
      "account_id": 82812,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1070",
      "zip": "85710",
      "address": "8230 E Broadway Blvd, Ste E3",
      "phone": "(520) 795-5940",
      "fax": null,
      "email": "mrelectrictucsaz@brite-post.com",
      "name": "Mr Electric Of Tucson",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.0390116",
      "lon": "41.9631954",
      "cityname": "Tucson",
      "statename": "Arizona"
   },
   "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": ""
}