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 - 2
King County Online 12/10/2014 thru 12/24/2014
CITY OF MERCER ISLAND NOTICE OF COUNCIL VACANCY RECRUITMENT The City of Mercer Island is requesting applications from residents of Mercer Island to fill a vacancy on the City Council. The term will commence once a candidate is appointed by a majority vote of the City Council, and will expire... [Full Notice]
King County Online 12/17/2014 thru 12/24/2014
CITY OF MERCER ISLAND NOTICE OF COUNCIL VACANCY RECRUITMENT The City of Mercer Island is requesting applications from residents of Mercer Island to fill a vacancy on the City Council. The term will commence once a candidate is appointed by a majority vote of the City Council, and will expire... [Full Notice]
Business News
Latest King County business news.
Wednesday December 17, 2014 at 05:00 PM
TripAdvisor announced the winners of its winners of its inaugural Exceptional Service Awards on Dec. 17 and a Kirkland employee is on the list. Read More ›
Thursday December 18, 2014 at 07:00 AM
The Seattle/King County Realtors honored Trish Englund from Windermere RE/East Inc., Yarrow Bay in Kirkland with its One to Watch Award for young professionals. Read More ›
Wednesday December 17, 2014 at 02:00 PM
Whether it's investor funding, team building, technology support or developing best strategies for business startups, extraSlice CEO Binu Reghunathan says Bellevue's Smart Space is here to help. Read More ›
Tuesday December 16, 2014 at 11:00 AM
Bellevue resident and inventor Jim Fabregas has gotten another national publicity boost for his Garden and Tool Caddy  again just in time for the holidays. Read More ›
Sunday December 14, 2014 at 08:00 PM
Nature + Love has opened in Bellevue. The business sells health and beauty products and provides spa services such as facials, massage, yoga and reiki. Read More ›
Tuesday December 09, 2014 at 12:00 PM
The Snoqualmie Valley Hospital Lunch and Learn at noon, Thursday, Dec. 11, will feature news on Public Hospital District No. 4. Speaker Rodger McCollum, Superintendent of Snoqualmie Valley Hospital, will present the community benefits and services of the past year and discuss the grand opening of the districts new hospital. Read More ›