Alliance Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340744,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.allianceplumbingco.com",
      "title": "Alliance Plumbing",
      "description": "Alliance Plumbing provides top-notch plumbing services, specializing in repairs, installations, and maintenance for both residential and commercial properties. With years of experience, their expert team ensures reliable and efficient solutions to all plumbing challenges. From leaky faucets to major installations, Alliance Plumbing Co. is committed to delivering exceptional customer service and high-quality workmanship. Whether you're dealing with an emergency or planning routine maintenance, trust them to handle your plumbing needs with professionalism and expertise.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 91441,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1907,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f3c4bc5d-d28f-11ef-a909-b66e99367f32",
      "subdate": "Jan 14, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 22
   },
   "visits": {
      "storefront": 22,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Alliance Plumbing is a Licensed Contractor with 20 years of experience working in Northern California. We are dedicated to serving our valued customers in a friendly, professional and honest manner while providing quality services at a fair price.\r
\r
Learn More: https://www.allianceplumbingco.com/drain-and-sewer/hydro-jetting/",
      "service1": "Plumbing",
      "service2": "water heater",
      "service3": "sewer camera inspection",
      "service4": "Hydro Jetting",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-14 15:55:18"
   },
   "location": {
      "uuid": "f3c4bc5d-d28f-11ef-a909-b66e99367f32",
      "link_id": 340744,
      "account_id": 91441,
      "company": "Alliance Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1907",
      "zip": "",
      "address": "Not Available",
      "phone": "",
      "fax": null,
      "email": "allianceplumbingmarketing@gmail.com",
      "name": "Alliance Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.4000193",
      "lon": "-121.3770255",
      "cityname": "Elk Grove",
      "statename": "California"
   },
   "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": ""
}