San Juan Quality Pools

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310503,
      "site_id": 68,
      "cat_id": 79,
      "priority": 0,
      "url": "http://www.swimmingpoolcontractorssandiego.com/",
      "title": "San Juan Quality Pools",
      "description": "San Juan Quality Pools is the only San Diego company that installs cement and fiberglass swimming pools. Since 1978, we have been the top swimming pool contractors. We also offer swimming pool remodeling. If you''re looking for the most experienced and knowledgeable custom pool builder, give us a call for a free design consultation!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61738,
      "approve_dt": "2015-09-22T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1926,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2614,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5151,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954db181-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 22, 2015",
      "subcategory": "Swimming Pool Construction",
      "request_types": "",
      "visitcount": 2288
   },
   "visits": {
      "storefront": 2288,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "San Juan Quality Pools began doing business in 1958 when one-piece fiberglass pools were brand new. We have always maintained our dedication to client satisfaction through quality pool design and installation. We expanded our office in 1969, and in 1978, San Juan, by Quality Fiberglass Pools, became the first pool company in California to install customized cement and fiberglass pools. With all of these years of experience, we are able to offer you the best craftsmanship, quality guarantees, and customer care for your pool installation.\n

\nTurn Your Backyard into a Water Park\n

\nWith our customized pool features, you can create the perfect pool. You can choose from a wide range of features, including custom water and rock features that San Juan Quality Pools has developed over the years. Don’t just get a swimming pool, get a complete retreat or personalized water park for your family. You can combine many different features to create the ultimate swimming experience, ",
      "service1": "swimming pool contractors",
      "service2": " swimming pool remodeling",
      "service3": " pool spas",
      "service4": " artificial rock",
      "service5": " masonary work",
      "service6": " concrete pools",
      "service7": " fiber glass pools",
      "submit_dt": "2015-09-22 07:12:33"
   },
   "location": {
      "uuid": "954db181-56da-11ed-b77c-b66e99367f32",
      "link_id": 310503,
      "account_id": 61738,
      "company": "San Juan Quality Pools",
      "sid": 68,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2614",
      "zip": "92082",
      "address": "26691 Oaktrail Rd",
      "phone": "760-715-1769",
      "fax": "",
      "email": "johnmitchell112233@gmail.com",
      "name": "San Juan Quality Pools",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.197021",
      "lon": "-116.938066",
      "cityname": "Valley Center",
      "statename": "California"
   },
   "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": ""
}