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 09/17/2014 thru 09/24/2014
Advertisement for Bids CITY OF MERCER ISLAND, WASHINGTON 2014 Decant Facility Retrofit Project (XD313C) DATE OF BID OPENING: September 26, 2014 TIME: 10:00am Sealed bids for the 2014 Decant Facility Retrofit Project will be received by the City of Mercer Island at the DSG Permit Counter, 9611 SE 36th Street,... [Full Notice]
Business News
Latest King County business news.
Saturday September 20, 2014 at 03:00 PM
Seattle-based Windermere Property Management/JMW has announced its expansion to the Eastside. Windermere Property Management Kirkland is slated to open in October inside the Rose Hill Plaza Building at 12801 NE 85th Street. Read More ›
Sunday September 21, 2014 at 08:00 AM
The Women Business Owners (WBO), one of the Puget Sounds leading organization for women entrepreneurs, has named Kirkland business owners Makaylaa Powers and Niki McKay as two of five finalists for the 2014 Nellie Cashman Woman Business Owner of the Year Awards Competition (The Nellie). Read More ›
Friday September 19, 2014 at 06:00 AM
Business owners on Park Lane arent worried about being blocked off by construction. Theyre more worried that their regular customers wont know that. Read More ›
Wednesday September 17, 2014 at 11:00 AM
Major King County transportation players Metro and Sound Transit face massive cumulative deficits projected into 2015 and rapidly increasing ridership. County Executive Dow Constantine has instructed both agencies to work together to integrate and streamline service and planning. Read More ›
Wednesday September 17, 2014 at 11:00 AM
The city has cleared the design for a seven-story AC Marriott Hotel on Northeast Second in downtown Bellevue to offer upscale lodging downtown. Read More ›
Wednesday September 17, 2014 at 07:00 AM
Bellevue-based tech startup Point Inside today (Wednesday) announced a 1,690 percent growth in revenue since 2010, which CEO Josh Marti says positions the company to focus on new capabilities and products looking 18 months ahead. Read More ›