select "a-" as test,l.pubid,l.adid, l.startdate,DATE_ADD(l.enddate,INTERVAL 7 DAY) AS enddate,l.classid,l.text,ll.county,l.classid,substring_index(l.text,' ',50) AS groupText from ads.legals_location ll join ads.legals l on l.pubid = ll.pubid and CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) where ll.county like '%king%' and l.adid like '%%' AND CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) and l.pubid like '%fwm%' group by groupText,l.startdate,l.enddate order by l.text;
Legal Notices
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 - 2
King County Online 12/19/2014 thru 01/02/2015
CITY OF FEDERAL WAY REQUEST FOR PROPOSAL I. PURPOSE OF REQUEST. The City of Federal Way (“City”) is requesting proposals for the purpose of obtaining new fitness equipment for the Federal Way Community Center. The City’s needs are outlined in the following Request for Proposal (“RFP”). II. TIME SCHEDULE. The... [Full Notice]
King County Online 12/26/2014 thru 01/02/2015
CITY OF FEDERAL WAY REQUEST FOR PROPOSAL I. PURPOSE OF REQUEST. The City of Federal Way (“City”) is requesting proposals for the purpose of obtaining new fitness equipment for the Federal Way Community Center. The City’s needs are outlined in the following Request for Proposal (“RFP”). II. TIME SCHEDULE. The... [Full Notice]
Business News
Latest King County business news.
Friday December 26, 2014 at 06:00 PM
At the U.S. Small Business Administration (SBA), were all about helping small businesses start, grow and succeed. Read More ›
Monday December 22, 2014 at 11:00 AM
The commitment when finalized will be valued at more than $6 billion at current list prices. Read More ›
Tuesday December 23, 2014 at 11:00 AM
Employees now own the Ram family of restaurants and breweries, including a location at Kent Station. Read More ›
Monday December 22, 2014 at 06:00 PM
The U.S. Small Business Administration (SBA) announced today that it renewed its partnership agreement with the Minority Business RoundTable (MBRT) to continue joint outreach efforts to minority entrepreneurs. Read More ›
Monday December 22, 2014 at 03:00 PM
Albertsons and Safeway are planning to merge, and the grocery chains must sell the stores as part of a divestment required by the FTC. Read More ›
Monday December 22, 2014 at 12:00 PM
Starting up of a new business or running one now? Consider attending the City of Auburn's Business 101 Overview Workshop on Wednesday, Jan. 7. Read More ›