SCE

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336046,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.sceunderground.com",
      "title": "SCE",
      "description": "SCE specializes in Land clearing, Demolition, Earth work, and utility Contruction. At SCE we are committed to delivering exceptional service to our clients. We prioritize safety, efficiency, environmental sustainability in everything we do by using the latest and most advanced practices specialized equipment and always training our staff on the newest technology to give us the edge on any project. Our Team of Professionals is dedicated ensuring that every project is completed to the highest standards while still adhering to strict schedules and meeting Budget.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86787,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3739,
      "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": 5864,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "380650f1-7de9-11ef-ab46-b66e99367f32",
      "subdate": "Sep 28, 2024",
      "subcategory": "Home Cleaners",
      "request_types": "",
      "visitcount": 11
   },
   "visits": {
      "storefront": 11,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "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-09-28 22:30:09"
   },
   "location": {
      "uuid": "380650f1-7de9-11ef-ab46-b66e99367f32",
      "link_id": 336046,
      "account_id": 86787,
      "company": "SCE",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3739",
      "zip": "33187",
      "address": "MIAMI FL, Miami, FL 33187",
      "phone": "",
      "fax": null,
      "email": "ybj4cQIx.directory@usestyle.ai",
      "name": "SCE",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "25.5994424",
      "lon": "-80.4660256",
      "cityname": "Miami",
      "statename": "Florida"
   },
   "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": ""
}