Ian McGregor Pools And Landscapes

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 311070,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "http://www.ianspoolsandscapes.com",
      "title": "Ian McGregor Pools And Landscapes",
      "description": "Owner on site, in house design & build services, 20 working years of knowledge & experience of Swimming pool & landscape construction, personalized client attention first & foremost, attention to detail x 10.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 62304,
      "approve_dt": "2015-12-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-11-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1511,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "city_id": 157,
      "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": 5191,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9550fa38-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 22, 2015",
      "subcategory": "Pool Landscaping",
      "request_types": "",
      "visitcount": 1747
   },
   "visits": {
      "storefront": 1747,
      "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": "Ian McGregor Pools & Landscaping is a premiere landscaping company for your gardening and landscaping needs. Among the top pool landscaping companies in Hamilton, Ian Pools is an award winning landscape design company. We offer landscape maintenance, installation and construction services in Burlington, Cambridge, Brantford and its surrounding areas.\n\nOur company has been designing and building custom pools and landscapes for over 18 years. Like our clients, we have a great passion for pool landscaping and gardening.\n\nIan is known for his attention to detail and being on site for the entire project. We are also one of the very few companies across Canada that actually do both pools and landscapes.\n\nOur services include outdoor kitchens and fireplaces, swimming pool construction or renovation, design, landscape lighting, construction of decks, fences and patios and much more. We are located in Ancaster but also serve the rest of Hamilton and its surrounding areas.\n\nIan Mcgregor Pools and Landscapes has created a team of professionals that share the same high level of workmanship, ethics and experience, they are all masters of their craft and come together to create breathtaking pools and landscapes.\n\nWe hope you find our portfolio helpful with photos of some of the jobs we have done. Feel free to contact us or call us at (905) 627-2066 to organize meeting with one of our design consultants to come out to you, discuss your needs, and put together a free no-obligation quote!",
      "service1": "Outdoor Kitchens",
      "service2": "Outdoor Lighting",
      "service3": "Swimming Pool Service",
      "service4": "Landscape Contractors",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2015-11-23 04:03:43"
   },
   "location": {
      "uuid": "9550fa38-56da-11ed-b77c-b66e99367f32",
      "link_id": 311070,
      "account_id": 62304,
      "company": "Ian McGregor Pools And Landscapes",
      "sid": 69,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "157",
      "zip": "L0R 1T0",
      "address": "2532 Governors Road",
      "phone": "",
      "fax": "",
      "email": "ianmcgregor2532@gmail.com",
      "name": "Ian McGregor Pools And Landscapes",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "43.2397418",
      "lon": "-80.0777515",
      "cityname": "Hamilton",
      "statename": ""
   },
   "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": ""
}