Ace Plumbing & Rooter, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327616,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://aceplumbingandrooter.com/",
      "title": "Ace Plumbing & Rooter, Inc.",
      "description": "Ace Plumbing & Rooter, Inc. of San Francisco is your local plumber for professional sewer, water heater and emergency plumbing services. We provide residential and commercial services around the San Francisco, Daly City, Brisbane and South SF areas. For repairs, maintenance and new installations - contact our expert team for all of your plumbing, water heater and sewer needs - we're dedicated to delivering a seamless and positive customer experience for you every time!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78465,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 16,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2456,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "be4ecf53-b0fc-11ee-8344-b66e99367f32",
      "subdate": "Jan 12, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 61
   },
   "visits": {
      "storefront": 61,
      "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": "",
      "service1": "Plumbing",
      "service2": "Emergency Plumbing",
      "service3": "Water Heaters",
      "service4": "Sewer Repair & Service",
      "service5": "Drain Repair & Service",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-12 03:43:26"
   },
   "location": {
      "uuid": "be4ecf53-b0fc-11ee-8344-b66e99367f32",
      "link_id": 327616,
      "account_id": 78465,
      "company": "Ace Plumbing & Rooter, Inc.",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2456",
      "zip": "94103",
      "address": "1090 Bryant St.",
      "phone": "+1 415-824-6444",
      "fax": null,
      "email": "aceplumbingca@mail-burst.com",
      "name": "Ace Plumbing & Rooter, Inc.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.7716113",
      "lon": "-122.4085628",
      "cityname": "San Francisco",
      "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": ""
}