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 '%aub%' 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 10/17/2014 thru 10/31/2014
CITY OF PACIFIC Notice of PUBLIC HEARING October 14, 2014 NOTICE IS HEREBY GIVEN that on Monday, October 27, 2014, at approximately 6:30 p.m., the City Council will conduct a public hearing during the regular City Council meeting for the purpose of taking public testimony for consideration of the 2015... [Full Notice]
King County Online 10/24/2014 thru 10/31/2014
CITY OF PACIFIC Notice of PUBLIC HEARING October 14, 2014 NOTICE IS HEREBY GIVEN that on Monday, October 27, 2014, at approximately 6:30 p.m., the City Council will conduct a public hearing during the regular City Council meeting for the purpose of taking public testimony for consideration of the 2015... [Full Notice]
Business News
Latest King County business news.
Wednesday July 30, 2014 at 01:00 PM
The 3No Networking business mixer returns to Don Giovanni's Ristorante and Wine Bar at 5:30 p.m. Thursday. Read More ›
Wednesday October 29, 2014 at 11:00 AM
Life Care Centers of America recently honored Cindy Matthews, director of clinical services for its Northwest Division, with its company-wide Division Support Award. Read More ›
Monday October 27, 2014 at 11:00 AM
Terreno Realty Corp., of San Francisco, owner and operator of industrial real estate in six major coastal U.S. markets, acquired an industrial property on Oct. 24 in Kent for approximately $9.2 million. Read More ›
Wednesday August 27, 2014 at 11:00 AM
Join the 3No Networking business mixer at 5:30 p.m. Thursday at Zola's Café, 402 E. Main St., Suite 120. Read More ›
Wednesday October 22, 2014 at 10:00 AM
Kent home prices were down 1 percent in September compared to the same month in 2013 with a median price of $260,000. Read More ›
Sunday October 19, 2014 at 08:00 PM
Scams tend to follow the news, especially when a health scare makes the headlines. Read More ›