Excavation

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330984,
      "site_id": 68,
      "cat_id": 79,
      "priority": 2,
      "url": "https://nyexcavation.com/",
      "title": "Excavation",
      "description": "NY Excavation & Reliable Contracting is a New York-based excavation and construction company that specializes in providing a wide range of services to residential and commercial clients. Our services include excavation, site preparation, demolition, foundation work, and general contracting. The company has been in business for over 20 years and has built a strong reputation for delivering high-quality workmanship and exceptional customer service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81785,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 23,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 0,
      "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": 5141,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "beb752d9-16a3-11ef-8344-b66e99367f32",
      "subdate": "May 20, 2024",
      "subcategory": "Swimming Pool Cleaning Service",
      "request_types": "",
      "visitcount": 70
   },
   "visits": {
      "storefront": 70,
      "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": "NY Excavation&Reliable Contracting is a New York-based excavation and construction company that specializes in providing a wide range of services to residential and commercial clients. Our services include excavation, site preparation, demolition, foundation work, and general contracting. The company has been in business for over 20 years and has built a strong reputation for delivering high-quality workmanship and exceptional customer service.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-20 12:23:21"
   },
   "location": {
      "uuid": "beb752d9-16a3-11ef-8344-b66e99367f32",
      "link_id": 330984,
      "account_id": 81785,
      "company": "NY Excavation",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "",
      "zip": "11743",
      "address": "Excavation Services 1160 E. Jericho Turnpike Huntington NY ",
      "phone": "631-499-4330",
      "fax": null,
      "email": "nyexcavation@gmail.com",
      "name": "NY Excavation",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.8335151",
      "lon": "-73.3649593"
   },
   "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": ""
}