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/16/2014 thru 07/23/2014
Advertisement for Bids CITY OF MERCER ISLAND, WASHINGTON Sub Basin 6 Phase II Watercourse Stabilization Project (WD312C) DATE OF BID OPENING: July 24th, 2014 TIME: 2:00 PM Sealed bids for the Sub Basin 6 Phase II Watercourse Stabilization Project will be received by the City of Mercer Island at the... [Full Notice]
Business News
Latest King County business news.
Monday July 21, 2014 at 09:00 AM
Teri Clark is the new owner and manager at Snoqualmie Valley Weight Loss Center.A past client and employee, Clark has kept the same location, at 213 Bendigo Blvd. N., North Bend, adding hours and inventory.An open house is 4 to 8 p.m. Monday, July 21. Visitors are welcome to sample products and meet the new owner. Read More ›
Thursday July 17, 2014 at 05:00 PM
Bellevue-based Edifecs is moving to its new campus at the Bellefield Office Park following a 95-day renovation the healthcare technology solutions company is calling the "new cool" in office space. Read More ›
Thursday July 17, 2014 at 06:00 AM
We all know of a corporation or business that steps up and does good things in your community, whether its donating money or supplies, or providing volunteer help. Read More ›
Wednesday July 16, 2014 at 03:00 PM
A Microsoft spokesperson couldn't comment on the scenario on Wednesday, but according to a lengthy memo that Chief Executive Officer Satya Nadella sent to employees on July 10, layoffs may be forthcoming this month. Read More ›
Thursday July 17, 2014 at 07:00 AM
Lady Yum will officially open its doors on July 18 in downtown Kirkland at 111 Lake Street. Read More ›
Tuesday July 15, 2014 at 04:00 PM
Birches Habitat owner Nancy Wray has opened a new business, Arty Party Place, adjacent to her retail shop.Arty Party Place offers a space for art group classes, private parties and gatherings.We provide your canvas, supplies and paint and easy to follow lessons, Wray told the Record. All we need is you, your enthusiasm and some wine for a really fun night out with your gal pals, neighbors and friends. Read More ›