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 - 2
King County Online 07/18/2014 thru 08/01/2014
High Country Homes Soundview Manor LLC, PO Box 731749, Puyallup, WA, is seeking coverage under the Washington State Department of Ecology’s Construction Stormwater NPDES and State Waste Discharge General Permit. The proposed project, Soundview Manor is located at 44xx SW Dash Point Rd in Federal Way, in King Co, WA.... [Full Notice]
King County Online 07/18/2014 thru 07/25/2014
ORDINANCE SUMMARY At their July 15, 2014 Regular Meeting, the Federal Way City Council passed the following ordinance: ORDINANCE NO. 14-769 AN ORDINANCE of the City of Federal Way, Washington, amending Federal Way Revised Code 12.45 “Taxicabs”. (Amending Ordinance Nos. 90-27 and 09-600) ORDINANCE NO. 14-770 AN ORDINANCE of the... [Full Notice]
Business News
Latest King County business news.
Tuesday July 22, 2014 at 03:00 PM
Kent home prices were up 3.7 percent in June compared to the same month in 2013 with a median price of $269,750. Read More ›
Tuesday July 22, 2014 at 02:00 PM
Homes sales in Auburn were up 4.4 percent and home prices rose 11 percent in June compared to the same month last year. Read More ›
Monday July 21, 2014 at 02:00 PM
Simply Paws, a Federal Way pet store, donated between 2,500 and 3,000 pounds of dog food to Sunny Sky Rescue. Read More ›
Saturday July 19, 2014 at 08:00 AM
The 398,000-square-foot current store was built in 1994. It was the first U.S. franchise for the Swedish retailer and is located on 29 acres in Rentons southern, industrial and commercial section. Read More ›
Friday July 18, 2014 at 11:00 AM
The Renton honorees are American Classic Homes Real Estate, City of Renton, Kenworth Truck Company and Taco Time Northwest. Read More ›
Thursday July 17, 2014 at 07:00 PM
Reducing mankinds carbon footprint has become the defining issue of our time and rightly so. Virtually every level of government has policies to reduce greenhouse gases by regulating everything from industrial CO2 emissions to cow flatulence. Read More ›