{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 334989,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://www.hawkdrillingcompany.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 85736,
"approve_dt": null,
"source": null,
"submit_dt": "2024-09-05T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 3,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 31,
"city_id": 14676,
"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": 288,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "86fe9a81-6b67-11ef-ab46-b66e99367f32",
"subdate": "Sep 05, 2024",
"subcategory": "Home And Garden",
"request_types": "",
"visitcount": 22
},
"visits": {
"storefront": 22,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 4,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "We are a 5th generation family-owned business that has been drilling wells in the upstate NY region since 1927. Jeremy is a Master Groundwater Contractor and hydrogeologist who is passionate about well drilling and customer service. Our water treatment division is without comparison. Our techs have more than 45 years of experience in all water concerns.",
"service1": "Whole Home Water Filtration",
"service2": "Water Softeners",
"service3": "Reverse Osmosis Drinking Water Filters",
"service4": "Well Water Testing",
"service5": "Water Well Drilling",
"service6": "",
"service7": "",
"submit_dt": "2024-09-05 09:16:26"
},
"location": {
"uuid": "86fe9a81-6b67-11ef-ab46-b66e99367f32",
"link_id": 334989,
"account_id": 85736,
"company": "Hawk Drilling Co Inc",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 31,
"city": "14676",
"zip": "12020-4610",
"address": "354 Stone Church Road",
"phone": "(518) 885-7952",
"fax": null,
"email": "hawkdrillingcompany@burst-email.com",
"name": "Hawk Drilling Co Inc",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "43.0439688",
"lon": "-73.8742514",
"cityname": "Ballston Spa",
"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": ""
}
all our featured social media
