Brightwater Services Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327942,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://brightwaterservicesinc.com/",
      "title": "Brightwater Services Inc",
      "description": "When you''re searching for a dependable Palm Desert plumber or electrician, look no further than Brightwater Services Inc. We provide an array of essential services tailored to meet the unique demands of each customer in Palm Desert, California. From everyday plumbing fixes to critical electrical repairs - our experienced technicians handle general electrical services with ease, install cutting-edge EV charging stations, rectify bad circuits, carry out panel upgrades, ensure homes have automatic water shutoff systems, service water heaters, and clear out clogged drains effectively. As a full-service plumbing and electrical specialty company serving the vibrant Coachella Valley community since our inception in 2020, our aim is not simply fixing problems but ensuring that every aspect of your home''s infrastructure performs reliably for you and your family''s safety and peace of mind.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78789,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 22,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2325,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ffc44c0e-baad-11ee-8344-b66e99367f32",
      "subdate": "Jan 24, 2024",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 56
   },
   "visits": {
      "storefront": 56,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "General electrical services",
      "service2": "EV Charging stations",
      "service3": "Bad circuits",
      "service4": "Panel upgrades",
      "service5": "automatic water shutoff",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-24 11:44:57"
   },
   "location": {
      "uuid": "ffc44c0e-baad-11ee-8344-b66e99367f32",
      "link_id": 327942,
      "account_id": 78789,
      "company": "",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2325",
      "zip": "92211",
      "address": "75091 St Charles Pl Suite B",
      "phone": "7603411488",
      "fax": null,
      "email": "brightwaterservicesinc@outlook.com",
      "name": "Brightwater Services Inc",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.7455734",
      "lon": "-116.3538624",
      "cityname": "Palm Desert",
      "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": ""
}