Charleston Paving Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349374,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://drivewaypavingcharleston.com/",
      "title": "Charleston Paving Solutions",
      "description": "Charleston Paving Solutions is a trusted paving contractor serving Charleston, North Charleston, and Summerville, SC. With over 30 years of combined experience, they specialize in asphalt driveway paving, repair, and decorative concrete solutions, offering free estimates and top-tier craftsmanship.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100069,
      "approve_dt": "2025-07-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-13T00: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": 38,
      "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": 6475,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0591550f-5f9f-11f0-a909-b66e99367f32",
      "subdate": "Jul 13, 2025",
      "subcategory": "Paving",
      "request_types": "",
      "visitcount": 59
   },
   "visits": {
      "storefront": 59,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Driveway Paving Charleston SC\nPaving your driveway is an excellent investment in your property because it increases value, enhances aesthetic appeal, and improves safety around your home. Our experienced team offers exceptional driveway paving Charleston SC residents prefer, working with homeowners, rental property owners, and contractors throughout the area. We provide premier services at competitive prices while maintaining the highest standards of artistry in the industry. With a wide range of colors, designs, and styles available, we ensure every customer can select an option that perfectly aligns with their home's exterior design.\n",
      "service1": "paving company charleston sc",
      "service2": "asphalt paving charleston",
      "service3": "driveway repair charleston sc",
      "service4": "asphalt paving charleston sc",
      "service5": "driveway paving charleston sc",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-07-13 04:08:24"
   },
   "location": {
      "uuid": "0591550f-5f9f-11f0-a909-b66e99367f32",
      "link_id": 349374,
      "account_id": 100069,
      "company": "Charleston  Paving",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 38,
      "city": "0",
      "zip": "29407",
      "address": "874 Orleans Rd, Charleston, SC",
      "phone": "8437382496",
      "fax": null,
      "email": "charlestonpavingsolu@outlook.com",
      "name": "Charleston Paving Solutions",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "",
      "statename": ""
   },
   "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": ""
}