SELECT DISTINCT tblFirms.FirmID, tblFirms.FirmName, tblFirms.AddressLine1, tblFirms.AddressLine2, tblFirms.City, tblFirms.State, tblFirms.ZipCode, tblFirms.PhoneNumber, tblFirms.TollFreeNumber, tblFirms.FaxNumber, tblFirms.ListingCompanyURL, tblFirms.SignupDate, tblFirms.Slogan, tblFirms.Vbutton, tblFirms.Video, tblFirms.Teleconf, tblFirms.Status, tblListings.CategoryDescription, tblListings.ListingCategoryID, tblListingNames.ListingNameEmail,tblListingNames.ShowName, tblListings.SortStatus, tblListings.ListingCategoryURL,tblListingNames.ListingFirstName, tblListingNames.ListingLastName, tblListings.ListingPhoneNumber,tblListings.ListingFaxNumber,tblListings.ListingDate FROM tblFirms INNER JOIN tblListingNames ON tblFirms.FirmID = tblListingNames.FirmID INNER JOIN tblListings ON tblListingNames.ListingNameID = tblListings.ListingNameID INNER JOIN tblAreacodelistings ON tblListings.AreaCode = tblAreacodelistings.areacode WHERE (tblFirms.LeadCounsel = '1') AND (tblFirms.Status = '1') AND (tblListings.Status = '1') AND (tblListingNames.Status = '1') AND (tbllistings.listingcategoryid ='26') AND (tblAreacodelistings.state = '#state_letters#') AND (tblListings.Status = 1) AND (tblListingNames.Status = 1) ORDER BY tblFirms.Firmname Employment and Labor Attorney: Lawyer, Law Firm




No Attorneys Found in #state#.

Total of #display_state.recordcount# Labor and Employment Attorneys found in #State#.

Firm Name Contact's Email Address Phone Number

#FirmName#

#ListingNameEmail#

#AddressLine1# #AddressLine2#
#City#, #State# #ZipCode#

#PhoneNumber#

    Home   |  Attorney Search   |  FAQ's   |  Contact Us
Hosted By
Hosted by Lawinfo.com    Check your stats
Copyright © 2002 LawInfo.com Inc. All rights reserved.