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 found.
King County Online 08/22/2014 thru 09/19/2014
Reference Number(s) of Documents assigned or released: 20050909001580 Document Title: Notice of Trustee’s Sale Grantor:Nold Muchinsky PLLC Grantee: Patricia A. Sewell, as her separate estate Abbreviated Legal Description: UNIT 1 THROUGH 6, GREEN VILLA CONDO, VOL 12, PG 86 Assessor's Property Tax Parcel/Account Number(s): 289530001006, 289530006005, 289530002004, 289530003002, 289530004000, 289530005007,... [Full Notice]
Business News
Latest King County business news.
Friday August 29, 2014 at 11:00 AM
Big 5 Sporting Goods, one of the leading sporting goods retailers in the Western States, opened its newest location in Auburn on Friday. Read More ›
Thursday August 28, 2014 at 10:00 AM
The Night of the Stars Gala is at the Seattle Airport Marriott, 3201 S. 176th St., SeaTac. Cost is $75 a person. For more information call 206-575-1633 or register at 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 August 27, 2014 at 11:00 AM
Ted J. Fick, a Tacoma native with decades of experience leading manufacturing organizations across the country, will take the helm when current CEO Tay Yoshitani retires next month, according to a port news release. Read More ›
Tuesday August 26, 2014 at 03:00 PM
The construction contract for Tukwila Village has been awarded to Inter-city Contractors of Kenmore, which has built many of the Senior Housing Assistance Group's (SHAG) communities. Read More ›
Monday August 25, 2014 at 01:00 PM
The order, valued at $8.8 billion at list prices, is the largest in BOC Aviation's 20-year history. Read More ›