Underwood Law Firm P.C

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 325780,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.underwood.law",
      "title": "Underwood Law Firm P.C",
      "description": "The Underwood Law firm, P.C. is a California-based boutique partition, real estate, and civil litigation company. We are helping clients escape abusive real estate relationships, involving single-family residences, multi-million dollar apartment buildings, warehouses, vacant property, and farm land that are handled by the firm at any given time.Our attorneys have handled these issues in courts throughout California, including Los Angeles, San Francisco, Sacramento, Orange County, San Diego, Riverside, Stockton, and the East Bay.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76689,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-09-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2436,
      "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": 2250,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8afabe43-4e0e-11ee-8344-b66e99367f32",
      "subdate": "Sep 08, 2023",
      "subcategory": "Real Estate Law",
      "request_types": "",
      "visitcount": 8
   },
   "visits": {
      "storefront": 8,
      "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": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-09-08 06:11:26"
   },
   "location": {
      "uuid": "8afabe43-4e0e-11ee-8344-b66e99367f32",
      "link_id": 325780,
      "account_id": 76689,
      "company": "Underwood Law Firm, P.C.",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2436",
      "zip": "95814",
      "address": "428 J St 4th Floor",
      "phone": "916-318-8000",
      "fax": null,
      "email": "info.underwoodlaw@gmail.com",
      "name": "Underwood Law Firm, P.C.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.5819629",
      "lon": "-121.5004546",
      "cityname": "Sacramento",
      "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": ""
}