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 01/21/2015 thru 01/28/2015
CITY OF MERCER ISLAND NOTICE OF SPECIAL MEETING CITY COUNCIL ANNUAL PLANNING SESSION Notice is hereby given that the Mercer Island City Council will hold its annual planning session January 23-25, 2015 in the Calkins Room at the Mercer Island Community & Event Center (8236 SE 24th Street, Mercer... [Full Notice]
Business News
Latest King County business news.
Tuesday January 27, 2015 at 03:00 PM
The next Chamber After Hours is also the Valley Young Professionals Hangout, 6 to 9 p.m., Wednesday Jan. 28, at Snoqualmie Casino. Read More ›
Tuesday January 27, 2015 at 12:00 PM
A new program at Kirkland-based ATGStores.com offers students with a valid school email address a 10 percent site-wide discount on all purchases at any time of year, with limited manufacturer exclusions. Read More ›
Monday January 26, 2015 at 03:00 PM
Bartell Drugs is spotlighting American Heart Month as the family-owned drugstore chain celebrates its 125th anniversary. High cholesterol is one of the major controllable risk factors for coronary heart disease, and locally-owned Bartell Drugs offers heart-healthy screenings at all 63 locations in King, Snohomish and Pierce counties. Read More ›
Monday January 26, 2015 at 03:00 PM
In a NerdWallet analysis, Redmond is the No. 1-ranked city in Washington that appeals most to millennial job seekers. Read More ›
Monday January 26, 2015 at 11:00 AM
Bellevue bests Seattle for top Washington cities for millenial job seekers, according to an analysis by consumer finance site NerdWallet, that population growing nearly 10.5 percent from 2010 to 2013. Read More ›
Saturday January 24, 2015 at 08:00 AM
Kendra Alkire, a doctor of physical therapy, has been appointed as the clinical director of operations for Novelty Hill Physical Therapy (NHPT) in Redmond. Read More ›