{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 347342,
"site_id": 66,
"cat_id": 78,
"priority": 2,
"url": "https://www.affordableplumbingaz.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 98036,
"approve_dt": null,
"source": null,
"submit_dt": "2025-05-21T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 3,
"city_id": 990,
"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": 4974,
"d_url": null,
"approved": null,
"logo_ext": "png",
"screen_ext": "png",
"pack_id": null,
"uuid": "59586f99-3639-11f0-a909-b66e99367f32",
"subdate": "May 21, 2025",
"subcategory": "Plumbing",
"request_types": "",
"visitcount": 16
},
"visits": {
"storefront": 16,
"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": "We prioritize affordable solutions without compromising on quality. Our plumbers put your satisfaction and well-being first, ensuring fair pricing and high standards. We believe in empowering you with transparent information to make informed decisions about your plumbing needs. When you choose our plumbers for water heater replacement or any other service, you're choosing excellence, integrity, and customer-focused care.",
"service1": "Water Filtration",
"service2": "Water heaters",
"service3": "Plumbing",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-05-21 11:47:18"
},
"location": {
"uuid": "59586f99-3639-11f0-a909-b66e99367f32",
"link_id": 347342,
"account_id": 98036,
"company": "Affordable Plumbing, Rooter and Water Heaters",
"sid": 66,
"country": 277,
"countrycode": "US",
"state": 3,
"city": "990",
"zip": "85032",
"address": "16042 North 32nd Street, Suite C-3",
"phone": "(480) 660-8900",
"fax": null,
"email": "affordableplmb@mail-burst.com",
"name": "Affordable Plumbing, Rooter and Water Heaters",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "33.6333079",
"lon": "-112.0140262",
"cityname": "Phoenix",
"statename": "Arizona"
},
"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
