Find Family lawyers in cities near Chula Vista, 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 39 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(32.6400541) ) * cos( radians( ud.lat ) ) * cos( radians( ud.lon ) - radians(-117.0841955) ) + sin( radians(32.6400541) ) * 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 (65) 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(32.6400541) ) * cos( radians( sa2.lat ) ) * cos( radians( sa2.lon ) - radians(-117.0841955) ) + sin( radians(32.6400541) ) * sin(radians(sa2.lat)) ) ) AS service_distance FROM `service_areas` AS sa2 WHERE ( (3959 * acos( cos( radians(32.6400541) ) * cos( radians( sa2.lat ) ) * cos( radians( sa2.lon ) - radians(-117.0841955) ) + sin( radians(32.6400541) ) * sin(radians(sa2.lat)) ) ) <= 100 AND country_sn = 'US' AND state_sn = 'CA' AND county_sn = 'San Diego 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 = 'San Diego 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 (65) OR st.service_limit = 'all') AND ud.state_code = "CA" AND st.search_membership_permissions REGEXP 'visitor' AND ( ( (3959 * acos( cos( radians(32.6400541) ) * cos( radians( ud.lat ) ) * cos( radians( ud.lon ) - radians(-117.0841955) ) + sin( radians(32.6400541) ) * 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

Francis Connaughton

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

Alan Thoms

Rated /5 ( Reviews)
Licensed for 33 years.
Child Support, Divorce & Separation, Family
California, United States

Steve Gnau

Rated /5 ( Reviews)
Child Custody, Divorce & Separation, Family
California, United States

Andrea Schneider

Rated /5 ( Reviews)
Criminal Defense, Divorce & Separation, Family
California, United States

Garrison Klueck

Rated /5 ( Reviews)
Child Custody, Divorce & Separation, Family
California, United States

Kelly Combs

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

Matthew Mesnik

Rated /5 ( Reviews)
Child Custody, Child Support, Divorce & Separation
California, United States

Jylan Megahed

Rated /5 ( Reviews)
Child Custody, Divorce & Separation, Family
California, United States

Nancy Bickford

Rated /5 ( Reviews)
Family
California, United States

Family in cities near Chula Vista, CA

Chula Vista, CA attorneys in related practice areas

Join our Mailing List to Receive Marketing Tips