Carnahan Landscaping & Pools

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313621,
      "site_id": 76,
      "cat_id": 65,
      "priority": 2,
      "url": "http://carnahanlandscaping.com",
      "title": "Carnahan Landscaping & Pools",
      "description": "We provide custom landscaping, swimming pool, outdoor kitchen, patio, and much more. Go to our website to learn more about our turn-key services today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64848,
      "approve_dt": "2017-09-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-09-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1210,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22332,
      "ltop": "",
      "facebook": "https://www.facebook.com/CarnahanLandscapingInc/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/carnahanlandscapingandpools/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5178,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "955b9519-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 08, 2017",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 1563
   },
   "visits": {
      "storefront": 1563,
      "articles": 0,
      "videos": 0,
      "reviews": 16,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Building your dream yard is our specialty. Carnahan custom swimming pools, spas, landscaping, outdoor kitchens, patios, and pergolas will turn your home into an oasis of entertainment and relaxation. We have the right team to do it all at the right price for you. With more than 30 years of experience, we are your experts in custom landscaping and backyard pools. Whether you’re looking for a small, large, luxury, or basic pool and spa, Carnahan can make it happen. We specialize in low-maintenance and durable pools which optimize power and keep year-round costs low. In addition to design and construction, we also clean, repair, service, and maintain existing pools. With or without a new pool, Carnahan takes pleasure in transforming your yard into a timeless, landscaping masterpiece. Divine gardens, premium grass, and stone walkways accompanied with low-voltage lighting, make your beautiful home into a fresh and welcoming environment. Our additional features such as irrigation and drain systems, retaining walls, outdoor lighting, and more add the finishing touches to ensure quality, comfort, and safety for the whole family.",
      "service1": "Pool maintenance",
      "service2": " Custom pergola",
      "service3": " Retaining wall",
      "service4": " Patio",
      "service5": " Outdoor kitchen",
      "service6": " Custom swimming pool",
      "service7": " Custom landscaping",
      "submit_dt": "2017-09-08 22:44:51"
   },
   "location": {
      "uuid": "955b9519-56da-11ed-b77c-b66e99367f32",
      "link_id": 313621,
      "account_id": 64848,
      "company": "Carnahan Landscaping & Pools",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22332",
      "zip": "77362",
      "address": "32831 TX-249",
      "phone": "281-376-6868",
      "fax": null,
      "email": "website@carnahans.com",
      "name": "Carnahan Landscaping & Pools",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.1400467",
      "lon": "-95.6584066",
      "cityname": "Pinehurst",
      "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": ""
}