{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 331474,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://pawater.net/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 82269,
"approve_dt": "2025-12-22T00:00:00.000Z",
"source": null,
"submit_dt": "2024-06-04T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 10,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 37,
"city_id": 19369,
"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": 5732,
"d_url": null,
"approved": {
"type": "Buffer",
"data": [
49
]
},
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "8b50f40b-2249-11ef-8344-b66e99367f32",
"subdate": "Jun 04, 2024",
"subcategory": "Business Services",
"request_types": "",
"visitcount": 22
},
"visits": {
"storefront": 22,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 1,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "We are a full-service water treatment and filtration services company. For the past 30-years, we have built our reputation on integrity, honesty, and lasting relationships. Countless Pennsylvania neighbors have enjoyed the benefits of clean, healthy drinking water with our quality water filters & water purification services. When you work with us, you will be given personalized attention and expert knowledge on your water filtration system based on our years of experience working in this area.",
"service1": "Well Water testing",
"service2": "Whole Home Water Filters",
"service3": "Reverse Osmosis Drinking Water Filters",
"service4": "Whole Home water Softeners",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2024-06-04 08:07:53"
},
"location": {
"uuid": "8b50f40b-2249-11ef-8344-b66e99367f32",
"link_id": 331474,
"account_id": 82269,
"company": "Pennsylvania Water and Energy Solutions Inc",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 37,
"city": "19369",
"zip": "17601",
"address": "501 Service Road #2",
"phone": "(717) 923-5115",
"fax": null,
"email": "pennsylvaniawater@brite-post.com",
"name": "Pennsylvania Water and Energy Solutions Inc",
"status": "show",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "",
"lon": "",
"cityname": "Lancaster",
"statename": "Pennsylvania"
},
"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
