Find Bankruptcy lawyers in cities near Lancaster, California

Browse through lawyer profiles near you and get the legal help you need.

Join our Mailing List to Receive Marketing Tips

Showing 1 - 9 of 262 Results

SELECT DISTINCT ud.user_id, ud.listing_type, ud.years, ud.language, CASE WHEN ud.listing_type = 'individual' THEN CASE WHEN TRIM(ud.first_name) <> '' THEN CONCAT(TRIM(ud.first_name), ' ', TRIM(ud.last_name)) ELSE ud.company END ELSE CASE WHEN ud.company = '' THEN CONCAT(TRIM(ud.first_name), ' ', TRIM(ud.last_name)) ELSE ud.company END END AS name , (3959 * acos( cos( radians(34.6867846) ) * cos( radians( ud.lat ) ) * cos( radians( ud.lon ) - radians(-118.1541632) ) + sin( radians(34.6867846) ) * sin(radians(ud.lat)) ) ) AS distance, user_service_areas.service_area_user_id AS service_area, user_service_areas.service_distance AS service_distance FROM `users_data` AS ud INNER JOIN `subscription_types` AS st ON ud.subscription_id = st.subscription_id INNER JOIN ( SELECT rss.service_id AS rel_service_id, rss.user_id AS rel_service_user_id FROM `rel_services` AS rss WHERE rss.service_id IN (56) GROUP BY rss.user_id ) AS rs ON ud.user_id = rs.rel_service_user_id LEFT JOIN ( SELECT sa2.user_id AS service_area_user_id, (3959 * acos( cos( radians(34.6867846) ) * cos( radians( sa2.lat ) ) * cos( radians( sa2.lon ) - radians(-118.1541632) ) + sin( radians(34.6867846) ) * sin(radians(sa2.lat)) ) ) AS service_distance FROM `service_areas` AS sa2 WHERE ( (3959 * acos( cos( radians(34.6867846) ) * cos( radians( sa2.lat ) ) * cos( radians( sa2.lon ) - radians(-118.1541632) ) + sin( radians(34.6867846) ) * sin(radians(sa2.lat)) ) ) <= 100 AND country_sn = 'US' AND state_sn = 'CA' AND county_sn = 'Los Angeles County' ) OR ( ( sa2.country_sn = 'US' AND sa2.location_type = 'Country' ) OR ( sa2.country_sn = 'US' AND sa2.state_sn = 'CA' AND sa2.location_type = 'State' ) OR ( sa2.country_sn = 'US' AND sa2.state_sn = 'CA' AND sa2.county_sn = 'Los Angeles County' AND sa2.location_type = 'County' ) ) GROUP BY sa2.user_id ) user_service_areas ON user_service_areas.service_area_user_id = ud.user_id WHERE ud.active = '2' AND st.searchable = '1' AND (rs.rel_service_id IN (56) OR st.service_limit = 'all') AND ud.state_code = "CA" AND st.search_membership_permissions REGEXP 'visitor' AND ( ( (3959 * acos( cos( radians(34.6867846) ) * cos( radians( ud.lat ) ) * cos( radians( ud.lon ) - radians(-118.1541632) ) + sin( radians(34.6867846) ) * sin(radians(ud.lat)) ) ) <= 100 AND ud.country_code = 'US' AND ud.state_code = "CA" ) OR user_service_areas.service_area_user_id > 0 OR ud.nationwide = 1 ) ORDER BY st.search_priority ASC, distance ASC, name ASC, ud.user_id DESC

Marc Herbert

Rated /5 ( Reviews)
Bankruptcy, Bankruptcy & Debt, Business
California, United States

Rene Lopez de arenoza Jr.

Rated /5 ( Reviews)
Bankruptcy, Bankruptcy & Debt, Divorce & Separation
California, United States

Raj Wadhwani

Rated /5 ( Reviews)
Bankruptcy, Chapter 11 Bankruptcy, Chapter 7 Bankruptcy
California, United States

Ali Nader

Rated /5 ( Reviews)
Licensed for 23 years.
Bankruptcy, Bankruptcy & Debt, Chapter 11 Bankruptcy
California, United States

Stephen Vokshori

Rated /5 ( Reviews)
Bankruptcy, Bankruptcy & Debt
California, United States

Raj Wadhwani

Rated /5 ( Reviews)
Bankruptcy, Chapter 13 Bankruptcy, Chapter 7 Bankruptcy
California, United States

Valerie F. Horn

Rated /5 ( Reviews)
Bankruptcy, Business, Commercial
California, United States

James Selth

Rated /5 ( Reviews)
Bankruptcy, Chapter 11 Bankruptcy, Chapter 13 Bankruptcy
California, United States

Shawn Kerendian

Rated /5 ( Reviews)
Bankruptcy, Bankruptcy & Debt
California, United States

Bankruptcy in cities near Lancaster, CA

Lancaster, CA attorneys in related practice areas

Join our Mailing List to Receive Marketing Tips