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 '%mir%' 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 found.
King County Online 07/29/2015 thru 08/05/2015
PUBLIC NOTICE OF APPLICATION AND OPEN RECORD HEARING NOTICE IS HEREBY GIVEN that an application for a Zoning Text Amendment (File # ZTR15-003) and State Environmental Policy Act (SEPA) checklist (File # SEP15-016) modifying Mercer Island City Code (MICC) Title 19 pertaining to walk-off parking in the Town Center. The... [Full Notice]
Business News
Latest King County business news.
Monday August 03, 2015 at 02:00 PM
OneRedmond, along with Washington Interactive Network (WIN) and the City of Bellevue, will be attending gamescom this week from Wednesday through Sunday. Read More ›
Wednesday July 29, 2015 at 05:00 PM
To celebrate the global launch of Windows 10, Microsoft executives flocked to Downtown Bellevue and employees scattered across King County on Wednesday to volunteer in several dozen community service projects, including four in Bellevue. Read More ›
Wednesday July 29, 2015 at 02:00 PM
Whole Foods Market's first Washington store for its 365 by Whole Foods Market will be opening up in Bellevue Square in the second half of 2016, according to Kemper Development Company, taking up the ground level of the former J.C. Penney Building, now know as the South Commons Shop. Read More ›
Wednesday July 29, 2015 at 08:00 AM
This fall Northwest University will be launching a business incubator and co-working space. Read More ›
Tuesday July 28, 2015 at 05:00 PM
The North Bend Downtown Foundation is seeking a manager for its visitor center and art gallery facility located on Bendigo Boulevard and Park Street. Read More ›
Monday July 27, 2015 at 03:00 PM
For the third consecutive year, U.S. News & World Report recognized EvergreenHealth as one of the top health care organizations in the region for its exceptional clinical care. The publications 2015-16 rankings name the Kirkland-based health system  which has a primary care center in Redmond  the No. 3 hospital in the Seattle metro area and No. 4 hospital in Washington state. Read More ›