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 04/16/2014 thru 04/23/2014
PROPOSAL TO SURPLUS PROPERTY Notice is hereby given that the City of Mercer Island is considering designating 2584 square feet of the south boundary of Clarke Beach Park at 7700 East Mercer Way as surplus property. Public comment will be taken on this proposal until 5pm on May 16, 2014.... [Full Notice]
Business News
Latest King County business news.
Friday April 18, 2014 at 03:00 PM
Meet other Valley businesspeople and check out whats new at North Bends Selah Gifts at this months Snoqualmie Valley Chamber of Commerce After Hours event, 5:30 p.m. Wednesday, April 30. Read More ›
Friday April 18, 2014 at 02:00 PM
Kitsap Bank now opened a loan production office in Bellevue at 11711 S.E. Eighth St., Suite 310. Read More ›
Wednesday April 16, 2014 at 03:00 PM
Creative networking will be literally taking center stage with the launch of Business Theatre Live! on Wednesday, April 22 Read More ›
Thursday April 17, 2014 at 12:00 PM
Earl Bell, author of the book, Winning in Baseball and Business, speaks at the Snoqualmie Valley Chamber of Commerces College of Business Knowledge Breakfast, 7:30 a.m. Friday, April 25, at the Mount Si Golf Course Restaurant, Snoqualmie.Learn a model for creating a spiral of success in your company. Read More ›
Tuesday April 15, 2014 at 04:00 PM
Tom Zebroski has been named vice president, wealth management advisor at The Private Client Reserve of U.S. Bank in Bellevue. Read More ›
Tuesday April 15, 2014 at 12:00 PM
The Rockefeller Group announced this week its 20-story Bellevue office tower project will be named the Sterling Center in honor of its partnership with Sterling Realty Organization. Read More ›