Mcfarlanes Asphalt

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331837,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://mcfarlanesasphalt.com",
      "title": "Mcfarlanes Asphalt",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82628,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 13,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 14194,
      "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": 6475,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "077c84bb-2c43-11ef-8344-b66e99367f32",
      "subdate": "Jun 17, 2024",
      "subcategory": "Paving",
      "request_types": "",
      "visitcount": 74
   },
   "visits": {
      "storefront": 74,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "\"Are you searching for an asphalt paving contractor? Searching for an asphalt paving contractor in Oakland, NJ who can provide you with reliable service and affordable prices? If so, you should not look any further than McFarlanes Asphalt Driveway Paving. They are a family-owned and operated business that has a long history of serving the residents and businesses of Bergen County since 1959.\"",
      "service1": "Asphalt driveways",
      "service2": "Paving stone driveways and Patio's",
      "service3": "Concrete Sidewalks",
      "service4": "Asphalt Parking lots",
      "service5": "Belgian block curbing",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-17 00:46:27"
   },
   "location": {
      "uuid": "077c84bb-2c43-11ef-8344-b66e99367f32",
      "link_id": 331837,
      "account_id": 82628,
      "company": "Mcfarlanes Asphalt",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "14194",
      "zip": "07436",
      "address": "350 W Oakland Ave",
      "phone": "201-300-7861",
      "fax": null,
      "email": "mcfarlanesasphalt@burst-email.com",
      "name": "Mcfarlanes Asphalt",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.0193697",
      "lon": "-74.2645276",
      "cityname": "Oakland",
      "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": ""
}