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 found.
King County Online 07/30/2014 thru 08/06/2014
CITY OF MERCER ISLAND NOTICE OF PUBLIC HEARING Notice is hereby given that the Mercer Island City Council will hold a public hearing at the August 4, 2014 Regular Meeting to discuss creating a Transportation Benefit District (TBD). The proposed Transportation Benefit District would authorize a new and renewing vehicle... [Full Notice]
Business News
Latest King County business news.
Wednesday July 30, 2014 at 08:00 AM
Facilities that exceeded wastewater discharge permit requirements in 2013 earned environmental awards from King Countys Industrial Waste Program for dedication to business practices that protect regional water quality. Read More ›
Monday July 28, 2014 at 03:00 PM
The Red Lion Hotel Bellevue is on the market, with broker Kidder Mathews highlighting the listing as a transit-oriented development opportunity, but prospective buyers may want to hold off until a redevelopment model is defined by an East Main Station Citizens Advisory Committee. Read More ›
Saturday July 26, 2014 at 01:00 PM
Earlier this year, JPMorgan Chase & Co. launched Small Business Forward, a five-year, $30 million grant program to boost small business support networks that help growing enterprises in specific industries. Read More ›
Friday July 25, 2014 at 11:00 AM
Bellevue's latest building boom brought Development Services Director Mike Brennan before the City Council on Monday to request additional staffing to tackle increasingly high volumes of building permits and shore up resource deficiencies. Read More ›
Thursday July 24, 2014 at 11:00 AM
The Target Corporation may have scrapped plans for a new retail center in Bellevue's Wilburton subarea, but that isn't stopping landowner KG Investment Management from moving forward with another large development across the Fourth Street extension. Read More ›
Wednesday July 23, 2014 at 11:00 AM
As a second phase of downtown Snoqualmie improvements starts kicking up dust, downtown merchants have rallied together to ensure tourists know they are still open for business.They started a Sip, Shop & Savor Summer in Downtown Snoqualmie campaign to showcase the business district between now and early September. Read More ›