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 '%fwm%' 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 09/12/2014 thru 09/26/2014
CITY OF FEDERAL WAY REQUEST FOR BIDS 2015 STREET SWEEPING SERVICES RFB#14-113 SUBMITTAL OF SEALED BIDS: Notice is hereby given that the City of Federal Way, Washington, will receive sealed bids through October 7, 2014, until 10:00 a.m., at the City Hall Purchasing Office or by US Mail at City... [Full Notice]
Business News
Latest King County business news.
Wednesday September 17, 2014 at 09:00 AM
The 737 MAX has surpassed 2,200 orders from 47 customers worldwide. Read More ›
Friday September 12, 2014 at 02:00 PM
The FAA currently occupies about 360,000-square-feet in several different leased locations in Renton. The new requirements are for a maximum of 300,000 rentable square feet of office and related space. Read More ›
Thursday September 11, 2014 at 03:00 PM
Kent business owners impacted by a potential local improvement district (LID) by the city of Kent to pay for railroad-vehicle grade separation projects can attend a meeting with Kent City Council members on Monday, Sept. 15 at the ShoWare Center. Read More ›
Wednesday September 10, 2014 at 04:00 PM
Franciscan Health System has a new name and logo  it's now called CHI Franciscan Health, a change that is part of a system-wide branding strategy by parent organization Catholic Health Initiatives (CHI), one of the nation's largest nonprofit health systems. Read More ›
Thursday September 11, 2014 at 03:00 PM
Three doors down from his original location, Wade Schwartz found a better spot to showcase his salon. Read More ›
Wednesday September 10, 2014 at 02:00 PM
Offering a variety of womens and childrens fashions at budget-friendly prices, Budget Fashion has opened for business at a Cole Street location in Enumclaw. Read More ›