Randall & Bruch, P.C

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333828,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.valegalservices.com/",
      "title": "Randall & Bruch, P.C",
      "description": "Eighty-Five Combined Years Of Experience On Your Side. We are a community-rooted firm committed to helping people overcome legal troubles. With many decades of experience, our team provides trusted and effective representation for clients from all walks of life. We have a respected reputation among insurance companies, prosecutors and other opponents as being strong advocates for our clients. No matter what kind of challenge you''re facing, you can rely on us to come through for you.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84593,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 11,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23317,
      "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": 2184,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "cd1a8528-52dd-11ef-8344-b66e99367f32",
      "subdate": "Aug 05, 2024",
      "subcategory": "Criminal Law",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Eighty-Five Combined Years Of Experience On Your Side. We are a community-rooted firm committed to helping people overcome legal troubles. With many decades of experience, our team provides trusted and effective representation for clients from all walks of life. We have a respected reputation among insurance companies, prosecutors and other opponents as being strong advocates for our clients. No matter what kind of challenge you're facing, you can rely on us to come through for you.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-08-05 03:50:05"
   },
   "location": {
      "uuid": "cd1a8528-52dd-11ef-8344-b66e99367f32",
      "link_id": 333828,
      "account_id": 84593,
      "company": "",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23317",
      "zip": "23860",
      "address": "408 N 6th Ave, Suite 2",
      "phone": "(804) 255-9977",
      "fax": null,
      "email": "valegalserviceshw@mail-burst.com",
      "name": "Randall & Bruch, P.C",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.3055183",
      "lon": "-77.2933433",
      "cityname": "Hopewell",
      "statename": "Virginia"
   },
   "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": ""
}