Pools by Mario

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344483,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.poolsbymario.com/",
      "title": "Pools by Mario",
      "description": "Pool Contractor",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95178,
      "approve_dt": "2025-11-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-03-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 8,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22436,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d7777e36-0c6b-11f0-a909-b66e99367f32",
      "subdate": "Mar 29, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 54
   },
   "visits": {
      "storefront": 54,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Back yard dreams from start to finish. We build concrete and fiberglass swimming pools, spas, outside kitchens, Pergola's, Cabanas, flagstone, boulders, stamped concrete, and pavers. We service all of the Coastal Bend including Rockport, Aransas Pass, Port Aransas, Corpus Christi, and all surrounding areas.\r
",
      "service1": "Square Pools",
      "service2": "Freeform Pools",
      "service3": "Grottos & Waterfalls",
      "service4": "Slides",
      "service5": "Fire Pits/Outdoor Kitchens",
      "service6": "Maintenance/Cleaning",
      "service7": "",
      "submit_dt": "2025-03-29 07:02:56"
   },
   "location": {
      "uuid": "d7777e36-0c6b-11f0-a909-b66e99367f32",
      "link_id": 344483,
      "account_id": 95178,
      "company": "Pools by Mario",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22436",
      "zip": "78380",
      "address": "5340 Riverview Dr",
      "phone": "(361) 246-7989",
      "fax": null,
      "email": "poolsbymariotx@gmail.com",
      "name": "Pools by Mario",
      "status": "hide",
      "start_dt": null,
      "end_dt": null,
      "lat": "27.86225",
      "lon": "-97.664067",
      "cityname": "Robstown",
      "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": "",
   "form": []
}
Pools by Mario

all our featured social media

11

Addess:

Visit Our Website

Site Content

Key Services in 2025

Our Social Media

Contact Us
