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 '%mir%' 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 - 4
King County Online 05/20/2015 thru 06/03/2015
ADVERTISEMENT FOR BIDS CITY OF MERCER ISLAND, WASHINGTON 2015 RESIDENTIAL STREET OVERLAYS DATE OF BID OPENING: June 2, 2015 TIME: 11:00 AM Sealed bids for the 2015 RESIDENTIAL STREET OVERLAYS will be received by the City of Mercer Island at the DSG Permit Counter, 9611 SE 36th Street, Mercer Island,... [Full Notice]
King County Online 05/20/2015 thru 05/27/2015
Advertisement for Bids CITY OF MERCER ISLAND, WASHINGTON Sub Basin 27 Watercourse Stabilization Project WD311C DATE OF BID OPENING: May 29, 2015 TIME: 10:00 AM Sealed bids for the Sub Basin 27 Watercourse Stabilization Project will be received by the City of Mercer Island at the DSG Permit Counter, 9611... [Full Notice]
King County Online 05/13/2015 thru 06/10/2015
Subject: To the governing body of Madrona Crest Addition Design Review Committee, MN Custom Homes is proposing a new construction home at 8885 SE 36th St, Parcel 502190-0380-05. The home will be two stories with approximately 4,500 square feet of living space and a 3-car garage of approximately 700 square... [Full Notice]
King County Online 05/20/2015 thru 06/10/2015
Subject: To the governing body of Madrona Crest Addition Design Review Committee, MN Custom Homes is proposing a new construction home at 8885 SE 36th St, Parcel 502190-0380-05. The home will be two stories with approximately 4,500 square feet of living space and a 3-car garage of approximately 700 square... [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 ›