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/22/2015 thru 04/29/2015
WSDOT will replace 21 anchor cables on the I-90 floating bridges between Mercer Island and Seattle. The contractor will begin work as early as late April 2015 and all work will be completed by July 2015. This work may require weeknight closures of a single lane in both directions of... [Full Notice]
Business News
Latest King County business news.
Friday April 24, 2015 at 11:00 AM
Bellevue marijuana shop, BelMar, will host a launch party 10 a.m. to 11 p.m. Friday, May 8, for Northwest Cannabis Solutions' new line of Magic Kitchen edibles, including bonbons (Koko Gemz), hard candies (Pebbles), caramel chews (Chewees) and cookies. All NWCS' Magic Kitchen edibles are 10mg THC. BelMar is located at 614 116th Ave. N.E. Read More ›
Monday April 20, 2015 at 10:00 AM
The Sherwood Center is coming down as a retail outlet and rising up as a 620-unit apartment complex as outlined in permits by Carmel Partners, a San Francisco-based real estate investment firm that purchased the property earlier this year. Read More ›
Monday April 20, 2015 at 01:00 PM
Entrepreneur and business coach Jeff Levy is offering a free seminar on what it takes to start and run your own business 5:30-8 p.m. Tuesday, April 28 at the Bellevue branch of the King County Library. Read More ›
Monday April 20, 2015 at 12:00 PM
Redmond's MediaAlpha, the emerging leader in performance-based digital advertising technology, announced that it has introduced Direct-to-Quote (DTQ), a new technology solution that benefits consumers, advertisers and publishers. DTQ provides a better online consumer experience that yields higher conversions and greater advertising ROI without a commensurate increase in cost or an unnecessary drain on an insurance companys technical resources. Read More ›
Saturday April 18, 2015 at 04:00 AM
Kirkland-based Robinswood Financial announced on April 10 that Brian D. Gawthrop, a Certified Financial Planner practitioner, has joined the Robinswood family. Gawthrop, founder of Five Cedars Financial, LLC, also in Kirkland, comes to Robinswood with a wealth of great experience and sound best practices within the financial advisory business. Read More ›
Friday April 17, 2015 at 12:00 PM
The city council could soon pave the way for 230 multifamily housing units to replace the vacant Haggen grocery site in Bellevue, the proponent awaiting an agreement to lift restrictions on such development in the Crossroads neighborhood. Read More ›