Mike Diamond Plumbing, HVAC & Electrical

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349774,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "https://www.mikediamondservices.com/",
      "title": "Mike Diamond Plumbing, HVAC & Electrical",
      "description": "Mike Diamond Plumbing, HVAC & Electrical in Inglewood, CA offers expert plumbing, HVAC, electrical, heating, AC, and drain cleaning services across Los Angeles and Orange County. Known as the Smell Good Plumber™, we provide 24/7 reliable service with certified technicians.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100469,
      "approve_dt": "2025-08-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2049,
      "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": 4976,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9df71226-7dce-11f0-bb42-b66e99367f32",
      "subdate": "Aug 20, 2025",
      "subcategory": "Plumbing Contractor",
      "request_types": "",
      "visitcount": 29
   },
   "visits": {
      "storefront": 29,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mike Diamond Plumbing, HVAC & Electrical in Inglewood, CA, proudly serves Los Angeles, Orange County, and nearby areas with expert plumbing, HVAC, electrical, air conditioning, heating, and drain cleaning services. Known as the Smell Good Plumber™, Mike Diamond has delivered trusted service for over 40 years. Our certified technicians handle everything from plumbing emergencies to HVAC repairs with professionalism and care. Need a plumber or electrician near you? Call Mike Diamond Plumbing in Inglewood for reliable 24/7 service and top-quality results every time.\n",
      "service1": "Air Conditioning",
      "service2": "Furnace Repair",
      "service3": "Drainage Services",
      "service4": "Electrician",
      "service5": "HVAC",
      "service6": "Plumber",
      "service7": "",
      "submit_dt": "2025-08-20 14:04:41"
   },
   "location": {
      "uuid": "9df71226-7dce-11f0-bb42-b66e99367f32",
      "link_id": 349774,
      "account_id": 100469,
      "company": "Mike D",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2049",
      "zip": "90301",
      "address": "8295 S. La Cienega Blvd",
      "phone": "310-775-2743",
      "fax": null,
      "email": "mikediamondi@hotmail.com",
      "name": "Mike Diamond Plumbing, HVAC & Electrical | Inglewood, CA",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Inglewood",
      "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": ""
}