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 '%aub%' group by groupText,l.startdate,l.enddate order by l.text;
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 - 2
CITY OF PACIFIC PLANNING COMMISSION SPECIAL MEETING AND PUBLIC HEARING Draft Ordinances Regarding Marijuana Uses in the City of Pacific The City of Pacific Planning Commission will hold a Public Hearing at a Special Meeting on Wednesday, August 6, 2014, at 6:00 p.m. at Pacific City Hall, 100 3rd Ave.... [Full Notice]
NOTICE OF SPECIAL BOARD OF DIRECTORS' MEETING The Auburn School District Board of Directors will hold a special board meeting at 6 p.m. on Monday, July 28, immediately preceding the regular meeting at 7 p.m. The purpose of the special board meeting is for the board to conduct their annual... [Full Notice]
Latest King County business news.
San Francisco-based Terreno Realty Corp., has bought an industrial property in south Kent for about $2.8 million. Read More ›
Valley Medical celebrated the soon to be open clinic with a ribbon cutting ceremony on July 24. Read More ›
Caffe D'arte serves up artisan traditions at new Federal Way headquarters | Slideshow - Federal Way MirrorSaturday July 26, 2014 at 12:00 PM
Dario Brancato kneels down and peers inside a small door on the wood-fired roaster, watching the flame lick the base of the drum. Read More ›
Sidney Rice is going from the Seahawks to chickens with plans to open a Wingstop restaurant at Kent Station. Read More ›
Six Kent businesses named Best Workplaces for Waste Prevention and Recycling by King County - Kent ReporterThursday July 24, 2014 at 02:00 PM
Six local businesses, including the city of Kent, made King County's list of Best Workplaces for Waste Prevention and Recycling. Businesses meeting the criteria include Applus Technologies, Inc., Fred Meyer #215, Hexcel Corporation, Ingenium Group, LLC and Torklift Central. Read More ›
As single-game tickets for the Seahawks go on sale, the Better Business Bureau serving Alaska, Oregon and Western Washington warns fans to be wary of too-good-to-be-true deals. Read More ›