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;
Legal Notices
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 - 2
King County Online 04/10/2015 thru 04/24/2015
CITY OF PACIFIC REQUEST FOR PROPOSALS SOLID WASTE SERVICES The City of Pacific (the “City”) is requesting Proposals from qualified firms for solid waste collection services within the City Service Area. These Services include: residential and commercial garbage collection, recycling and yard debris collection. The initial contract term will be... [Full Notice]
King County Online 04/10/2015 thru 05/01/2015
NOTICE OF SPECIAL MEETING City Council Retreat April 10, 2015 NOTICE IS HEREBY GIVEN that on SATURDAY, MAY 2, 2015, at 9:00 a.m., the City Council will hold a CITY COUNCIL RETREAT at the City of Pacific City Hall Council Chambers, 100 3rd Avenue SE, Pacific, WA. The Council will... [Full Notice]
Business News
Latest King County business news.
Friday April 17, 2015 at 12:00 PM
San Francisco-based Terreno Realty Corp. this week bought another industrial property in Kent. Read More ›
Thursday April 16, 2015 at 03:00 PM
Wild Waves Theme Park will host a lifeguard hiring fair to assist in staffing their 2015 lifeguard team. Applicants who are not certified through Ellis & Associates can receive certification in April and May. Read More ›
Thursday April 16, 2015 at 03:00 PM
Tyson Foods recently recognized Auburn-based Zones, Inc., a technology solutions provider, as its Diverse Supplier of the Year. Read More ›
Wednesday April 15, 2015 at 10:00 AM
After several months of increasing or steady unemployment rates, Washington's unemployment rate for the month of March dropped to 5.9 percent, on a preliminary, seasonally adjusted basis, according to estimates by the federal Bureau of Labor Statistics. Read More ›
Tuesday April 14, 2015 at 01:00 PM
Employee rights are the topic for a free community event at 5 p.m. on Saturday, May 9 at the Kent Senior Center, 600 E. Smith St. Read More ›
Monday April 13, 2015 at 01:00 PM
Agrishop celebrates 40 years in business with an open house and specials throughout on May 16 at its center, 308 W. Main St, Auburn. Read More ›