Asphalt Paving & Sealing of Fredericksburg

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316873,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "http://fredericksburgpavingsealcoat.com/",
      "title": "Asphalt Paving & Sealing of Fredericksburg",
      "description": "Our asphalt paving and sealing company prides itself on outstanding customer service and unsurpassed quality of work. We care for our customers and make sure to give the best possible price at the time of estimate. Asphalt Paving & Sealing of Fredericksburg is your trusted neighbor and contractor that will go above and beyond for your property whether residential or commercial, big or small. We work with asphalt on the following: paving, sealcoating, parking lot striping, repairs, pothole work, resurfacing and much more. We service all of Fredericksburg, VA and surrounding areas! Call today for your free estimate.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68070,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-04-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 156,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23283,
      "ltop": "",
      "facebook": "https://www.facebook.com/Asphalt-Paving-Sealing-of-Fredericksburg-2345964162088601/",
      "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": 5209,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956c9fda-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 05, 2019",
      "subcategory": "Concrete Landscaping",
      "request_types": "",
      "visitcount": 190
   },
   "visits": {
      "storefront": 190,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Our asphalt paving and sealing company prides itself on outstanding customer service and unsurpassed quality of work. We care for our customers and make sure to give the best possible price at the time of estimate. Asphalt Paving & Sealing of Fredericksburg is your trusted neighbor and contractor that will go above and beyond for your property whether residential or commercial, big or small. We work with asphalt on the following: paving, sealcoating, parking lot striping, repairs, pothole work, resurfacing and much more. We service all of Fredericksburg, VA and surrounding areas! Call today for your free estimate.",
      "service1": "Paving",
      "service2": "Seal Coating",
      "service3": "Asphalt paving",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-04-05 13:52:32"
   },
   "location": {
      "uuid": "956c9fda-56da-11ed-b77c-b66e99367f32",
      "link_id": 316873,
      "account_id": 68070,
      "company": "Asphalt Paving & Sealing of Fredericksburg",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23283",
      "zip": "22401",
      "address": "523 George St",
      "phone": "5403170814",
      "fax": null,
      "email": "leo@oceansofpets.com",
      "name": "Asphalt Paving & Sealing of Fredericksburg",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.3012892",
      "lon": "-77.4631834",
      "cityname": "Fredericksburg",
      "statename": "Virginia"
   },
   "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": ""
}