General Contractor

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336800,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.advancepoolsinc.com/",
      "title": "General Contractor",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87533,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22106,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d8bb2ae4-8ae2-11ef-ab46-b66e99367f32",
      "subdate": "Oct 15, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 7
   },
   "visits": {
      "storefront": 7,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Advance Pools, Inc. was founded in 1994 by Richard Prince with a desire to focus on a unique portion of the pool market. Our desire to create an innovative experience for our clients encompasses a total concept for our customers. The collaboration of design-sensitive pools, landscape, fencing, gazebo and barbecue structures, and special features including water and fire elements, custom tiling, and other extraordinary installations are all part of the Advance Pools, Inc. experience.",
      "service1": "Pool Design & Construction",
      "service2": "Pool Remodeling",
      "service3": "Outdoor Living",
      "service4": "Pool Decking",
      "service5": "Pool Landscaping",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-15 10:47:17"
   },
   "location": {
      "uuid": "d8bb2ae4-8ae2-11ef-ab46-b66e99367f32",
      "link_id": 336800,
      "account_id": 87533,
      "company": "Advance Pools Inc",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22106",
      "zip": "75069",
      "address": "2202 FM 546",
      "phone": "972-248-4360",
      "fax": null,
      "email": "advancepoolsinc@brite-email.com",
      "name": "Advance Pools Inc",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.16597",
      "lon": "-96.566397",
      "cityname": "McKinney",
      "statename": "Texas"
   },
   "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": ""
}