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 found.
King County Online 05/27/2016 thru 06/10/2016
State of Washington Department of Ecology Notice of Application to Change an existing water right TAKE NOTICE: That Gerald & Carolyn Grinstein of Medina, Washington on February 18, 2016, have filed an application of change to Ground Water Claim G1-158498CL. Claimed use is for 900 gallons per minute (gpm), 1440... [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 ›