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 07/18/2014 thru 07/25/2014
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 Tuesday, August 6, 2014, at 6:00 p.m. at Pacific City Hall, 100 3rd Ave.... [Full Notice]
King County Online 07/18/2014 thru 07/25/2014
Peasley Canyon Homes, LLC, 11624 SE 5th St Bellevue, WA 98005, is seeking coverage under the Washington State Department of Ecology’s Construction Stormwater NPDES and State Waste Discharge General Permit. The proposed project, Peasley Canyon Homes, is located at 5201 S 321st St, Auburn 32234 46th Place S, Auburn 32413... [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 ›