General contractor

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344797,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.stonecreekbackyards.com/",
      "title": "General contractor",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95492,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-04-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 48,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 14143,
      "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": 5190,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "6cff74c9-1147-11f0-a909-b66e99367f32",
      "subdate": "Apr 04, 2025",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 95
   },
   "visits": {
      "storefront": 95,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Stone Creek Landscape Construction transforms backyards into outdoor oases. Established in 2012, this family-owned business specializes in excavation and tree and shrub planting services while also offering landscape design, fence installation, landscape lighting, and overall landscape installation. As a trusted hardscape and drainage contractor, they handle residential projects throughout Northern New Jersey. They serve Morris County (including Morristown, Randolph, Chester, Madison, Chatham, Long Valley, New Vernon, Morris Plains, Dover, Florham Park, Parsippany-Troy Hills, Mount Olive, Boonton), Somerset County (Bernardsville, Bedminster, Peapack-Gladstone), Summit, Livingston, West Caldwell, Hackettstown, and beyond.",
      "service1": "excavating contractor",
      "service2": "tree and shrub planting",
      "service3": "landscape lighting",
      "service4": "drainage contractor",
      "service5": "landscape installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-04 11:24:51"
   },
   "location": {
      "uuid": "6cff74c9-1147-11f0-a909-b66e99367f32",
      "link_id": 344797,
      "account_id": 95492,
      "company": "Stone Creek Landscape Construction",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "14143",
      "zip": "07945",
      "address": "8 Combs Hollow Road",
      "phone": "+1 973-997-2147",
      "fax": null,
      "email": "stonecreekb@brite-mail.com",
      "name": "Stone Creek Landscape Construction",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.8062521",
      "lon": "-74.6084231",
      "cityname": "Mendham",
      "statename": "New Jersey"
   },
   "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": ""
}