Paving the Way in the Great Northwest

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 351956,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://leggettasphalt.com",
      "title": "Paving the Way in the Great Northwest",
      "description": "Leggett Asphalt Inc provides expert paving services to customers throughout Sherwood as well as Portland and the surrounding cities. We are able to install and repair asphalt surfaces including driveways, roads and parking lots.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 102685,
      "approve_dt": "2026-03-03T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-03-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18659,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "2193e686-1726-11f1-bb42-b66e99367f32",
      "subdate": "Mar 03, 2026",
      "subcategory": "Paving",
      "request_types": "",
      "visitcount": 3
   },
   "visits": {
      "storefront": 3,
      "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": "Leggett Asphalt Inc has years of professional experience in the Portland area paving asphalt surfaces for residents and business owners. We properly prepare the work area prior to paving to ensure the durability and functionality of the finished project. We pave private roads, driveways, parking lots and more. Our crews can also install retaining walls if necessary.",
      "service1": "Asphalt Paving",
      "service2": "Curbing",
      "service3": "Retaining Walls",
      "service4": "Seal Coating",
      "service5": "Crack Filling",
      "service6": "Asphalt Patching",
      "service7": "Driveway Paving",
      "submit_dt": "2026-03-03 17:26:36"
   },
   "location": {
      "uuid": "2193e686-1726-11f1-bb42-b66e99367f32",
      "link_id": 351956,
      "account_id": 102685,
      "company": "Scot Leggett",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18659",
      "zip": "97210",
      "address": "1157 NW 23rd Ave",
      "phone": "(503) 869-6316",
      "fax": null,
      "email": "leggett.asphalt.or@gmail.com",
      "name": "Paving the Way in the Great Northwest",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Portland",
      "statename": "Oregon"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}