Charleston Deck Crafters

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349458,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://deckbuilderscharleston.com/",
      "title": "Charleston Deck Crafters",
      "description": "Charleston Deck Crafters specializes in custom deck construction, repair, and maintenance across Charleston, SC. Offering services like power washing, staining, and sealing, they ensure durable and aesthetically pleasing outdoor spaces. With a commitment to quality craftsmanship and customer satisfaction, they transform backyards into beautiful retreats.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100153,
      "approve_dt": "2025-07-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-18T00: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": 39,
      "city_id": 20231,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9e4990f9-639a-11f0-a909-b66e99367f32",
      "subdate": "Jul 18, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 50
   },
   "visits": {
      "storefront": 50,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 24,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Charleston Deck Crafters is dedicated to providing the highest level of service and value in designing beautiful outdoor living spaces. Our trained professionals treat your home like our own, focusing on superior craftsmanship and attention to detail in every project, backed by unbeatable warranties and years of industry expertise.",
      "service1": "Custom Deck Construction",
      "service2": " Landscape Design Services",
      "service3": " Walkway Deck Installation",
      "service4": " Patio Construction",
      "service5": " Pool Deck Building",
      "service6": " Outdoor Living Space Design",
      "service7": " Deck Maintenance and Repair",
      "submit_dt": "2025-07-18 05:46:58"
   },
   "location": {
      "uuid": "9e4990f9-639a-11f0-a909-b66e99367f32",
      "link_id": 349458,
      "account_id": 100153,
      "company": "Charleston  Deck Crafters",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20231",
      "zip": "29407",
      "address": "2031 Sam Rittenberg Blvd,",
      "phone": "843-938-1413",
      "fax": null,
      "email": "Charlestondeckcrafters2025@outlook.com",
      "name": "Charleston Deck Crafters",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Charleston",
      "statename": "South Carolina"
   },
   "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": ""
}