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 '%bel%' 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 05/22/2015 thru 06/05/2015
Olympic Pipe Line Company, 600 SW 39th Street Suite 275, Renton, WA 98057, is seeking coverage under the Washington State Department of Ecology's Construction Stormwater NPDES and State Waste Discharge General Permit. 136th Place NE in Bellevue, King County, Washington. The proposed project, East Link Light Rail - Olympic Pipeline... [Full Notice]
Business News
Latest King County business news.
Tuesday May 19, 2015 at 03:00 PM
Join the Snoqualmie Valley Chamber of Commerce in celebrating the grand opening of Wild Hare Vintage in its new location in downtown historic Snoqualmie. Read More ›
Friday May 15, 2015 at 08:00 AM
Snoqualmie Valley Women in Business host NJ Shelsby, of Breakthrough Coaching, at the May luncheon event. Doors open at 11:30 and the program begins at noon, Wednesday, May 13, at the TPC Snoqualmie Ridge. Read More ›
Tuesday May 12, 2015 at 04:00 PM
Join Mark the Pond Guy for a free workshop on water-features, 10 a.m. to 3 p.m. Friday, May 15 at Marenakos Rock Center in Issaquah. Read More ›
Monday May 11, 2015 at 04:00 PM
After two years of tinkering, Redmond resident Hui Dai and Kirkland resident Alvin Loh have developed what they hope is the equivalent of match.com for small and medium-sized businesses. Read More ›
Friday May 08, 2015 at 04:00 PM
Don Cruickshank bought a fixer-upper in Bellevue's Crossroads neighborhood, but couldn't start remodeling until something was done about the pesky mass of blackberry bushes in the backyard. Read More ›
Monday May 11, 2015 at 07:00 AM
Talking Rain Beverage Company in Preston was named Company of the Year by the Beverage Forum, an annual conference of beverage company executives held April 21 and 22 in Chicago. Read More ›