Columbia Pool & Spa

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326711,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.columbiapoolandspa.com/",
      "title": "Columbia Pool & Spa",
      "description": "Columbia Pool & Spa has the largest selection and greatest prices on swimming pools and hot tubs in mid-Missouri. Over our 25 years in business, we''ve built countless custom swimming pools for families and businesses in Columbia, MO and beyond. We uphold the highest standards of quality and safety in all of our services and take pride in our friendly, knowledgeable staff. Whether you''re looking for a large commercial pool or a Jacuzzi hot tub, contact us today to learn more and get started!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77574,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-12-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 32,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 25,
      "city_id": 12167,
      "ltop": "",
      "facebook": "https://www.facebook.com/ColumbiaMOPoolandSpa",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/columbiapool/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5881,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "36cde10f-91d2-11ee-8344-b66e99367f32",
      "subdate": "Dec 03, 2023",
      "subcategory": "Swimming Pool Contractors",
      "request_types": "",
      "visitcount": 103
   },
   "visits": {
      "storefront": 103,
      "articles": 0,
      "videos": 0,
      "reviews": 14,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Custom swimming pools",
      "service2": "Swimming pool installation",
      "service3": "Swimming pool contractor",
      "service4": "Swimming pool maintenance",
      "service5": "Hot tubs and jacuzzis",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-12-03 11:50:54"
   },
   "location": {
      "uuid": "36cde10f-91d2-11ee-8344-b66e99367f32",
      "link_id": 326711,
      "account_id": 77574,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12167",
      "zip": "65202",
      "address": "1200 Business Loop 70 W",
      "phone": "(573) 874-6972",
      "fax": null,
      "email": "columbiapoolandspa@mail-burst.com",
      "name": "Columbia Pool & Spa",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.9653636",
      "lon": "-92.3562762",
      "cityname": "Columbia",
      "statename": "Missouri"
   },
   "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": ""
}