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;
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 found.
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]
Latest King County business news.
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 ›
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 ›
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 ›
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 ›
Goat where the work is | Couple uses free-range landscaping in Bellevue backyard - Bellevue ReporterFriday 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 ›
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 ›