Charleston Piano Transport

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349265,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://pianomoverscharleston.com/",
      "title": "Charleston Piano Transport",
      "description": "Charleston Piano Transport is a premier piano moving service based in Charleston, South Carolina, dedicated to the safe and efficient relocation of pianos. Serving Charleston, North Charleston, and Summerville, they specialize in moving upright, grand, and baby grand pianos. Their comprehensive services include detailed assessments, custom crating, climate-controlled transportation, and meticulous placement and setup at the destination. The team is adept at navigating the unique challenges of the region's historic architecture and tight spaces, ensuring both the instrument and property are protected throughout the move. Whether relocating a family heirloom or preparing for a concert, Charleston Piano Transport combines technical expertise with a passion for music to deliver unparalleled service",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99960,
      "approve_dt": "2025-07-05T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-05T00: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": 5874,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "73fc7e9c-59b6-11f0-a909-b66e99367f32",
      "subdate": "Jul 05, 2025",
      "subcategory": "Movers",
      "request_types": "",
      "visitcount": 46
   },
   "visits": {
      "storefront": 46,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 22,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Charleston Piano Transport is a premier piano moving service based in Charleston, South Carolina, dedicated to the safe and efficient relocation of pianos. Serving Charleston, North Charleston, and Summerville, they specialize in moving upright, grand, and baby grand pianos. Their comprehensive services include detailed assessments, custom crating, climate-controlled transportation, and meticulous placement and setup at the destination. The team is adept at navigating the unique challenges of the region's historic architecture and tight spaces, ensuring both the instrument and property are protected throughout the move. Whether relocating a family heirloom or preparing for a concert, Charleston Piano Transport combines technical expertise with a passion for music to deliver unparalleled service.",
      "service1": "Upright Piano Moving",
      "service2": " Grand Piano Moving",
      "service3": " Baby Grand Piano Moving",
      "service4": " Detailed Moving Assessments",
      "service5": " Custom Crating",
      "service6": " Climate-Controlled Transportation",
      "service7": " Piano Placement & Setup",
      "submit_dt": "2025-07-05 15:41:01"
   },
   "location": {
      "uuid": "73fc7e9c-59b6-11f0-a909-b66e99367f32",
      "link_id": 349265,
      "account_id": 99960,
      "company": "Charleston  Piano",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20231",
      "zip": "29407",
      "address": "1835 Savage Rd, ",
      "phone": "8434273999",
      "fax": null,
      "email": "Charlestonpianotransport1@outlook.com",
      "name": "Charleston Piano Transport",
      "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": ""
}