Palmetto Hot Tubs & Pool Tables in South Carolina

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 312745,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.palmetto1.com",
      "title": "Palmetto Hot Tubs & Pool Tables in South Carolina",
      "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. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 63977,
      "approve_dt": "2016-10-31T00:00:00.000Z",
      "source": null,
      "submit_dt": "2016-10-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1762,
      "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": 5844,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "955782ee-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 28, 2016",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 2074
   },
   "visits": {
      "storefront": 2074,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "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. 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.",
      "service1": "Palmetto Hot Tubs",
      "service2": " Sundance Hot Tub",
      "service3": " Signature Spas",
      "service4": " Jacuzzi Hot Tubs",
      "service5": " Brunswick Billiards Tables",
      "service6": " Ping Pong Tables",
      "service7": " Shuffleboards",
      "submit_dt": "2016-10-28 04:47:50"
   },
   "location": {
      "uuid": "955782ee-56da-11ed-b77c-b66e99367f32",
      "link_id": 312745,
      "account_id": 63977,
      "company": "Palmetto Hot Tubs and Pool Tables",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20231",
      "zip": "29407",
      "address": "1401 Sam Rittenberg Blvd",
      "phone": "",
      "fax": null,
      "email": "palmetto.hottubs2@gmail.com",
      "name": "Hot Tubs & Pool Tables in South Carolina",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.8130217",
      "lon": "-79.9969567",
      "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": ""
}