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;
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 - 2
City of Federal Way Notice of Public Hearing Proposed Community Development Block Grant 2015 Annual Action Plan NOTICE IS GIVEN that the Federal Way Human Services Commission will conduct a public hearing on Monday, September 22, 2014, at 5:30 p.m. in the City Council Chambers on the second floor at... [Full Notice]
PLANNING COMMISSION NOTICE OF PUBLIC HEARING Proposed Amendments to the Federal Way Revised Code (FWRC) Related to Marijuana-Related Businesses Files: 14- 102659-UP and 14-102660-SE (Non-Project Action) The City of Federal Way’s Planning Commission will conduct a public hearing on Wednesday, September 17, 2014, at 7:00 p.m. in the Council Chambers... [Full Notice]
Latest King County business news.
Big 5 Sporting Goods, one of the leading sporting goods retailers in the Western States, opened its newest location in Auburn on Friday. Read More ›
The Night of the Stars Gala is at the Seattle Airport Marriott, 3201 S. 176th St., SeaTac. Cost is $75 a person. For more information call 206-575-1633 or register at www.swkcc.org. Read More ›
Join the 3No Networking business mixer at 5:30 p.m. Thursday at Zola's Café, 402 E. Main St., Suite 120. Read More ›
Ted J. Fick, a Tacoma native with decades of experience leading manufacturing organizations across the country, will take the helm when current CEO Tay Yoshitani retires next month, according to a port news release. Read More ›
The construction contract for Tukwila Village has been awarded to Inter-city Contractors of Kenmore, which has built many of the Senior Housing Assistance Group's (SHAG) communities. Read More ›
The order, valued at $8.8 billion at list prices, is the largest in BOC Aviation's 20-year history. Read More ›