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 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]
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]
Latest King County business news.
Terreno Realty purchases Kent industrial property for $11.2 million; 5th buy in city in 5 years - Kent ReporterFriday April 17, 2015 at 12:00 PM
San Francisco-based Terreno Realty Corp. this week bought another industrial property in Kent. Read More ›
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 ›
Tyson Foods recently recognized Auburn-based Zones, Inc., a technology solutions provider, as its Diverse Supplier of the Year. Read More ›
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 ›
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 ›
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 ›