{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 345223,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://www.callallaloha.com/phoenix/",
"title": " ",
"description": " ",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 95918,
"approve_dt": null,
"source": null,
"submit_dt": "2025-04-13T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 4,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 3,
"city_id": 1058,
"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": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "1631dc22-1841-11f0-a909-b66e99367f32",
"subdate": "Apr 13, 2025",
"subcategory": "Home And Garden",
"request_types": "",
"visitcount": 32
},
"visits": {
"storefront": 32,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 13,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "All Aloha Plumbing Phoenix is your trusted local plumbing company, providing top-quality residential and commercial plumbing services across Tempe, Arizona. With a commitment to excellence and the Aloha spirit, we offer expert solutions, including drain cleaning, leak detection, water heater services, repiping, and emergency plumbing. Our skilled team ensures reliable, efficient, and affordable service with a customer-first approach. Whether you need routine maintenance or urgent repairs, All Aloha Plumbing Phoenix is here to keep your plumbing running smoothly. Experience professional service with a touch of Aloha. Call 24/7 to schedule all types of reliable Plumbing Services in Tempe!",
"service1": "Bathroom Remodeling",
"service2": "Backflow Prevention",
"service3": "Drain and Toilet Clog Removal",
"service4": "Gas Line Installation and Repair",
"service5": "Water Heater Installation and Repair",
"service6": "",
"service7": "",
"submit_dt": "2025-04-13 08:27:07"
},
"location": {
"uuid": "1631dc22-1841-11f0-a909-b66e99367f32",
"link_id": 345223,
"account_id": 95918,
"company": "All Aloha Plumbing Phoenix",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 3,
"city": "1058",
"zip": "85281",
"address": "1615 West University Drive, STE 131",
"phone": "+1 480-447-8153",
"fax": null,
"email": "callallalohataz@mail-burst.com",
"name": "All Aloha Plumbing Phoenix",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "33.4210206",
"lon": "-111.9651879",
"cityname": "Tempe",
"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
