Alex & Bros Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332872,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.alexandbrosplumbing.com/",
      "title": "Alex & Bros Plumbing",
      "description": "Alex & Bros Plumbing, spearheaded by experienced plumber Alex, is your trusted solution for all plumbing needs in [Location]. With over 6 years of industry expertise, we specialize in comprehensive plumbing services including plumbing repairs, drain cleaning, leak detection and repair, and fixture installation for faucets, sinks, and toilets. Our skilled team also excels in water heater installation and repair, pipe repair and replacement, and sewer line services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83651,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 9,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 988,
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "33f8e9c2-3f56-11ef-8344-b66e99367f32",
      "subdate": "Jul 11, 2024",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 38
   },
   "visits": {
      "storefront": 38,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Alex&Bros Plumbing, spearheaded by experienced plumber Alex, is your trusted solution for all plumbing needs in [Location]. With over 6 years of industry expertise, we specialize in comprehensive plumbing services including plumbing repairs, drain cleaning, leak detection and repair, and fixture installation for faucets, sinks, and toilets. Our skilled team also excels in water heater installation and repair, pipe repair and replacement, and sewer line services.",
      "service1": "Plumbing Repairs",
      "service2": "Drain Cleaning",
      "service3": "Leak Detection and Repair",
      "service4": "Emergency Plumbing Services",
      "service5": "Water Heater Installation and Repair",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-11 07:21:34"
   },
   "location": {
      "uuid": "33f8e9c2-3f56-11ef-8344-b66e99367f32",
      "link_id": 332872,
      "account_id": 83651,
      "company": "",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "988",
      "zip": "85381",
      "address": "7162 West Rue De Lamour",
      "phone": "480-349-5386",
      "fax": null,
      "email": "alexnbrosplumbing@brite-post.com",
      "name": "Alex & Bros Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.1986394",
      "lon": "72.0404293",
      "cityname": "Peoria",
      "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": ""
}