Palmetto Hot Tubs and Pool Tables Columbia SC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 312736,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://palmetto1.com/",
      "title": "Palmetto Hot Tubs and Pool Tables Columbia SC",
      "description": "Palmetto Hot Tubs and Pool Tables is a family owned and operated business since 1989 in South Carolina.  We Specialize in Hot Tubs and Pool Table Sales. We are the dealer for Sundance Hot Tub, Signature Spas and Jacuzzi Hot Tubs in Columbia SC. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 63968,
      "approve_dt": "2017-01-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2016-10-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1578,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20245,
      "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": 5844,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "95577688-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 25, 2016",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 1893
   },
   "visits": {
      "storefront": 1893,
      "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": "Palmetto Hot Tubs and Pool Tables is a family owned and operated business since 1989 in South Carolina. We Specialize in Hot Tubs and Pool Table Sales. We are the dealer for Sundance Hot Tub, Signature Spas and Jacuzzi Hot Tubs in Columbia SC. We also sell Brunswick Billiards Pool Tables. We service all Pool Tables and the Brands of Hot Tubs we sell. We sell and deliver to the entire Columbia and Charleston market.\n

\nEstablished in 1989, Palmetto has managed to build a reputation for providing the best hot tubs and Spas in Charleston and Columbia. Moreover, we also have a host of other products such as pool tables, billiard tables, shuffleboards, ping pong tables and more. Our focus on quality has allowed us to not only experience growth, we’re also the number one choice for people who’re looking for hot tubs for sale in Charleston and Columbia.\n

\nKeeping the needs and wants of your family in mind, we make sure that all our products, our hot tubs in particular, can cater to not just your family size but also your personal style and are the perfect way for you to relax and unwind with your hectic schedule.\n

\nWe have successfully been providing stellar quality hot tubs for sale in Charleston and Columbia as well as pool tables and other services for more than 20 years now. ",
      "service1": "Ping Pong Tables",
      "service2": "Shuffleboards",
      "service3": "Billiards Tables",
      "service4": "Pool Tables",
      "service5": "Hot Tubs",
      "service6": "",
      "service7": "",
      "submit_dt": "2016-10-25 08:12:02"
   },
   "location": {
      "uuid": "95577688-56da-11ed-b77c-b66e99367f32",
      "link_id": 312736,
      "account_id": 63968,
      "company": "Palmetto Hot Tubs and Pool Tables",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20245",
      "zip": "29209",
      "address": "7408 Garners Ferry Rd",
      "phone": "(803) 764-1136",
      "fax": null,
      "email": "palmettohottubs2@gmail.com",
      "name": "Palmetto Hot Tubs and Pool Tables",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.9690155",
      "lon": "-80.9460924",
      "cityname": "Columbia",
      "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": ""
}