Constantine Cannon LLP

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 353040,
      "site_id": 18,
      "cat_id": 69,
      "priority": 0,
      "url": "https://constantinecannon.com/",
      "title": "Constantine Cannon LLP",
      "description": "
Business Hours:\n
Mon: 8:00 am - 5:00 pm\n
Tue: 8:00 am - 5:00 pm\n
Wed: 8:00 am - 5:00 pm\n
Thu: 8:00 am - 5:00 pm\n
Fri: 8:00 am - 5:00 pm\n
Sat: Closed \n
Sun: Closed\n
\n
For more information, please contact us with the following details:\n
\n
Contact Telephone:\n
(415) 639-4001",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 103802,
      "approve_dt": "2026-05-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-05-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2456,
      "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": 696,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e5a0b83d-47cc-11f1-bb42-b66e99367f32",
      "subdate": "May 04, 2026",
      "subcategory": "Antitrust Attorney",
      "request_types": "",
      "visitcount": 4
   },
   "visits": {
      "storefront": 4,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Since 2015, our San Francisco, California office has offered services to a diverse range of clients from whistleblowers to public entities and companies in various industries. Our attorneys practice throughout the state and nationally working with Constantine Cannon lawyers in other locations.",
      "service1": "Law Firm",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2026-05-04 15:21:17"
   },
   "location": {
      "uuid": "e5a0b83d-47cc-11f1-bb42-b66e99367f32",
      "link_id": 353040,
      "account_id": 103802,
      "company": "Constantine Cannon LLP",
      "sid": 18,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2456",
      "zip": "94111",
      "address": "50 California Street, Suite 1500",
      "phone": "(415) 639-4001",
      "fax": null,
      "email": "constantinecannon@brite-mail.com",
      "name": "Constantine Cannon LLP",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "San Francisco",
      "statename": "California"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}