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 '%bel%' 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 - 2
King County Online 04/22/2016 thru 05/06/2016
Bellevue School District No. 402, 12037 NE 5th Street Bellevue, WA 98009-9010 is seeking coverage under the Washington State Department of Ecology's Construction Stormwater General Permit. The proposed project, Richard Bennett Elementary School, is located at 179000 NE 16th Street in Bellevue in King County, in WA. This project involves... [Full Notice]
King County Online 04/22/2016 thru 05/06/2016
Spee West Construction, 307 Bell Street #101 Edmonds, WA 98020, is seeking coverage under the Washington State Department of Ecology’s Construction Stormwater General Permit.The proposed project, TILLICUM MIDDLE SCHOOL, is located at 16020 SE 16th St in Bellevue in King County, in WA. This project involves 15.2 acres of soil... [Full Notice]
Business News
Latest King County business news.
Tuesday March 29, 2016 at 06:00 AM
The Woodmark Hotel and Still Spa in Kirkland has announce the addition of Brooke Gogerty and Jason Friendy to the staff. Read More ›
Wednesday March 23, 2016 at 11:00 AM
Washington added 10,600 new nonfarm jobs on a preliminary, seasonally adjusted basis from January 2016 to February 2016, according to the states Employment Security Department (ESD). Read More ›
Monday March 21, 2016 at 12:00 PM
Molly Moons has announced the opening date for its seventh ice cream shop: April 8 at 16272 Cleveland St. in downtown Redmond. The shop is slated to start serving scoops to patrons at 3 p.m. Kids 12 and under can enjoy a complementary scoop of any flavor of their choosing until 5 p.m. that same evening. Read More ›
Monday March 21, 2016 at 12:00 PM
Redmonds Versium, a leading data technology company that delivers automated data technology solutions to marketing agencies and enterprises, announced the Predictive List Builder, an extension of Versiums predictive marketing suite of services. Read More ›
Monday March 21, 2016 at 07:00 AM
Kirkland resident Rebecca Penn has joined the Kirkland-based law firm Livengood Alskog as an associate attorney. Read More ›
Thursday March 10, 2016 at 02:00 PM
You cant really parse out who came first  green developers or buyers who want green homes, Built Green Program Director Leah Missik said. Its the chicken and the egg. Read More ›