Casola Well Drillers Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314236,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://casolawelldrillers.com/",
      "title": "Casola Well Drillers Inc",
      "description": "In business for over 75 years, Casola Well Drillers, Inc. has the equipment and experience you can depend on for high-quality water well drilling, water filtration, and treatment. Give our family-owned and operated company a call to get your project started!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65463,
      "approve_dt": "2020-09-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2018-01-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 508,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 14743,
      "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": 5891,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "955f2fd1-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 11, 2018",
      "subcategory": "Water Filter System",
      "request_types": "",
      "visitcount": 744
   },
   "visits": {
      "storefront": 744,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Beginning in the early 1930s, my dad Maurice started his own plumbing and heating business. He needed to sub-contract well drillers to supply the water for the jobs. It became so difficult finding reliable well drillers that he finally decided to start drilling his own wells.\n\nHe was so successful at this that he gradually gave up plumbing and heating to specialize exclusively in wells. As a young man, I saw the opportunity in the field and so instead of going to college, I joined him in the well business. That was in 1948 after I graduated from high school.\n\nIn those days we would improvise our own rigs out of old 1927 Buicks, attached with \"cat head\" drives off the rear wheels. This method was so dangerous that it eventually became illegal. In 1955 we bought our first factory-made cable tool machine. Over the past 50 years, the drilling equipment and materials that we use, have changed dramatically. They are a lot safer. We now have 5 rotary well machines that install PVC wells with stainless steel screens that are state-of-the-art for quality and long term trouble-free service.\n\nNow my sons, daughters, and grandsons are all working for the family business. Besides, we have numerous technicians that have been working faithfully with us for many years.\n\n- Robert F Casola, President",
      "service1": "Domestic Use",
      "service2": " Irrigation",
      "service3": " Geothermal Supply and Dispersion",
      "service4": " Test Wells",
      "service5": " Monitoring",
      "service6": " Firefighting Purposes",
      "service7": " Dewatering",
      "submit_dt": "2018-01-12 04:30:58"
   },
   "location": {
      "uuid": "955f2fd1-56da-11ed-b77c-b66e99367f32",
      "link_id": 314236,
      "account_id": 65463,
      "company": "Casola Well Drillers Inc",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "14743",
      "zip": "11933",
      "address": "600 Burman Blvd.",
      "phone": "631-281-5454",
      "fax": null,
      "email": "casolawelldrillers@yahoo.com",
      "name": "Casola Well Drillers Inc",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.9153034",
      "lon": "-72.7928403",
      "cityname": "Calverton",
      "statename": "New York"
   },
   "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": ""
}