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 '%svr%' 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 12/17/2014 thru 12/24/2014
PUBLIC NOTICE #1204941 CITY OF NORTH BEND NOTICE OF PUBLIC HEARING SEGALE TANNER ROAD PRELIMINARY PLAT January 8, 2015 - 3:30 PM Mount Si Senior Center - 411 Main Avenue S. North Bend, Washington The City of North Bend will hold a Public Hearing at the date and time... [Full Notice]
Business News
Latest King County business news.
Friday December 19, 2014 at 10:00 AM
After two years of research by AT&T to create a retail design that provides an interactive customer experience, the telecommunications company launched its fourth "Store of the Future" at Lincoln Square on Thursday. Read More ›
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 ›