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/23/2014 thru 05/07/2014
Dean Mack, Mercer Island School Distirct, 4160 86th Ave SE, Mercer Island, WA 98040, is seeking coverage under the Washington State Department of Ecology's Construction Stormwater NPDES and State Waste Discharge General Permit. The proposed project, Mercer Island High School, is located at 9100 SE 42nd Street, in Mercer Island,... [Full Notice]
Business News
Latest King County business news.
Wednesday April 16, 2014 at 03:00 PM
All the world is a stage and, in the business world, Christina Marie Kimball and Jenni Butz believe getting the right part is all about a good performance. Read More ›
Wednesday April 23, 2014 at 02:00 PM
With spring in full swing, color comes quickly to the grounds of North Bends Nursery at Mount Si.So staff are hard at work to keep the plants, and the knowledge, growing and spreading to customers.Its showtime in the garden business, says owner Nels Melgaard, whos at the center of the activity. Read More ›
Monday April 21, 2014 at 09:00 AM
Evergreen Home Loans in Kirkland is offering a free class on purchasing a house from 7-8:30 p.m. on April 30 at the Windermere Real Estate office located 737 Market Street. Read More ›
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 ›
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 ›