Consolidated Fuel Oil Co.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315528,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://consolidatedfuel.com/",
      "title": "Consolidated Fuel Oil Co.",
      "description": "Consolidated Fuel Oil Co. is a family owned & operated family business providing comprehensive fuel oil delivery as well as we handle all of your boiler installation, repair and maintenance needs. Contact us today at 631-265-2930 and get a FREE estimate on your work!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66743,
      "approve_dt": "2018-10-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2018-07-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 559,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 15104,
      "ltop": "",
      "facebook": "https://www.facebook.com/Consolidated-Fuel-Oil-1747635055507853/?fref=ts",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/ConsolidatedFu",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95654912-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 25, 2018",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 678
   },
   "visits": {
      "storefront": 678,
      "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": "We are a family owned and operated repair furnace and boiler service who have been providing expert service for over 50 years. Our company is a father and son team who are committed to making sure that your home stays safe and warm all year round.\n\nBenefits:\n\nFamily Owned Business for over 50 years\n\nFather and Son working together to make sure your home is safe and warm\n\nAll of our technicians NORA Certified Gold Techs\n\nServing the North Shore of Long Island\n\nLet us give you the repairs, maintenance, and installation service you need along with prompt oil delivery service. You can call for oil delivery or be placed on automatic delivery.  Our full range of services are offered at great prices.",
      "service1": "Oil Tank Installation",
      "service2": " Oil Tank Removal",
      "service3": " Automatic Metered Oil Delivery Service",
      "service4": " Fast 24-Hour Emergency Service",
      "service5": " Energy Saving Evaluations",
      "service6": " Fuel Oil",
      "service7": " Diesel",
      "submit_dt": "2018-07-25 07:08:16"
   },
   "location": {
      "uuid": "95654912-56da-11ed-b77c-b66e99367f32",
      "link_id": 315528,
      "account_id": 66743,
      "company": "Consolidated Fuel Oil Co.",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "15104",
      "zip": "11780",
      "address": "Saint James,NY",
      "phone": "631-265-2930",
      "fax": null,
      "email": "consolidatedfuelny@gmail.com",
      "name": "Consolidated Fuel Oil Co.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.8754335",
      "lon": "-73.1526623",
      "cityname": "Lake Ronkonkoma",
      "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": ""
}